X-Cart forums

[aim]

To whom are running PHP7.2

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

 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]

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]

still getting robot sql errors even after applying the patch:

[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]

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]

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

Originally Posted by Dougrun

still getting robot sql errors even after applying the patch:

[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]

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]

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]

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]

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]

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.