Vote Error !

[alserb]

Hi All,

When we try create a vote we can not and appears for us the next Error :

Database error in vBulletin 3.5.1:

Invalid SQL:
INSERT INTO poll
(question, dateline, active, timeout, multiple, public, numberoptions, options, votes)
VALUES

MySQL Error : Unknown column 'multiple' in 'field list'
Error Number : 1054
Date : Friday, December 2nd 2005 @ 01:17:34 AM
Classname : vb_database
---------
And i asked somebody and he told me :

There is no 'multiple' field in the default vB 3.5.1 poll table. This error is from a hack you've installed. To fix this you will need to remove your hacks and reupload the original files.

Now i reuploaded all the original files but before i remove any hacks, i need ask if you have any idea here !!!

Regards

[merk]

Do you have any plugins installed?

[Marco van Herwaarden]

Wrong, there is a multiple column in default poll table.

How did you install your board? Fresh install or an upgrade?

[alserb]

Hello all again,

merk
Yes, i installed 3 plugin:
TOP 5 STATS, Members who have visited today and bbcode ( ToolBox )

But Please note that i have another forum and by it the same plugins and more and it does not find by it the same problem, believe that the problem in the database to this shows the mistake this way.

MarcoH64
Is his reply is WRONG appeared : ) !
I have upgraded it to latest version.

Please Help us this issue.

Regards,

[Marco van Herwaarden]

From what version did you upgrade and to what version?

Both 3.5.1 and 3.0.10 do have a multiple column.

[alserb]

MarcoH64

I upgraded it from version 3.0.3 to the latest one 3.5.1

[Marco van Herwaarden]

Then you should have that column. I don't have a 303 database on my machine at the moment, but will try to check later.

In the mean time i suggest you post this at vb.com. It might be a problem with the upgrade script.

[alserb]

MarcoH64,

Thank you and i'm waiting your help

Please check you PM here :)

Regards,

[Marco van Herwaarden]

Checked and replied.

PS You could remporary solve this by adding the column to your Poll table, but this could frustrate the handling of the Support Ticket:
ALTER TABLE poll ADD COLUMN multiple smallint(5) unsigned NOT NULL default 0;

[Marco van Herwaarden]

Just installed a 303 database again, and even in that version the 'multiple' column in the Poll table already exists. So either i am getting crazy (which would not be a surprise :D) or someone else is overlooking something.

[alserb]

MarcoH64,
A truth I do not know how I thank you for this wonderful support and this more beautiful work.

The problem is resolved and FIXED .
Kind Regards,