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]

Originally Posted by markbolyard

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.