IPB MySQL Syntax Problem...
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.
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.