Scrabble study tactics: Alternate Spellings » |
MySQL DELAYED error message
Last week I discovered that Switched Keys quit working. Visitors coul only see a page with a MySQL error message.
Switched Keys uses the b2evolution CMS. Although b2evolution hasn't been updated for a few years it meets all my needs. It also requires an older version of php to work. Now it uses MariaDB instead of the original MySQL and apparently it was changed from MyISAM to InnoDB. While both MariaDB and MySQL support the keyword DELAYED in MyISAM, InnoDB doesn't support it.
I wondered how much work was involved to get this fixed. Database modification, code editing, etc. I found the simple fix in the file _hit.class.php found inĀ ...\b2e\inc\sessions\model\.
I only needed to take DELAYED out of the line
$sql = $delayed ? 'INSERT DELAYED INTO' : 'INSERT INTO';
As an afterthought I could have simply replaced it with the instruction
$sql = 'INSERT INTO';
Maybe some other b2evolution user will find this quick fix useful.