SQL errors appearing after changing from MyISAM to INNODB
It was fixed with the cache clear multiple times and a MySQL Reboot.
Since doing a database change I keep getting the following database error:
REPLACE INTO `bx_timeline_cache` SET `type` = 'owner',`context_id` = ,`profile_id` = '',`event_id` = '1328',`date` = '1576078059'
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 '`profile_id` = '',`event_id` = '1328',`date` = '1576078059'' at line 1
The error was found in query function in the file /home/vybz/public_html/modules/boonex/timeline/classes/BxTimelineDb.php at line 409.
Has anyone ran into this after converting. With Froala when I was on MyISAM I had to change to utf8mb4_unicode_ci for collation. Could this be the problem, possibly needing to change type with #INNODB ? Ive also upgraded to Litespeed but that should be unrelated.