Edit Options not working anymore!

[KeithMcL]

Since installing some new hacks to my forums, the Edit Options section of the forums is not working anymore.

I did originally install the "Receive Community Bulletin" hack before version 2.2.1 was released and have also installed the "Compact threads when read" hack. Can either of these cause this problem do you know? When I submit the page it loads a blank page with all the editoptions in the URL and nothing else.

Anyone got any ideas?

URL: www.webdevforums.com

[KeithMcL]

I'm also unable to make any changes to the permissions of members (or myself) now either :(

Getting the error:
Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid=191
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 2

mysql error number: 1064Anyone got any ideas?

[Lesane]

"awaydate" comes from the away hack from Bira. You should check the thread for an solution or post your problem in the thread:

https://vborg.vbsupport.ru/showthread.php?s=&threadid=33099

[KeithMcL]

Thanks for your help Lesane. I got the problem fixed. Would you believe it was down to one single , ????

[JamesUS]

Try changing the word 'GET' in your modifyoptions template to 'POST'. That should fix your first problem.

[Admin]

Most erros are down to a single , ; or ". :)