MySQL Forums
Forum List  »  Newbie

IPB MySQL Syntax Problem...
Posted by: barry carpenter
Date: June 20, 2005 10:06PM

Ok, I am a 100% MySQL newb. Here is the message I get, what can I do to fix it?

--------------------------
mySQL query error: SELECT m2.id, m2.name, m2.email, m2.hide_email, m2.location, m2.aim_name, m2.icq_number,
f.id as forum_id, f.read_perms, f.name as forum_name, c.state
FROM ibf_moderators mod
LEFT JOIN ibf_forums f ON(f.id=mod.forum_id)
LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0)
LEFT JOIN ibf_members m2 ON (mod.member_id=m2.id)


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
LEFT JOIN ibf_forums f ON(f.id=mod.forum_id)
' at line 3
mySQL error code:
Date: Tuesday 21st of June 2005 05:01:19 AM
------------------------

My host has 4.1.11-standard MySQL version Installed on my host.

Options: ReplyQuote


Subject
Written By
Posted
IPB MySQL Syntax Problem...
June 20, 2005 10:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.