I just went through and upgraded my entire store, but now when I go to the blocks section under admin, this is what I get. Hopefully someone has had a similar issue and knows how to resolve it? If I revert all the upgrades it fixes it, but I would rather have my store upgraded!
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/fatalacc/public_html/thestungunshop/store/core/fn.database.php
Line: 310
Function: db_error
File: /home/fatalacc/public_html/thestungunshop/store/core/fn.database.php
Line: 37
Function: db_query
File: /home/fatalacc/public_html/thestungunshop/store/core/fn.cms.php
Line: 1208
Function: db_get_array
File: /home/fatalacc/public_html/thestungunshop/store/controllers/admin/block_manager.php
Line: 157
Function: fn_get_available_group
File: /home/fatalacc/public_html/thestungunshop/store/core/fn.control.php
Line: 567
Function: include
File: /home/fatalacc/public_html/thestungunshop/store/core/fn.control.php
Line: 422
Function: fn_run_controller
File: /home/fatalacc/public_html/thestungunshop/store/admin.php
Line: 28
Function: fn_dispatch
[quote]
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT)
[/quote]
Find the table that has a collation of uft8_unicode_ci and change it to utf8_general_ci. Unicode is multi-byte encoding and general is single byte. That’s why it can’t compare them.
I got problem with blocks also.
For some unknown reason after update, bottom block appears inside top block and as a bottom block in bottom. If I add anything to it content appears in top and in bottom.
Also all created blocks in old store are displayed in places like product or page blocks but they are not shown in block manager and cannot be edited or removed, where all block info is held?
Your signature says you’re on 2.0.7, what version did you upgrade to? If you “went all the way”, did you resolve conflicts for each increment?
I’m assuming you can’t just drag your bottom block (that’s in the top area) to the bottom?
[quote name=‘tbirnseth’]Your signature says you’re on 2.0.7, what version did you upgrade to? If you “went all the way”, did you resolve conflicts for each increment?
I’m assuming you can’t just drag your bottom block (that’s in the top area) to the bottom?[/QUOTE]
No I cant drag.
Update process was following:
- live store backup (2.07) db import to 2.07(new install) on localhost.
- update
- new install of 2.1.4 on live spare domain on my VPS, then imported updated db from localhost.
- simply switched public_html of live store and updated store, reset permissions and usergroups, edited config file.
Done.
No php or tpl files were edited or modified before and during update.
Hello Darius,
We are sorry to hear that you experience such a problem.
It seems that the problem with the block functionality appeared after the incorrect upgrade process performed from CS-Cart version 2.0.15 to CS-Cart version 2.1.0 Professional Edition and then your store was upgraded just to the next version. So, I can suggest that you should downgrade your current CS-Cart installation 2.1.4 Professional Edition to 2.0.15 (that requires 5 downgrades) and then try to perform the upgrade again. Or we can try to help you using the FTP access details to your server.
Downgrade is out of the question. Will supply ftp access to support.