SaveGamePro icon indicating copy to clipboard operation
SaveGamePro copied to clipboard

Issue with setting db

Open 360bladez opened this issue 5 years ago • 1 comments

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

360bladez avatar May 11 '19 22:05 360bladez

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

Regards.

hasanbayatme avatar May 12 '19 06:05 hasanbayatme