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 ''; I have fixed it in the upgrade packs. Thank you. |
Re: X-Cart 4.7.10 released
Quote:
|
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 |
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
Quote:
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:
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
Quote:
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
Quote:
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
Quote:
maybe, but then I get this on occasion.. PHP Code:
Has only happened once though. |
Re: X-Cart 4.7.10 released
Quote:
Hello, Unfortunately, an additional investigation is needed. Please, contact our support team. Thank you. |
All times are GMT -8. The time now is 01:03 PM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.