Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jan 2005
Posts: 35
P
newbie
newbie
P Offline
Joined: Jan 2005
Posts: 35
Whenever one of my moderators goes to Approve Posts under the Control Panel, he gets the following error:

Quote
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

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Hmm, is he assigned to be a moderator of any particular forum or multiple forums?

Joined: Jan 2005
Posts: 35
P
newbie
newbie
P Offline
Joined: Jan 2005
Posts: 35
Multiple Forums. One of my other admins however said he checked the box to allow this mod to approve posts and it appears to have fixed the problem. I thought I had set all those, thanks for the reply.

jason


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)