Error Number: 1364

Having a problem getting Nova installed? Can't figure out why something isn't working right? This is the place to get help and report any bugs you find with Nova!

LcNessie Fri Jul 06, 2018 3:00 am

Re: Error Number: 1364

Database in strict mode might actually be the problem.
I also was informed by John (Rotten-Emu) that he also got error 1366 when trying to create a mission without start and/or end date. This will try to insert an (empty) string into an integer field.

I will try to find this strict-mode thingy and disable that.

edit: ... Ehm... There are multiple strict thingies available. Which should I disable?


edit 2: I did the following to get things working:
- innodb_strict_mode to off
- sql-mode from "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Some of these changes might not have been necessary, I think. Going to turn them on one by one when I have some more time to test.

Posts: 8


AgentPhoenix Fri Jul 06, 2018 8:58 pm

Re: Error Number: 1364

I've actually never gone through to find out which need to be turned off, so I'll be curious to know which of them are necessary.
User avatar

Posts: 7582


jasoncollege24 Mon Dec 17, 2018 2:16 am

Re: Error Number: 1364

Disabling strict mode in mysql settings resolves the 1366 error.
Image
User avatar

Posts: 183


Previous

Return to Help

Who is online

Users browsing this forum: No registered users and 3 guests

cron