Avatar(forumhome) problem with me...

[The Chief]

I am having a problem with MySql and avatars when I visit the forum home page. This is the error that i get whenever I am logged in and visit the forumhome.



Database error in vBulletin 3.5.2:

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 : Tuesday, December 27th 2005 @ 11:18:44 PM
Script : http://www.myetalk.com/forums/index.php
Referrer : http://www.myetalk.com/forums/login.php
IP Address : 69.156.33.211
Username : The Chief
Classname : vb_database



Can anybody help me with this??

[markbolyard]

Go to phpmyadmin and run this query:

ALTER TABLE customavatar CHANGE filedata filedata MEDIUMBLOB NOT NULL

That should fix your problem.

Mark

[The Chief]

Go to phpmyadmin and run this query:

ALTER TABLE customavatar CHANGE filedata filedata MEDIUMBLOB NOT NULL

That should fix your problem.

Mark

well its fixed now and I didn't do anything, thanks for the offer though haha, I will be sure to run this if I ever encounter the problem again or if one of my members do, thanks! :)

[markbolyard]

Great. This is a past problem with 3.5.1, but since you are on 3.5.2, that should have fixed it. Anyway, glad you got it running.

[Marco van Herwaarden]

An empty userid in the WHERE clause is not caused by the datatype of a column.