Last modified: 2013-03-01 09:24:29 UTC
Hi. I've just upgraded a SMW 1.8.0 instance to 1.8.0.2. When I run SMW_setup.php I get the following errors: Selected storage "SMWSQLStore3" for update! Setting up standard database configuration for SMW ... Selected storage engine is "SMWSQLStore" (or an extension thereof) Checking table `smw_object_ids` ... Table already exists, checking structure ... ... changing type of field smw_id from 'INT(8) UNSIGNED NOT NULL KEY AUTO_INCREMENT' to 'INT(8) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT' ... A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: ALTER TABLE `smw_object_ids` CHANGE `smw_id` `smw_id` INT(8) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST Function: SMWSQLHelpers::updateMySqlField Error: 1068 Multiple primary key defined (localhost) I have run update.php. That throws the same error. This has happened on two instances now.
Fixed with 1.8.0.3.