Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

X-Cart 4.7.10 released

 
Reply
   X-Cart forums > News and Announcements
 
Thread Tools
  #31  
Old 10-30-2018, 04:34 AM
 
aim aim is offline
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 928
 

Default 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.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote

The following 3 users thank aim for this useful post:
cherie (10-30-2018), elmirage001 (10-30-2018), PhilJ (11-01-2018)
  #32  
Old 10-30-2018, 06:57 AM
  cherie's Avatar 
cherie cherie is offline
 

X-Wizard
  
Join Date: May 2003
Location: USA
Posts: 1,534
 

Default 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?
__________________
redlimeweb.com
custom mods and design integration
4.7 linux
Reply With Quote

The following user thanks cherie for this useful post:
elmirage001 (10-30-2018)
  #33  
Old 10-31-2018, 08:15 AM
 
Dougrun Dougrun is offline
 

X-Adept
  
Join Date: Apr 2012
Posts: 895
 

Default 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
__________________
4.7.x xcart store
Business 5.4xx
Reply With Quote
  #34  
Old 10-31-2018, 12:16 PM
 
Tim Soles Tim Soles is offline
 

Senior Member
  
Join Date: Sep 2006
Location: UK
Posts: 152
 

Default 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.
__________________
Version 4.7.12
Reply With Quote
  #35  
Old 11-01-2018, 03:21 AM
 
aim aim is offline
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 928
 

Default 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.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote
  #36  
Old 11-01-2018, 05:43 AM
 
aim aim is offline
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 928
 

Default 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.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote

The following user thanks aim for this useful post:
Dougrun (11-01-2018)
  #37  
Old 11-01-2018, 12:10 PM
 
Tim Soles Tim Soles is offline
 

Senior Member
  
Join Date: Sep 2006
Location: UK
Posts: 152
 

Default 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?
__________________
Version 4.7.12
Reply With Quote
  #38  
Old 11-01-2018, 06:50 PM
 
PhilJ PhilJ is offline
 

X-Guru
  
Join Date: Nov 2002
Posts: 4,094
 

Default 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
__________________
xcartmods.co.uk
Reply With Quote

The following 3 users thank PhilJ for this useful post:
aim (11-01-2018), elmirage001 (11-02-2018), Tim Soles (11-02-2018)
  #39  
Old 11-05-2018, 01:56 PM
 
Dougrun Dougrun is offline
 

X-Adept
  
Join Date: Apr 2012
Posts: 895
 

Default 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.
__________________
4.7.x xcart store
Business 5.4xx
Reply With Quote
  #40  
Old 11-05-2018, 09:35 PM
 
aim aim is offline
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 928
 

Default 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.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote
Reply
   X-Cart forums > News and Announcements


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


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

   

 
X-Cart forums © 2001-2020