vb.org Archive - Error Database Vote

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Error Database Vote (https://vborg.vbsupport.ru/showthread.php?t=223487)

asimovietnam

09-18-2009 02:33 AM

Error Database Vote

help me !

I have upgrade Vbb 3.6.8 to 3.8.3 . When I vote error database . Please help me fix error ??

Thanks !!

Database error in vBulletin 3.8.3:

Invalid SQL:
INSERT IGNORE INTO pollvote
(pollid, votedate, voteoption, userid, votetype)
VALUES
(27, 1253248212, 2, 1, 0);

MySQL Error : Unknown column 'votetype' in 'field list'
Error Number : 1054
Request Date : Friday, September 18th 2009 @ 11:30:12 AM
Error Date : Friday, September 18th 2009 @ 11:30:12 AM

snakes1100

09-18-2009 12:58 PM

I would guess when you ran the upgrade, it failed to run correctly or timed out etc and possibly you tried to refresh duiring one of the steps.

Run this command in phpmyadmin or the admincp maintenance area.

Code:

ALTER TABLE forumpollvote ADD votetype INT UNSIGNED NOT NULL DEFAULT '0';

asimovietnam

09-20-2009 11:31 PM

Quote:

Originally Posted by snakes1100 (Post 1886985)

Code:

ALTER TABLE forumpollvote ADD votetype INT UNSIGNED NOT NULL DEFAULT '0';

I defered to your but still impossible guideline. Hope you helps

All times are GMT. The time now is 04:47 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02461 seconds Memory Usage 1,712KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: