Dumpshock Forums > Bug: Clicking on "The Moderating Team" link

Full Version: Bug: Clicking on "The Moderating Team" link

Dumpshock Forums > Discussion > Dumpshock News, Bug Reports, Feature Requests, & Discussion

Lagomorph

Mar 27 2007, 04:48 PM

Description:

The link http://forums.dumpshock.com/index.php?act=...ts&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.

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

eidolon

Mar 27 2007, 07:09 PM

Yeah, been that way forever.

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

Tanka

Mar 27 2007, 09:35 PM

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

fistandantilus4.0

Mar 27 2007, 09:40 PM

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

Fenris

Jun 27 2007, 01:20 AM

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

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".

Fenris

Jun 27 2007, 03:32 PM

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

eidolon

Jun 27 2007, 04:42 PM

Np.

Adam

Jun 27 2007, 05:55 PM

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

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.