Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Feb 2004
Posts: 6
Lurker
Lurker
Offline
Joined: Feb 2004
Posts: 6
Hello everybody.

I've searched forum for simillar problem, but found nothing.

I have UBBThreads 6.3 running and i want upgrade it to version 6.4.1 Here's what I do:

Buckup first
Then I copy and overwrite all files and catalogues except filters/ images/ includes/ stylesheets/ and three main config files.
Then I run altertable-6.3-6.4.php (this takes a while, my database weights about 200MB) and I get this output:

Adding a new table to save database queries that are used frequently from the admin section
SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: CREATE TABLE w3t_Queries ( Q_Entry INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY, Q_Query TEXT )
Table 'w3t_Queries' already existsAdding a new field to the Groups table to allow for disabling of groups.
SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: ALTER TABLE w3t_Groups ADD G_Disabled INT(1) UNSIGNED DEFAULT '0'
Duplicate column name 'G_Disabled'Grabbing all old poll data for conversion.
SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: SELECT * FROM w3t_Polls ORDER BY P_Name,P_Number
Table 'forum.w3t_Polls' doesn't existSQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: SELECT * FROM w3t_PollData ORDER BY P_Name
Table 'forum.w3t_PollData' doesn't existDropping old poll tables and creating new ones for the updated poll system.
SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: DROP TABLE w3t_Polls
Unknown table 'w3t_Polls'SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: DROP TABLE w3t_PollData
Unknown table 'w3t_PollData'SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: CREATE TABLE w3t_PollMain ( P_Id INT(11) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, P_Start INT(11) UNSIGNED, P_Stop INT(11) UNSIGNED, P_MustVote INT(1) UNSIGNED, P_NoResults INT(1) UNSIGNED )
Table 'w3t_PollMain' already existsSQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: CREATE TABLE w3t_PollQuestions ( P_QuestionNum INT(11) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, P_PollId INT(11), P_Question TEXT, P_ChoiceType VARCHAR(4) )
Table 'w3t_PollQuestions' already existsSQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: CREATE TABLE w3t_PollOptions ( P_OptionNum INT(11) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, P_QuestionNum INT(11) UNSIGNED NOT NULL, P_Option VARCHAR(255), P_PollId INT(11) UNSIGNED, INDEX Question_ndx(P_QuestionNum) )
Table 'w3t_PollOptions' already existsSQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: CREATE TABLE w3t_PollVotes ( P_PollId INT(11) UNSIGNED, P_QuestionNum INT(11) UNSIGNED NOT NULL, P_OptionNum INT(11) UNSIGNED NOT NULL, P_Voter VARCHAR(15), INDEX Option_ndx(P_QuestionNum,P_OptionNum), INDEX Voted_ndx(P_PollId,P_Voter) )
Table 'w3t_PollVotes' already existsimporting old poll data...
Adding a table for calendar events...
SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: CREATE TABLE w3t_Calendar ( C_Entry INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, C_Owner INT(9) UNSIGNED, C_Date INT(4) UNSIGNED, C_Month INT(4) UNSIGNED, C_Year INT(4) UNSIGNED, C_Recurring ENUM ('monthly','yearly','never') DEFAULT 'never', C_Brief VARCHAR(255), C_Notes TEXT, C_Type ENUM ('private','public'), INDEX owner_ndx (C_Owner), INDEX date_ndx (C_Date,C_Month,C_Year), INDEX recur_ndx (C_Recurring) )
Table 'w3t_Calendar' already existsAltering the user's table to add a few new fields/preferences...
SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: ALTER TABLE w3t_Users ADD U_Birthday VARCHAR(10) NOT NULL DEFAULT '0', ADD U_ShowBday INT(1) NOT NULL DEFAULT '0', ADD U_TimeFormat VARCHAR(6), ADD U_Ignored TEXT, ADD U_OC_Userid VARCHAR(64), ADD INDEX birthday_ndx (U_Birthday,U_ShowBday)
Duplicate column name 'U_Birthday'Altering the online table to store info a bit differently...
SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: ALTER TABLE w3t_Online ADD O_Board VARCHAR(100)
Duplicate column name 'O_Board'Altering the board's table to allow admin's to associate an image with a forum...
SQL ERROR: Thu, Feb 05 2004 12:19:29 +0100 Unable to do_query: ALTER TABLE w3t_Boards ADD Bo_Image VARCHAR(255)
Duplicate column name 'Bo_Image'Altering the posts table so posts can be linked to a calendar event...
SQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts ADD B_CalDay INT(2) NOT NULL DEFAULT '0', ADD B_CalMonth INT(2) NOT NULL DEFAULT '0', ADD B_CalYear INT(2) NOT NULL DEFAULT '0', ADD B_AddSig INT(1) NOT NULL DEFAULT '1', ADD INDEX cal_ndx (B_CalYear,B_CalMonth,B_CalDay)
Duplicate column name 'B_CalDay'Reworking some indexes for speed, this may take awhile. You will get a few errors about indexes not being able to be dropped. This is ok, index names might be a bit different depending on when you installed but they will be dropped properly...
SQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Last DROP INDEX Last_indx
Can't DROP 'Last_indx'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Last DROP INDEX userlast_ndx
Can't DROP 'userlast_ndx'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Last DROP INDEX Luid_ndx
Can't DROP 'Luid_ndx'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Last ADD PRIMARY KEY Last_index(L_Uid,L_Board)
Multiple primary key definedSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex10
Can't DROP 'w3t_Postsindex10'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex10
Can't DROP 'w3t_Postsindex10'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX topic_index
Can't DROP 'topic_index'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX topic_ndx
Can't DROP 'topic_ndx'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex9
Can't DROP 'w3t_Postsindex9'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex9
Can't DROP 'w3t_Postsindex9'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex6
Can't DROP 'w3t_Postsindex6'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex6
Can't DROP 'w3t_Postsindex6'. Check that column/key existsSQL ERROR: Thu, Feb 05 2004 12:20:57 +0100 Unable to do_query: ALTER TABLE w3t_Posts ADD INDEX board_topic_ndx (B_Board,B_Topic)
Duplicate key name 'board_topic_ndx'Creating a cache table for some things that don't change to often...
Creating a table to store version info to make future upgrades easier...
Done



After upgrade I login as administrator and confirm changes by editing forum config. After that i run altertable-6.4-6.4.1.php and confirm changes again.

Everything works fine except polls. Some of them are converted and some are not. Those which works, are nicely displayed by doincludepoll.php, and those which doesn't work are displayed like in 6.3 (as form in post body).

If You need any more details, please tell me, I'll provide it.

Thanks in advance,
Hubert.

Sponsored Links
Entire Thread
Subject Posted By Posted
sql errors while running altertable-6.3-6.4.php HooG 02/05/2004 3:23 PM
Re: sql errors while running altertable-6.3-6.4.php Pappy 02/05/2004 4:20 PM
Re: sql errors while running altertable-6.3-6.4.php JoshPet 02/05/2004 5:05 PM
Re: sql errors while running altertable-6.3-6.4.php HooG 02/05/2004 7:42 PM
Re: sql errors while running altertable-6.3-6.4.php Astaran 02/05/2004 8:47 PM
Re: sql errors while running altertable-6.3-6.4.php HooG 02/05/2004 9:25 PM
Re: sql errors while running altertable-6.3-6.4.php HooG 02/07/2004 12:19 PM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Zarzal
Zarzal
Berlin, Germany
Posts: 808
Joined: July 2001
Forum Statistics
Forums63
Topics37,574
Posts293,926
Members13,850
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)