Announcement

Collapse
No announcement yet.

vBulletin Database Error!

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

  • 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

  • #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 - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      Vesrion 4.2.1
      php 5.3.29
      MySQL 5.5.42-cll

      cHEERS

      Comment


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


        • #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 - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment


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