(User CP) Database Error vBulletin 3.0.6: Invalid SQL

Discussion in 'Software' started by mystique-topaz, Dec 13, 2007.

  1. mystique-topaz

    mystique-topaz Private E-2

    I am an admin/member of another board which also has the "User CP" option like the one on this board. I have been getting the following error when clicking on the User CP link at the top of my board:

    Database error in vBulletin 3.0.6:
    Invalid SQL:
    SELECT thread.threadid, thread.forumid
    FROM thread AS thread, subscribethread AS subscribethread
    LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
    WHERE subscribethread.threadid = thread.threadid
    AND subscribethread.userid = 2
    AND thread.visible = 1
    AND lastpost > 1197542220
    AND deletionlog.primaryid IS NULL
    mysql error: Unknown column 'thread.threadid' in 'on clause'
    mysql error number: 1054
    Date: Thursday 13th of December 2007 03:33:01 AM
    Script: http://www.xxxxxx.xxx/forums/usercp.php?
    Referer: http://www.xxxxxx.xxx/foru...read.php?t=5639
    Username: (my username)
    IP Address: xxx.xxx.xxx.xxx

    I apologize in advance if I have hit the wrong forum with this, but if anyone could shed some light on a fix to this, it would be greatly appreciated.

    Thank you.
     
  2. plodr

    plodr MajorGeek Super Extraordinaire Moderator Staff Member


MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds