Known Cs-Cart Upgrade Center Issues

Hi,

Today we upgrade an old client from 4.1.5 to 4.6.2 and in regards to custom work everything went just fine because all the development was done by us and we know what to change between versions but this post is not about upgrading 3rd party add-ons and will not cover this because it depends on each developer and what will actually cover are the small cs-cart upgrade between versions ( at least what we face it over time ):

#Common

Very important to change the database prefix to default ( cscart_ )

-

-

4.2.3 - 4.2.4

#ERROR

Unknown column 'company_id' in 'field list' (1054):

SELECT processor_params, company_id FROM cscart_payments WHERE processor_id = (SELECT processor_id FROM cscart_payment_processors WHERE processor_script = 'paypal.php')

#FIX

please run query

ALTER TABLE `cscart_payments` ADD `company_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `payment_id`;

-

-

-

4.2.4 - 4.3.1

#ERROR

Unfortunately, you cannot proceed with the upgrade because we cannot access thevar/upgrade/upgrade_4.2.4_ultimate-4.3.1_ultimate.tgz/restore.php file, which is used to roll back the upgrade. We must be sure that the restore functionality works fine before you continue with the upgrade.....

#FIX

Set 755 permissions for var/
Set 755 permissions for var/upgrade/
Set 755 permissions for var/upgrade/upgrade_4.2.4_ultimate-4.3.1_ultimate.tgz

-

-

-

4.3.2 - 4.3.3

#ERROR

Unable to prepare restore file. restore.php was locally modified/removed or renamed.

#FIX

please edit the file config.local.php

#REPLACE

define('DEFAULT_FILE_PERMISSIONS', 0666);
define('DEFAULT_DIR_PERMISSIONS', 0777);

#WITH

define('DEFAULT_FILE_PERMISSIONS', 0644);
define('DEFAULT_DIR_PERMISSIONS', 0755);

-

-

-

I hope will help you on your upgrade process and feel free to post your own experiences to be able to do the future upgrades easy

THANK YOU

Keep on smiling,

---
Valentin
part of hungryweb.net

For CS-Cart version 4.3.1

...
[+] Add-ons: The Newsletters add-on was created from the News and Emails add-on. 
...

#FIX
any custom development created for add-on news_and_emails should be changed to newsletters
for ex: a tpl override for subscribe.tpl block

#before CS-Cart 4.3.1

design/themes/[THEME]/templates/addons/[ADDON]/overrides/addons/news_and_emails/blocks/static_templates/subscribe.tpl

#after CS-Cart 4.3.1

design/themes/[THEME]/templates/addons/[ADDON]/overrides/addons/newsletters/blocks/static_templates/subscribe.tpl

I'm guessing your first one regarding the need for cscart_ to be the table prefix is a coding error in the upgrade scripts that assumed that path rather than using '?:'...

I always change the FILE?DIR permissions before starting to ensure they are correct throughout the process.

The good thing about using 'upgrade' versus 'store_import' is that you can pick up where you left off after corrections rather than having to start the whole process from the beginning again.

Just one note to add to this about store_import. I you plan to run multiple 'actualize' steps, be sure to remove var/store_import/export.sql before each attempt otherwise you'll be repeating prior actualizations and the process will just get slower/longer with each actualize.

Thanks Valii for the clarifications...

P.S. Should be 'news_and_emails', not 'new_and_emails'! :-) But we get it.

P.S. Should be 'news_and_emails', not 'new_and_emails'! :-) But we get it.

Thank you @tbirnseth for the notice, I updated :D

I'm guessing your first one regarding the need for cscart_ to be the table prefix is a coding error in the upgrade scripts that assumed that path rather than using '?:'...

-- Yes

The good thing about using 'upgrade' versus 'store_import' is that you can pick up where you left off after corrections rather than having to start the whole process from the beginning again.

-- Yes, take a little more but you have control and can test between versions