Printable Version of Topic

Click here to view this topic in its original format

Dumpshock Forums _ Dumpshock News, Bug Reports, Feature Requests, & Discussion _ Bug: Clicking on "The Moderating Team" link

Posted by: Lagomorph Mar 27 2007, 04:48 PM

Description:

The link http://forums.dumpshock.com/index.php?act=Stats&CODE=leaders produces a page which states:

There appears to be an error with the Dumpshock Forums database.
You can try to refresh the page by clicking here, if this does not fix the error, you can contact the board administrator by clicking here

Error Returned

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: Tuesday 27th of March 2007 12:43:35 PM

We apologise for any inconvenience

Repro:
1. From forums.dumpshock.com click on the "The Moderating Team" link
Note: This was done on XP using IE6, have not tried to repro this on other OS or Browsers.

Posted by: Demerzel Mar 27 2007, 06:28 PM

It's been asked before, I don't think there's a very high priority on this one...

http://forums.dumpshock.com/index.php?showtopic=16137

Posted by: eidolon Mar 27 2007, 07:09 PM

Yeah, been that way forever.

Posted by: Lagomorph Mar 27 2007, 07:51 PM

ah, okay, didn't see it here in the bugreports section when I made the post. As long as they know about it, then priority is up to them

Posted by: Tanka Mar 27 2007, 09:35 PM

AFAIK, it's been like that since I joined. Possibly longer.

Posted by: fistandantilus3.0 Mar 27 2007, 09:40 PM

Another thing that probably won't be addressed until a software change. Whenever that may be.

Posted by: Fenris Jun 27 2007, 01:20 AM

In the meantime, is there a way of getting ahold of the moderators?

Posted by: eidolon Jun 27 2007, 02:21 AM

Yup. Feel free to PM any of us with any issues. If it's general enough you can always throw a thread up in this forum.

The Admins (superpermissionawesomesauce users) include Adam, Bull, and Neuron Basher. (NB is usually extremely busy and may not get back to you super fast, fair warning).

The moderating team includes myself, fistandantilus3.0, Caine Hazen, and Aristotle. There are a few more of us around, but I haven't seen them in a while, so those are "your most likely to notice quickly".

Posted by: Fenris Jun 27 2007, 03:32 PM

Wow, thanks very much for the rapid response, much appreciated.

Posted by: eidolon Jun 27 2007, 04:42 PM

Np.

Posted by: Adam Jun 27 2007, 05:55 PM

You can also email forums@dumpshock.com -- which is linked on the bottom of every single page.