Announcement

Collapse
No announcement yet.

Error on only one member page....

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

  • 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...

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

    Comment


    • #3
      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!

      Comment


      • #4
        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?
        Best Regards,
        Andy Huang

        Comment


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

          Comment

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