vb.org Archive - View Single Post

#97 12-19-2000, 08:55 PM

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]

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01106 seconds Memory Usage 1,765KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: