Announcement

Collapse
No announcement yet.

vBulletin Database Error!

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

  • Paul M
    replied
    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.

    Leave a comment:


  • Wayne Luke
    replied
    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.

    Leave a comment:


  • winky8300
    replied
    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

    Leave a comment:


  • malcolmtay
    replied
    Vesrion 4.2.1
    php 5.3.29
    MySQL 5.5.42-cll

    cHEERS

    Leave a comment:


  • Wayne Luke
    replied
    What version of vBulletin, PHP and MySQL are you using?

    Leave a comment:


  • malcolmtay
    started a topic vBulletin Database Error!

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X