Last modified: 2011-03-14 14:28:52 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T30037, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 28037 - Manage MySQL Syntax Updates (TYPE==>ENGINE)
Manage MySQL Syntax Updates (TYPE==>ENGINE)
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
unspecified
PC Windows Vista
: Normal trivial (vote)
: ---
Assigned To: Markus Krötzsch
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-03-14 08:58 UTC by JB
Modified: 2011-03-14 14:28 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description JB 2011-03-14 08:58:52 UTC
For MySQL version >= 5.5.8 the storage engine cannot be specied via TYPE= but only by ENGINE=.
Otherwise, when SM queries are big and need the creation of a temporary table, queries fail and return a MySQL syntax error code
Comment 1 Antoine "hashar" Musso (WMF) 2011-03-14 12:32:13 UTC
Also have a look at Bug 13586 - ENGINE vs TYPE
Comment 2 Jeroen De Dauw 2011-03-14 12:46:47 UTC
This has already been fixed on trunk (and the latest SMW release if I'm not mistaken).
Comment 3 JB 2011-03-14 12:50:16 UTC
(In reply to comment #2)
> This has already been fixed on trunk (and the latest SMW release if I'm not
> mistaken).

May-be on trunk but I tested yersterday the last SMW release and I had to debug it by myslef ;-)
BTW, many thanks for all your great job on SMW.
Comment 4 Jeroen De Dauw 2011-03-14 13:42:44 UTC
I just checked an the fix indeed was part of the latest SMW release (1.5.6). Is this the version you have? And if so, where is the error occurring? I can't find any remaining 'TYPE's, but might be overlooking something.
Comment 5 JB 2011-03-14 14:28:52 UTC
Oups ! My mistake.
I was talking about the last release of semantic-bundle for which the SMW extension is of lower version. Sorry  about that.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links