Author: mitchell_neill

Description:
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.

Version: master
Severity: major