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.10 released (https://forum.x-cart.com/showthread.php?t=76592)

aim 10-30-2018 04:34 AM

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.

Code:

ALTER TABLE xcart_reset_passwords MODIFY password_reset_key varchar(255) NOT NULL DEFAULT '';
https://bt.x-cart.com/view.php?id=50113#210750

I have fixed it in the upgrade packs.

Thank you.

cherie 10-30-2018 06:57 AM

Re: X-Cart 4.7.10 released
 
Quote:

Originally Posted by aim
I have uploaded a patch to update the bot signatures.

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?

Dougrun 10-31-2018 08:15 AM

Re: X-Cart 4.7.10 released
 
still getting robot sql errors even after applying the patch:


Code:

[29-Oct-2018 15:08:03] (shop: 29-Oct-2018 08:08:03) SQL error:    Site        :    Remote IP  : 166.67.66.240    Logged as  :      SQL query  : UPDATE xcart_sessions_data SET expiry='1540829283', signature='257c482e6279eb67f892fb6fe3e3c23488ec380c', data = 'a:47:{s:8:\"is_robot\";s:1:\"N\";s:14:\"is_new_session\";b:1;s:5:\"robot\";N;s:11:\"editor_mode\";N;s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:10:\"flc_forced\";b:0;s:15:\"allowed_surveys\";N;s:22:\"antibot_validation_val\";a:5:{s:13:\"on_contact_us\";a:3:{s:8:\"old_code\";s:6:\"OKY1UN\";s:4:\"code\";s:6:\"OKY1UN\";s:4:\"used\";s:1:\"N\";}s:10:\"on_reviews\";a:3:{s:8:\"old_code\";s:6:\"VTLNHO\";s:4:\"code\";s:6:\"VTLNHO\";s:4:\"used\";s:1:\"N\";}s:10:\"on_surveys\";a:3:{s:8:\"old_code\";s:6:\"R0R9VC\";s:4:\"code\";s:6:\"R0R9VC\";s:4:\"used\";s:1:\"N\";}s:13:\"on_news_panel\";a:3:{s:8:\"old_code\";s:6:\"UAE526\";s:4:\"code\";s:6:\"UAE526\";s:4:\"used\";s:1:\"N\";}s:11:\"on_ask_form\";a:3:{s:8:\"old_code\";s:6:\"N00NJ3\";s:4:\"code\";s:6:\"N00NJ3\";s:4:\"used\";s:1:\"N\";}}s:13:\"logged_userid\";i:0;s:23:\"offer_products_priority\";a:0:{}s:4:\"cart\";a:0:{}s:5:\"login\";s:0:\"\";s:10:\"co_disable\";N;s:12:\"cojs_disable\";N;s:11:\"cart_loaded\";N;s:17:\"update_saved_cart\";b:0;s:24:\"postponed_events_storage\";a:0:{}s:11:\"logout_user\";N;s:26:\"session_failed_transaction\";N;s:16:\"add_to_cart_time\";N;s:17:\"always_allow_shop\";b:0;s:11:\"search_data\";a:0:{}s:22:\"https_redirect_counter\";i:0;s:24:\"https_redirect_forbidden\";b:0;s:4:\"wlid\";N;s:11:\"top_message\";a:0:{}s:7:\"partner\";N;s:15:\"partner_clickid\";N;s:14:\"adv_campaignid\";N;s:15:\"referer_session\";s:163:\"http://www.bing.com/search?q=+women%27s+high+jump+shoes&qs=n&sp=-1&pq=women%27s+high+jump+shoes&sc=3-23&sk=&cvid=0517BF279B424B07B24282B22815C776&first=7&FORM=PORE\";s:10:"login_type";s:0:"";s:11:"identifiers";a:0:{}s:14:"remember_login";b:0;s:13:"remember_data";N;s:14:"_remember_vars";N;s:7:"old_lng";N;s:20:"is_switched_language";N;s:14:"filled_surveys";N;s:18:"new_offers_message";N;s:25:"customer_available_offers";a:4:{i:0;s:1:"5";i:1;s:2:"28";i:2;s:2:"31";i:3;s:2:"35";}s:23:"require_change_password";N;s:16:"login_antibot_on";s:0:"";s:18:"anonymous_userinfo";a:0:{}s:24:"recently_viewed_products";a:1:{i:0;i:2185;}s:17:"last_search_range";N;s:24:"stored_navigation_script";s:33:"product.php?productid=2185&cat=20";}' WHERE sessid = 'c3d06db8af960deb013dbc0c58ebb6d4'    Error code  : 144    Description : Table './xxxxxxxxx/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed Request URI: /xxxxx/product.php?productid=2185 Backtrace: /xxx/include/func/func.db.php:754 /xxx/include/func/func.db.php:625 /xxx/include/sessions.php:599 /xxx/include/func/func.core.php:1141 /xxx/product.php:332 /xxx/dispatcher.php:185

Tim Soles 10-31-2018 12:16 PM

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.

aim 11-01-2018 03:21 AM

Re: X-Cart 4.7.10 released
 
Quote:

Originally Posted by Tim Soles
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.


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



Quote:

Originally Posted by Dougrun
still getting robot sql errors even after applying the patch:


Code:

[29-Oct-2018 15:08:03] (shop: 29-Oct-2018 08:08:03) SQL error:    Site        :    Remote IP  : 166.67.66.240    Logged as  :      SQL query  : UPDATE xcart_sessions_data SET expiry='1540829283', signature='257c482e6279eb67f892fb6fe3e3c23488ec380c', data = 'a:47:{s:8:\"is_robot\";s:1:\"N\";s:14:\"is_new_session\";b:1;s:5:\"robot\";N;s:11:\"editor_mode\";N;s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:10:\"flc_forced\";b:0;s:15:\"allowed_surveys\";N;s:22:\"antibot_validation_val\";a:5:{s:13:\"on_contact_us\";a:3:{s:8:\"old_code\";s:6:\"OKY1UN\";s:4:\"code\";s:6:\"OKY1UN\";s:4:\"used\";s:1:\"N\";}s:10:\"on_reviews\";a:3:{s:8:\"old_code\";s:6:\"VTLNHO\";s:4:\"code\";s:6:\"VTLNHO\";s:4:\"used\";s:1:\"N\";}s:10:\"on_surveys\";a:3:{s:8:\"old_code\";s:6:\"R0R9VC\";s:4:\"code\";s:6:\"R0R9VC\";s:4:\"used\";s:1:\"N\";}s:13:\"on_news_panel\";a:3:{s:8:\"old_code\";s:6:\"UAE526\";s:4:\"code\";s:6:\"UAE526\";s:4:\"used\";s:1:\"N\";}s:11:\"on_ask_form\";a:3:{s:8:\"old_code\";s:6:\"N00NJ3\";s:4:\"code\";s:6:\"N00NJ3\";s:4:\"used\";s:1:\"N\";}}s:13:\"logged_userid\";i:0;s:23:\"offer_products_priority\";a:0:{}s:4:\"cart\";a:0:{}s:5:\"login\";s:0:\"\";s:10:\"co_disable\";N;s:12:\"cojs_disable\";N;s:11:\"cart_loaded\";N;s:17:\"update_saved_cart\";b:0;s:24:\"postponed_events_storage\";a:0:{}s:11:\"logout_user\";N;s:26:\"session_failed_transaction\";N;s:16:\"add_to_cart_time\";N;s:17:\"always_allow_shop\";b:0;s:11:\"search_data\";a:0:{}s:22:\"https_redirect_counter\";i:0;s:24:\"https_redirect_forbidden\";b:0;s:4:\"wlid\";N;s:11:\"top_message\";a:0:{}s:7:\"partner\";N;s:15:\"partner_clickid\";N;s:14:\"adv_campaignid\";N;s:15:\"referer_session\";s:163:\"http://www.bing.com/search?q=+women%27s+high+jump+shoes&qs=n&sp=-1&pq=women%27s+high+jump+shoes&sc=3-23&sk=&cvid=0517BF279B424B07B24282B22815C776&first=7&FORM=PORE\";s:10:"login_type";s:0:"";s:11:"identifiers";a:0:{}s:14:"remember_login";b:0;s:13:"remember_data";N;s:14:"_remember_vars";N;s:7:"old_lng";N;s:20:"is_switched_language";N;s:14:"filled_surveys";N;s:18:"new_offers_message";N;s:25:"customer_available_offers";a:4:{i:0;s:1:"5";i:1;s:2:"28";i:2;s:2:"31";i:3;s:2:"35";}s:23:"require_change_password";N;s:16:"login_antibot_on";s:0:"";s:18:"anonymous_userinfo";a:0:{}s:24:"recently_viewed_products";a:1:{i:0;i:2185;}s:17:"last_search_range";N;s:24:"stored_navigation_script";s:33:"product.php?productid=2185&cat=20";}' WHERE sessid = 'c3d06db8af960deb013dbc0c58ebb6d4'    Error code  : 144    Description : Table './xxxxxxxxx/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed Request URI: /xxxxx/product.php?productid=2185 Backtrace: /xxx/include/func/func.db.php:754 /xxx/include/func/func.db.php:625 /xxx/include/sessions.php:599 /xxx/include/func/func.core.php:1141 /xxx/product.php:332 /xxx/dispatcher.php:185


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.

aim 11-01-2018 05:43 AM

Re: X-Cart 4.7.10 released
 
Quote:

Originally Posted by Dougrun
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.


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.

Tim Soles 11-01-2018 12:10 PM

Re: X-Cart 4.7.10 released
 
Quote:

Originally Posted by aim
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



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?

PhilJ 11-01-2018 06:50 PM

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

Dougrun 11-05-2018 01:56 PM

Re: X-Cart 4.7.10 released
 
Quote:

Originally Posted by aim
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.





maybe, but then I get this on occasion..

PHP Code:

Error code  1213
    Description 
Deadlock found when trying to get lock; try restarting transaction 



Has only happened once though.

aim 11-05-2018 09:35 PM

Re: X-Cart 4.7.10 released
 
Quote:

Originally Posted by Dougrun
maybe, but then I get this on occasion..

PHP Code:

Error code  1213
    Description 
Deadlock found when trying to get lock; try restarting transaction 



Has only happened once though.


Hello,

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

Thank you.


All times are GMT -8. The time now is 04:23 PM.

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