Problem Upgrading to 2.1 (Database error)
Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ (1267)
Invalid query: SELECT cscart_blocks.block_id, cscart_block_descriptions.description, cscart_block_positions.group_id as parent_id FROM cscart_blocks LEFT JOIN cscart_block_descriptions ON cscart_block_descriptions.block_id = cscart_blocks.block_id AND cscart_block_descriptions.object_type = ‘B’ AND cscart_block_descriptions.lang_code = ‘EN’ LEFT JOIN cscart_block_positions ON cscart_block_positions.block_id = cscart_blocks.block_id AND cscart_block_positions.location = cscart_blocks.location AND (cscart_block_positions.object_id = 0 OR (cscart_block_positions.object_id = ‘0’ AND NOT EXISTS(SELECT * FROM cscart_block_positions as bp WHERE bp.block_id = cscart_blocks.block_id AND bp.location = cscart_blocks.location AND bp.object_id = 0))) WHERE cscart_blocks.block_type = ‘G’ AND (cscart_blocks.location = ‘all_pages’ OR cscart_blocks.location = ‘all_pages’)
---------------------------------------------------------------------------------
Backtrace: File: /home/elking/public_html/shop/core/fn.database.php
Line: 310
Function: db_error
File: /home/elking/public_html/shop/core/fn.database.php
Line: 37
Function: db_query
File: /home/elking/public_html/shop/core/fn.cms.php
Line: 1183
Function: db_get_array
File: /home/elking/public_html/shop/controllers/admin/block_manager.php
Line: 157
Function: fn_get_available_group
File: /home/elking/public_html/shop/core/fn.control.php
Line: 560
Function: include
File: /home/elking/public_html/shop/core/fn.control.php
Line: 415
Function: fn_run_controller
File: /home/elking/public_html/shop/adminpower.php
Line: 27
Function: fn_dispatch
[SIZE=“6”]Please what is the solution to this problem[/SIZE]
Please answer quickly, we have at this problem
Thank you
my mail : admin@power-fix.net
Try a forum search for “collations”.