Anyone familiar with IPB?

For some strange reason, my moderators have access to all mod functions, but not the mod cp.

My admins are getting this error:

Quote:

---

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((m.id=mod.member_id or (mod.is_group=1 and mod.group_id=m
mySQL error code: 1064

---

i get that it's some kind of syntax error.


someone suggested that it's because mySQL has reserved the word "mod" and i should go through all that php code and change any instances of the word "mod" to "mods".

however...

why did it work before? nothing has changed. nobody has been monkeying around with the code at all.

we did have a problem where our whole board was down for a couple of weeks (inexplicably, our host is less then forth coming with information or help for that matter), but i don't think it could be a corrupted database... could it?

that wouldn't produce that error code, right?

i'm so confused. my poor pregnant brain is muddled.