search

devryan / GamePanelX-V3

The Original Free and Open Source Game Control Panel
https://www.gamepanelx.com
Other
131 stars 94 forks source link

Error: Failed to create user: Field 'last_updated' doesn't have a default value #151

Closed ghost closed 7 years ago

ghost commented 7 years ago

During installation.

skeeta92 commented 7 years ago

how do I fix this error "Error: error, Internal Server Error"

jonafeucht commented 7 years ago

@BeFreezy @skeeta92 It's bc u have "MySQL Strict Mode" enabled.

Fix:

  1. Edit ur my.cnf -> Can either be found under /etc/my.cnf or /etc/mysql/my.cnf
  2. Replace [mysqld] sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" with this [mysqld] sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Should look like this: this

skeeta92 commented 7 years ago

That line doesn't exist... do I need to just add it ?

jonafeucht commented 7 years ago

Yes

skeeta92 commented 7 years ago

Still no luck :/

devryan commented 7 years ago

You restarted mysqld after your change? What mysql server version and flavor is it?

Note that gpx is not tested against strict mode-enabled mysql so you may need to tweak some things.

devryan commented 7 years ago

This is being hosted on a hosting control panel other than gpx -- can't support it if I don't know how it works or what it blocks

sterrek commented 7 years ago

Hi, i have to same problem im searching for a few hours. i could provide you the details of my vps