Last modified: 2013-01-18 21:19:09 UTC
Selected storage engine is "SMWSQLStore" (or an extension thereof) Checking table smw_object_ids ... Table not found, now creating... A database query syntax error has occurred. The last attempted database query was: "CREATE TABLE smw_object_ids (smw_id INTEGER NOT NULL KEY AUTO_INCREMENT,smw_namespace INT(11) NOT NULL,smw_title VARBINARY(255) NOT NULL,smw_iw TEXT NOT NULL,smw_subobject VARBINARY(255) NOT NULL,smw_sortkey VARBINARY(255) NOT NULL,smw_proptable_hash MEDIUMBLOB) " from within function "SMWSQLHelpers::createTable". Database returned error "1: near "KEY": syntax error On a new install, using MW 1.21 alpha efb075268dffaf65d30b57b6874cb1dddfe60efb and SMW 1.8 beta 7e0db091c35969c7a32a8763ff13d5d465da69af
The problem seems to be caused because of different syntax of sqllite http://www.sqlite.org/syntaxdiagrams.html#column-def https://gerrit.wikimedia.org/r/#/c/34541/
That commit solves the first issue, this is the next one :) Selected storage engine is "SMWSQLStore" (or an extension thereof) Checking table smw_object_ids ... Table not found, now creating... ... done. Checking table smw_concept_cache ... Table not found, now creating... ... done. Checking table smw_prop_stats ... Table not found, now creating... A database query syntax error has occurred. The last attempted database query was: "CREATE TABLE smw_prop_stats (p_id INTEGER,usage_count INT(8) UNSIGNED) " from within function "SMWSQLHelpers::createTable". Database returned error "1: near "UNSIGNED": syntax error"
Please test with https://gerrit.wikimedia.org/r/#/c/34572/
(In reply to comment #3) > Please test with https://gerrit.wikimedia.org/r/#/c/34572/ abandoned. with https://gerrit.wikimedia.org/r/#/c/44624/ already merged can we consider this fixed?
Yes, this is fixed