IPB

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> SQL Errors redux
gefahrmaus
post May 17 2005, 11:34 PM
Post #1


Target
*

Group: Members
Posts: 0
Joined: 15-May 05
Member No.: 7,396
Invision PowerBoard Database Error

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 17th of May 2005 07:31:06 PM
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: 22nd June 2025 - 09:54 AM
Powered By IP.Board © 2025  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.