Print Page - DB error only affects some users

Title: DB error only affects some users
Post by: Sir Osis of Liver 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.

Title: Re: DB error only affects some users
Post by: Arantor on December 07, 2018, 11:49:07 AM

Turn off strict mode in MySQL.

Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Sir Osis of Liver on December 07, 2018, 11:25:45 AM