Wikimedia Bugzilla is closed!

During the installation of SMW 1.9.1.1 in a Postgres based Mediawiki 1.22.3 the following error occurs:

The SMWAdmin function "Initialize or Upgrade Tables" fails because of the use of the ENGINE keyword on Postgres. The corresponding code in SemanticMediaWiki/includes/storage/SMW_SQLHelpers.php line 285:

 $db->query( "ALTER TABLE " . $tableName . " ALT\ER COLUMN \"" . $name . "\" ENGINE " . $type, __METHOD__ );

must be changed to:

 $db->query( "ALTER TABLE " . $tableName . " ALT\ER COLUMN \"" . $name . "\" TYPE " . $type, __METHOD__ );