Error: Illegal mix of collations (utf8_bin,NONE) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'

For fixing this problem you need to make sure that column `name`in following tables has the same collation:

- `ps_product_lang`
- `ps_attribute_lang`
- `ps_attribute_group_lang`

Make changes to those columns and issue must be fixed.