vb.org Archive - Error Upgrade 3.7

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

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

- - Error Upgrade 3.7 (https://vborg.vbsupport.ru/showthread.php?t=177596)

Mr.Fidel

04-30-2008 11:15 AM

Error Upgrade 3.7

Code:

Database error in vBulletin 3.7.0 Beta 2:



Invalid SQL:

ALTER TABLE dqd_album

                        CHANGE userid userid INT UNSIGNED NOT NULL DEFAULT '0',

                        CHANGE createdate createdate INT UNSIGNED NOT NULL DEFAULT '0',

                        CHANGE lastpicturedate lastpicturedate INT UNSIGNED NOT NULL DEFAULT '0',

                        CHANGE picturecount picturecount INT UNSIGNED NOT NULL DEFAULT '0',

                        CHANGE title title VARCHAR(100) NOT NULL DEFAULT '',

                        CHANGE description description TEXT,

                        CHANGE coverpictureid coverpictureid INT UNSIGNED NOT NULL DEFAULT '0';



MySQL Error   : Unknown column 'picturecount' in 'dqd_album'

Error Number  : 1054

Request Date  : Wednesday, April 30th 2008 @ 07:03:39 PM

Error Date    : Wednesday, April 30th 2008 @ 07:03:39 PM

Script        : http://duongquangdong.net/f@rum/install/upgrade_370b3.php?step=2

Referrer      : 

IP Address    : 203.162.3.154

Username      : 

Classname     : vB_Database

MySQL Version : 5.0.51a-community

So, How I do that ?

Marco van Herwaarden

04-30-2008 01:26 PM

From which version are you trying to upgrade? Also are you trying to upgrade to 3.7 'Gold'?

Marco van Herwaarden

04-30-2008 01:31 PM

If you are upgrading from 3.6, have previously tested a 3.7 version in this same database and after this restored the 3.6 database without first deleting all tables and then try to upgrade, then this can also happen. See bug report: http://www.vbulletin.com/forum/proje...?issueid=25167

All times are GMT. The time now is 07:10 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01136 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 (1)bbcode_code_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: