[BUG] System Error! An Error occured! Error ID: xx

[mdziekon]

[BUG] System Error! An Error occured! Error ID: xx

[Daeloran]

I get this error (more precise I think) from the database

Field 'buildQueue' doesn't have a default value
INSERT INTO _planets (id, metal, crystal, deuterium, last_update, metal_perhour, crystal_perhour, deuterium_perhour, energy_used, energy_max) VALUES (1, '588.26147783', '1093.3766222433', '129.94359444333', '1605866375', '175', '48', '13', '-106', '117') ON DUPLICATE KEY UPDATE metal = VALUES(metal), crystal = VALUES(crystal), deuterium = VALUES(deuterium), last_update = VALUES(last_update), metal_perhour = VALUES(metal_perhour), crystal_perhour = VALUES(crystal_perhour), deuterium_perhour = VALUES(deuterium_perhour), energy_used = VALUES(energy_used), energy_max = VALUES(energy_max)
File: /overview.php
User: Lupink[1]

[mdziekon]

Hi @Daeloran,

quickly looking at the attached SQL error, it seems that you did not disable STRICT_TRANS_TABLES as mentioned in the installation guide (https://github.com/mdziekon/UniEngine#installation), as this looks very similar to another report (#118).

Could you please verify that option on your instance's database?

[Daeloran]

HEllo @mdziekon

Thank you for your fast answer.
I disable the STRICT_TRANS_TABLES with the command mysql -u root -p -e "SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';". I have too because my Universe don't create if I don't do it (get an sql error at the installation).

I have re-create my site/DB for now.

[mdziekon]

To clarify, are you saying that disabling STRICT_TRANS_TABLES and recreating the DB did, or did not solve the problem?

[Daeloran]

Excuse me,

Recreating my DB solve the problem.

Thank You

[mdziekon]

Sure thing, I'll close the issue now and mark it as resolved.