Problem Upgrading to 2.1 (Database error)

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”.