Database error, and user info tabs dissapear.

[krizg]

Need some help again.

Every time someone tries to look at my profile (user 1) they get a database error, just saying the forum database has encounter a problem. Then on the admins email i get the following :

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb

FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 1
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'

ORDER BY RAND()
LIMIT 0, 1.399;

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 '1.399' at line 13
Error Number : 1064"

Now this only happens when trying to see user's 1 profile, not with any other profile, any clues?

And also when looking at any profile with Internet Explorer 8 the tabs on user profiles don't show up (stats, about, contact, etc.) but with firefox they show up with no problem.

Thanks for any help.

[snakes1100]

I find it easier to check the user out in phpmyadmin as well, check all fields for that user, notably around 1.399

Do you have hacks installed relating to users?

[noppid]

Find out what variable is used to generate the 1.399 value. That should not be a decimal number. It needs to be run though round() or ceil() or something to make it a non decimal integer.

[krizg]

The hacks I had relating to users, was Log in as User for admin, I disabled it and all it did was show the actual error to the users looking at the profile.
The other hack relating to users was the Automatically Added Friend that came with vbulletin, I also disabled and it did nothing. And I have no clue as to how to find out what's generating the 1.399 value

[snakes1100]

You can use phpmyadmin and remove it from the field to quick fix it.

I have seen that behavior on another board, but it was actually leaving a comma after removing a user from a extra usergroup.

[krizg]

Sorry, remove what from the field snakes1100?

[snakes1100]

Go to the user table in your db and then browse the table, edit your record in the table, check and see if 1.399 is set there, if it is, you can remove it.

Remember to backup before modifying your db manually.

[krizg]

ohh already tried that but I cant find 1.399 anywhere on the table

[snakes1100]

Can you view the profile using a default style with no parent set?

[krizg]

Nop, same error even when looking with default style.