X-Cart forums

[xanadude]

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

[RichieRich]

I didnt get any issue with the upgrade

[xanadude]

got it back from local xampp build thank god for backup

bit worried now about giving it another go

[xanadude]

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

[qualiteam]

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.

[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.

[xanadude]

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]

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

[New York]

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

[xanadude]

thanks for the pointers will see what I can find