Update #131 * Failed: ALTER TABLE {boxes} DROP INDEX title

Topic: error while update database from older versions

Desc:

Drupal 4.4.0 database.mysql file say:

--
-- Table structure for table 'boxes'
--

CREATE TABLE boxes (
bid tinyint(4) NOT NULL auto_increment,
title varchar(64) NOT NULL default '',
body longtext,
info varchar(128) NOT NULL default '',
type tinyint(2) NOT NULL default '0',
PRIMARY KEY (bid),
UNIQUE KEY subject (title),
UNIQUE KEY info (info)
) TYPE=MyISAM;

If you try update your database 4.4.0 -> 4.6.0 -> 4.6.5 everything is OK.

But if you continue the update process, and try to update 4.6.5 -> 4.7.0-beta{1-2-3} you get following error message:

Update #131

* Failed: ALTER TABLE {boxes} DROP INDEX title

Solution:

Before you try to update from 4.6.5 to 4.7.0-beta{1-2-3}:

ALTER TABLE `boxes` DROP INDEX `subject` ,
ADD UNIQUE `title` ( `title` );