|
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
Quote:
|
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. Quote:
|
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 |
Quote:
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. |
| All times are GMT. The time now is 09:53 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
| X vBulletin 3.8.12 by vBS Debug Information | |
|---|---|
|
|
 More Information |
|
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|