Problems After Hack Installation

I've recently installed a large number or hacks from VB.org onto my board, and I'm now experiencing some problems. Firstly, I am unable to add/remove moderators from forums via my admin CP, and secondly, no one can alter their avatars, even if I try via my admin CP.

Please advise...

URL: http://www.expandyourmental.com/forum

Thanks for the help...

Del

[Admin]

(Obvious questions) What happens when you try to mess with moderators, and the same with avatars.

[Del]

I dunno, what happens?

Anyway, here's the error I get when I try and edit/add a moderator:

Invalid SQL: SELECT forumid,userid,newpostemail,newthreademail,canedit posts,candeleteposts,canviewips,canmanagethreads,c anopenclose,caneditthreads,caneditstyles,canbanuse rs,canviewprofile,canannounce,canmassmove,canmassp rune,canmoderateposts,canmoderateattachments,caned itaccess FROM moderator WHERE moderatorid=47
mysql error: Unknown column 'caneditaccess' in 'field list'

mysql error number: 1054

Date: Sunday 03rd of March 2002 08:18:58 PM
Script: http://www.expandyourmental.com/foru...moderatorid=47
Referer: http://www.expandyourmental.com/foru...?action=modify


When I try to change an avatar via my CP, it just returns me to the page I was on previously after I've pressed 'Save Changes' or whatever, and if any user tries to edit his/her avatars, they get a 'password retrieval' screen.

Any help would be appreciated...

Del

[Admin]

Open modifyoptions and change method="post" to method="get", that should fix the problem for your users.

The mods problem is because you haven't ran a query that you needed to when you installed a hack (I'm guessing it was the mods can edit access masks hack, according to the column name at least).

[Del]

Thanks a lot Firefly...

Now how do I run a query?

[Del]

Ahhhhh....

Editing the modifyoptions like you said just produces a blank screen??