vBulletin Database Error!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • malcolmtay
    Member
    • Jan 2015
    • 34
    • 4.2.x

    vBulletin Database Error!

    I got this error below does anyone know how to fix it

    SELECT post.*,userfield.*, usertextfield.*, user.*, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,
    customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height,
    customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb
    FROM vB_post AS post
    LEFT JOIN vB_user AS user ON (user.userid = post.userid)
    LEFT JOIN vB_userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN vB_usertextfield AS usertextfield ON (user.userid = usertextfield.userid)
    LEFT JOIN vB_avatar AS avatar ON (avatar.avatarid = user.avatarid)
    LEFT JOIN vB_customavatar AS customavatar ON (customavatar.userid = post.userid)
    WHERE post.postid IN (.);

    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 10
    Error Number : 1064
    Request Date : Wednesday, May 6th 2015 @ 01:11:05 AM
    Error Date : Wednesday, May 6th 2015 @ 01:11:05 AM
    Script : http://jandeane81.com/search.php?searchid=733031
    Referrer : http://jandeane81.com/search.php
    IP Address : 207.91.13.126
    Username : Unregistered
    Classname : vB_Database MySQL Version
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73976

    #2
    What version of vBulletin, PHP and MySQL are you using?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • malcolmtay
      Member
      • Jan 2015
      • 34
      • 4.2.x

      #3
      Vesrion 4.2.1
      php 5.3.29
      MySQL 5.5.42-cll

      cHEERS

      Comment

      • winky8300
        Member
        • Oct 2013
        • 44
        • 4.2.X

        #4
        Hello
        I allows me to revive this discussion because I have the same error

        php :5.6.9-0+deb8u1

        mysql : 5.5.44-0+deb8u1

        thank you for your help

        Comment

        • Wayne Luke
          vBulletin Technical Support Lead
          • Aug 2000
          • 73976

          #5
          If you have the exact same error, I advise upgrading to vBulletin 4.2.3. vBulletin 4.2.1 is not compatible with PHP 5.6.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

          • Paul M
            Former Lead Developer
            vB.Com & vB.Org
            • Sep 2004
            • 9886

            #6
            The error is that you have no postids in the query

            Code:
            WHERE post.postid IN (.);
            Its unlikely thats related to the php version, more likely some modification.
            Baby, I was born this way

            Comment

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