Last modified: 2011-02-07 00:13:25 UTC
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. .
Created attachment 8083 [details] patch that should fix issue
Thanks Jeroen. That has done the trick but I cannot believe I am the first to encounter this issue. Greetings from New Zealand. Mark.