Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Problem with Blocks after Upgrade Rate Topic   - - - - -

 
  • devannielsen
  • Junior Member
  • Members
  • Join Date: 22-Jun 07
  • 10 posts

Posted 06 April 2011 - 09:16 PM #1

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

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12091 posts

Posted 06 April 2011 - 11:34 PM #2

(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT)

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.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3541 posts

Posted 07 April 2011 - 04:36 AM #3

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?

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12091 posts

Posted 07 April 2011 - 04:43 AM #4

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?

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3541 posts

Posted 07 April 2011 - 05:02 AM #5

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?


No I cant drag.

Update process was following:

1. live store backup (2.07) db import to 2.07(new install) on localhost.
2. update
3. new install of 2.1.4 on live spare domain on my VPS, then imported updated db from localhost.
4. 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.

 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3815 posts

Posted 07 April 2011 - 08:24 AM #6

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.

Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3541 posts

Posted 07 April 2011 - 09:25 AM #7

Downgrade is out of the question. Will supply ftp access to support.