Printable Version of Topic

Click here to view this topic in its original format

Dumpshock Forums _ Dumpshock News, Bug Reports, Feature Requests, & Discussion _ Show Moderators

Posted by: BishopMcQ Jan 15 2006, 11:58 PM

Here's what I get when I go into My Assistant to show Moderators...

CODE

mySQL query error: SELECT m.id, m.name, m.email, m.hide_email, m.location, m.aim_name, m.icq_number,
f.id as forum_id, f.read_perms, f.name as forum_name, c.state
FROM ibf_members m, ibf_categories c
LEFT JOIN ibf_moderators mod ON((m.id=mod.member_id or (mod.is_group=1 and mod.group_id=m.mgroup)))
LEFT JOIN ibf_forums f ON(f.id=mod.forum_id)
WHERE c.id=f.category AND c.state != 0

mySQL error: 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 'mod ON((m.id=mod.member_id or (mod.is_group=1 and mod.group_id=m.mgroup)))
' at line 4
mySQL error code:
Date: Sunday 15th of January 2006 06:56:42 PM

Posted by: Aku Jan 16 2006, 01:33 AM

ya know, i noticed that about a week ago. I figured it was some new witness protection program

Posted by: BishopMcQ Jan 17 2006, 05:35 AM

Same error message happens if I click on "The Moderator Team" at the bottom of the Main page...