Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue with setting db #4

Open
360bladez opened this issue May 11, 2019 · 1 comment
Open

Issue with setting db #4

360bladez opened this issue May 11, 2019 · 1 comment
Assignees
Labels

Comments

@360bladez
Copy link

After enter my db info into the install.php page

I get this error
Failed to Create Table 'users', See the below for more details:

Invalid default value for 'registered'

Failed to Create Table 'saves', See the below for more details:

Can't create table 'c1dbhbm.saves' (errno: 150)

Seems to be corrected by changing?

registered datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Registration Date' to registered TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Registration Date'

5.5.60-MariaDB

@hasanbayatme
Copy link
Member

Thanks for the detailed report.
Did you have got working with changing the "datetime" to "timestamp"?

Regards.

@hasanbayatme hasanbayatme self-assigned this May 12, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants