UBB.Dev
Posted By: Pilgrim Error running Altertable-6.4-6.4.1.php - 01/12/2004 7:52 AM
Trying updating my Board and after uploading all the new files, etc., I ran the "altertable-6.4-6.4.1.php" file in my browser and got the following error:

SQL ERROR: Sun, Jan 11 2004 23:43:02 -0600 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX board_topic_ndx
Can't DROP 'board_topic_ndx'. Check that column/key existsSQL ERROR: Sun, Jan 11 2004 23:43:03 -0600 Unable to do_query: ALTER TABLE w3t_Posts ADD INDEX board_topic_index (B_Board,B_Topic,B_Last_Post)
Duplicate key name 'board_topic_index'SQL ERROR: Sun, Jan 11 2004 23:43:03 -0600 Unable to do_query: UPDATE w3t_Version SET V_Version='6.4.1'
Table 'phpthreads.w3t_Version' doesn't existDone

Okay.... now what do I do?

Jeff
Posted By: Astaran Re: Error running Altertable-6.4-6.4.1.php - 01/12/2004 3:03 PM
Quote from the release notes

[]Please note that there is an altertable to run in this update. This altertable removes an old index on your posts table and adds a new one. As always, make a database backup before this and any upgrade.

If the version you are upgrading from did not have this old index you will receive an error message. That is fine, the altertable script will continue to run.[/]

So the first errors about the index is ok.

The second one
[]Sun, Jan 11 2004 23:43:03 -0600 Unable to do_query: UPDATE w3t_Version SET V_Version='6.4.1'
Table 'phpthreads.w3t_Version' doesn't existDone
[/]
looks like that the update to 6.4.0 wasn't done completely. Otherwise the table w3t_Version should be present.
Posted By: omegatron Re: Error running Altertable-6.4-6.4.1.php - 01/12/2004 5:43 PM
Okay run this to fix that

CREATE TABLE `w3t_Version` (
`V_Version` varchar(25) default NULL,
`V_AlterStep` int(1) default NULL,
`V_StartTime` int(11) default NULL,
`V_StopTime` int(11) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `w3t_Version`
#

INSERT INTO `w3t_Version` VALUES ('6.4.1', NULL, NULL, NULL);
INSERT INTO `w3t_Version` VALUES ('6.4.1', NULL, NULL, NULL);
© UBB.Developers