۱۳۹۸/۲/۷، ۱۴:۰۰:۱۶ عصر
با سلام
من سایم را به هاست جدید منتقل کردم پس از تنظیم دیتابیس ، وقتی صفحه اول سایتم را باز میکنم این ارور را می دهد.
مشکل چیست و چگونه رفعش کنم؟
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1055 - Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'urbanity_forum.a.downloads' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT p.subject,t.fid,t.visible,a.pid,a.downloads,a.filename FROM mybb_attachments a LEFT JOIN mybb_posts p ON (p.pid = a.pid) LEFT JOIN mybb_threads t ON (t.tid = p.tid) WHERE (t.visible = '1' OR '1'='1' ) AND t.fid NOT IN ('174','175') AND t.closed NOT LIKE 'moved|%' AND t.visible != '-2' AND a.thumbnail = '' GROUP BY p.pid ORDER BY a.downloads DESC LIMIT 0,15
Please contact the MyBB Group for technical support.
من سایم را به هاست جدید منتقل کردم پس از تنظیم دیتابیس ، وقتی صفحه اول سایتم را باز میکنم این ارور را می دهد.
مشکل چیست و چگونه رفعش کنم؟
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1055 - Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'urbanity_forum.a.downloads' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT p.subject,t.fid,t.visible,a.pid,a.downloads,a.filename FROM mybb_attachments a LEFT JOIN mybb_posts p ON (p.pid = a.pid) LEFT JOIN mybb_threads t ON (t.tid = p.tid) WHERE (t.visible = '1' OR '1'='1' ) AND t.fid NOT IN ('174','175') AND t.closed NOT LIKE 'moved|%' AND t.visible != '-2' AND a.thumbnail = '' GROUP BY p.pid ORDER BY a.downloads DESC LIMIT 0,15
Please contact the MyBB Group for technical support.