Help mySQL error 1064

I tried to receive assistance in the chat room and I got nowhere. Could someone please tell me how to fix this problem. I'm not smart with sql so I need the simplest way possible. Here is the error i'm getting. The error only comes up when a member is logged in. If you're not logged in you can read the board just fine.

------------------------------------

mySQL query error: SELECT mod.mid as is_mod, m.id, m.name, m.mgroup, m.password, m.email, m.allow_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup )
WHERE m.id='1'

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 (mod.member_id=m.id OR mod.group_id=m.mgroup )
WHERE m.' at line 6
mySQL error code: 1064
Date: Wednesday 12th of January 2005 05:51:43 PM

[tbonekkt]

http://forum.powweb.com/showthread.php?t=45463

Originally Posted by acfishing

I tried to receive assistance in the chat room and I got nowhere. Could someone please tell me how to fix this problem. I'm not smart with sql so I need the simplest way possible. Here is the error i'm getting. The error only comes up when a member is logged in. If you're not logged in you can read the board just fine.

------------------------------------

mySQL query error: SELECT mod.mid as is_mod, m.id, m.name, m.mgroup, m.password, m.email, m.allow_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup )
WHERE m.id='1'

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 (mod.member_id=m.id OR mod.group_id=m.mgroup )
WHERE m.' at line 6
mySQL error code: 1064
Date: Wednesday 12th of January 2005 05:51:43 PM

dont waste your time here ive been trying to get some help all morning. a fellow member has tried to help out but unfortunatly his problem is not with ikonboard so its hard to figure out which file has issues

Could you be more specific with fixing this. I'm not too familiar with the technical part of mysql and find myself clueless right now.