1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggrega

[nokte]

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'urbanity_forum.t1.pid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byQuery:SELECT t1.* FROM mybb_posts t1 JOIN ( SELECT pid FROM mybb_posts WHERE visible='1' ORDER BY pid DESC )t2 ON t1.pid = t2.pid GROUP BY tid ORDER BY pid DESC
Please contact the MyBB Group for technical support.


who to solve it?
plz help me

[Crazycat]

Try to disable the sql_mode only_full_group_by.
Have a look on the most voted answer @ https://stackoverflow.com/questions/2392...l-group-by if you don't know how to do that.