I'm trying to migrate rows from a Joomla K2 table.
The issue happens when I add the 'fulltext' field to the field list on my select inside my migration class. This field is a medium text field with html inside. The error only happens when I put this field in the query.
The error is like so:
Migration failed with source plugin exception: SQLSTATE: Syntax error or access violation: 1064 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 'fulltext FROM j3_k2_items n WHERE (catid IN ('43', '45', '46', '51', '68', '7' at line 1,
I have set
$this->source = new MigrateSourceSQL($query, array(), NULL, array('map_joinable' => FALSE)); but it didn't help.
Any ideas? I don't know what to do.