Database Errors

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aristor
    Member
    • Sep 2013
    • 51
    • 5.0.X

    Database Errors

    What causes this error?

    Code:
    [FONT=-moz-fixed][SIZE=14px] Database error in vBulletin 5.1.0:  
    Invalid SQL: SELECT DISTINCT node.nodeid, node.contenttypeid FROM vb5_node AS starter INNER JOIN vb5_node AS node ON (node.starter = starter.nodeid) WHERE (  )AND node.contenttypeid NOT IN (27,23) ORDER BY node.publishdate DESC LIMIT  20;  
    
    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 node.contenttypeid NOT IN (27,23) ORDER BY node.publishdate DESC LIMIT  20' at line 4
    Error Number  : 1064
    Request Date  : Saturday, April 26th 2014 @ 09:31:28 PM
    Error Date    : Saturday, April 26th 2014 @ 09:31:28 PM
    Script        : [URL="http://privatemessage/index"]http:///privatemessage/index[/URL]
    Referrer      : [URL]http://www.akdenizmotosiklet.org/privatemessage/index[/URL]
    IP Address    : 94.123.60.86
    Username      : Akil
    Classname     : vB_Database_MySQLi MySQL Version :  [/SIZE][/FONT]
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73978

    #2
    Change the "Can Publish" option for registered users to the opposite of what it is now and save.

    Usergroups -> Usergroup Manager.
    Translations provided by Google.

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

    Comment

    • aristor
      Member
      • Sep 2013
      • 51
      • 5.0.X

      #3
      Thank you Luke...

      Comment

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