Silverbacks
1-13-05, 02:36 PM
My forum was working fine a couple nights ago. I think the MySQL upgrade made my message board stop working. Can anyone assist?
This is the error message I get:
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 ib1members m
LEFT JOIN ib1groups g ON (g.g_id=m.mgroup)
LEFT JOIN ib1moderators mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup )
WHERE m.id='3'
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: Thursday 13th of January 2005 10:34:10 AM
This is the error message I get:
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 ib1members m
LEFT JOIN ib1groups g ON (g.g_id=m.mgroup)
LEFT JOIN ib1moderators mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup )
WHERE m.id='3'
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: Thursday 13th of January 2005 10:34:10 AM