UserCP Database Error When Clicked On

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SoberNClean
    Senior Member
    • Sep 2007
    • 215
    • 3.8.x

    UserCP Database Error When Clicked On

    Yes we just suddenly started to receive database errors on our forums when we click on UserCp it goes straight to a database error. I don't know how long it has been going on, it only emails errors when someone clicks on their UserCP so we need some help please.

    Here is the error code....



    Database error in vBulletin 3.8.7:

    Invalid SQL:
    SELECT user.username, quote.*, post.threadid, thread.title
    FROM quotedatanew As quote
    LEFT JOIN post AS post ON(quote.postid = post.postid)
    LEFT JOIN thread AS thread ON(post.threadid = thread.threadid)
    LEFT JOIN user AS user ON(user.userid = quote.quoter)
    WHERE quote.quoted = '82' ORDER BY quote.dateline DESC LIMIT;

    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
    Request Date : Tuesday, April 24th 2012 @ 02:47:12 PM
    Error Date : Tuesday, April 24th 2012 @ 02:47:12 PM
    Script : http://www.justfortodaymeditations.c...ums/usercp.php
    Referrer : http://www.justfortodaymeditations.com/forums/
    IP Address : 66.231.113.236
    Username : cudmolinski
    Classname : vB_Database
    MySQL Version :

  • Matthew Gordon
    Senior Member
    • May 2002
    • 3243
    • 1.1.x

    #2
    "quotedatanew" is not a default vBulletin table, therefore this looks like an error caused by one of your addons. Try disabling your addons one at a time until the error stops and ask for support for the problem addon at vBulletin.org.

    Comment

    • SoberNClean
      Senior Member
      • Sep 2007
      • 215
      • 3.8.x

      #3
      Originally posted by Matthew Gordon
      "quotedatanew" is not a default vBulletin table, therefore this looks like an error caused by one of your addons. Try disabling your addons one at a time until the error stops and ask for support for the problem addon at vBulletin.org.
      Thank You and I knew which one to go too

      Appreciate the help

      Comment

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