Website does not create accounts

[danhakhavro 42]

Hello,

I am registering a new account in the website, the site says that the account was registered successfully but it doesnt add any account to my database.

I already change the website, use a simple 1 page register, allow all columns in account.account to NULL, nothing works.

But if i use one id that already exist, the website say that i cant create account, the ranking is working also fine.

Does anyone have an idea of what it might be?

Thanks

Edited May 11, 2021 by danhakhavro

[danhakhavro 42]

Problem solved!

 

If somebody have the same problem, here the fix:

 

Create a new file or edit if you already have: my.cnf in your /usr/locale

 

At the end write: sql_mode=NO_ENGINE_SUBSTITUTION

You can also try to run a query at navicat.account: sql_mode=NO_ENGINE_SUBSTITUTION

 

You welcome

Edited May 11, 2021 by danhakhavro