https://bugzilla.wikimedia.org/show_bug.cgi?id=27100
Summary: Function getUnusedPropertySubjects returns MySQL
database error 1064.
Product: MediaWiki extensions
Version: any
Platform: All
OS/Version: All
Status: NEW
Severity: major
Priority: Normal
Component: Semantic MediaWiki
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Function getUnusedPropertySubjects returns MySQL database error 1064.
Hi. I have been setting up a new wiki on the following versions:
Apache/2.2.17
PHP 5.3.5 (apache2handler)
MySQL 5.5.8
MediaWiki 1.16.0
Semantic MediaWiki (Version 1.5.5.1)
Semantic Forms (Version 2.0.9)
When I open some of the Semantic MediaWiki special pages, such as Special:Ask,
I get the following error:
A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:
CREATE TEMPORARY TABLE `ITMax_smw_tmp_unusedprops`( title VARCHAR(255) )
TYPE=MEMORY
from within function "SMW::getUnusedPropertySubjects". Database returned the
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 'TYPE=MEMORY' at line 1 (localhost)".
>From the note below (http://dev.mysql.com/doc/refman/5.5/en/create-table.html)
it appears to be a combatability issue with MySQL 5.5.
Note The older TYPE option was synonymous with ENGINE. TYPE was deprecated in
MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you
must convert existing applications that rely on TYPE to use ENGINE instead.
I have searched my server to try and find where this SQL is generated but
cannot find anything. Please can you confirm this issue and advise a solution
or patch.
Thanks, Mark.
.
--
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
