X-Cart: shopping cart software

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

mvs 03-11-2020 10:09 AM

X-Cart 4.7.12 released
 
Hi fellow X-Carters,

We’ve just released X-Cart v4.7.12. You might want to check out the blog post:
https://www.x-cart.com/blog/x-cart-4-7-12-released.html

aim 03-11-2020 11:34 AM

Re: X-Cart 4.7.12 released
 
*BACKOFFICE*
[*] 28 Jan 2020, aim - Improvement (Y:148883): Updated the selector of payment gateways per country on the 'Main page :: Payment methods' page. Removed the 'PayByCheck - XML' payment gateway.[*] 14 Jan 2020, aim - Improvement (Y:148882): On some servers buffer output disallowed to print the .(dot) during log operations. Fixed. Thanks to Pino.[*] 03 Jan 2020, aim - Improvement (Y:148881): The warning related to php.net/eol.php updated for PHP7.2.x.
[!] 03 Oct 2019, aim - Bug (Y:148865): Firefox was caching order statuses in the Admin area. https://forum.x-cart.com/showpost.php?p=411729&postcount=8.Fixed

*USERS*
[!] 14 Jun 2019, aim - Bug (Y:148837): Wrong sort order for first states / counties like Alabama in Chrome. Fixed.
*CART*[*] 23 Sep 2019, aim - Improvement (Y:148862, B:0050990): If a product cannot be updated in the cart due to low stock, a warning is now shown.

*PAYMENTS*
[*] 10 Feb 2020, aim - Improvement (Y:148888): [Sage Pay Go - Form protocol] phpseclib updated 2.0.18 - 2.0.25[*] 03 Jun 2019, aim - Improvement (Y:148824): Updated the signup links for Sage Pay.
[!] 06 Feb 2020, aim - Bug (Y:148887): PayPal. Website Payments Pro Hosted. There was a random cancelled request right after a successful payment on some occasions. Fixed. Thanks to Pinakin Patel. (Zone1 Creative Ltd).
[!] 06 Jun 2020, aim - Bug (Y:148830): 'Registration cancel reversal record for PayPal transaction'. PHP Fatal error: Uncaught Error: Call to undefined function func_change_order_status() in include/func/func.paypal.php related to func_paypal_reg_reversal function. Fixed.

*SHIPPING*
[*] 12 Feb 2020, aim - Improvement (Y:148884): USPS update. Code added to prevent 'All Dimensions Must Be Greater Than 0' error. Renamed 'Macedonia, Republic of'.[*] 11 Feb 2020, aim - Improvement (Y:148889): Australia Post updates. Values for pre-paid satchels will no longer reference weight and will now reference size. https://view.email.auspost.com.au/?qs=08788791a932c4ff542497732d0403e616f7b37ae01a4d 9674845e9e375499d555...5a4cb721756141 [APOST]

*CHECKOUT*
[!] 08 Oct 2019, aim - Bug (Y:148634, B:0051076): Anonymous registration on checkout did not work in Safari/Firefox as autocomplete="off" did not work for the related hidden username field. Fixed.

*MODULES/ADD-ONS*
*Advanced Customer Reviews*
[!] 17 Feb 2020, aim - Bug (Y:148891, B:0051489): [Advanced Customer Reviews] Sql errors like "Duplicate entry '1-1533744000-18290-1257' for key 'func_acr_get_reviews_menu1orderby'". Fixed. [Advanced_Customer_Reviews]
*Amazon Feeds*
[*] 06 Sep 2019, aim - Improvement (Y:148858): [Amazon Feeds] Added the ability to use Singapore, Netherlands, Egypt, Saudi Arabia regions. [Amazon_Feeds]
[*] 28 Jun 2019, aim - Improvement (Y:148839): [Amazon Feeds] WirelessLockedPhone categories added. [Amazon_Feeds]
*AvaTax*[*] 20 Jun 2019, aim - Improvement (Y:148816, B:0050625): [AvaTax] Products tax exempt property was ignored. Fixed. SDK updated from version 15.6.0.0 to 5.10.0.0 .
*Facebook E-Commerce*
[!] 19 Sep 2019, aim - Bug (Y:148849): [Facebook E-Commerce] Facebook Pixel Id did not work without product's microdata. Fixed. Wrong currency for ViewContent/cartChanged/Purchase when XMultiCurrency was used. Fixed. [Facebook_Ecommerce]
*Google Ads by Kliken* [*] 06 Feb 2020, aim - Improvement (Y:148838): [Google Ads Kliken] Google Ads by Kliken integration added. The automated Google Shopping solution to get your products found on Google and grow your X-Cart Store. [Google_Ads_Kliken]
*Google Shopping*
[!] 29 Dec 2019, aim - Bug (Y:148880, B:0051318): [Google Shopping] export issue in cron mode. The files like froogle_en.txt were not deleted before renewal. Fixed. [Froogle]
*Klarna Payments*
[!] 05 Jul 2019, aim - Bug (Y:148841): [Klarna Payments ] White srcreen related to the error 'Call to undefined function func_get_anonymous_userinfo() in modules/Klarna_Payments/postinit.php'. Fixed. [Klarna_Payments]
*One Page Checkout* and *Discount Coupons*
[!] 10 Jul 2019, aim - Bug (Y:148843, B:0050853): [One Page Checkout, Discount Coupons ] Shipping section was not updated on the coupon application. Fixed. [One_Page_Checkout,Discount_Coupons]
*Product Notifications*[*] 04 Jun 2019, aim - Improvement (Y:148822, B:0050560): [Product Notifications] A new selector added: "Show the 'Low stock' notification sign up buttons/forms for the products whose current quantity in stock is smaller/greater than the value defined by the field above". [Product_Notifications][*] 04 Jun 2019, aim - Improvement (Y:148822, B:0050609): [Product Notifications] The option 'Minimal product available amount for low-stock notifications' renamed to 'Product quantity that should trigger the sending of low stock notifications'. Thanks to Anna Verbichenko. [Product_Notifications]
[*] 10 May 2019, aim - Improvement (Y:148820, B:0050642): [Product Notifications] Sent low stock notification when the product stock is equal or less than 'Minimal product available amount for low-stock notifications ' setting. [Product_Notifications]
*Recommended Products*[*] 08 Jul 2019, aim - Improvement (Y:148842): [Recommended Products] More random products are now shown in the 'Customers also bought' section. [Recommended_Products]
*Rich Google Search Results*
[!] 20 Feb 2020, aim - Bug (Y:148896, B:0051401): Rich google search breadcrumbs value deprecated. [Rich_Google_Search_Results]
*Social Feeds*[*] 31 Jan 2020, aim - Improvement (Y:148885): Social Feeds integration added. Facebook, Twitter, Flickr, YouTube feeds. [Social_Feeds]
*TaxJar* [*] 05 Feb 2020, aim - Improvement (Y:148878): TaxJar integration added. TaxJar makes eCommerce easier for everyone by helping merchants spend time on their business, and not sales tax. [TaxJar]
*Two-Factor Authentication*[*] 10 Feb 2020, aim - Improvement (Y:148886): Two-Factor Authentication module added. Two factor authentication using Authy service. [TwoFactorAuth]
*Upselling Products*[*] 06 Jun 2019, aim - Improvement (Y:148832, B:0050659): A new setting added: 'Show hidden products in "Related products" list' [Upselling_Products]
*X-MultiCurrency*[*] 16 Sep 2019, aim - Improvement (Y:148840): [XMultiCurrency] currencyconverterapi.com API changed to V7. [MultiCurrency]

*PERFORMANCE*
[*] 10 Mar 2020, aim - Improvement (Y:148898): memcache worked incorrectly when multiple stores were using the same URL. Fixed. https://help.x-cart.com/X-Cart:Using_Memcached_with_X-Cart[*] 16 Oct 2019, aim - Improvement (Y:148870): Small optimization related to custom smarty functions. Custom classes are loaded on actual call only.[*] 08 Aug 2019, aim - Improvement (Y:148844, B:0050909): Huge speed up of 'Force cache generation' for stores with a lot of categories.[*] 22 May 2019, aim - Improvement (Y:148825, B:0050619): [Image Verification] Optimization for the [Image_Verification] module.

*SECURITY*
[!] 14 Jun 2019, aim - Bug (Y:148835): Possible SQL injection. Fixed.

*MISCELLANEOUS*
[*] 11 Mar 2020, aim - Improvement (Y:148812): The minimum supported PHP version is now 5.4.0.[*] 16 Dec 2019, aim - Improvement (Y:148879): Event handling. The previous result of a handler is now passed to the next handler.[*] 22 May 2019, aim - Improvement (Y:148826): Product tabs did not work in Firefox 66-67 in some cases. Fixed.[*] 08 May 2019, aim - Improvement (Y:148810): CSS & JavaScript minifier (matthiasmullie/minify) updated to 1.3.63 version.
[!] 20 Feb 2020, aim - Bug (Y:148895, B:0051490): Error related to Rich google search missing field 'itemReviewed'. Multiple warnings. Fixed. [Rich_Google_Search_Results][Advanced_Customer_Reviews]
[!] 10 Feb 2020, aim - Bug (Y:148847): PHP 7.4 was not supported. Fixed. [PHP 74 compatible]
[!] 01 Nov 2019, aim - Bug (Y:148866): [GDPR-friendly addon] Jumping submit button on the 'Create Profile' page. Fixed. Major. Since jQuery 3.3.0, position() started using the native offsetParent property which started the respected table, th, and td as offset parents. https://github.com/jquery/api.jquery.com/issues/1081 offset() is replacement for these cases skin/common_files/lib/jqueryui/components/effects/effect-shake.min.js
[!] 08 Oct 2019, aim - Bug (Y:148869): MySQL8.0.17 [MySQL 8017 compatible] minor bugfix. Deprecation. int(11) is not used now to avoid the Warning (Code 1681): Integer display width is deprecated and will be removed in a future release.

adriant 03-18-2020 06:15 AM

Re: X-Cart 4.7.12 released
 
How do you make a product available for Kliken. Doesn't appear to be a an option in the product details.

Also why no GBP (UK) in the currency option for this module? Are we excluded yet again?

aim 03-18-2020 09:06 AM

Re: X-Cart 4.7.12 released
 
1 Attachment(s)
Quote:

Originally Posted by adriant
How do you make a product available for Kliken. Doesn't appear to be a an option in the product details.

Also why no GBP (UK) in the currency option for this module? Are we excluded yet again?


Hello,

:arrow: Kliken team is still working on their service. There is no a special field for the product. Kliken uses REST API to obtain the necessary data.

:arrow: Maybe the currency name is not so obvious




Thank you.

adriant 03-19-2020 02:31 AM

Re: X-Cart 4.7.12 released
 
Thanks for currency pointer......

Have set a category and refreshed the store on Kliken but it keeps coming back with

"We were unable to find any enabled products in your store. Please check for at least 1 enabled product, and resync your store to continue."

aim 03-19-2020 10:19 PM

Re: X-Cart 4.7.12 released
 
Quote:

Originally Posted by adriant
Thanks for currency pointer......

Have set a category and refreshed the store on Kliken but it keeps coming back with

"We were unable to find any enabled products in your store. Please check for at least 1 enabled product, and resync your store to continue."


Hello,
I am consulting with Kliken team regarding the question.

aim 03-23-2020 11:56 PM

Re: X-Cart 4.7.12 released
 
Quote:

Originally Posted by aim
Hello,
I am consulting with Kliken team regarding the question.


Hello,

They said their service was not ready yet.
We will let you know when you can use the module.

Thank you.

elmirage001 05-24-2020 01:11 PM

Re: X-Cart 4.7.12 released
 
Dear XC4 Team,

Just upgraded from 4.7.11 to 4.7.12

Thank you all for such a smooth and easy upgrade!

Paul

herber@wirehub.nl 05-31-2020 08:07 AM

Re: X-Cart 4.7.12 released
 
We are upgrading from 4.7.9 to 4.7.12 on our testing environment, however we are running into this bug:
https://bt.x-cart.com/view.php?id=51786

Is there a patch available that we can run after the upgrade to correct the issue?

During the upgrade itself, we get the following error during the SQL patch:
Code:

SQL PATCH ``patch.sql'' FAILED AT QUERIES:
ALTER TABLE xcart_modules ADD UNIQUE KEY `module_name` (`module_name`);


I believe the rest of the patch runs just fine & this can be ignored as it is only regarding the error above, for the modules that will now appear double in the system. Is there a simple patch we can run afterwards to remove the double modules?

aim 05-31-2020 11:17 PM

Re: X-Cart 4.7.12 released
 
Hello,

You are right, I have added the query intentionally.

You can safely ignore the error in the log files.

To remove duplicates do the following steps:
0) Make a DB backup. (Especially the xcart_modules table)


1) Find the duplicates
Code:

select module_name,moduleid,active,author,tags from  xcart_modules order by module_name, moduleid;


2) Remove the duplicates that have the highest moduleid by using the query
Code:

DELETE FROM xcart_modules WHERE moduleid IN (id1,id2,id3);

3) After that add the UNIQUE INDEX
Code:

ALTER TABLE xcart_modules ADD UNIQUE KEY `module_name` (`module_name`);
to prevent future problems.

Thank you.

PhilJ 10-15-2020 03:12 PM

Re: X-Cart 4.7.12 released
 
Any chance of an update to the roadmap ? :D

adriant 10-16-2020 01:49 AM

Re: X-Cart 4.7.12 released
 
This would be really useful

aim 10-20-2020 12:40 AM

Re: X-Cart 4.7.12 released
 
Hello,

We've updated the roadmap
https://help.x-cart.com/Roadmap

Thank you.

herber@wirehub.nl 10-27-2020 02:57 AM

Re: X-Cart 4.7.12 released
 
Quote:

Originally Posted by aim
Hello,

You are right, I have added the query intentionally.

You can safely ignore the error in the log files.

To remove duplicates do the following steps:
0) Make a DB backup. (Especially the xcart_modules table)


1) Find the duplicates
Code:

select module_name,moduleid,active,author,tags from  xcart_modules order by module_name, moduleid;


2) Remove the duplicates that have the highest moduleid by using the query
Code:

DELETE FROM xcart_modules WHERE moduleid IN (id1,id2,id3);

3) After that add the UNIQUE INDEX
Code:

ALTER TABLE xcart_modules ADD UNIQUE KEY `module_name` (`module_name`);
to prevent future problems.

Thank you.

Sorry, it has been a while since I've had time to continue the 4.7.12 upgrade.
I'm getting the following error when running the ALTER TABLE query:
Code:

Error in query (1061): Duplicate key name 'module_name'

module_name is already an INDEX, should that be changed to UNIQUE?

aim 10-27-2020 07:01 AM

Re: X-Cart 4.7.12 released
 
Quote:

Originally Posted by herber@wirehub.nl
Sorry, it has been a while since I've had time to continue the 4.7.12 upgrade.
I'm getting the following error when running the ALTER TABLE query:
Code:

Error in query (1061): Duplicate key name 'module_name'

module_name is already an INDEX, should that be changed to UNIQUE?


Hello,

When did you download the upgrade pack?

I made a fix in September which took into account your current xcart_modules structure.

Could you upload the upgrade/4.7.9-4.7.12/patch.sql file?

Thank you.

herber@wirehub.nl 10-27-2020 09:18 AM

Re: X-Cart 4.7.12 released
 
Quote:

Originally Posted by aim
Hello,

When did you download the upgrade pack?

I made a fix in September which took into account your current xcart_modules structure.

Could you upload the upgrade/4.7.9-4.7.12/patch.sql file?

Thank you.

This is an 'old' upgrade pack that I downloaded on May 31st, I will download a new one & check if the problem is resolved.

/edit

I have downloaded a new patch from 4.7.9 to 4.7.12 & it gives the same error when upgrading:
Code:

SQL PATCH ``patch.sql'' FAILED AT QUERIES:
ALTER TABLE xcart_modules ADD UNIQUE KEY `module_name` (`module_name`);


But if the solution is to change the INDEX on module_name to UNIQUE, than I will just do that?

aim 10-27-2020 09:34 PM

Re: X-Cart 4.7.12 released
 
Quote:

Originally Posted by herber@wirehub.nl
This is an 'old' upgrade pack that I downloaded on May 31st, I will download a new one & check if the problem is resolved.

/edit

I have downloaded a new patch from 4.7.9 to 4.7.12 & it gives the same error when upgrading:
Code:

SQL PATCH ``patch.sql'' FAILED AT QUERIES:
ALTER TABLE xcart_modules ADD UNIQUE KEY `module_name` (`module_name`);


But if the solution is to change the INDEX on module_name to UNIQUE, than I will just do that?


Hello

There is a code before the ALTER statement which should safely remove duplicates to avoid such errors.

Code:

-- remove duplicates from xCart_mOdules
CREATE TABLE IF NOT EXISTS _xcart_modules_orig_aim_ (
  moduleid int NOT NULL AUTO_INCREMENT,
  module_name varchar(255) NOT NULL DEFAULT '',
  module_descr varchar(255) NOT NULL DEFAULT '',
  `active` char(1) NOT NULL DEFAULT 'Y',
  init_orderby varchar(255) NOT NULL DEFAULT '',
  author varchar(255) NOT NULL DEFAULT 'other',
  module_url varchar(255) NOT NULL DEFAULT '',
  tags varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (moduleid),
  UNIQUE KEY module_name (module_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT IGNORE INTO _xcart_modules_orig_aim_ SELECT moduleid,module_name,module_descr,`active`,init_orderby,author,module_url,tags FROM xcart_modules ORDER BY active DESC, moduleid;
DELETE FROM xcart_modules WHERE moduleid NOT IN (SELECT moduleid FROM _xcart_modules_orig_aim_);
DROP TABLE _xcart_modules_orig_aim_;
-- https://bt.x-cart.com/view.php?id=51786
ALTER TABLE xcart_modules ADD UNIQUE KEY `module_name` (`module_name`);


but you got the idea correctly
You can remove the whole block if your module_name is already UNIQUE KEY

Thank you.

PhilJ 10-29-2020 03:57 AM

Re: X-Cart 4.7.12 released
 
Suggestion for v4.7.13 - When the Email Account Activation module is enabled, after a customer registers, they are returned to the homepage, but there's no message to tell them to check their email!

So it would be nice to show a message or modal to tell them to check their email to activate their account.

aim 10-29-2020 09:07 AM

Re: X-Cart 4.7.12 released
 
1 Attachment(s)
Quote:

Originally Posted by PhilJ
Suggestion for v4.7.13 - When the Email Account Activation module is enabled, after a customer registers, they are returned to the homepage, but there's no message to tell them to check their email!

So it would be nice to show a message or modal to tell them to check their email to activate their account.


Hello.

Thank you for your suggestion.

As I can see it works properly

https://demo.x-cart.com/demo_goldplus/


Maybe there is a module which overwrites the $top_message variable?

Thank you.

PhilJ 10-29-2020 09:37 AM

Re: X-Cart 4.7.12 released
 
Yes, func_email_activation_get_register_top_message() doesn't seem to be doing its job, I'll do some digging, thanks Ildar.

herber@wirehub.nl 11-03-2020 02:07 AM

Re: X-Cart 4.7.12 released
 
After upgrading to 4.7.12 (I am almost ready for the upgrade on our live website), are there any patches I need to apply afterwards?

I see in the files are for 4.7.12:
security-sameSiteCookie-2020-07-28_4.7.12.tgz

Does this need to be applied?
Are there older patches that need to be applied that are not in 4.7.12 (I am coming from 4.7.9 and did not apply any of the jquery / samesitecookie / php7.4 patches to the 4.7.9 installation).

aim 11-03-2020 02:28 AM

Re: X-Cart 4.7.12 released
 
Quote:

Originally Posted by herber@wirehub.nl
After upgrading to 4.7.12 (I am almost ready for the upgrade on our live website), are there any patches I need to apply afterwards?

I see in the files are for 4.7.12:
security-sameSiteCookie-2020-07-28_4.7.12.tgz

Does this need to be applied?
Are there older patches that need to be applied that are not in 4.7.12 (I am coming from 4.7.9 and did not apply any of the jquery / samesitecookie / php7.4 patches to the 4.7.9 installation).





Hello,


security-sameSiteCookie-2020-07-28_4.7.12.tgz is recommended to apply.


There are no other patches for X-Cart 4.7.12



Thank you.

herber@wirehub.nl 11-03-2020 06:36 AM

Re: X-Cart 4.7.12 released
 
Quote:

Originally Posted by aim
Hello,


security-sameSiteCookie-2020-07-28_4.7.12.tgz is recommended to apply.


There are no other patches for X-Cart 4.7.12



Thank you.

Thank you very much, I have applied the 4.7.12 to our live site & applied the sameSiteCookie patch!

herber@wirehub.nl 11-13-2020 02:34 AM

Re: X-Cart 4.7.12 released
 
1 Attachment(s)
I have found a bug in 4.7.12:

When a special offer is applied to an order, it is shown below the order details.

However, it no longer shows the Category Name or the Zone Name in the list.
Also, the links no longer work.

It leads to:
Code:

/admin/search.php?mode=search&cat=912
/admin/search.php?mode=search&cat=912


and

Code:

/admin/zones.php?zoneid=7

However, the file /admin/zones.php doesn't exist, only /provider/zones.php exists.

The /admin/search.php?mode=search&cat=912 file doesn't show the correct search results when clicked on it.

elmirage001 11-28-2020 02:13 PM

Re: X-Cart 4.7.12 released
 
Possible 4.7.12 Issue with New Macs using Edge and Chrome.

My brother-in-law and fellow XC4 user informed me that my site was not displaying properly on his "NEW" Mac using Edge or Chrome. It displayed fine in Safari. All browsers display my site fine on Windows. His "OLD" Mac displayed my site fine on Edge and Chrome.

I tracked it down to the "Use speed-up tool for Javascript" under General Settings. I turned the speed-up tool "OFF" and my site now displays fine on his NEW Mac in Edge and Chrome.

His 4.7.10 site was not affected and displays fine with "Use speed-up tool for Javascript" turned "ON".

Paul

aim 12-02-2020 03:19 AM

Re: X-Cart 4.7.12 released
 
3 Attachment(s)
Quote:

Originally Posted by herber@wirehub.nl
I have found a bug in 4.7.12:

When a special offer is applied to an order, it is shown below the order details.

However, it no longer shows the Category Name or the Zone Name in the list.
Also, the links no longer work.

It leads to:
Code:

/admin/search.php?mode=search&cat=912
/admin/search.php?mode=search&cat=912


and

Code:

/admin/zones.php?zoneid=7

However, the file /admin/zones.php doesn't exist, only /provider/zones.php exists.

The /admin/search.php?mode=search&cat=912 file doesn't show the correct search results when clicked on it.


Hello,

I cannot reproduce the problem with the names


Could you compare your files with the default ones?
default_files_special_offer.tgz

As for links here is the patch.
links.diff

Thank you.

aim 12-02-2020 03:25 AM

Re: X-Cart 4.7.12 released
 
Quote:

Originally Posted by elmirage001
Possible 4.7.12 Issue with New Macs using Edge and Chrome.

My brother-in-law and fellow XC4 user informed me that my site was not displaying properly on his "NEW" Mac using Edge or Chrome. It displayed fine in Safari. All browsers display my site fine on Windows. His "OLD" Mac displayed my site fine on Edge and Chrome.

I tracked it down to the "Use speed-up tool for Javascript" under General Settings. I turned the speed-up tool "OFF" and my site now displays fine on his NEW Mac in Edge and Chrome.

His 4.7.10 site was not affected and displays fine with "Use speed-up tool for Javascript" turned "ON".

Paul


Hello,

Could you post a ticket at https://secure.x-cart.com/ ?

Thank you.

aim 12-10-2020 01:31 AM

Re: X-Cart 4.7.12 released
 
Hello,

We've changed the planned release date to Q1 2021
https://help.x-cart.com/Roadmap

Thank you.


All times are GMT -8. The time now is 11:19 AM.

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