News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Broken SMF forum on Linux upgrade

Started by ozbob, May 30, 2019, 03:44:54 PM

Previous topic - Next topic

ozbob

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.



Can you advise how to proceed please?

Thanks.

Bob


vbgamer45

Open /etc/my.cnf
Change sql_mode
To
sql_mode = ""


Then restart mysql
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

ozbob

Thanks.  I am not sure how to do that.

Illori

did you upgrade the server? do you manage the server, if the answer is no, contact your host.

ozbob

Thanks.  No I did not do the upgrade.  Will go back to my host.

ozbob

Thanks host effected the change suggested above.

All fine now.

Thank you for the help in resolving the issue.

:)

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

LiroyvH

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.
((U + C + I)x(10 − S)) / 20xAx1 / (1 − sin(F / 10))
President/CEO of Simple Machines - Server Manager
Please do not PM for support - anything else is usually OK.

albertlast

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

Advertisement: