Quote:
|
Originally Posted by kustomrides
I'm getting multiple SQL errors on the 4.4.3-4.4.4 upgrade (on top of the 403 server error mentioned above in accessing cart.php).
∙ ALTER TABLE xcart_amazon_orders ADD UNIQUE ao (amazon_oid, orderid)
∙ ALTER TABLE xcart_amazon_orders DROP INDEX amazon_oid
∙ ALTER TABLE xcart_cc_pp3_data ADD param6 varchar(255) NOT NULL DEFAULT '' AFTER param5
∙ ALTER TABLE xcart_cc_pp3_data ADD param7 varchar(255) NOT NULL DEFAULT '' AFTER param6
∙ ALTER TABLE xcart_cc_pp3_data ADD param8 varchar(255) NOT NULL DEFAULT '' AFTER param7
∙ ALTER TABLE xcart_config ADD INDEX category (category)
Not sure what to do with the 4.4.3-4 upgrade at this point. Seems to be the most problematic upgrade I've come across since 4.1.12. I realize others have had issue with other upgrades while I just breezed through them. I guess it's a matter of how your cart is set up (?).
|
I agree with you - I just upgraded 4.4.2 to 4.4.4 and started the process thinking it wouldn't be very difficult. Took longer than I expected due to various sql errors (similar to yours). I've upgraded my cart across branches (4.3-4.4) and didn't have as many problems. But I got it done (thanks to Steve @ CFLsystems who posted an answer to my post yesterday). This is what I did, and it worked.
Assuming your pre-patch notice came back ok (all the templates/php files are patched) - open the patch.sql from the upgrade pack in a text editor (I use notepad++). Anything above the lines you posted have been patched. Anything including those lines and down has not. Remove those lines and paste them into another document, save the patch and run it again. Assuming that patch runs without problems you just have ones you posted above to patch. Try running each one separately (you can do this in the admin>tools>apply sql patch. You may need to run them out of the order they are listed in as well. If one fails try the next. It worked for me, and my cart is working - except for a totally unrelated issue with https module which seems to be a problem for quite a few others since upgrading to 4.4.4...but that's another post.
Hope this helps