Poll hack problem !

Hello,

After installing the poll hack and when I run makepolltables.php to make sure it's installed properly I received this error message:


Editing post table ...
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
-----------------------
By opening the source for this error page I found this :

--------------
Editing <i>post</i> table ...
<!-- Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: Duplicate column name 'pollid'
mysql error number: 1060
Date: Monday 23rd of October 2000 10:14:51 PM
Script: /vb/makepolltables.php
Referer:
-->
---------------

And no I didn't receive any e-mail !!

How can I solve this problem??

sometimes it means you already have the tables installed!

But there are no templates created !!

eh sorry I dont know


Jump in pros?

Open makepolltables.php

first entry is:

echo "Editing <i>post</i> table ... ";
//$DB_site->query("ALTER TABLE post DROP pollid");
$DB_site->query("ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null");

change

//$DB_site->query("ALTER TABLE post DROP pollid");

into

$DB_site->query("ALTER TABLE post DROP pollid");

this will delete the pollid column. Be warned, if you had polls before, they will die.

Thanks doron that works and the templates are created.However,when I tried to post a new poll it give me this database error:
-------------
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
-------------
And this is in the page source :
------------
Database error in vBulletin: Invalid SQL: INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,p ostusername,lastposter,dateline,iconid,visible) VALUES
mysql error: You have an error in your SQL syntax near '1)' at line 1
mysql error number: 1064
--------

??!!

Could I have a url of your board?

Also, what version of the vB are you running?

Hi doren..

My problem same theGAME but you told me that i have to do some thing with ALTER TABLE .

Why ?

Originally posted by dellow
My problem same theGAME but you told me that i have to do some thing with ALTER TABLE .

Why ?

Your email message told you that the alter command had been denied. The error screen that pops up on your browser is a generic error screen given for all data base probs with vbulletin (I know I have seen that screen about 200 times in the last three weeks)