Not sure if I can post this here or not. I'm just making some rounds from links I found from a Google search.
Anyways, about a month ago my IPB forum went on the fritz for no apparent reason (I am the only one with admin access and had not used or done anything from the admin panel in almost 6 months.). The forums are all there and intact, but upon logging in, I and other members receive the white error screen with the "Mysql Error" box and this is the error it gives.
I am completely unable to decipher this and am hoping that someone with a better knowledge of Mysql or IPB can translate and prescribe a fix (if there is one). This is a community forum for gaming friends that has been online and active for over 2 years now and we have a good deal of memories on it. Sadly I neglected my admin duties of making backups of the forum in the event that this happened.
Thanks for any and all help that can be offered.
Code:
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: Sunday 12th of August 2007 02:37:19 PM