X-Cart 4.7.10 released: Improved SEO & Performance, Mailchimp Order Notifications
 

Hey everyone!

We've released a new X-Cart Classic version today - v 4.7.10. Here is an overview of the improvements: https://www.x-cart.com/blog/x-cart-4-7-10.html

Re: X-Cart 4.7.10 released: Improved SEO & Performance, Mailchimp Order Notifications
 

*DESIGN AND APPEARANCE*

[!] 18 Sep 2018, aim - Bug (Y:148711, B:0049948 ): [Special_Offers] There was a gap between the product image and the product description in product catalogs. Fixed.

*BACKOFFICE*
[*] 19 Sep 2018, aim - Improvement (Y:148712, B:0049971): Improvement related to the creation of new profiles - Admin, Customer, Provider, Partner. Newly created accounts now have the enabled status by default. Colors added.
[*] 17 Aug 2018, aim - Improvement (Y:148682, B:0049822): [Special_Offers] 'Detailed promo' field is now shown on the 'Main page :: Special offers' page in the Admin area.
[*] 14 Mar 2018, aim - Improvement (Y:148617, B:0049221): Added a help tip related to the 'Group product editing' mode on the 'Product variants' page.
[*] 25 Jan 2018, aim - Improvement (Y:148581, B:0049023): [PayPal Express] Correct errors are now shown on the 'Main page :: Orders management :: Order # details' page in connection with the refund/void/update transaction operations.
[!] 21 Aug 2018, aim - Bug (Y:148685, B:0049806): Autofocus issue on the coupons list in the Admin area. Removed autofocus from skin/common_files/modules/Discount_Coupons/coupons.tpl. Thanks to Joe Funderburg (Cherie).
[!] 28 May 2018, aim - Bug (Y:148660): [Canada Post] Wrong label related to the 'Shipping cost conversion rate:' and US Dollars in the admin area. Fixed.

*USERS*
[*] 24 Apr 2018, aim - Improvement (Y:148649, B:0049277): Updated the states (counties) for UK (Great Britain). [GB]
[*] 14 Feb 2018, aim - Improvement (Y:148596, B:0049005): User profiles values were deleted when a field was deactivated on the Main page :: General settings :: User Profiles page. Fixed.
[!] 06 Sep 2018, aim - Bug (Y:148702, B:0049890, B:0049903): [Additional fields] Partner and provider additional fields were shown in the customer email notifications and on the Admin Order details page. Fixed.
[!] 13 Apr 2018, aim - Bug (Y:148644, B:0049378 ): [Static pages] Wrong 'Disabled' status was shown on the Main page :: Static pages :: Edit page. Fixed.

*PAYMENTS*
[*] 03 Apr 2018, aim - Improvement (Y:148635, B:0049300): Disabled the Refund feature for 'Fulfillment staff' members. Added a confirmation dialog. Thanks to Ross Kelson.
[*] 15 Mar 2018, aim - Improvement (Y:148618, B:0049215): [PayPal] Added the ability to use the Guest Checkout option. You must have PayPal Account Optional set to 'On' within the PayPal account settings to turn on this feature. Thanks to Joe Funderburg (Cherie). https://www.paypal.com/us/selfhelp/article/how-do-i-accept-credit-cards-with-express-checkout-using-the-gu...-option-ts1623
[*] 06 Feb 2018, aim - Improvement (Y:148590): [PayPal] does not change the order status from 'Complete' to 'Processed' now when a dispute/case is closed.
[!] 04 Oct 2018, aim - Bug (Y:148718 ): [HeidelPay - Cheque] payment gateway. PHP7.2 compatibility.
[!] 17 Aug 2018, aim - Bug (Y:148681, B:0049814): PayPal Express/Website Payments Pro Hosted confusing blank page was displayed when an order was placed using the Submit button at checkout. Fixed.
[!] 19 Mar 2018, aim - Bug (Y:148622, B:0049244): Amazon Pay Button was not displayed. Fixed. Thanks to Joe Funderburg (Cherie).
[!] 14 Mar 2018, aim - Bug (Y:148616, B:0049209): [PayPal Payments Standard] 'Billing address' was used in the 'Ship to'/'Shipped to' sections. Fixed.
[!] 07 Feb 2018, aim - Bug (Y:148591): [PayPal Website Payments Pro Hosted] An error related to the empty last name value. Fixed. Thanks to Pino.

*SHIPPING*
[*] 28 May 2018, aim - Improvement (Y:148661, B:0049522): [FedEx] Added the ability to use manual delivery times. To activate the feature, set the constant XC_FEDEX_USE_MANUAL_DELIVERY_DATES.
[!] 28 Jun 2018, aim - Bug (Y:148671): There were duplicated realtime shipping methods available for a cart when a weight condition was applied. Fixed.
[!] 08 Jun 2018, aim - Bug (Y:148666): [Canada Post] 'Maximum package weight/dimensions' were converted incorrectly. Fixed.
[!] 23 Mar 2018, aim - Bug (Y:148627): [Canada Post] integration was broken (AA006 Platform not authorized.) You have to complete the registration of merchant again after the upgrade is finished here: admin/configuration.php?option=Shipping#CPC_register_but ton

*CHECKOUT*

[!] 06 Sep 2018, aim - Bug (Y:148704): [One Page Checkout] In some cases the Additional field names that had been added on the page 'General settings :: User Profiles' page were displayed as blank. Fixed.

*ORDERS*
[*] 11 Sep 2018, aim - Improvement (Y:148708, B:0049932): [Email Notifications] A link to the order is now added to customer order notifications.
[!] 30 Aug 2018, aim - Bug (Y:148694, B:0049864): International or custom payment names were not used in some order notifications. Fixed.
[!] 04 Apr 2018, aim - Bug (Y:148636, B:0049341): Order export in the '4.0.x compatible' format did not work with the "Do not delete empty strings in templates" option disabled. Fixed.
[!] 14 Feb 2018, aim - Bug (Y:148599): [Order_Tracking] The 'Track It' button in the Admin area did not work. Fixed.

Re: X-Cart 4.7.10 released: Improved SEO & Performance, Mailchimp Order Notifications
 

*MODULES/ADD-ONS*

*Advanced Customer Reviews*
[*] 24 Aug 2018, aim - Improvement (Y:148691, B:0049816): [Advanced Customer Reviews] Removed prefilled rating according to Google Product Rating Team policy. Thanks to Isden.

*Advanced Order Management*
[!] 25 Sep 2018, aim - Bug (Y:148714, B:0049995): [Advanced Order Management] Address line 2 was not saved when the 'Create order' feature was used. Fixed. [AOM]
[!] 27 Feb 2018, aim - Bug (Y:148608, B:0048463): [Advanced_Order_Management] AOM: Shipping cost was changed to zero if the order had been placed with real-time shipping cost calculation.

*Amazon Feeds*
[*] 05 Apr 2018, aim - Improvement (Y:148638 ): [Amazon Feeds] Added the categories Baby(InfantToddlerCarSeat/Stroller), Toys(ChildrensCostume/PartySupplies), CampingEquipment/CyclingEquipment/FishingEquipment/PrinterConsumable/Boot/SportGloves and SkinCareProduct/HairCareProduct/BodyCareProduct/MakeUp/Fragrance/HairRemovalAndShavingProduct. [Amazon_Feeds]
[*] 09 Mar 2018, aim - Improvement (Y:148614): [Amazon Feeds] Added the category Health -> MedicalSupplies.
[*] 01 Feb 2018, aim - Improvement (Y:148587): [Amazon_Feeds] Added the ability to import/export the category (Amazon product type).
[!] 21 Aug 2018, aim - Bug (Y:148683): [Amazon_Feeds] Fatal Error: Class 'XCAmazonFeedsDefs' not found in modules/Amazon_Feeds/func.php on line 632 related to include/search.php. Fixed.
[!] 08 Feb 2018, aim - Bug (Y:148592): [Amazon_Feeds] did not work correctly on PHP 5.4.x and some PHP 5.5.x versions. Fixed. Thanks to Barni.

*Amazon Payments Advanced*
[!] 08 Feb 2018, aim - Bug (Y:148594, B:0049013): [Amazon_Payments_Advanced] When Amazon Pay was active, the other payment methods could not be refunded. Fixed. Thanks to Joe Funderburg (Cherie).

*AvaTax*
[!] 24 Jan 2018, aim - Bug (Y:148578, B:0049025): [AvaTax] The Avalara plugin was making too many API calls. Fixed.

*Custom Order Statuses*
[!] 07 Sep 2018, aim - Bug (Y:148706, B:0049889): [Custom Order Statuses] A newly created order status was not displaying its color. Fixed.

*EU Cookie Law / GDPR-friendly*
[*] 12 Sep 2018, aim - Improvement (Y:148609): Added a new addon - GDPR-friendly - to comply with the EU General Data Protection Regulation. It is based on the EU Cookie Law module. [EU_Cookie_Law]
*Image Verification*[*] 10 Sep 2018, aim - Improvement (Y:148624): [Image Verification] The Captcha code is now changed on every page refresh. Should help to reduce spam messages.
[*] 03 Sep 2018, aim - Improvement (Y:148701, B:0049888 ): [Image_Verification] On the Affiliate partner registration page, the Image verification image was moved to the right side and aligned with the rest of the fields. [Affiliate]

*Interneka*
[*] 26 Sep 2018, aim - Improvement (Y:148715): [Interneka] Removed the obsolete Interneka module.

*GiftRegistry*
[!] 14 Sep 2018, aim - Bug (Y:148615): [Gift_Registry] PHP Fatal error: Uncaught Error: Call to undefined function func_check_uploaded_files_sizes(). Fixed.

*Google Shopping*
[*] 19 Feb 2018, aim - Improvement (Y:148602, B:0049137): [Google Shopping] Added the ability to export feeds via cron. [Froogle]

*Mailchimp*
[*] 03 Oct 2018, aim - Improvement (Y:148717): [Mailchimp] Updated some text abels related to Mailchimp so that the product name reads "Mailchimp".
[*] 25 Sep 2018, aim - Improvement (Y:148709): [Mailchimp] Order notification transactional automation emails are now supported. https://mailchimp.com/help/create-order-notifications/#how+order+notifications+work
[*] 23 Aug 2018, aim - Improvement (Y:148689): [Mailchimp] A saved cart is no longer deleted after a MailChimp abandoned cart link to it is clicked. https://forum.x-cart.com/showpost.php?p=408625&postcount=26
[*] 23 Aug 2018, aim - Improvement (Y:148690, B:0049754): [Mailchimp] Special characters are now allowed in Mailchimp list names.
[*] 17 Apr 2018, aim - Improvement (Y:148646, B:0049395): [MailChimp] Added the landing_site param to support Order notifications automation.
[*] 04 Apr 2018, aim - Improvement (Y:148637):[MailChimp] The setting 'Enable confirmation request for subscription' affects user profile/checkout pages now.
[*] 21 Feb 2018, aim - Improvement (Y:148604, B:0049119): [MailChimp] 'Link orders created outside campaigns to this store' fixes related to connected sites. Thanks to Joe Funderburg (Cherie).
[*] 19 Feb 2018, aim - Improvement (Y:148603): [MailChimp] API lib updated to version 2.5.
[!] 05 Jun 2018, aim - Bug (Y:148664, B:0049584): [MailChimp] Confirmation emails were sent persistently when lists on the last checkout page were used. Fixed. Thanks to Joe Funderburg (Cherie).

*Mandrill*
[*] 06 Jun 2018, aim - Improvement (Y:148665, B:0049583): [Mandrill] Added the ability to specify port/protocol. Added debuggig using define('XC_DEBUG_PHPMAILER', 3).

*MultiCurrency*
[!] 21 Jun 2018, aim - Bug (Y:148640): [MultiCurrency] The old freegeoip API is now treated as deprecated; changed to ipstack.com service or PHP GeoIP extension.
[!] 28 Mar 2018, aim - Bug (Y:148629): [MultiCurrency] 'Google Finance Currency Converter' is deprecated. Added a new 'Free Currency Converter API'.

*On Sale*
[*] 21 Aug 2018, aim - Improvement (Y:148684, B:0049841): [On_Sale] Added a new setting 'Show page navigator on the Home page'.

*Product Options*
[*] 24 Jan 2018, aim - Improvement (Y:148580, B:0048813): [Product_Options] 'Out of stock' top message is now used instead of the popup alert for unavailable variants.

*Product returns*
[*] 07 Sep 2018, aim - Improvement (Y:148707, B:0049921): [Product returns] - Return Time improvement. Added a new setting 'Order status from which return time period is started'.[RMA]

*RMA*
[!] 31 Aug 2018, aim - Bug (Y:148699, B:0049882): [RMA] Return slip: no distance from text to border. 'Print Return Slip' feature. Fixed.

*Segment*
[!] 30 Aug 2018, aim - Bug (Y:148693): [Segment] did not pass the 'Viewed cart/checkout' events on to Google Analytics. Fixed.

*Shopper Approved*
[*] 08 Jun 2018, aim - Improvement (Y:148657): [Shopper Approved] Integration with Shopper Approved Merchant Reviews.

*Socialize*
[*] 11 Oct 2018, aim - Improvement (Y:148583): [Socialize] Google +1 button plusone.js is deprecated. Changed to the newest platform.js.
[!] 17 Sep 2018, aim - Bug (Y:148710): [Socialize] Incorrect shared URL was used on the product details page after the 'Add to Cart' popup had closed. Twitter/Google "+1"/Pinterest/Facebook. Fixed.

*Special Offers*
[*] 31 Aug 2018, aim - Improvement (Y:148696, B:0049868 ): [Special Offers] Added a note for anonymous customers on the cart/checkout pages: 'After checkout registered users will be able to get:'.
[*] 31 Aug 2018, aim - Improvement (Y:148698, B:0049867): [Special Offers] More accurate offers are now shown on the 'Check for special offers' page.
[!] 30 Aug 2018, aim - Bug (Y:148695, B:0049869): [Special offers] Removed the redundant URL 'more offers' from the 'Our special offers' page.

*Tax Cloud*
[!] 28 Aug 2018, aim - Bug (Y:148692, B:0042971): [Tax Cloud] refunds did not work with the Product_Options module. Fixed.

*X-Affiliate*
[*] 06 Sep 2018, aim - Improvement (Y:148705, B:0049865): [XAffiliate] URL for Login was missing from the Affiliate email. Fixed. Added a new setting 'Allow to select pending partner plan'.
[*] 22 May 2018, aim - Improvement (Y:148655, B:0049446): [XAffiliate] The default customer language is now used by default for partners.
[*] 11 May 2018, aim - Improvement (Y:148653, B:0049446): [XAffiliate] Partner registration vs different language. Added the ability to open pages like partner/register.php?sl=fr.

*XBackup*
[*] 18 Jun 2018, aim - Improvement (Y:148669): [XBackup] Error "rm: cannot remove `var/database_backup/backup_18_06_18_12_55_db.sql': No such file or directory". Fixed. Thanks to Pino.

*X-Payments Subscriptions*
[*] 11 Oct 2018, aim - Bug (XP-1086, XP-1732, XP-1691, XP-500): [X-Payments Subscriptions] Taxes/Discounts/Shipping/Bonus Points were not applied to recurring payments. Fixed. Thanks to Aliende.

Re: X-Cart 4.7.10 released: Improved SEO & Performance, Mailchimp Order Notifications
 

*IMPORT/EXPORT*

[!] 31 Jan 2018, aim - Bug (Y:148585): [Advanced_Customer_Reviews] SQL error related to import when drop checkbox was used.

*PERFORMANCE*

[*] 25 Sep 2018, aim - Improvement (Y:148652): [SEO] Google PageSpeed Insights improvement. CSS Delivery Optimization. Prioritization of visible content. Reduction in the size of the above-the-fold content.
[*] 03 Jul 2018, aim - Improvement (Y:148675, Y:148676): [Advanced_Customer_Reviews] Huge optimization for customer reviews menu. [SEO] Google PageSpeed Insights improvement.
[*] 23 Jul 2018, aim - Improvement (Y:148676, Y:148675): Optimization for product's widgets like New Arrivals/Bestsellers/Upselling products and so on. [SEO] Google PageSpeed Insights improvement.
[*] 19 Jun 2018, aim - Improvement (Y:148670): [Product_Options] Optimization of variant addition to the cart.
[*] 14 May 2018, aim - Improvement (Y:148654): Small optimization related to logged in users and languages.
[*] 09 Apr 2018, aim - Improvement (Y:148628 ): InnoDB MySQL engine is used by default now instead of the MyISAM one.
[*] 22 Mar 2018, aim - Improvement (Y:148619): [SEO] Google PageSpeed Insights improvement. Added minification for CSS + JavaScript resources.[ Minify Resources]
[*] 05 Feb 2018, aim - Improvement (Y:148582, B:0048995): Optimized the rebuilding of quick prices. pqmv key in the xcart_pricing table is now UNIQUE. Now a combination of productid, quantity, variantid and membershipid can have only one price value. Thanks to Abr.
[*] 01 Feb 2018, aim - Improvement (Y:148586): [Benchmark] Added the ability to use quick search while benchmark is enabled. (Can be enabled in top.inc.php). Thanks to Mixon.

*SECURITY*

[*] 22 Aug 2018, aim - Improvement (Y:148687, B:0049702): Cookies are now secure and satisfy the PCI Compliance requirement. Only for stores with configured HTTPS. Thanks to Joe Funderburg (Cherie). https://help.x-cart.com/index.php?title=X-Cart:Configuring_HTTPS
[*] 06 Feb 2018, aim - Improvement (Y:148589): [User access control] Added the ability to use upper case in IPv6 addresses. https://help.x-cart.com/index.php?title=X-Cart:User_Access_Control

*MISCELLANEOUS*

[*] 25 Jun 2018, aim - Improvement (Y:148651): Added autofocus for the partner/provider Contact us page.
[*] 27 Feb 2018, aim - Improvement (Y:148607, B:0049009): Small optimization related to the show variables call. Thanks to Abr.
[*] 15 Feb 2018, aim - Improvement (Y:148600, B:0049014): Font Awesome updated from version 4.2.0 to 4.7.0; https://fontawesome.com/v4.7.0/icons/
[*] 13 Feb 2018, aim - Improvement (Y:148597): Removed some outdated P3P headers. Thanks to Isden.
[*] 23 Jan 2018, aim - Improvement (Y:148577): Removed the deprecated $use_tls param for the func_https_request function.
[!] 25 Jun 2018, aim - Bug (Y:148641): When a product management page in the store's back end was accessed via https, the product url for customers was formed using http. Fixed.
[!] 25 May 2018, aim - Bug (Y:148659): MySQL8.0 minor bugfix. Error 'Variable 'sql_mode' can't be set to the value of 'MYSQL40''. Fixed. [mysql 80 compatible]
[!] 25 May 2018, aim - Bug (Y:148659): MySQL8.0 critical bugfix related to STRICT_TRANS_TABLES on some servers. [mysql 80 compatible]
[!] 24 May 2018, aim - Bug (Y:148658, B:0049539): The internal cron was run twice sometimes. Race condition. Fixed. Thanks to Snake && Pino.
[!] 23 May 2018, aim - Bug (Y:148656, B:0049275): [Emails] mail-tester.com reported "-1.396 MISSING_DATE Missing Date: header" for some servers. Fixed. Thanks to Isden.
[!] 13 Mar 2018, aim - Bug (Y:148610): PHP errors were fixed. Warning: Illegal string offset 'EXCEPTIONS_TOTAL_COUNT' in include/func/func.backoffice.php / Illegal string offset 'imgerr_D'
[!] 26 Feb 2018, aim - Bug (Y:148606, B:0049055): [Address book] Additional fields were not restored on error when a new address was added. Fixed.

Re: X-Cart 4.7.10 released
 

great,

[Advanced_Customer_Reviews] Huge optimization for customer reviews menu. --

this was a dog and killed my server a few times had to disable the customer reviews menu and add some code to limited reviews to last 28 days

in function func_acr_get_reviews, I added a condition

if ($_GET['productid']=='') {

$time_search=strtotime("-28 days");
$condition.= " AND $sql_tbl[product_reviews].datetime > $time_search ";

}

-- maybe I'll update this module.. will you have upgrade packs from 4.7.7 to 4.7.10 - don't need much else ..

that and PCI compliant cookies.. I'd like to see how that was done and get it onto my version.

Re: X-Cart 4.7.10 released
 

Hello,

Why didn't you post a ticket regarding the problem?

You can download the upgrade packs as follows.
https://help.x-cart.com/index.php?title=X-Cart:Obtaining_Upgrade_Packs_and_Database_Upgrade_ Scripts

Thank you.

Re: X-Cart 4.7.10 released
 

upgrade went smooth on my small store except the sport life skin sliders (featured/new arriavlas/bestsellers) on the home page, see here:
https://vsa-fitness.com/


looks like the css file modified whats visible, cutting them off at the bottom.

Re: X-Cart 4.7.10 released
 

Hello,

Which browser do you use?
As I can see the sliders are visible.
https://imgur.com/a/XaynBUz

Thank you.

Re: X-Cart 4.7.10 released
 

The latest firefox. See how the arrows have 1 more item on the right and the bottoms are cut off. I have cleared my browser and xc caches. Chrome shows it fine though. weird.

Re: X-Cart 4.7.10 released
 

A huge thank you to the X-CART team for this upgrade! Paul

Upgrade from 4.7.9 went smoothly except some duplicate entry tries for GB States.

SQL query : INSERT INTO xcart_states (`state`, `code`, `country_code`) VALUES ("York", "YOR", "GB") Error code : 1062 Description : Duplicate entry 'GB-YOR' for key 'code' Request URI: /admin/patch.php

Re: X-Cart 4.7.10 released
 

I changed "INSERT INTO" TO "REPLACE INTO" and pasted patch. I also received the error shown below. I checked phpMyAdmin and it was already done. Maybe from doing the GDPR mod a while back?

SQL query : ALTER TABLE xcart_customers
DROP INDEX usertype,
ADD INDEX AccessLogUpdateCustomersEU_GDPR (usertype, status)
Error code : 1091
Description : Can't DROP 'usertype'; check that column/key exists

Patch is now complete with version showing is 4.7.10

Re: X-Cart 4.7.10 released
 

As of PHP 7.1 php-mcrypt was deprecated. As of PHP 7.2 it has been removed removed.

I'm testing v4.7.10 on PHP 7.2 and get a blank screen and the following error when trying to access admin.

[21-Oct-2018 19:48:02 UTC] PHP Fatal error: Uncaught Error: Call to undefined function mcrypt_module_open() in /home/user/mydomain.com/include/blowfish.php:830

I have opened a ticket.

Re: X-Cart 4.7.10 released
 

See this - https://www.techrepublic.com/article/how-to-install-mcrypt-for-php-7-2/

You just need to install it on the server - you can from cPanel

Re: X-Cart 4.7.10 released
 

Hello,


Posted a ticket.
https://bt.x-cart.com/view.php?id=50087


I have adjusted the queries in the upgrade packs.

Thank you.

Re: X-Cart 4.7.10 released
 

The better approach is installing/enabling the OpenSSL PHP extension.

X-Cart 4.7.[9-10] allows using the OpenSSL PHP extension for authorization.

The last update of the mcrypt library was in 2008.

Thank you.

Re: X-Cart 4.7.10 released
 

We have released a fix for the
Sport life skin sliders issue.
https://bt.x-cart.com/view.php?id=50087#attachments

Thank you.

Re: X-Cart 4.7.10 released
 

Thats a pretty big diff file. Most of my files say already patched. Just to be sure I uploaded a complete 478 version of the skin and the front page still has that issue in firefox. I even applied the altskin.FF.css patch and same result.


cache and temp files cleared as well.
If I limit the main category list to 4 items, it fixes itself so i'll just do that for now.

Re: X-Cart 4.7.10 released
 

Hello,

Could you please provide us with the valid SSH/FTP or Control Panel access info to your server so we can see whats causing the issue directly.

Please do not post the access here, instead post it in X-Business access list section here:
https://secure.x-cart.com/customer.php?target=create_access_info

Thank you.

Re: X-Cart 4.7.10 released
 

On a store updated from older versions some (a few) tables show InnoDB while others are MyISAM. Would it be recommended to switch all tables to InnoDB?

Re: X-Cart 4.7.10 released
 

Yes, I believe that is correct.

Re: X-Cart 4.7.10 released
 

Hello,

It is definitely recommended in 3 cases.

1) You are using the newest MySQL/MariaDB version.

or
2) You are experiencing the loss of productivity due to the Meltdown Fix.
https://forums.mysql.com/read.php?21,664350,664350#msg-664350

or
3) You are experiencing the MySQL error 'MySQL table is marked as crashed and should be repaired'
https://confluence.atlassian.com/confkb/mysql-table-is-marked-as-crashed-and-should-be-repaired-151519802.html

In other cases, it is recommended to measure the BEFORE/AFTER performance on a dev server.

Thank you.

Re: X-Cart 4.7.10 released
 

For the past few days we're experiencing periodical site outages. Host support staff claim the reason most probably was very high bot activity with bots hitting the site and tying up MySQL queries.
As one of the measures they suggest switching from MyISAM to InnoDB.

Are there any changes in 4.7.10 as compared to 4.7.9 that would cause issues if x-cart is subjected to high bot activity?

Re: X-Cart 4.7.10 released
 

Maybe your SEO position has been improved due to some of these changes.



It seems you are in the green zone
there
https://developers.google.com/speed/pagespeed/insights/

Could you ask your hosting for the bot's HTTP_USER_AGENT?
Maybe our XCRobots::getRobotsSignatures() method has to be corrected.
It should help to reduce the amount of MySQL queries.


Thank you.

Re: X-Cart 4.7.10 released
 

I'v been having sql errors ever since this update. Today i was locked out of admin after a xcart_sessions_data sql error. Repairing the tables fixed it.



Not sure if it matters but its a InnoDB table. Most of my tables are MyISAM. I'm running 10.2.18-MariaDB



It should be noted that I also updated to the latest MariaDB just before the update

Re: X-Cart 4.7.10 released
 

Google page speed insight results have in fact improved drastically both for mobile and desktop. Thanks for that!

The most heavily active bots for the past few days were MJ12bot (200K+ hits & 4.8+ gigs), Semrushbot, Baidu, and some others. There are a couple of Unknown bots as well.

Re: X-Cart 4.7.10 released
 

is it safe to run



on a live shop (assuming I close the shop)

Re: X-Cart 4.7.10 released
 

Yep, that looks right. Just make sure the table is backed up first.

Here is more info on InnoDB: https://dev.mysql.com/doc/refman/5.5/en/innodb-introduction.html

Re: X-Cart 4.7.10 released
 

Hello,

I have uploaded a patch to update the bot signatures.

It will prevent xcart_sessions_data table overload.

Thank you.

Re: X-Cart 4.7.10 released
 

Thank you very much for the patch!


The MySQL version is 5.5.61-cll. Host support did not report problems as per 2) and 3). I don't think that we can do dev server testing, because in order to have realistic results to compare, we'll have to duplicate our site on the Internet which does not sound like a good idea to me.

We could eventually switch our site to use an InnoDB copy of the database for a while to see what happens. Wonder would it be wise to do it?

Re: X-Cart 4.7.10 released
 

InnoDB in MySQL 5.5 has some limitations which have to be checked by technical staff.
https://stackoverflow.com/questions/15678406/when-to-use-myisam-and-innodb
https://dba.stackexchange.com/questions/22678/when-to-switch-from-myisam-to-innodb

Please contact our support staff at https://secure.x-cart.com/ - I'm not sure if this is something that can be solved via a forum discussion, unfortunately.

Thank you.

Re: X-Cart 4.7.10 released
 

To whom are running PHP7.2

The 'Password Recovery' feature didn't work under PHP7.2. To fix apply the SQL query.

https://bt.x-cart.com/view.php?id=50113#210750

I have fixed it in the upgrade packs.

Thank you.

Re: X-Cart 4.7.10 released
 

Could this be moved to a separate file in the future so that func.core.php doesn't need to be patched just to update the bot signatures?

Re: X-Cart 4.7.10 released
 

still getting robot sql errors even after applying the patch:

Re: X-Cart 4.7.10 released
 

We have the upgrade from 4.7.9 to 4.7.10 in our test environment and everything is patching correctly apart from:

Error for the following file, could not patch:

skin/common_files/modules/EU_Cookie_Law/func.js

Tried downloading the full version of 4.7.10 and copying that file across, expecting it to say it was already patched, but no, same error could not patch.

If we remove that file from file.lst to run the patch then view the site, the pop up saying "this site uses cookies" is missing, so I'm guessing something is wrong.

Re: X-Cart 4.7.10 released
 

1) Ignore the error and finish the upgrade
2) Overwrite your file with the full version of 4.7.10
skin/common_files/modules/EU_Cookie_Law/func.js




Switching to InnoDB for the xcart_sessions_data table should help in this case.
Please contact our support staff at https://secure.x-cart.com/

Thank you.

Re: X-Cart 4.7.10 released
 

We have uploaded an additional patch patch2.diff there
https://bt.x-cart.com/view.php?id=50087
Please apply it.

By the way, it seems the access info has been expired. Could you update it?

Thank you.

Re: X-Cart 4.7.10 released
 

Yes, we have done that and everything looks OK apart from the fact that the cookie message popup is no longer appearing on the home page. Is that the expected outcome?

Re: X-Cart 4.7.10 released
 

Tim, delete cookie named "eucl_cookie_access" and refresh.

Do a CTRL / CMD + SHIFT + i

Firefox - Click Storage tab
Chrome / Opera - Click Application tab > Cookies

Re: X-Cart 4.7.10 released
 

maybe, but then I get this on occasion..



Has only happened once though.

Re: X-Cart 4.7.10 released
 

Hello,

Unfortunately, an additional investigation is needed. Please, contact our support team.

Thank you.