Author: alxndr+wikimedia
Description:
Getting an error when trying to set up SMW on MW 1.15.3 with MySQL 5.0.67:
<code>
php5 SMW_setup.php
X-Powered-By: PHP/5.2.13
Content-type: text/html
Setting up standard database configuration for SMW ...
Selected storage engine is "SMWSQLStore2" (or an extension thereof)
Setting up table [wikiname]_smw_ids ...
A database query syntax error has occurred.
The last attempted database query was:
"CREATE TABLE [dbname].[wikiname]_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,smw_sortkey VARBINARY(255) NOT NULL) ENGINE=InnoDB"
from within function "SMWSQLHelpers::setupTable".
MySQL 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 ([dbserver])"
</code>
I had SMW 1.0 or 1.1 on this wiki ages ago, but disabled it in 2008.
Version: unspecified
Severity: normal
OS: Linux