vb.org Archive - 1064 Error When Trying to View Own Profile

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

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - 1064 Error When Trying to View Own Profile (https://vborg.vbsupport.ru/showthread.php?t=79930)

The Equivocate

04-14-2005 07:49 PM

1064 Error When Trying to View Own Profile

When you try and view your own profile, you get this error:

Quote:

Invalid SQL:
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid =
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 '' at line 5

mysql error number: 1064

tnguy3n

04-15-2005 12:33 AM

Quote:

Originally Posted by The Equivocate

When you try and view your own profile, you get this error:

Did you install any hacks that alter the code of your member.php file?
There's a null value , which gives that error, in WHERE clause.

The Equivocate

04-15-2005 06:22 PM

So it would be an edit in member.php? I mean, I've figured out that the vBookie hack is causing it, but that hack doesn't alter member.php... what part of the vBookie hack would make the change that causes that error?

All times are GMT. The time now is 04:13 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01006 seconds Memory Usage 1,712KB 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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: