Jump to content

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

Error When Upgrading To Cs-Cart 4.2.4 Rate Topic   - - - - -

 
  • ecom1
  • Newbie
  • Members
  • Join Date: 06-Dec 14
  • 2 posts

Posted 06 December 2014 - 06:15 PM #1

When upgrading from CS-Cart v4.2.3 to v4.2.4 I get the following error message:

Error occurred: post upgradeUnknown column 'company_id' in 'field list' (1054): SELECT processor_params, company_id FROM egx_payments WHERE processor_id = (SELECT processor_id FROM egx_payment_processors WHERE processor_script = 'paypal.php')

Does anyone know the reason for this error message or how to fix?

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 18934 posts

Posted 08 December 2014 - 08:17 AM #2

I am not sure why the egx_payments table does not contain the default company_id column. Try to use phpMyAdmin and create it manually.

Name: company_id
Type: INT
Length: 11
Default value: 0

GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • ecom1
  • Newbie
  • Members
  • Join Date: 06-Dec 14
  • 2 posts

Posted 09 December 2014 - 11:42 AM #3

Thanks eComLabs! I'm going to wait until early next year to try what you suggested. I'm new to phpMyAdmin, so I may need to check back with you then.

 

Posted 20 January 2015 - 11:36 PM #4

I just tried the upgrade to 4.2.4 and got a similar error:

Error occurred: post upgradeUnknown 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')

Does anyone know how to fix this?

Additionally, I got a second error message:


Error occurred: post upgradeSubquery returns more than 1 row (1242):
REPLACE INTO cscart_settings_descriptions VALUES ((SELECT object_id FROM cscart_settings_objects WHERE name = 'test_mode'), 'O', 'en', 'Test mode', '')

Any help would be greatly appreciated. Thanks!

 

Posted 22 January 2015 - 05:47 PM #5

Helpdesk fixed this for me. This was their answer:

The issue appeared because the company_id column was missing from the cscart_payments table for some reason. To resolve the issue, I reverted the upgrade, then added the missing column to the database using the following SQL query:
ALTER TABLE cscart_payments ADD COLUMN company_id int(11) unsigned NOT NULL DEFAULT '1' AFTER payment_id

and upgraded the installation once again.