X-Cart forums

[Ana]

Originally Posted by cflsystems

One warning for anyone using jquery from CDN (like Google and others) - make sure you are loading 1.6.2 or OPC and and some admin features depending on it will not work

You're saying that jquery 1.6.4 is going to fubar features? ( I may not have noticed yet.)

Ana

[cflsystems]

4.4.4 comes with 1.6.2 - if you load anything before 1.6.2 some of the admin features won't work, newer versions - should be ok

[kustomrides]

Finished the upgrade, but am getting a 403 error when accessing the cart:

You are not allowed to access that resource!

Id: 79


ANy ideas? I'll try to hunt this down meantime

xcart shows id 79 to be:

ID 79 (include/func/func.db.php):
- Resolution of table field names between supplied data and SHOW FIELDS FROM failed (e.g. there's a problem with the SQL tables)

Edit 2: Still getting the 403 error (Apache) after restoring then upgrading.
Only files I took off the file list after patching manually were skin/common_files/admin/menu_box.tpl ;
skin/common_files/customer/home.tpl ;
skin/common_files/customer/service_js.tpl ;
skin/common_files/main/product_details.tpl ;

Would one of these files be needed to update the SQL table ???

ANyway, back to 4.4.3 for me. Only wanted 4.4.4 for the google feed update anyway, so maybe try that standalone.

[josebueso]

Hello

I upgraded to xcart 4.4.4 and now I have xcart advertising in the admin every time I log in.

I paid for this license and I don't want to see any advertising, how can I remove this.

Blessing

Saul

[seyfin]

Originally Posted by kustomrides

Finished the upgrade, but am getting a 403 error when accessing the cart:

You are not allowed to access that resource!

Id: 79


ANy ideas? I'll try to hunt this down meantime

xcart shows id 79 to be:

ID 79 (include/func/func.db.php):
- Resolution of table field names between supplied data and SHOW FIELDS FROM failed (e.g. there's a problem with the SQL tables)

Edit 2: Still getting the 403 error (Apache) after restoring then upgrading.
Only files I took off the file list after patching manually were skin/common_files/admin/menu_box.tpl ;
skin/common_files/customer/home.tpl ;
skin/common_files/customer/service_js.tpl ;
skin/common_files/main/product_details.tpl ;

Would one of these files be needed to update the SQL table ???

ANyway, back to 4.4.3 for me. Only wanted 4.4.4 for the google feed update anyway, so maybe try that standalone.

When you use the X-cart built-in upgrade utility, the first step of the upgrade process is applying file patches, the second one - applying database update patch (patch.sql).

Make sure the second step has been completed correctly.

By the way, you can use a special patch to update the froogle feed module in your 4.4.3 cart:

How do I update the Google/Froogle module to meet the latest Google's Product Feed Specification?

[seyfin]

Originally Posted by josebueso

I upgraded to xcart 4.4.4 and now I have xcart advertising in the admin every time I log in.

I paid for this license and I don't want to see any advertising, how can I remove this.

Modify <xcart_dir>/skin/common_files/admin/main/main.tpl file, find this line:

{if $smarty.cookies.hide_dialog_xcart_news eq ''}

and change it to:

{if false && $smarty.cookies.hide_dialog_xcart_news eq ''}

[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 (?).

[heather@MX1]

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

[Jobananas]

Trying to upgrade to 4.4.4 from 4.4.2 and getting a couple of problems.

Made a copy of the database and copied the live site to a different domain. Updated config.php to point to the new database and domain.

For some reason when I now try to login as admin it tells me the username and password are incorrect?

Any ideas why this is happening?

[candc]

Have you copied the Blowfish key to your new config .php as well?