Hello,
My forum at https://railbotforum.org/mbs/ has been upgraded to a new Linux 7 server.
This has broken the forum.
I am getting this error.
(https://ozrecover.net/images/misc/dberror.jpg)
Can you advise how to proceed please?
Thanks.
Bob
Open /etc/my.cnf
Change sql_mode
To
sql_mode = ""
Then restart mysql
Thanks. I am not sure how to do that.
did you upgrade the server? do you manage the server, if the answer is no, contact your host.
Thanks. No I did not do the upgrade. Will go back to my host.
Thanks host effected the change suggested above.
All fine now.
Thank you for the help in resolving the issue.
:)
Glad all is working!
Actually that looks like it may be a bug. If it is: one we should probably address if reasonably possible. Encountered it before but forgot about it.
Disabling such mySQL modes is reasonable for a short-term solution, but I don't think it ought to be long-term. Not a huge problem/major concern, but all the same. Would save some trouble too.
Well the base issue is here that the query are "broken",
this broken queries got fixed in smf 2.1 to get work.
this took some time...
but the funny thing is,
the most of the quries got already fixed in 2.0.x but only for postgres