Announcement

Collapse
No announcement yet.

Error on only one member page....

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • buurmannetje
    replied
    No, it was a normal 1044, after changing it to 999 it worked again, no strange decimal or anything.

    Leave a comment:


  • Andy Huang
    replied
    I'll have to check... Though, off the top of my hand, I don't think 1044 friends would've caused the problem... are you sure it wasn't 1.044 or something with a fancy decimal place?

    Leave a comment:


  • buurmannetje
    replied
    Originally posted by Andy Huang View Post
    Check your database to see that user's friendcount have gone crazy. The limit shouldn't have a decimal value.
    You were absolutely right!!!

    The friendslist reached 1044 and then crashed his profile.
    I changed it to 999 and it works again.

    Is it possible to change this, I let them clean theyre "friends" anyway, but better to prevent then cure....

    Thanks for the support!

    Leave a comment:


  • Andy Huang
    replied
    Check your database to see that user's friendcount have gone crazy. The limit shouldn't have a decimal value.

    Leave a comment:


  • buurmannetje
    started a topic Error on only one member page....

    Error on only one member page....

    DB Error on only one member page:

    --------------

    Database error in vBulletin 3.8.3:

    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 = 163
    AND userlist.type = 'buddy'
    AND userlist.friend = 'yes'

    ORDER BY RAND()
    LIMIT 0, 1.04;

    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.04' at line 13
    Error Number : 1064
    Request Date : Tuesday, August 11th 2009 @ 10:18:04 AM
    Error Date : Tuesday, August 11th 2009 @ 10:18:04 AM
    Script : http://www.pieppiep.nl/forum/member.php?u=163
    Referrer : http://www.pieppiep.nl/forum/memberlist.php?do=getall
    IP Address : ********
    Username : *******
    Classname : vB_Database
    MySQL Version : 5.0.32-Debian_7etch10-log

    -----

    All other member pages are working normally.
    Anyone know how to fix this?

    Thx...
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X