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

5.1.3 update killed store

 
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)
 
Thread Tools Search this Thread
  #1  
Old 06-10-2014, 09:20 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default 5.1.3 update killed store

Im getting

Run the "Doctrine_Plugin_UpdateSchema" plugin...
Error
ERROR: "0" (code N/A)

SQLSTATE[HY000]: General error: 1025 Error on rename of './Shop2014a/xc_attribute_values_select' to './Shop2014a/#sql2-1c87-58c93a1' (errno: 152) SQL query: ALTER TABLE `xc_attribute_values_select` DROP FOREIGN KEY FK_BF4282481AE56DE9

and its stuck at this point
anyone else having issue with the latest update


now at


ERROR: "42" (code N/A)

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.default_card_id' in 'field list' SQL query: SELECT t0.default_card_id AS default_card_id1, t0.socialLoginProvider AS socialLoginProvider2, t0.socialLoginId AS socialLoginId3, t0.profile_id AS profile_id4, t0.login AS login5, t0.password AS password6, t0.password_hint AS password_hint7, t0.password_hint_answer AS password_hint_answer8, t0.passwordResetKey AS passwordResetKey9, t0.passwordResetKeyDate AS passwordResetKeyDate10, t0.access_level AS access_level11, t0.cms_profile_id AS cms_profile_id12, t0.cms_name AS cms_name13, t0.added AS added14, t0.first_login AS first_login15, t0.last_login AS last_login16, t0.status AS status17, t0.referer AS referer18, t0.language AS language19, t0.last_shipping_id AS last_shipping_id20, t0.last_payment_id AS last_payment_id21, t0.anonymous AS anonymous22, t0.forceChangePassword AS forceChangePassword23, t0.order_id AS order_id24, t0.membership_id AS membership_id25, t0.pending_membership_id AS pending_membership_id26 FROM xc_profiles t0 WHERE t0.login = ? AND t0.order_id IS NULL LIMIT 1 SQL query parameters: array ( 0 => 'roger@wemakeanyshirt.com', )

Now Im getting the X-Cart 5 is not installed and it is

the cloned site will come up so I can get admin and orders but none of the links from the shop front will work all say its not installed
what the hell is it with this software that every single upgrade causes nothing but grief
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #2  
Old 06-10-2014, 11:50 AM
  RichieRich's Avatar 
RichieRich RichieRich is offline
 

X-Adept
  
Join Date: Sep 2004
Location: London, England
Posts: 750
 

Default Re: 5.1.3 update killed store

I didnt get any issue with the upgrade
__________________
Richard


Ultimate 5.4 testing
Reply With Quote
  #3  
Old 06-10-2014, 01:19 PM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: 5.1.3 update killed store

got it back from local xampp build thank god for backup

bit worried now about giving it another go
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #4  
Old 06-11-2014, 09:58 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: 5.1.3 update killed store

well got it back but now problems increasing .
adding a product due to lost some from the failed upgrade the new product is in the category but you cant actually get into it to view other than in the pop up window

any ideas as this is now getting to be causing nothing but problems

Im trying to go live after months of build /rebuilds due to this package problems I cant start again as now people buying
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #5  
Old 06-11-2014, 10:40 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

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

Default Re: 5.1.3 update killed store

Quote:
Originally Posted by xanadude
got it back from local xampp build thank god for backup
bit worried now about giving it another go

Had you disabled any modules when upgraded the store? In 5.1.2 there was a bug that might cause a similar issue when disabling some mods.
__________________
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
  #6  
Old 06-11-2014, 11:05 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: 5.1.3 update killed store

I let the backup process do as it asked.

I did not specifically disable anything that was not already disabled

I'm working on keeping it up at present.
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #7  
Old 06-12-2014, 11:56 PM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: 5.1.3 update killed store

Quote:
Originally Posted by xanadude
I let the backup process do as it asked.

I did not specifically disable anything that was not already disabled

I'm working on keeping it up at present.


Im now incurring a lot of problems as in

creating new items seems ok but you cant go into them from the cart front end

Clone items seems to get around this but cant change prices.. new price is ok in admin view and the tables via phpMyAdmin but the store shows the pre cloned price.

I am back at 5.1.2 to keep me up and running but finding it hard to get things to work clean
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #8  
Old 06-14-2014, 10:46 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: 5.1.3 update killed store

Need help with this one guy's

Why since recovering can I not change prices to items in the store.....

they change in admin. I go into phpMyAdmin and they are changed there but the front of store shows old price - done rebuild cache no change

created clone backup and still no change

any ideas
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #9  
Old 06-16-2014, 09:41 AM
 
New York New York is offline
 

Advanced Member
  
Join Date: May 2014
Posts: 31
 

Default Re: 5.1.3 update killed store

it will sound strange,

1) but search your x-cart 5 directory for any fieles with tpl0000644, php0000644, png0000644.

x-cart use 7-zip to compress, if you uncompressed on SOME files it end up with those extensions.

2) if you disable some default module upgrade may fail


3) if you upgrade from 5 you better just reinstall clean 5.1.3.

If above not help let me know i have more to share...

Good luck
__________________
Thank you for your help.

http://www.1webmaker.com
Reply With Quote
  #10  
Old 06-16-2014, 12:57 PM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: 5.1.3 update killed store

thanks for the pointers will see what I can find
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
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 07:36 PM.

   

 
X-Cart forums © 2001-2020