The following (pretty much harmless, but nevertheless alarming) error message may be triggered when upgrading from Drupal 5.23 to 6.19:

user warning: Table 'actions_aid' already exists query: CREATE TABLE actions_aid ( `aid` INT unsigned NOT NULL auto_increment, PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /sman/app/testdb/httpsdocs/includes/database.inc on line 555.

The reason for this error is that the D5 site used the Actions 5.x-2.6 module, which is a backport of D6-style actions to D5. For this reason the table indeed existed (and also contained valid data). The attempt to create it again in system_update_6030 failed.

I noticed that the table definition in D5 differs slightly of what system.install tries to create: the primary key is of type bigint(20) unsigned rather than int unsigned. So the correct behavior would be to check whether the table exists and then update the attribute type if necessary.

Comments

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.