Doron, can you help me? I got this error when I ran the updatepoll.php - the weird thing is that my directory is not /usr/local/apache/sites...

But my board is still functional so I don't know what this is about!

<!-- Database error in vBulletin: Invalid SQL: ALTER TABLE thread ADD poll SMALLINT (1) DEFAULT '0' not null
mysql error: Duplicate column name 'poll'
mysql error number: 1060
Date: Saturday 02nd of December 2000 08:33:54 PM
Script: /updatepoll.php
Referer:
-->

Warning: Cannot add header information - headers already sent by (output started at /usr/local/apache/sites/***.com/htdocs/updatepoll.php:7) in /usr/local/apache/sites/***.com/htdocs/global.php on line 754

Warning: Cannot add header information - headers already sent by (output started at /usr/local/apache/sites/***.com/htdocs/updatepoll.php:7) in /usr/local/apache/sites/***.com/htdocs/global.php on line 757
Editing thread table ...

[Edited by Me2Be on 12-02-2000 at 07:44 PM]

Me2b, I had a kind of similar problem than the one you mention in you last 2 quotes.

Check my recent thread:
http://www.vbulletin.com/forum/showt...?threadid=5041

I'm sure you have the same blank lines problem.

Benj

[Edited by Benj on 12-02-2000 at 08:37 PM]

Benj, I just tried checking for blank spaces and couldn't find anything. The weird thing is that the board is working fine - It just gives me the error when I run the updatepoll.php file

ALTER TABLE thread ADD poll SMALLINT (1) DEFAULT '0' not null

look for that and comment it ouy with a //, you seem to already have the poll column in thread. As for the other error, that other thread seems to cover it.

you probably got the 2nd error once, retried the updatescript, but it succedded the first time to create that column. What sort of system are you on?

Right... could I have a copy of the templates or an edited makepolltables.php file that just does the templates and does not add any tables...

thanks

just comment out (by putting a // infront of the line) the lines where the tables are created ie ALTER etc. The onlyones you need are the INSERT lines.

Cheers... it was a problem with my header as well.
But it all works fine now.

doron, commenting out that line worked perfectly! I still got that header error even after making sure there was no white space, but nevertheless, it still worked!

Thanks doron!

hmm, the header issue is wierd, I'll try to reproduce. Are you all running php4?

php4 for me! But like I said, it did work though!