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.