X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Hi friends,

Meet X-Cart 4.7.6 with significant performance improvements, new features, and many bug fixes. Learn more in our blog http://blog.x-cart.com/4-7-6-released.html

I'll add a detailed changelog here in a couple of minutes.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

------------------ X-CART v4.7.6 RELEASED

*DESIGN AND APPEARANCE*

[!] 22 Mar 2016, mixon - Bug (0146039): HTML tags were displayed for currency values in plain text emails. Fixed.

[!] 17 Mar 2016, aim - Bug (0147669): When a customer tried to update their address, the entire site was going blank for a number of seconds in IE (Internet Explorer). Fixed

[!] 11 Mar 2016, mixon - Bug (0145365): Misaligned "Save" label on the "Product details" page in the "Ideal Responsive" skin. Fixed.

*BACKOFFICE*[*] 09 Jun 2016, aim - Improvement (0147933): Added Image Uploader for use within the HTML Editor (CKEditor). The ability to drag and drop images to a textarea is supported. Thanks to Vadim Sattarov (magos).

*USERS*[*] 25 Apr 2016, aim - Improvement (0148078 ) : User address firstname/lastname are now searchable via the 'User search' page in the admin area.
[*] 20 Apr 2016, aim - Improvement (0148044): The message 'Enter the Username associated with your account' on the 'Forgot password?' page is now shown as 'Enter the Username/Email' when the 'Username as login' authorization mode is used.

[!] 07 Apr 2016, aim - Bug (0147928, 0045911): JS error message was not shown when using a password that was the same as the email address. Fixed. Thanks to Steve Stoyanov (Cflsystems)

*PRODUCTS*
[!] 02 Jun 2016, aim - Bug (0148451): After the setting 'Maximum thumbnail width/height' had been changed, product thumbnails continued to use their old sizes. Fixed.

[!] 11 Apr 2016, aim - Bug (0147938 ) : If the first product variant was out of stock, the search results did not provide an add to cart button for the product. Fixed. [Product_Options].

*PAYMENTS*[*] 03 May 2016, aim - Improvement (0146629): "eWay - Responsive Shared Page" payment gateway added. Supports 3D Secure, PayPal, MasterPass and Visa Checkout.
[*] 22 Apr 2016, aim - Improvement (0148082): Removed the no longer supported payment integration 'eWAY - Stored payment (Shared)'. (cc_ewayweb.php)
[*] 25 Mar 2016, aim - Improvement (0147810): Enabled Paypal In-context Express Checkout for all Buyer's countries exept Japan, China (domestic buyers), India (domestic buyers), Algeria, Bahrain, Bhutan, Brunei, Israel, Jordan, Kuwait, Morocco, Oman, Qatar, Saudi Arabia, Tunisia, United Arab Emirates, or Yemen.
[*] 22 Mar 2016, mixon - Improvement (0146352): Amazon Simple Pay is no longer supported. Removed.
[*] 15 Mar 2016, aim - Improvement (0147710): Added a helpful link related to "Payment amount mismatch: wrong order total error" for PayPal Payments Standard.
[*] 09 Mar 2016, aim - Improvement (0140048 ) : Added "Used from Authorize backend" as an option for the Currency: field for Authorize.Net: SIM.

[!] 31 May 2016, aim - Bug (0148436, 0044307): "State/Territory, Postcode" was not pre-selected on the PayPal Payments Standard end when a buyer's country was Australia and the option "Pay with a credit or debit card" was used. Fixed. Thanks to Eugene Bikulov.

[!] 31 May 2016, aim - Bug (0139385, 0042789): 'Canceled by the user' message added to order payment gateway log; products are put back in stock when a user cancels the order on the PayPal Payments Standard end.

[!] 06 May 2016, aim - Bug (0148212, 0046005): PayPal Payments Standard orders failed in some cases (related to IPN and User-Agent header).

[!] 12 Apr 2016, aim - Bug (0147924): The "Please wait" popup froze when a PayPal Payments Advanced transacation was canceled. PHP Fatal error: Uncaught Error: Call to undefined function func_payflow_get_processor_name. Fixed.

*SHIPPING*[*] 10 Jun 2016, aim - Improvement (0148536): Removed the "Select a carrier:" selector related to UPS from the last checkout page.
[*] 25 May 2016, aim - Improvement (0147760): Changes to the Australia Post integration according to the http://auspost.com.au/pdfs/pac-api-update-2016.pdf doc (18 April 2016). New methods added.
[*] 18 May 2016, aim - Improvement (0147528 ) : Added the ability to track multiple order tracking numbers at once via USPS/UPS/FedEx/DHL/Australia_Post in the admin/customer area.

*TAXES*[*] 11 Apr 2016, mixon - Improvement (0146632): Tax Number validation service status note is now added to order details if the service was not available during checkout.[*] 06 Apr 2016, mixon - Improvement (0146632): Tax system improved. A new configuration option "How to operate if Tax Number validation service is not available" added to tax configuration page.
[!] 11 Apr 2016, mixon - Bug (0146632): Tax Number validation actions were not applied in certain cases. Fixed.
[!] 21 Mar 2016, mixon - Bug (0147361): Discount was distributed incorrectly for products with included taxes. Fixed.

*CHECKOUT*
[!] 31 Mar 2016, mixon - Bug (0146632): If the store was configured to use VAT checking service, and VAT checking service was not available, it was still possible to place an order. Fixed.

[!] 18 Feb 2016, mixon - Bug (0146944): When PayPal Express was used with Real-time shipping calculation during a checkout, the shipping cost was not passed to PayPal. Fixed.

*ORDERS*
[!] 25 Mar 2016, aim - Bug (0147783): Export of orders in IIF (QuickBooks) format did not work when the option "Do not delete empty strings in templates" was disabled. Fixed.

[!] 03 Mar 2016, aim - Bug (0147607): Cost_Pricing: Gross profit calculation is now based on paid orders.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

*MODULES/ADD-ONS*
[*] 20 May 2016, aim - Improvement (0148038 ): Pitney_Bowes/XMonitoring modules extracted to become separate free modules.
[*] 04 May 2016, aim - Improvement (0148125): Product_Configurator: Slot/Step descriptions are now filled from the default language description.
[*] 05 Apr 2016, aim - Improvement (0147905): Updated CKEditor HTML_Editor to version 4.5.8.
[*] 31 Mar 2016, mixon - Improvement (0136337): Product notifications: The outdated JQuery tooltips lib replaced with the JQuery UI tooltips v.11.0.4. Minor enhancements related to JQuery UI tooltips animation.
[*] 21 Mar 2016, aim - Improvement (0147643): A new setting - "Apply tax to Discounted subtotal/Subtotal" - added for the TaxCloud module.

[!] 14 Jun 2016, aim - Bug (0148519): Product Notifications: If the inventory level of a disabled product was increased from 0 to a greater quantity, customers who were subscribed to receive back in stock notifications for that product could receive the notification regardless of the fact that the product was still disabled. Fixed.

[!] 09 Jun 2016, aim - Bug (0148531): Call to undefined function func_get_login_by_userid() error (Related to XAffiliate module). Fixed.

[!] 24 May 2016, aim - Bug (0148360, 0046064): Banner System: There was a black background for banners in Google Chrome. Fixed. Thanks to Joe Funderburg (Cherie). [Banner_System]

[!] 04 May 2016, aim - Bug (0138872): "No news available at the moment" on the mailchimp_news.php page. Fixed. [Adv_Mailchimp_Subscription, MailChimp]

[!] 03 May 2016, aim - Bug (0148169, 0045988 ): In certain cases, low inventory email notifications had empty product information in Advanced_Order_Management for new products with product variants. Fixed. [AOM]

[!] 03 May 2016, aim - Bug (0148166): SQL error related to XMultiCurrency module and unknown IP(REMOTE_ADDR). Fixed. Thanks to Isden.

[!] 26 Apr 2016, aim - Bug (0148097, 0045974): X-Affiliate: Banner statistics were not deleted when a banner was deleted. Fixed. Thanks to Doug Lynch. [XAffiliate]

[!] 20 Apr 2016, aim - Bug (0148030): MailChimp icon was not shown in the admin area. Fixed.

[!] 13 Apr 2016, aim - Bug (0147939): "Offer products for free" special offers were not working properly for product variants. Fixed. [Product_Options, Special_Offers]

[!] 25 Mar 2016, mixon - Bug (0146590): Product options: Double javascript alert appeared on the cart page for a combination of options from the exceptions list. Fixed.

[!] 17 Mar 2016, aim - Bug (0147734): PHP Fatal error: Class 'XCCostChange' not found in include/func/func.product.php on line 1550 - when Cost_Pricing module was disabled. Fixed.

[!] 17 Mar 2016, aim - Bug (0147734): Fatal error: Uncaught Error: Class 'XCCostOrderChange' not found in include/func/func.order.php on line 3069 - when Cost_Pricing module was disabled. Fixed.

[!] 16 Mar 2016, aim - Bug (0147667): Special offer bonus points were displayed incorrectly on the cart page if the setting "Reduce customer's bonus points balance after an order has been completed" was used. Fixed.

[!] 14 Mar 2016, mixon - Bug (0147693): AOM: Init current payment method surcharge was not displayed for edited orders. Fixed.

[!] 09 Mar 2016, mixon - Bug (0147627): Pitney Bowes: Error id 33 on cloned products. Fixed. [PB]

[!] 09 Mar 2016, mixon - Bug (0147360): Discount coupons: A coupon could not be applied after changing the cart totals (taxes involved). Fixed.

*IMPORT/EXPORT*

[!] 05 Apr 2016, aim - Bug (0147882): International Detailed description was removed during the import of product data with fulldescr field not specified in the CSV file. Fixed.

*PERFORMANCE*
[*] 10 Jun 2016, aim - Improvement (0148533): Small optimization related to mysql int types in image tables.
[*] 24 May 2016, aim - Improvement (0148360): Moved modules/Banner_System/js/jquery.cycle.all.js to body to increase Google PageSpeed Insights score.
[*] 11 Apr 2016, aim - Improvement (0147969): Small optimization for product search and variants. [Product_Options]
[*] 10 Apr 2016, aim - Improvement (0147958 ): Small optimization related to product quick prices rebuilding.
[*] 01 Apr 2016, aim - Improvement (0147880): Small optimization related to logging.
[*] 29 Mar 2016, aim - Improvement (0147834): welcome_picture.jpg files converted to progressive JPEG format and optimized.

*SECURITY*
[*] 09 Jun 2016, aim - Improvement (0148530): Security improvement related to users. Thanks to Alexey Galkin (nogard).
[*] 25 Mar 2016, mixon - Improvement (0146429): Updated the "htmlpurifier" lib to v.4.7.0
[*] 04 Mar 2016, aim - Improvement (0147619): Security improvement related to the 'Pay with Amazon' module.

*USABILITY*[*] 29 Mar 2016, mixon - Improvement (0134168 ): Product Notifications: Replaced the popup notice with an icon and an explanation text on product details pages.

*MISCELLANEOUS*
[*] 21 Apr 2016, aim - Improvement (0147842): PHP7 support added. 2-3x performance boost.
[*] 07 Apr 2016, aim - Improvement (0147750): Updated jquery from version 2.1.4 to 2.2.4.
[*] 21 Mar 2016, mixon - Improvement (0146557): Updated PHPMailer to v.5.2.16

[!] 05 May 2016, aim - Bug (0147586): Moneybookers Payment methods renamed to Skrill.

[!] 29 Mar 2016, aim - Bug (0147826): Error: Attempted to retrieve non-existent variable ErrorCollectorinclude/lib/htmlpurifier4/library/HTMLPurifier/Context.php on line 48 - related to multiple func_purify_html calls. Fixed.

[!] 30 Mar 2016, mixon - Bug (0146557): PHPMailer SMTP hello was not working with empty host. Changed to localhost.

[!] 09 Mar 2016, aim - Bug (0147659): PHP7 critical bugfix related to phpunsharpmask and detailed images thumbnail regeneration [PHP 7 compatible]

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

so quickly, no need to wait to next month!

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

i will install a demo site today!

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

when will you update all old skins to responsive templates or add more new responsive templates, pls?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

good news that v4.7.6 supports php 7 now, i think i have to study php 7 as soon as possible.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

hope all old templates will be removed and offer us responsive templates! i want to buy a new gold plus also to have a try.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Is it possible to outline how to add multiple tracking numbers to an order, outside of X-Cart?
What table(s) are used for this?

We have a shipping application, not connected to X-Cart, and currently it just adds the tracking number to the field 'tracking' in 'xcart_orders', nothing complicated.
It would be great if you could tell us how to add multiple tracking numbers to an order, so we can have our shipping program changed (self-written) to add tracking numbers in the same way.

Never mind, I see a new table: 'xcart_order_tracking_numbers' which is quite easy! I only don't understand the 'carrier_code' field.

------------

I have just upgraded our testserver to 4.7.6 (from 4.7.5), and this is not visible:

If logged in as a customer, the list with tracking numbers & button (and even the header "Order tracking" is not visible.

They are tracking numbers that are added by hand, not via a shipping provider, so the 'carrier_code' is empty, is that the problem?
How can we get the Track It button attached to it?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Another bug we are experiencing:

Product Notifications Module.
See screenshot.

The 'popup' that should occur when hovering over the icon has disappeared, the text is now permanently displayed.
Perhaps it has to do with the JQuery update?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Which skin do use use ?
Watch shipping method is used for the order ?

The 'carrier_code' field can be empty.

Thank you.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Ideal responsive & not shipping method from the X-Cart system, we ship with the local postal office and just fill in the tracking code by hand.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Dear Michel,

You have to
1)enable the "Order Tracking" module.

2)Optionally, add your track shipper template to the
skin/common_files/modules/Order_Tracking/customer_tracking.tpl file
For example

myshipper_post.tpl can be generated via firefox firebug from your track numbers site


Thank you.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Ha, and here I was thinking I knew quite a lot of X-Cart modules, this one is new to me.
It's working now, great. I will figure out the button with the tracking link myself from here, thank you!
/edit
I already have it working, great. Only it seems Font Awesome is not working, so I am not getting the truck icon, but everything else works flawlessly.
How do I also enable the tracking button on the admin backend?

Have you had time to look at the Production Notifications 'bug' from my 2nd message?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Just wondering if you may be running PHP 7 on your server and whether you may have noticed a speed improvement at all?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

The feature in question has been re-designed.
The action information now available without extra mouse movements for better customers experience.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

We're not running PHP7, we're on a cPanel server & to run PHP7 on a cPanel server, you have to update to EasyApache4, which is still in Beta.
We won't upgrade until that's out of Beta, so no PHP7 for us immediately, unfortunately.

I will be testing with PHP7 on our testserver, just for the fun of it.
I definitely want to switch to PHP7 in the near future, as the results look amazing. Our website is definitely not slow (21.000+ products) and very fast, but faster is always better.

Alright thanks!
I just have to place this:
"It's not a bug, it's a feature!"

But I was already getting the impression that not all customers understood the icons, so it's probably better this way yeah.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

4.7.5 to 4.7.6 upgraded smooth. no issues (4 manually edited files)

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

4.7.4 to 4.7.6 test upgrade, only ran into 2 errors, the html editor files i patched needed fresh ones. So did the discount coupon module files. Everything else looked ok.

edit: spoke too soon, sql patch errors:

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

We have fixed it.

Thank you.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Could you post what has changed? I already have 4.7.6 test environment running and would like to patch it before migrating it to the live environment in 1 or 2 days.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

I have changed INSERT to REPLACE in the patch.sql file for some queries

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

for the record, which db is preferred?
Mysql 5.6 or Mariadb 10.0??
I'm currently on Mysql 5.5

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

MySQL 5.5.50 here.
Would like to know if MariaDB has significant performance improvements. I have no experience with MariaDB, but as far as I can see it is a drop-in replacement (and cPanel supports it, which is also important to us on a cPanel server).

Are there measurements available?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

The VAT checking service for customers trying to add their VAT number, is always unavailable for unknown reasons.

I can't find any error logs regarding this. The same number checks out on VIES. I've tried multiple numbers, could it be that something is being blocked?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

The Vat number checker service requires PHP Soap support, so please make sure it is available in your PHP configuration.

The "http://ec.europa.eu/" URL should be accessible from the hosting server.

Also, you can add the code below to the config.local.php file and check the VNC logs for more info

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Thank you, SOAP was not enabled when PHP was compiled, we will include it next time it is compiled.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

If SOAP is a requirement for a module, shouldn't it be more gracefully checked and handled?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

help! My site is down. upgrade tested ok but now i get this:

[29-Jun-2016 15:53:22 UTC] PHP Fatal error: require_once(): Failed opening required '/home/xxxx/public_html/store/modules/HTML_Editor/admin_func.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxxx/public_html/store/modules/HTML_Editor/config.php on line 71

i tried installing fresh files and still get that.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

I had to restore my 4.7.4 shop, I could not figure out what went wrong. Although, i may have run the patching procedure twice by reloading it by accident. 2nd time i got a bunch of "already patched" messages but i didnt think it would matter.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Did you check that the required file is present and has proper permissions?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

yes, permissions are not the issue. The file exists.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Could you post the listing of your modules/HTML_Editor/ directory ?

like this Screenshot_2016-06-30_10-15-48.png

Thank You.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

drwxr-xr-x 2 4096 Jun 29 08:54 ./
drwxr-xr-x 90 4096 Jun 29 08:53 ../
-rw-r--r-- 1 8666 Jun 29 09:27 admin_func.php
-rw------- 1 3210 Jun 29 09:35 config.php

so is the config read permissions the culprit??

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

actually, you didnt fix it in the upgrade files for 4.7.4 to 4.7.5, the sql in there is still wrong.

If patch.sql fails, do the commands previous to the fail line commit? and the ones after it did not run?

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

1)Could you check the permissions for files in the modules/Cloud_Search/ directory ?

2)It seems your modules/HTML_Editor/config.php differs from the default one





I have fixed it in the 4.7.4-4.7.5.tgz upgrade pack too.

X-Cart upgrade script tries to run all queries after the failed one.

Thank you.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

See answers in quote

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

I have encountered what might be a bug, I don't exactly know.

Sometimes, it seems that an empty entry is created in the table xcart_order_tracking_numbers.
The orderid will be filled in, but no tracking number is present. I haven't been able to find out when these records are created exactly.
In all these cases, this record is created before any tracking number is added to the order by hand. In this case, the order wasn't even shipped, it was picked up, I made up the tracking number that I added. The empty record was already present.

It is not possible to add a tracking number in the order, it will give the error 'Empty ids'.
It can also not be deleted in the order: it will look like it is deleted, but return upon reloading the page.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

Could you change the admin_func.php file permissions to 600 ?

Thank you.

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 

This is a query to delete these empty records



X-Cart adds tracking_numbers for orders shipped by 1-800Courier automatically.

In other cases only an admin can change or add tracking_numbers.

I suppose you have to check your custom modification.

Thank you.