IPB

Welcome Guest ( Log In | Register )

> 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

Posts in this topic
- Lagomorph   Bug: Clicking on "The Moderating Team" link   Mar 27 2007, 04:48 PM
- - Demerzel   It's been asked before, I don't think ther...   Mar 27 2007, 06:28 PM
- - eidolon   Yeah, been that way forever.   Mar 27 2007, 07:09 PM
- - Lagomorph   ah, okay, didn't see it here in the bugreports...   Mar 27 2007, 07:51 PM
- - Tanka   AFAIK, it's been like that since I joined. Po...   Mar 27 2007, 09:35 PM
- - fistandantilus3.0   Another thing that probably won't be addressed...   Mar 27 2007, 09:40 PM
- - Fenris   In the meantime, is there a way of getting ahold o...   Jun 27 2007, 01:20 AM
- - eidolon   Yup. Feel free to PM any of us with any issues. ...   Jun 27 2007, 02:21 AM
- - Fenris   Wow, thanks very much for the rapid response, much...   Jun 27 2007, 03:32 PM
- - eidolon   Np.   Jun 27 2007, 04:42 PM
- - Adam   You can also email forums@dumpshock.com -- which i...   Jun 27 2007, 05:55 PM

« Next Oldest · Dumpshock News, Bug Reports, Feature Requests, & Discussion · Next Newest »
 

Reply to this topicStart new topic

 

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

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

RSS Lo-Fi Version Time is now: 7th January 2026 - 04:02 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.