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: mar...@semantic-mediawiki.org
        ReportedBy: bugzi...@itmax.co.nz
                CC: jeroen_ded...@yahoo.com


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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to