i keep getting this database error when trying to withdraw nominations as wee as trying to view all nominations:
Code:
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT userid, username, usertitle, nominate_topic_user_amount, nominate_topic_nominated_posts, nominate_topic_nominated_times, nominate_topic_nominated_awards FROM user WHERE nominate_topic_nominated_awards > 0 ORDER BY nominate_topic_nominated_awards DESC LIMIT 0,2;
MySQL Error : Unknown column 'nominate_topic_nominated_awards' in 'field list'
Error Number : 1054
Request Date : Tuesday, July 8th 2008 @ 09:15:18 AM
Error Date : Tuesday, July 8th 2008 @ 09:15:18 AM
Script : http://mydomain.net/forums/nominate_topic.php?do=shownominationawardswinners
Referrer : http://mydomain.net/forums/passwords/491-biggest-list-more-than-10000-passes.html
IP Address : removed
Username : admin
Classname : vB_Database
MySQL Version : 4.1.22-standard
anyone else having this problem and know how to fix this?