Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Upgrade to 5.2 fails

 
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)
 
Thread Tools Search this Thread
  #11  
Old 03-26-2015, 02:56 PM
 
czebin czebin is offline
    
Join Date: Dec 2014
Posts: 1
 

Default ERROR: "0" (code N/A)

I upgraded to 5.2.2. After install the cart errors out and I have to do a soft reset. Here is the error that I receive:

ERROR: "0" (code N/A)
An exception occurred while executing 'ALTER TABLE `xc_form_ids` ADD CONSTRAINT `xc_formid_to_session` FOREIGN KEY `session_id` (`session_id`) REFERENCES `xc_sessions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`db570631593`., CONSTRAINT `xc_formid_to_session` FOREIGN KEY (`session_id`) REFERENCES `xc_sessions` (`id`) ON DELETE CASCADE ON UPDATE CA)


This cart has been nothing else but frustration for me. Can someone let me know how I can get the cart past this error?
__________________
X-Cart 5.1.9 Business
Sale
Sales Tax
Simple CMS
Theme Tweaker
Tiny MCE
User Permissions
X-Payments Connector
X-Payments Subscriptions
XML Sitemao
Free Shipping
Coupons
Reply With Quote
  #12  
Old 03-26-2015, 03:46 PM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Meet X-Cart 5.2.2 STABLE

Hello Richard,

Please could you send us your log files (the [xc5]/var/log/ directory)?
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote
  #13  
Old 03-26-2015, 04:23 PM
 
BauerKen BauerKen is offline
 

Newbie
  
Join Date: Feb 2015
Posts: 3
 

Default Re: Meet X-Cart 5.2.2 STABLE

I am also having a problem upgrading with this error coming from 5.1.11

ERROR: "0" (code N/A)
An exception occurred while executing 'ALTER TABLE xc_profile_addresses CHANGE country_code country_code CHAR(2) DEFAULT NULL, CHANGE is_billing is_billing TINYINT(1) NOT NULL, CHANGE is_shipping is_shipping TINYINT(1) NOT NULL, CHANGE isWork isWork TINYINT(1) NOT NULL': SQLSTATE[HY000]: General error: 1832 Cannot change column 'country_code': used in a foreign key constraint 'FK_EDFDEF52F026BB7C'

php 5.6.5, mysql v 5.6.22
__________________
5.1.11
Reply With Quote
  #14  
Old 03-26-2015, 11:14 PM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Upgrade to 5.2 fails

Hello!

It looks like all your messages are about the same 5.2 upgrade problem, so I've moved them into a single forum thread.

In case you face the same issue, please sign into your account at https://secure.x-cart.com/, create a ticket there, attach your log files (that you can find in the [xc5]/var/log/ directory) and let us have the access to your server (if possible).

Also, if you created a backup, please let us have it so that we could try upgrading your site on our computers locally.
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote
  #15  
Old 03-27-2015, 12:52 AM
 
xim xim is offline
 

X-Cart team
  
Join Date: Nov 2004
Posts: 677
 

Default Re: Upgrade to 5.2 fails

Hello,

We found the issue with updating foreign key in upgrade process on some versions on MySQL.

Our team is working on the fix and we will release the patch to recover stores. Also to fix the upgrade process we will have to release 5.2.3 version. There will be no any changes in the software, only the fixes in upgrade procedure.

To prevent such situation in the future we will implement waves for upgrades. It is impossible to emulate all the cases on QA-phase, what’s why we want to double check the upgrade procedure on private test group until make it public. The first wave will be available only for certain stores. After checking and corrections (if necessary) we will make upgrade available for all the other stores.
__________________
Sincerely yours, Max Vydrin
Reply With Quote
  #16  
Old 03-27-2015, 07:05 AM
  Ksenia's Avatar 
Ksenia Ksenia is offline
 

X-Cart team
  
Join Date: Apr 2013
Posts: 735
 

Default Re: Upgrade to 5.2 fails

Please find the solution here:
http://blog.x-cart.com/5-2-3-upgrade-issue-fix-for-the-users-running-MySQL-5-6.html
__________________
X-Cart team

Last edited by Ksenia : 03-27-2015 at 07:38 AM.
Reply With Quote
  #17  
Old 03-27-2015, 07:08 AM
 
xim xim is offline
 

X-Cart team
  
Join Date: Nov 2004
Posts: 677
 

Default Re: Upgrade to 5.2 fails

Quote:
Originally Posted by Ksenia

Plz, check the "How to fix the store if you already faced the problem" chapter.
__________________
Sincerely yours, Max Vydrin
Reply With Quote
  #18  
Old 03-27-2015, 07:15 AM
 
Burt Burt is offline
 

Newbie
  
Join Date: Jun 2007
Posts: 6
 

Default Re: Upgrade to 5.2 fails

Please find the solution here:
https://blog.x-cart.com/5-2-3-upgrade-issue-fix-for-the-users-running-MySQL-5-6.html

Link does not work.
__________________
Michael
Reply With Quote
  #19  
Old 03-27-2015, 07:18 AM
  Ksenia's Avatar 
Ksenia Ksenia is offline
 

X-Cart team
  
Join Date: Apr 2013
Posts: 735
 

Default Re: Upgrade to 5.2 fails

Quote:
Originally Posted by Burt

Please try once again. I have just opened it an the incognito mode of the browser and it works for me. Did it work?
__________________
X-Cart team

Last edited by Ksenia : 03-27-2015 at 07:20 AM.
Reply With Quote
  #20  
Old 03-27-2015, 07:34 AM
 
Burt Burt is offline
 

Newbie
  
Join Date: Jun 2007
Posts: 6
 

Default Re: Upgrade to 5.2 fails

No link fails. This happens on many links on your website as well.

Safari can’t open the page “https://blog.x-cart.com/5-2-3-upgrade-issue-fix-for-the-users-running-MySQL-5-6.html” because Safari can’t establish a secure connection to the server “blog.x-cart.com”.
__________________
Michael
Reply With Quote

The following user thanks Burt for this useful post:
Ksenia (03-27-2015)
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 01:25 PM.

   

 
X-Cart forums © 2001-2020