Author Topic: DB error only affects some users  (Read 204 times)

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 8,914
DB error only affects some users
« on: December 07, 2018, 11:25:45 AM »
2.0.15 install, 10-12 mods, get this error for 'Show new replies to your posts.' in owner's admin account, not in mine -

Expression #1 of ORDER BY clause is not in SELECT list, references column 'freeadzf_smf1.t.id_last_msg' which is not in SELECT list; this is incompatible with DISTINCT
File: /home/freeadzf/public_html/Sources/Recent.php
Line: 1105

Was also having problems with foreign language strings being mixed in with english, but looks like that's fixed.  Possible database damage after migration.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 70,992
    • StoryBB/StoryBB on GitHub
Re: DB error only affects some users
« Reply #1 on: December 07, 2018, 11:49:07 AM »
Turn off strict mode in MySQL.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.