PDA

View Full Version : Mysql Error


The Realist
02-24-2006, 07:25 PM
Well Im no good at errors, so can anyone give any pointers to a fix.

Only my members see this error, staff dont see it.

Invalid SQL:
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
customavatar.width, customavatar.height
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 6
Error Number : 1064
Date : Friday, February 24th 2006 @ 07:16:59 PM
Script : http://www.tech-tronix.com/forum.php
Referrer :
IP Address :
Username :
Classname : vb_database

HELP

Laters

Anyone have any ideas how to solve this error?

Marco van Herwaarden
02-25-2006, 09:23 AM
WHERE user.userid =;
Make sure a userid is supplied.

The Realist
02-25-2006, 11:13 AM
What ya mean?

As I said in my post, im not that cleaver on solving these errors M8.

Laters

Marco van Herwaarden
02-25-2006, 11:19 AM
Well i can only explain what the error means. I don't know what you changed on your board to cause it though.