vb.org Archive - Edit Options not working anymore!

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Edit Options not working anymore! (https://vborg.vbsupport.ru/showthread.php?t=34401)

KeithMcL

01-23-2002 02:17 PM

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

01-31-2002 08:51 AM

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

Getting the error:

Quote:

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: 1064

Anyone got any ideas?

Lesane

02-01-2002 06:41 AM

"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/showthrea...threadid=33099

KeithMcL

02-07-2002 03:28 PM

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

JamesUS

02-07-2002 03:32 PM

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

Admin

02-07-2002 03:32 PM

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

All times are GMT. The time now is 11:34 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01180 seconds Memory Usage 1,718KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: