X-Cart forums

[ARW VISIONS]

Sure there is, it's having tea with Big Foot, Nessi, and the Yeti.

[Jon]

Uploaded upgrade files from 4.4.1 -> 4.4.5 and the "Apply" upgrade button won't become enabled even when all the "Agree" check boxes are checked.

I modified patch.tpl to force the button to be enabled, but it just reloads the page. Any idea what the problem might be?

I'm reuploading files to see if there may have been a problem in the original upload.

[Jon]

Had to disable all the functionality to check for the checked boxes by editing the .tpl and then was finally able to proceed. Problem persists on the 4.4.5 cart. Strange.

[seyfin]

Originally Posted by Jon

Had to disable all the functionality to check for the checked boxes by editing the .tpl and then was finally able to proceed. Problem persists on the 4.4.5 cart. Strange.

Our maintenance team will look into the issue. If there are any problems with the upgrade packages, we will keep you updated.

Thank you.

[xenonshop]

I tried to update from 4.4.4 to 4.4.5, I'm getting sql patch error:
QL PATCH ``patch.sql'' FAILED AT QUERY:
ALTER TABLE xcart_ccprocessors ADD INDEX pph (paymentid, preauth_expire, has_preauth)
The database version has not been updated!

Anyone willing to help?

[cflsystems]

The upgrade to 4.4.5 has these sql lines

ALTER TABLE xcart_stats_pages DROP INDEX page;
ALTER TABLE xcart_stats_pages ADD UNIQUE page (`page`);
ALTER TABLE xcart_stats_pages_paths DROP INDEX path;

which makes "page" an unique index and of course throws sql error immediately when stats are on and same page is visited more then once.

This is bug. Fix it

ALTER TABLE xcart_stats_pages DROP INDEX `page` ,
ADD INDEX `page` ( `page` ) ;

[Yrik]

hi guys, just upgraded to 4.4.5, but Google Analytics seems to have been impacted somehow. Anybody experienced this already? Any workarounds available?
[*] 06 Dec 2011, aim - Improvement (0107971 ): Added Asynchronous Tracking to the Google Analytics module.

What seems to be happening is the JS script which includes "google-analytics.com/ga.js" is no longer in the HTML even though the module is enabled.

[junliw1975]

Originally Posted by xenonshop

I tried to update from 4.4.4 to 4.4.5, I'm getting sql patch error:
QL PATCH ``patch.sql'' FAILED AT QUERY:
ALTER TABLE xcart_ccprocessors ADD INDEX pph (paymentid, preauth_expire, has_preauth)
The database version has not been updated!

Anyone willing to help?

I am getting this error too, did you get it fixed?

Thanks

[junliw1975]

The error from the log is

"
SQL query : ALTER TABLE xcart_ccprocessors ADD INDEX pph (paymentid, preauth_expire, has_preauth)
Error code : 1061
Description : Duplicate key name 'pph'
Request URI: /admin/patch.php
Backtrace:
/home/bridalca/public_html/include/func/func.db.php:303
/home/bridalca/public_html/include/func/func.db.php:203
/home/bridalca/public_html/admin/patch_sql.php:183
/home/bridalca/public_html/admin/upgrade.php:150
/home/bridalca/public_html/admin/patch.php:300
-------

[junliw1975]

Fixed it, I restored the database and run the upgrade again and it worked.