Buying Need help to fix MySQL vBulletin Error

Discussion in 'Programming' started by Dave Hybrid, Dec 12, 2010.

  1. #1
    I recently uninstalled an old MOD in vBulletin and now my database is throwing this error every few hours; Let me know if you can fix this and what you would want for doing so. Thank you.

    Database error in vBulletin 3.8.6:

    Invalid SQL:

    SELECT postid
    FROM post AS post
    INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
    WHERE post.post_thanks_amount != 0
    AND thread.forumid IN(3,10,43,42,45,44,47,40,41,46,39,11,48,49,59,50,38,31,52,53,54,77,76,6,7,61,12,8)
    ORDER BY post.dateline DESC
    LIMIT 500;

    MySQL Error : Unknown column 'post.post_thanks_amount' in 'where clause'
    Error Number : 1054
    Request Date : Sunday, December 12th 2010 @ 01:15:00 PM
    Error Date : Sunday, December 12th 2010 @ 01:15:00 PM
    Script : http://www.computer-juice.com/forums/post_thanks.php?do=findallthanks
    Referrer :
    IP Address : 66.249.71.100
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
     
    Dave Hybrid, Dec 12, 2010 IP
  2. wpfan

    wpfan Member

    Messages:
    64
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Are you still having this problem?
     
    wpfan, Dec 13, 2010 IP
  3. yanton

    yanton Peon

    Messages:
    508
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    66.7% - 2
    #3
    wpfan - are you a vbulletin expert - i have an annoying problem with javascript error that i cannot cure.
     
    yanton, Dec 20, 2010 IP