X-Cart forums

[Ksenia]

Hi,

We're ready to introduce the new version of X-Cart Classic - v.4.6.4 is available. We hope it will help you to sell more, being a fast, convenient and reliable shopping cart software.

What's new?

*ePDQ Essential integration;
*CyberSource integration;
*updated FedEX API;
*improved X-Payments connector;
*speed optimization;
*Support of PHP 5.5 and MySQli;
* ability to search/export "anonymous" customers

More details in our blog: https://blog.x-cart.com/x-cart-464-released.html

The CHANGELOG is in the attachment.

[Ksenia]

Changelog X-CART v4.6.4 Part 1 of 2

*DESIGN AND APPEARANCE* [*] 12 Mar 2014, mixon - Improvement (0138586): IE detection corrected, due to recent MSIE User agent changes.
[!] 10 May 2014, aim - Bug (0139613): The top message about the format of tax service name did not say that tax service name must not contain spaces. Fixed.

*INTERFACE*
[!] 16 Jun 2014, aim - Bug (0140080): Search function returned all products not filtereted by substring phrase. Fixed using HTML5 placeholder tag. Thanks to Seyfin.

*BACKOFFICE*[*] 10 Jun 2014, aim - Improvement (0139527): Added Test mode notes for eSelect Plus - Hosted Paypages payment gateway.[*] 10 Jun 2014, aim - Improvement (0139526): Added setup notes for the eSelect Plus - Hosted Paypages payment gateway. Thanks to Seyfin.[*] 28 Mar 2014, aim - Improvement (0139033): Added a tooltip for the 'Reply-To newsletter email address' setting (related to the problem of emails getting blocked by Gmail).
[!] 05 Jun 2014, aim - Bug (0140013): Refund error top message was not displayed. Fixed.
[!] 21 May 2014, aim - Bug (0139634): No error message was shown when an invalid format was used for coupons in the Provider area. Fixed.
[!] 28 Apr 2014, aim - Bug (013948: Duplicated variant SKU was not highlighted on the product modify page. Fixed.
[!] 13 May 2014, aim - Bug (0139679): Some error messages were displayed without html tags. Fixed.
[!] 24 Mar 2014, mixon - Bug (0138924): Lexity was not loaded via HTTPS in Admin area. Fixed.
[!] 24 Mar 2014, aim - Bug (013893: Some queries did not free resourses on the product modify page. Fixed.
[!] 07 Mar 2014, aim - Bug (0138754): Debug console did not work in Webmaster mode. Fixed. Changed lib/function.assign_debug_info.php.

*PRODUCTS*
[!] 10 Jun 2014, aim - Bug (0139577): The 'Out of stock' message was not shown properly when the option 'Show quantity selector as input textbox' was used. Fixed.

*USERS*[*] 28 May 2014, aim - Improvement (0139885, 0137155): Added the ability to search for and export users who placed an order without creating a user account. [Anonymous customers]

*PAYMENTS*[*] 25 Jun 2014, mixon - Improvement (0139722): Updated iDeal Rabobank Professional (v.3.3.1), added 2048 bits certificates support. Added debug support for iDEAL, added default params, etc. Plus some code cleanup.[*] 05 Jun 2014, mixon, - Improvement (0137075): Replaced CyberSource Form with CyberSource - Secure Acceptance Web/Mobile.[*] 07 May 2014, mixon - Improvement (0126513): Added ePDQ essential integration.
[!] 16 Apr 2014, mixon - Bug (0139001): PayPal Express checkout total mismatch issue (Error: [PayPal response] Transaction refused because of an invalid argument. See additional error messages for details.: The totals of the cart item amounts do not match order amounts). Fixed.
[!] 18 Mar 2014, aim - Bug (0109797): 'ePDQ - CPI' used http POST request + 'Invoicing address line 2 is too long' error. Fixed. Card Security Code (CSC) is mandatory now.

*SHIPPING*[*] 25 Jun 2014, aim - Improvement (0140234): Shipping engines like USPS/FeDEX are now not run if address fields like s_country are empty. Calculation of shipping quotes for offline methods is allowed. Thanks to Seyfin.[*] 10 Jun 2014, mixon - Improvement (0136087): Updated FedEx shipping carrier integration (now v.14 and uses SOAP as a communication layer). Support for v9 rates was kept to avoid compatibility issues.[*] 10 Jun 2014, mixon - Improvement (0136087): FedEx shipping carrier integration: Dry Ice weight should be in kilograms. Fixed.[*] 17 Mar 2014, aim - Improvement (013886: Insurance Coverage is disabled by default for Canada Post to enable Small Packet methods.
[!] 28 May 2014, aim - Bug (0139886): 1-800Courier and seller address feature did not work in X-Cart Platinum edition.
[!] 28 May 2014, mixon - Bug (0139761): DHL/Airborne: Shipping rates could not be calculated if state name length exceeded the maximum allowed length of 10 characters (This caused problems when a customer entered a state name manually for a country that was marked as 'has states' but did not have states defined, and that name was longer than 10 characters). Fixed. Thanks to Isden.
[!] 27 May 2014, mixon - Bug (0139762): DHL/Airborne: The mandatory fields Street and City were not passed to DHL in some cases. Fixed. Thanks to Isden.
[!] 19 May 2014, mixon - Bug (0139745): DHL/Airborne: "Error: 2556: Country invalid" was returned when an attempt was made to retrieve rates for UK. Fixed.

*CHECKOUT*
[!] 11 Mar 2014, mixon - Bug (0138521) Fast Lane Checkout & PayPal Express Checkout: Incorrect checkout flow issue. Fixed.

*ORDERS*[*] 16 Apr 2014, aim - Improvement (0139300): Filtering by sku(productcode) works as 'sku*' mask now on the order search page.
[!] 22 Apr 2014, mixon - Bug (0119170): Capture button on edited orders displayed a wrong/misleading amount. Fixed.

*MODULES/ADD-ONS*[*] 01 Jul 2014, aim - Improvement (0139142, 0139142, 0135661, 013566): X-Payments Connector: Added the ability to manually save credit cards for future re-use. New configuration page. Lite interface was not working properly in Fast Lane Checkout. Fixed. Other fixes. Thanks to Random.
[!] 01 Jul 2014, aim - Bug (0140380): X-Payments Connector: Charset detection fail in some shops resulting in empty address fields. Fixed.[*] 09 Jun 2014, aim - Improvement (0139715): X-Payments Subscriptions: PayPal methods supported via X-Payments can now be used for subscriptions. Thanks to Mdk. [XPayments][*] 25 Apr 2014, aim - Improvement (0139453): Updated CloudSearch module to 1.3.4. Added Infinite Scroll support. Thanks2Nikita.[*] 24 Apr 2014, aim - Improvement (0138702): Added Pay with Amazon module. Thanks2Vjk. [PayWithAmazon][*] 18 Apr 2014, mixon - Improvement (0135256): HTTPS test is now performed automatically on checkout if it has not been performed yet.[*] 26 Mar 2014, mixon - Improvement (0122287): PayPal_Login: Minor improvements related to error handling. Added a more detailed message describing the reason for log in failure.
[!] 01 Jul 2014, random - Bug (0140380): X-Payments Connector: Charset detection fail in some shops resulting in empty address fields. Fixed.
[!] 30 Jun 2014, mixon - Bug (013333: Antifraud service did not check orders placed via PayPal Advanced. Fixed.
[!] 23 Jun 2014, aim - Bug (0140205): Users were always registered as 'anonymous' in the admin area even when logged in. Thanks to Gss. [Product_Notifications]
[!] 29 May 2014, aim - Bug (0138772): RMA vs. anonymous customers: An incorrect link was formed to the profile of an anonymous user. Fixed.
[!] 27 May 2014, mixon - Bug (0139689): Google Shopping: Products could not be imported when no Manufacturer was specified. Fixed. Thanks to Seyfin.
[!] 27 May 2014, mixon - Bug (0136764): X-Payments Connector: Sometimes during checkout, when a payment method was supposed to be added to or removed from the list of available payment methods as a result of a discount coupon aplied or shipping method changed, the payment methods list was not updated correctly. Fixed.
[!] 23 May 2014, mixon - Bug (0139699): X-AOM: The "Use other discount" option was not applied to the order total. Fixed.
[!] 22 May 2014, mixon - Bug (0139227): X-AOM: Shipping cost was not showing in the order invoice. Fixed.
[!] 24 Apr 2014, mixon - Bug (0139204): X-ProductNotifications: All product variants were shown in Admin back end instead of the one selected by the customer. Fixed. Thanks2Gss.
[!] 22 Apr 2014, mixon - Bug (0136524): X-Auth: JS error on the place order page: "ReferenceError: jQuery is not defined". Fixed. Thanks2Phoenix.
[!] 22 Apr 2014, mixon - Bug (0139164): Compability issue: Javascript error 'jQuery object not defined' on checkout page if X-Payments's 'Use iframe' option and X-Auth module were enabled. Fixed.
[!] 04 Apr 2014, mixon - Bug (0135256): If there was at least one payment method working via X-Payments, the user was redirected to HTTPS on checkout pages, even when HTTPS was not configured. Fixed.
[!] 31 Mar 2014, aim - Bug (0139043): Products Map: Products with a slash character in the product name were sometimes not displayed in Products Map. Fixed. Thanks2Snake.
[!] 25 Mar 2014, mixon - Bug (0138937): Products Map: Products with names starting from numbers did not work. Fixed.
[!] 18 Mar 2014, mixon - Bug (0138809): PayPal_Login: Double-clicking the Login with PayPal button caused an error in IE. Added popup focus.
[!] 17 Mar 2014, mixon - Bug (0138856): PayPal_Login: Sometimes PayPal returned full state name instead of state code. Fixed.

*LANGUAGES*[*] 26 Mar 2014, mixon - Improvement (0138730): Updated a language label.
[!] 28 Mar 2014, aim - Bug (0138966): Hot Products: New Arrivals did not support group product editing mode. Fixed. Thanks2Chemisk.

*IMPORT/EXPORT*
[!] 25 Apr 2014, aim - Bug (0139225): Error related to variants and the 'delete all existing data before importing' feature. Fixed.
[!] 24 Mar 2014, mixon - Bug (0138632): Variant code was not exported correctly for the Wholesale prices section. Fixed

[Ksenia]

Changelog X-CART v4.6.4 Part 2 of 2

*SECURITY*[*] 08 May 2014, aim - Improvement (0135256): Added HTTPS connection test results option signature to increase security.[*] 13 Mar 2014, aim - Improvement (0138824): Small security improvement.

*PERFORMANCE*[*] 25 Jun 2014, aim - Improvement (0140320): Removed duplicate processor_file key for the xcart_payment_methods table.[*] 20 Jun 2014, aim - Improvement (0139661): Janrain Engage/Social Login: Log-in took a very long time sometimes. Fixed. Thanks to Phoenix.[*] 04 Jun 2014, aim - Improvement (0140026): mysql query cache did not work correctly sometimes. Fixed.[*] 04 Jun 2014, aim - Improvement (0140011, 0130603): Some queries are run in destructor[mysqli].[*] 04 Jun 2014, aim - Improvement (0140011, 0130603): Some queries are run in asynchronous mode[mysqli][*] 30 May 2014, aim - Improvement (0139957): Optimization for xcart_customers queries. Moved the default_saved_card_orderid field to a separate table xcart_customer_xpc_saved_cards.default_xpc_orderid .[*] 30 May 2014, aim - Improvement (0139962): Optimization for xcart_customers queries. Moved xcart_customers.cookie_access to a separate table xcart_customer_eu_cookie_accesses.eu_cookie_access .[*] 23 May 2014, aim - Improvement (0139784): Optimization related to platinum edition and $sql_tbl[customers].activity flag.[*] 15 May 2014, aim - Improvement (0139713): Optimization for all xcart_customers queries. Moved xcart_customers.cart field to a separate table xcart_customer_saved_carts.saved_cart.[*] 14 Apr 2014, aim - Improvement (0139253): Opimization for bestsellers on the product.php page.[*] 17 Apr 2014, aim - Improvement (0139323): Opimization for the Cloud_Search module. Join with variants is used only when it is really necessary. Inner join is used instead of left join. IFNULL is not used in select fields.

*MISCELLANEOUS* [*] 25 Jun 2014, mixon - Improvement (0135256): Refactored and improved some code related to HTTPS detection.[*] 24 Jun 2014, mixon - Improvement (0136087): Updated some requirements related to FedEx shipping carrier integration.[*] 23 Jun 2014, mixon - Improvement (0139761): Improved code format.[*] 23 Jun 2014, mixon - Improvement (0139471): If a user chose to enable PayPal during X-Cart installation, PayPal was configured incorrectly. Fixed.[*] 23 Jun 2014, mixon - Improvement (0139001): Code cleanup, removed some spaces.[*] 13 Jun 2014, mixon - Improvement (0135581): Removed the skins "vivid_dreams" and "fashion_mosaic" from X-Cart distribution.[*] 29 Apr 2014, mixon - Improvement (0139445): Hyphen is now allowed in URL's anchor. Thanks2Polyansky.[*] 23 Apr 2014, mixon - Improvement (0139164): Minor improvements related to XAuth module init procedure.[*] 22 Apr 2014, mixon - Improvement (0138944): Performance optimization: func_is_valid_ip, multiple call of the same function (trim) is replaced with
value.[*] 21 Apr 2014, mixon - Improvement (0139356): Replaced font tag with span in the Customer front end.[*] 18 Apr 2014, aim - Improvement (0139341): Updated province codes for Belgium. Thanks to Isden.[*] 26 Mar 2014, mixon - Improvement (0138856): Fixed a PHP notice.[*] 24 Mar 2014, aim - Improvement (0138948, 0130603): Added support for Mysqli.[*] 13 Mar 2014, aim - Improvement (0138817): Added the ability to debug libcurl.
[!] 18 Jun 2014, aim - Bug (0140203, 004351: White screen caused by low pcre. Fixed the backtrack_limit setting. Thanks to Joe.
[!] 13 Jun 2014, mixon - Bug (0136285): Contact us form: Several errors related to form work and validation. Fixed.
[!] 27 May 2014, mixon - Bug (0139804): SQL errors in case of incorrect data entered on the product modify page. Fixed.
[!] 19 May 2014, mixon - Bug (0139720): PayPal Express Checkout: Discount label was passed incorrectly. Fixed.
[!] 19 May 2014, mixon - Bug (0139455): When product management page in the store's back end was opened via https, the product url for customers was also formed using https. Fixed.
[!] 19 May 2014, mixon - Bug (0139544): cc_bean_interaco.php: PHP Fatal error: Call to undefined function func_userinfo(). Fixed. Thanks to Isden.
[!] 28 Apr 2014, mixon - Bug (0139257): Cleanup: Removed code related to product options that existed in X-Cart 3.5.x.
[!] 22 Apr 2014, mixon - Bug (0139385): Payment failed error (instead of redirect) if customer canceled the order and 'returned to store' from PayPal's payment page. Fixed. Now, if the order is canceled on the side of PayPal Standard, the customer is redirected to the store's checkout page; the order remains in the "Not finished" status.
[!] 22 Apr 2014, mixon - Bug (0138944): The function func_is_valid_ip did not work with IPv6 like ::1. Fixed.
[!] 16 Apr 2014, aim - Bug (013929: Notice: Undefined index: enable_outofstock_products in modules/Product_Options/func.php. Fixed.
[!] 31 Mar 2014, aim - Bug (013907: SQL error "Duplicate entry 'en-opt_icons_levels_limit' for key 'PRIMARY'". Fixed. [Flyout_Menus]
[!] 25 Mar 2014, aim - Bug (0138967): SQL error "Field 'comment' doesn't have a default value" in MySQL strict mode (related to Survey module). Fixed.
[!] 18 Mar 2014, mixon - Bug (0138730): Incorrect error message was written to logs when inactive static pages were accessed. Fixed.
[!] 11 Mar 2014, mixon - Bug (0131589): Database integrity check performed after adding a root level static page detected errors ("The table xcart_pages contains some records for which related data in the table xcart_clean_urls has not been found:.."). Fixed.

[herber@wirehub.nl]

Bug:

[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (jquery-1.10.2.js, line 0)

404 as /skin/common_files/lib/jquery-1.10.2.js does not exist.
It is also not included in a fresh 4.6.4 download, only jquery-1.10.2.min.map

[aim]

Originally Posted by herber@wirehub.nl

Bug:

[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (jquery-1.10.2.js, line 0)

404 as /skin/common_files/lib/jquery-1.10.2.js does not exist.
It is also not included in a fresh 4.6.4 download, only jquery-1.10.2.min.map

This file is included as
jquery-min.js

[/www/xcart_4_6_x]$ grep -r jquery-min skin/common_files
skin/common_files/404/404_en.html:<script src="skin/common_files/lib/jquery-min.js" type="text/javascript"></script>
skin/common_files/meta.tpl:<script type="text/javascript" src="{$SkinDir}/lib/jquery-min.js"></script>
skin/common_files/customer/service_js.tpl:{load_defer file="lib/jquery-min.js" type="js"}
skin/common_files/customer/main/payment_wait.tpl:  {load_defer file="lib/jquery-min.js" type="js"}
[/www/xcart_4_6_x]$

Do you see the same problem on our demo ?
http://demo.x-cart.com/demo/home.php

Which browser do you use ?

[herber@wirehub.nl]

Originally Posted by aim

This file is included as
jquery-min.js

[/www/xcart_4_6_x]$ grep -r jquery-min skin/common_files
skin/common_files/404/404_en.html:<script src="skin/common_files/lib/jquery-min.js" type="text/javascript"></script>
skin/common_files/meta.tpl:<script type="text/javascript" src="{$SkinDir}/lib/jquery-min.js"></script>
skin/common_files/customer/service_js.tpl:{load_defer file="lib/jquery-min.js" type="js"}
skin/common_files/customer/main/payment_wait.tpl:  {load_defer file="lib/jquery-min.js" type="js"}
[/www/xcart_4_6_x]$

Do you see the same problem on our demo ?
http://demo.x-cart.com/demo/home.php

Which browser do you use ?

Yes, same error.
Safari 7.0.5 on Mac OS X 10.9.4

The demo also has the same CSS error as I reported in ticket 0043555.

[cflsystems]

I am not seeing this on any browser - xcart demo site. It could be your browser cache

[herber@wirehub.nl]

Originally Posted by cflsystems

I am not seeing this on any browser - xcart demo site. It could be your browser cache

Originally Posted by cflsystems

I am not seeing this on any browser - xcart demo site. It could be your browser cache

Completely different Mac, cleaned Safari Cache & X-Cart cache, still the same 404.

I fixed the CSS bug myself, so that is gone.
I can probably fix the Jquery 404 by just adding a copy of that file, but I'm tired & will try that tomorrow.

[cflsystems]

Serious bug in this upgrade - all orders will appear lost to customers after the upgrade. In admin on customers list page all customers have 0 orders.

Run this to correct (unofficial fix)

UPDATE `xcart_orders` SET `all_userid` = `userid` WHERE 1

[aim]

Originally Posted by cflsystems

Serious bug in this upgrade - all orders will appear lost to customers after the upgrade. In admin on customers list page all customers have 0 orders.

Run this to correct (unofficial fix)

UPDATE `xcart_orders` SET `all_userid` = `userid` WHERE 1

Thank you for the quick WA.

I have reuploaded the upgrade packs with this addition in the patch.sql file

-- Thanks to Steve Stoyanov (Cflsystems)
UPDATE `xcart_orders` SET `all_userid` = `userid` WHERE `all_userid`=0;