Author: bugzilla

Description:
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.

.

Version: unspecified
Severity: major