Author: gebhkla

Description:
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 );

Version: unspecified
Severity: major