Announcement

Collapse
No announcement yet.

vBulletin Database Error! :: cron.php error regularly since I upgraded to 3.5.4

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

  • vBulletin Database Error! :: cron.php error regularly since I upgraded to 3.5.4

    Hello,

    Ever since I upgraded to 3.5.4, I have been getting this database error report via email each day --

    Database error in vBulletin 3.5.4:

    Invalid SQL:

    SELECT user.userid, user.usergroupid, username, email, activationid, user.languageid
    FROM user AS user
    LEFT JOIN useractivation AS useractivation ON (user.userid=useractivation.userid AND type = 0)
    WHERE user.usergroupid = 3
    AND ((joindate >= 1142007748 AND joindate <= 1142094148) OR (joindate >= 1141662148 AND joindate <= 1141748548))
    AND NOT (user.options & );

    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 6
    Error Number : 1064
    Date : Sunday, March 12th 2006 @ 11:22:28 AM
    Script : http://www.nutformen.com/theclub/cron.php?&rand=150335
    Referrer : http://www.nutformen.com/theclub/online.php
    IP Address : 59.95.162.75
    Username : Unregistered
    Classname : vb_database
    Any guesses where I might have screwed up?
    =)

  • #2
    For syntax errors in queries, you should try uploading the original PHP files and disabling any plugins you have installed.

    Comment

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