https://bugzilla.wikimedia.org/show_bug.cgi?id=23701
Alexander <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Alexander <[email protected]> 2011-07-08 05:51:22 UTC --- MW 1.17.0, SMW 1.16 alpha (r91713), PHP 5.2.17, MySQL 4.0.27-max-log When running SMW_setup.php: ------------- Setting up standard database configuration for SMW ... Selected storage engine is "SMWSQLStore2" (or an extension thereof) Checking table `xxxxx_smw_ids` ... Table not found, now creating... A database query syntax error has occurred. The last attempted database query was: "CREATE TABLE `xxxxx`.`xxxxx_smw_ids` (smw_id INT(8) UNSIGNED NOT NULL KEY AUTO_INCREMENT,smw_namespace INT(11) NOT NULL,smw_title VARBINARY(255) NOT NULL,smw_iw VARCHAR(32) binary NOT NULL,smw_subobject VARCHAR(32) binary NOT NULL,smw_sortkey VARBINARY(255) NOT NULL) ENGINE=InnoDB" from within function "SMWSQLHelpers::createTable". Database returned error "1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY AUTO_INCREMENT,smw_namespace INT(11) NOT NULL,smw_title V (xxxxx.xxxxx.xxx)" ------------- Paul's fix above worked for me as well, but only includes/storage/SMW_SQLHelpers.php and includes/storage/SMW_SQLStorage2.php needed the tweak (s/(?<!PRIMARY) KEY AUTO/). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
