https://bugzilla.wikimedia.org/show_bug.cgi?id=23701
Summary: MySQL error on SMW_setup.php
Product: MediaWiki extensions
Version: any
Platform: All
OS/Version: Linux
Status: NEW
Severity: normal
Priority: Normal
Component: Semantic MediaWiki
AssignedTo: [email protected]
ReportedBy: [email protected]
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.
--
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
