Whenever one of my moderators goes to Approve Posts under the Control Panel, he gets the following error:
SELECT t1.POST_ID,t1.POST_SUBJECT,t3.FORUM_TITLE,t1.USER_ID,t2.USER_DISPLAY_NAME FROM ubbt_POSTS AS t1, ubbt_USERS AS t2, ubbt_FORUMS AS t3, ubbt_TOPICS as t4 WHERE t1.POST_IS_APPROVED = '0' AND t1.USER_ID = t2.USER_ID AND t1.TOPIC_ID = t4.TOPIC_ID AND t3.FORUM_ID = t4.FORUM_ID AND t4.FORUM_ID in () ORDER BY t4.FORUM_ID,t1.POST_ID DESC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY t4.FORUM_ID,t1.POST_ID DESC' at line 10
7.1, upgraded from 6.2.3 to 6.5.5 them 7.1 ~80,000 threads, and 9000 users
Jason
