Mysql Error - TYPE=HEAP' at line 4

[heusdens]

Hi

I'm wondering if anybody is able to help with this error.  I monitor my server using newrelic and it throws up this error several times in a day:

MysqlError: 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=HEAP' at line 4

Stack Trace:
...ql_query called at /home/uu/public_html/forums/Sources/
Subs-Db-mysql.php (354)
in smf_db_query called at /home/uu/public_html/forums/Sources/Search.php (1402)
in PlushSearch2 called at ? (?)
in call_user_func called at /home/uu/public_html/forums/index.php (163)

Appears to be related to search.

Any insight?

[Arantor]

That sounds like a bug in SMF 2.0 to me, because that shouldn't be using TYPE=HEAP, because MySQL stopped using TYPE=HEAP a *long* time ago.

There are two instances of TYPE=HEAP in Search.php, which should both be changed to ENGINE=MEMORY.


EDIT: If I remember I'll patch this in 2.0 next time I do a patch for 2.0, and I've tracked it for 2.1.

[Arantor]

This was fixed in 2.1 as per https://github.com/Oldiesmann/SMF21/commit/3be6e3b7e110ed947b89a8d0ed5b94a96bb5fc98


EDIT: Also added to my list of things to fix in 2.0.7.

[heusdens]

Thank you
I am going to apply this patch to my 2.0.6 version, it should be ok to do this before 2.0.7 comes out?

[Arantor]

Yup, just remember to undo it because 2.0.7 will fix it.