PDA

View Full Version : I have vote error ---> need help


alfahad1
11-08-2008, 09:26 AM
Hi all,

this is the content of the error message:

=================================================
Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT IGNORE INTO pollvote
(pollid, votedate, voteoption, userid, votetype)
VALUES
(31, 1226142956, 1, 1, 0);

MySQL Error : Unknown column 'votetype' in 'field list'
Error Number : 1054
Request Date : Saturday, November 8th 2008 @ 03:15:56 AM
Error Date : Saturday, November 8th 2008 @ 03:15:56 AM
Script : http://www.***.net/poll.php?do=pollvote&pollid=31
Referrer : http://www.***.net/showthread.php?t=13347
IP Address : 195.229.241.172
Username : ******
Classname : vb_database
MySQL Version : 5.0.51a-community
=================================================

Any one have an idea, I tried to disable all plugins and it didn't work!

Waiting for your replies.

Lynne
11-08-2008, 02:26 PM
It seems you didn't successfully run the upgrade script. That column was added sometimes between 3.6.8 and 3.7.3 (not sure where). vb.com will probably know the correct query to run to add that column.

alfahad1
11-11-2008, 07:51 PM
So, what should I do now!

Lynne
11-11-2008, 08:40 PM
Um, well, I suggested that vb.com would probably know the correct query, so probably your best bet is to head over there and post this same question.