I have to warn you guys first, I'm a total newbie, I haven't got the faintest idea what I'm talking about :). I'm planning on learning the basics soon though, but in the meantime, I'm relying on you here ;)

When I run makepolltables.php (after having done everything in the readmethingy), I get the following error:

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.


And this is the email I recieve:

Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: Access denied for user: 'kroet@localhost' to database 'kroet'
mysql error number: 1044
Date: Thursday 14th of December 2000 01:47:30 PM
Script: /~kroet/murmellius/makepolltables.php
Referer:

Er? Prolly some basic, newbie, mistake on my side, but I'm curious anywayz :)

seems you have no permissions to alter tables...also, are you running it form the main vB directory?

I'm running it from the forum main dir, and should have all the permissions I need on the server. I found out that makepolltables.php seems to be looking for *.php files instead of the *.php3 files I have on the server. It's 1.0.1.3 btw, but I thought I used the 1.0.1.3 manual readme thingy.

i have not done a .php3 version, you should just do a search and replace in all the files, that should help.

btw, it's 1.1.3

Errr. I knew that. I don't remember why I typed it wrong then ;)

I'll try the search 'n replace now :)

I did the search 'n replace, which didn't work. Still got the following email:

Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: Access denied for user: 'kroet@localhost' to database 'kroet'
mysql error number: 1044
Date: Saturday 16th of December 2000 02:24:47 PM
Script: /~kroet/murmellius/makepolltables.php3
Referer:

So I think it must be the acces stuff. I don't see how it could be wrong though, since makepolltables.php3 requires global.php3 for the password etc, which requires /admin/config.php3 for the password. So, that should work. Hummzz

my best guess is, you have no alter access. Is this a dedcated or a shared server? Also, have you installed any other hacks?

This is the first hack I installed. And I don't know if it's a shared one.

http://www.marmoset.net

I'll have a look

[EDIT]

Couldn't find it :|

[/EDIT]

[Edited by KroeT on 12-17-2000 at 09:45 AM]

you better contact your host and ask them for alter privilidges for mysql...

Will do

Hii

doron ..Where is the zip file of this hack ??

:(:)

I may be going nuts but here is the whole story in a nutshell.

I had vB 113 and the older poll hack from october. Cant remember the version number. I upgraded to vB ver.114. During this time I also moved servers. Worst came to worst... I created a back up of the vB data base. On the new server I installed 114 instead of doing a 113 to 114 upgrade. I imported the tables and all.

Now yesterday I download the latest release of Poll Hack. I read the intructions not thinking about theolder verison I had installed befor ethe server move and before the 114 upgrade. I follow the instruction for the 114 install cause I did not see in the MySQL tables any of the tables that were there from when I did the install of Poll hack on 113.

I get the following error running makepolltables.php

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.


I get the following in an email:

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 18th of December 2000 11:14:58 AM
Script: /makepolltables.php
Referer:

Ok now the fun part. After reviewing the tables and not finding any reference to Poll hack install. I decided to try the upgrade from older version as in the instructions. Still I get the error as above.

I am lost. I need some where to be pointed.

Anyone?

first - the hack is at vbulletin.org

this means you already have the poll hack installed (at least in the db). Do you have a poll table and does it contain anything? Try running the upgrade script in stead...

No there is not a poll table in there :(


I went through and looked and there is no table with Poll in it.

I have also tried the upgrade and it did not work either.
What can I do at this point. I would really like to have poll hack on the board.

so, you don't have any old polls? If not, simply remove the pollid column from the post table

Doron,

I have removed the poll id from the post table and tried once again.

THis is the error that I have gotten now when trying to run makepoll....

Editing post table ... Editing thread table ... Done!
Editing usergroup 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.

Did a refreash and I got the same error.

This is what I got in the Email:

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup ADD canpostpoll SMALLINT (6) DEFAULT '0' not null
mysql error: Duplicate column name 'canpostpoll'
mysql error number: 1060
Date: Tuesday 19th of December 2000 04:54:30 PM
Script: /makepolltables.php
Referer:

I also tried it once again and did the items you stated and then did the following: removed poll from thread table as well as canpostpoll from usergroup table.

Upon doing this and retrying I get the following:

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.

The email is as follows.
Database error in vBulletin: Invalid SQL: INSERT INTO template (templateid,title,template) VALUES (NULL,'editpoll','<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd"> $cssinclude

Then I got this email:
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: Tuesday 19th of December 2000 05:05:50 PM
Script: /makepolltables.php
Referer:

I just want to say I appreciate the help Doron.

[Edited by GMTalk on 12-19-2000 at 06:06 PM]

seems you have some fields from the poll hack and some not...

delete the poll table
drop the pollid in post
drop the canpostpoll in table usergroup
drop the poll column in the thread table
drop the table pollvote

you might also want to delete the templates as well, they are listing in the file. If you still are having problems, mail me and I will send you a script that will automatically do it.

hi,

The only problem i have is when i created a poll, and then try to vote, i get this:

No forum specified. If you followed a valid link, please notify the webmaster.

Anybody has the same problem as me? or know how i can fix this, thnx

i'm using vB1.1.3

when did you download the poll? this was the bug about a variable not being escaped in the install script.

In the pollvote template, look for <INPUT TYPE=hidden name=threadid VALUE=
there should be a $threadid in the VALUE=""

ok Doron,

here is what I run into now. I followed all your instructions removed all traces of Poll hack and all templates associated with it. Run makepolltables.php get the following:

Editing post table ... Editing thread table ... Done!
Editing usergroup table ... Done!
Creating table poll..
Creating table pollvote..
FINISHED!
Creating templates...

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.


I deleted the make polltables.php and then gave myself the rights to create polls as instructed.

I pull up the forum to test and enter the
poll.php?action=newpoll&forumid=x with the x being the forum ID and all O got was a blank screen. ALl other areas and tests were fine for the posting of messages and all. Just when I try the polls I get a blank screen

Any suggestions.

what error occured on the template creation?

Doron,

The error above is the only error that I got. I went through and deleted all exsistance of the Poll hack once again and I get to the point of install it in and get the same error as above.

I go in to look at the templates before I do anything and they are not there. THey were not created. That could have explained the blank screen.

I htink I am bald now. I have no hair left. :)

i meant, what does the error look like in real (ie, the email that got sent, or simply view the source of the page to get the error?)

Database error in vBulletin: Invalid SQL: INSERT INTO template (templateid,title,template) VALUES (NULL,'editpoll','{htmldoctype}
<HTML>
<HEAD>
<TITLE>$bbtitle - Edit this poll</TITLE>
on the top

HTML layout

on the bottom
$footer ') mysql error: You have an error in your SQL syntax near 's Hot Topics
<table wi' at line 1 mysql error number: 1064 Date: Wednesday 27th of December 2000 05:28:41 PM Script: /makepolltables.php Referer:

Here is the one that gets sent after trying to install polls.

No message is sent when I try to do the polls. There are also no templates created. I just tried this once again :(

Tried once again

ran Make polltables.php

got errors

Editing post table ... Editing thread table ... Done!
Editing usergroup table ... Done!

Creating table poll..
Creating table pollvote..


FINISHED!

Creating templates...


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.

This is the email

Database error in vBulletin: Invalid SQL: INSERT INTO template (templateid,title,template) VALUES (NULL,'editpoll','{htmldoctype} $cssinclude

Same as the previous message

I was wondering how i disable polls on certain forums?

Right now they are available on all, I want just one or 2 forums to have the ability to do it.

How do I do this?

I think there is one nasty bug in this poll hack.
It was the cause of vBoard's death :(

But I am not upset with the creater as I installed this hack at my own risk. :)

Just curious what happened? Post it here or email me either way I would like to know what happened to your board.

First off I removed everything off the poll hack on my board and there was nothing left of it.

Then I entered my forums to find a database error blocking me seeing the thread listing or any post.

Database dump was affected by this as it wouldn't dump right so my backup was a failer so I had no choice but to delete my database as it was giving off errors on the board.

I had no idea all my 24 hour backups were along not backing up right and that was since I installed the Poll Hack.

that's highly interesting..i can't see how the poll hack would do that, sounds more like a db corruption to me. how were your dumps conifgured?

I dump my database by PHP My Admin and its been missing some data to backup.

But there was no way I could make my board fresher as that error was there so I had no choice but to drop it.

i assume the error was because some old code from the poll hack still remained.

as for the db issues, possibly a corruption. i can't imagine any way that it could ruin the db unless something was wrong with the db structure.

I dont know it sounds like it but I can live with that. :)

I was wondering how i disable polls on certain forums?

Right now they are available on all, I want just one or 2 forums to have the ability to do it.

How do I do this?

the only current way is to have templates for each forum,and simply include the new poll image in those you want.

I sent you the email that you requested. I just want to tell you that I have just done the 115 upgrade. Let me know what needs to be done.

Thanks in advance.

Doron, I'm trying to update my other board from 1.1.3 to 1.1.5.

When I run the updatepoll.php, I'm getting the following error:

The error code is:
<!-- Database error in vBulletin: Invalid SQL: UPDATE thread SET poll='1' WHERE threadid=7372
mysql error: Unknown column 'poll' in 'field list'
mysql error number: 1054
Date: Friday 05th of January 2001 04:18:35 PM
Script: /backup/updatepoll.php
Referer:
-->

There is no poll #4, but there is a #5, etc...Can you help me?

Will there be instructions on how to do this hack to 1.1.5? Please help me get this done as I was hoping to install this but I did the upgrade to 1.1.5 and now it seems the code has changed. Please let me know how I can do this.

sorry, i was having issues with my computer, still am.

Me2Be: did you have the previous version installed? the error "Unknown column 'poll' in 'field list' " means there is no poll column in the thread table. The script should be clever and only take the existing polls...

Philly: as for 1.1.5, i have not had the time to look at it yet. It should work if you used the 1.1.4 install info.

Dumb newbie question.

Poll hack installed, works great, but ... when you view the poll results, there are no totals and no percent.

What is the var used for this? this is the pollresults template:
i know i'm missing something before "votes".