From: Linus S. <th...@un...> - 2011-02-20 11:57:53
|
Hey! I recently upgraded my server's MySQL to the latest 5.5.9 release, and I've been having some issues with Semantic MediaWiki ever since. I saw an older submission to this mailing list that suggested I change all instances of TYPE= to ENGINE= in the SQL queries, but I'm still getting errors thrown at me. > A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: > SELECT DISTINCT o_id AS id0,o0.smw_title AS v0,o0.smw_namespace AS v1,o0.smw_iw AS v2,o0.smw_sortkey AS v3 FROM `smw_subp2` INNER JOIN `smw_ids` AS o0 ON o_id=o0.smw_id WHERE s_id='52' > from within function "SMW::getSemanticData". Database returned error "1146: Table 'love2d_wiki.smw_subp2' doesn't exist (localhost)". The part of the page in question that errors is the following: > {{#ask: [[Category:Snippets]] > | headers=hide > | ?Description > | ?LOVE_Version > }} And the url of the wiki: http://love2d.org/wiki/Main_Page I'd appreciate any help you can provide. Thanks in advance. |
From: Jeroen De D. <jer...@gm...> - 2011-02-20 13:43:37
|
Hey, That doesn't look like a MySQL version problem, as it's complaining about a missing table. Are you sure there is actually a table at 'love2d_wiki.smw_subp2'? Cheers -- Jeroen De Dauw http://www.bn2vs.com Don't panic. Don't be evil. -- |