Error
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT `csvi_name`,`component_name`,`component_table`,`isprimary` FROM `z123_csvi_availablefields` AS `tbl` LEFT JOIN `z123_csvi_availabletables` AS `t` ON `t`.`template_table` = `tbl`.`component_table` WHERE `tbl`.`action` = 'import' AND `t`.`action` = 'import' AND `tbl`.`component` = 'com_virtuemart' AND `t`.`component` = 'com_virtuemart' AND `t`.`task_name` = 'product' GROUP BY `csvi_name`,`component_table` ORDER BY `csvi_name` ASC
All table have utf8_unicode_ci except _csvi_availablefields which has: utf8_general_ci
So I changed this to unicode all seems well.
But after update "available fields", it recreates the table, and it is back to utf8_general_ci!
SO I did again change it unicode, and this seems to work.
- ptrouw
- RO CSVI
- Monday, 01 February 2016
- Subscribe via email
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!