IPB

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Bug: Clicking on "The Moderating Team" link, Shows page with SQL error
Lagomorph
post Mar 27 2007, 04:48 PM
Post #1


Moving Target
**

Group: Members
Posts: 834
Joined: 30-June 03
Member No.: 4,832
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.
Go to the top of the page
 
+Quote Post
Demerzel
post Mar 27 2007, 06:28 PM
Post #2


Running Target
***

Group: Members
Posts: 1,206
Joined: 9-July 06
From: Fresno, CA
Member No.: 8,856
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
Go to the top of the page
 
+Quote Post
eidolon
post Mar 27 2007, 07:09 PM
Post #3


ghostrider
********

Group: Retired Admins
Posts: 4,196
Joined: 16-May 04
Member No.: 6,333
Yeah, been that way forever.
Go to the top of the page
 
+Quote Post
Lagomorph
post Mar 27 2007, 07:51 PM
Post #4


Moving Target
**

Group: Members
Posts: 834
Joined: 30-June 03
Member No.: 4,832
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 :)
Go to the top of the page
 
+Quote Post
Tanka
post Mar 27 2007, 09:35 PM
Post #5


Chrome to the Core
******

Group: Dumpshocked
Posts: 3,152
Joined: 14-October 03
From: ::1
Member No.: 5,715
AFAIK, it's been like that since I joined. Possibly longer.
Go to the top of the page
 
+Quote Post
fistandantilus4....
post Mar 27 2007, 09:40 PM
Post #6


Uncle Fisty
**********

Group: Admin
Posts: 13,891
Joined: 3-January 05
From: Next To Her
Member No.: 6,928
Another thing that probably won't be addressed until a software change. Whenever that may be.
Go to the top of the page
 
+Quote Post
Fenris
post Jun 27 2007, 01:20 AM
Post #7


GM of DOOM!
*******

Group: Members
Posts: 3,893
Joined: 20-March 03
From: San Diego
Member No.: 4,296
In the meantime, is there a way of getting ahold of the moderators?
Go to the top of the page
 
+Quote Post
eidolon
post Jun 27 2007, 02:21 AM
Post #8


ghostrider
********

Group: Retired Admins
Posts: 4,196
Joined: 16-May 04
Member No.: 6,333
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".
Go to the top of the page
 
+Quote Post
Fenris
post Jun 27 2007, 03:32 PM
Post #9


GM of DOOM!
*******

Group: Members
Posts: 3,893
Joined: 20-March 03
From: San Diego
Member No.: 4,296
Wow, thanks very much for the rapid response, much appreciated.
Go to the top of the page
 
+Quote Post
eidolon
post Jun 27 2007, 04:42 PM
Post #10


ghostrider
********

Group: Retired Admins
Posts: 4,196
Joined: 16-May 04
Member No.: 6,333
Np.
Go to the top of the page
 
+Quote Post
Adam
post Jun 27 2007, 05:55 PM
Post #11


Prime Runner
*******

Group: Retired Admins
Posts: 3,929
Joined: 26-February 02
From: .ca
Member No.: 51
You can also email forums@dumpshock.com -- which is linked on the bottom of every single page. :-)
Go to the top of the page
 
+Quote Post
« Next Oldest · Dumpshock News, Bug Reports, Feature Requests, & Discussion · Next Newest »
 

Reply to this topicStart new topic

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Lo-Fi Version Time is now: 4th January 2026 - 10:09 AM
Powered By IP.Board © 2026  IPS, Inc.

Topps, Inc has sole ownership of the names, logo, artwork, marks, photographs, sounds, audio, video and/or any proprietary material used in connection with the game Shadowrun. Topps, Inc has granted permission to the Dumpshock Forums to use such names, logos, artwork, marks and/or any proprietary materials for promotional and informational purposes on its website but does not endorse, and is not affiliated with the Dumpshock Forums in any official capacity whatsoever.