Announcement

Collapse
No announcement yet.

Database Error (mySQL errors.)

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

  • Database Error (mySQL errors.)

    The error:

    Code:
    Database error in vBulletin 3.8.1:
    
    Invalid SQL:
    
                           SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
                           FROM vb_thread AS thread
                           INNER JOIN vb_tagthread AS tagthread ON
                                   (tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)
                           WHERE thread.forumid IN()
                                   AND thread.visible = 1
                                   AND thread.sticky IN (0, 1)
                                   AND thread.open <> 10
                           GROUP BY tagthread.tagid;
    
    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 ')
                                   AND thread.visible = 1
                                   AND thread.sticky IN (0, ' at line 5
    Error Number  : 1064
    Request Date  : Saturday, March 21st 2009 @ 02:00:51 AM
    Error Date    : Saturday, March 21st 2009 @ 02:00:57 AM
    Script        : http://ploxage-scape.com/forums/cron.php?rand=1237618848
    Referrer      : http://ploxage-scape.com/forums/guides-tutorials/2932-99-range-guide-beginners.html
    IP Address    : 202.154.144.244
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    Any advice to how it happens?
    How to stop it?
    Feedback?
    Etc...

  • #2
    When you log into your Admin CP does it say:
    MySQL is running in strict mode. While you may proceed, some areas of vBulletin may not function properly. It is <em>strongly recommended</em> that you set
    Code:
    $config['Database']['force_sql_mode']
    to true in your includes/config.php file!
    ?

    If it does then please update that value.
    Translations provided by Google.

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

    Comment


    • #3
      No, it does not say that.

      Comment


      • #4
        Contact the provider of your URL Rewriting addon and make sure you are using the latest version.
        Translations provided by Google.

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

        Comment

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