X-Cart: shopping cart software
Page 3 of 10 < 12 3 45 > Last »
Show 40 posts from this thread on one page

X-Cart forums (https://forum.x-cart.com/index.php)
-   News and Announcements (https://forum.x-cart.com/forumdisplay.php?f=28)
-   -   X-Cart v4.4.5 released (https://forum.x-cart.com/showthread.php?t=62444)

seyfin 02-08-2012 12:34 AM
Re: X-Cart v4.4.5 released
 
Quote:
Originally Posted by Eyeglasses Expert
how to update v4.4 to v4.5, pls?

Please refer to our Knowledge Base:

* http://help.qtmsoft.com/index.php?title=X-Cart:Upgrade_procedure
* http://help.qtmsoft.com/index.php?title=X-Cart:Upgrading

Should you require assistance on upgrading your X-Cart store, do not hesitate to contact our support team via your personal Helpdesk area. Our support team is ready to help.

Thank you.

edisastersystems 02-10-2012 12:38 PM
Re: X-Cart v4.4.5 released
 
I had a problem upgrading from 4.4.3 to 4.4.5 in my test environment.

The files updated with no problems, but the SQL patch ran into a problem with the line:

ALTER TABLE xcart_stats_pages ADD UNIQUE page (`page`)

I think it's line 394. It said the database was not updated.

However, If I go back to the Patch/Upgrade center. I am now told the current version is 4.4.4 and there are no patches available. Am I able to attempt patching the database again by running the patch.sql file? Should I be concerned that the version says 4.4.4 instead of 4.4.5? I'm not sure what was wrong with the SQL file in the first place, and unfortunately I can't paste the exact error message since I've navigated away from the page and can't get back.

Any help is appreciated.

[Update]: Disregard the question, the issue has been resolved for now by deleting the store statistics.

seyfin 02-10-2012 09:34 PM
Re: X-Cart v4.4.5 released
 
Quote:
Originally Posted by edisastersystems
I had a problem upgrading from 4.4.3 to 4.4.5 in my test environment.

The files updated with no problems, but the SQL patch ran into a problem with the line:

ALTER TABLE xcart_stats_pages ADD UNIQUE page (`page`)

I think it's line 394. It said the database was not updated.

However, If I go back to the Patch/Upgrade center. I am now told the current version is 4.4.4 and there are no patches available. Am I able to attempt patching the database again by running the patch.sql file? Should I be concerned that the version says 4.4.4 instead of 4.4.5? I'm not sure what was wrong with the SQL file in the first place, and unfortunately I can't paste the exact error message since I've navigated away from the page and can't get back.

Any help is appreciated.

[Update]: Disregard the question, the issue has been resolved for now by deleting the store statistics.

The new version 4.4.5 adds a new UNIQUE KEY on 'page' field in 'xcart_stats_pages' table.

If there are duplicate 'pages' values in 'xcart_stats_pages' table in your original X-Cart database, you will get the error in question during the upgrade.

To solve the problem you should remove the duplicate entries from the table, or simply delete all statistics data from the table.

nortonz 02-10-2012 11:56 PM
Re: X-Cart v4.4.5 released
 
Quote:
Originally Posted by seyfin
Admin side, "Appearance" page -> "Cart & Checkout" section, and "Security" page -> "PCI DSS compliance options" section.

Once you get this code where do you put it

Michael

flyclothing 02-11-2012 01:49 PM
Re: X-Cart v4.4.5 released
 
It looks like the socialize mod isnt working correctly still. Whenever you like an item from the product page, it posts the wrong image.

cflsystems 02-11-2012 02:09 PM
Re: X-Cart v4.4.5 released
 
Sitemap 4.4.5 bug

Code:

SQL query : SELECT COUNT(xcart_products.productid) FROM xcart_products
LEFT JOIN xcart_variants ON
xcart_variants.productid=xcart_products.productid WHERE
xcart_products.forsale = 'Y' AND IFNULL(xcart_variants.avail,
xcart_products.avail)>0 GROUP BY id LIMIT 1
Error code : 1054
Description : Unknown column 'id' in 'group statement'
Request URI: /admin/configuration.php?option=Sitemap
Backtrace:
/public_html/include/func/func.db.php:303
/public_html/include/func/func.db.php:203
/public_html/include/func/func.db.php:554
/public_html/modules/Sitemap/func.php:258
/public_html/modules/Sitemap/func.php:1203
/public_html/modules/Sitemap/func.php:812
/public_html/modules/Sitemap/init.php:72
/public_html/init.php:1225
/public_html/admin/auth.php:60
/public_html/admin/configuration.php:63

In /home/flycloth/public_html/modules/Sitemap/func.php find

$group_by[] = 'id';

replace with

$group_by[] = "$sql_tbl[products].productid";

cflsystems 02-11-2012 02:13 PM
Re: X-Cart v4.4.5 released
 
This is still not fixed in 4.4.5 even though reported 4 months ago and Sergey said it will be considered

http://forum.x-cart.com/showpost.php?p=325696&postcount=66

Eyeglasses Expert 02-12-2012 04:00 PM
Re: X-Cart v4.4.5 released
 
we need 100% stable version!

ARW VISIONS 02-12-2012 07:45 PM
Re: X-Cart v4.4.5 released
 
prob stick with 4.4.4 for a while =D

cflsystems 02-12-2012 09:31 PM
Re: X-Cart v4.4.5 released
 
Quote:
Originally Posted by Eyeglasses Expert
we need 100% stable version!

There is no such animal


All times are GMT -8. The time now is 01:57 AM.
Page 3 of 10 < 12 3 45 > Last »
Show 40 posts from this thread on one page

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.