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

X-Cart 4.7.6 released: Improved Performance, Bugfixes
 
Reply
   X-Cart forums > News and Announcements
 
Thread Tools
  #101  
Old 10-05-2016, 08:02 AM
 
aim aim is online now
Advanced Staff Users
 

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

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

Quote:
Originally Posted by PhilJ
Is anyone out there using PHP 7.0 with v4.7.6?
I'm getting some strange errors when adding to cart...

This occurs on a fresh install. If anyone has any ideas, please let me know

You have two solutions

1) Use current Stable PHP 7.0.11 version
or
2) Apply this patch compatible_with_php7.1RC3.diff


Thank you.
Attached Files
File Type: diff compatible_with_php7.1RC3.diff (1.0 KB, 10 views)
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote

The following 2 users thank aim for this useful post:
chamberinternet (10-05-2016), PhilJ (10-05-2016)
  #102  
Old 10-05-2016, 08:09 AM
 
aim aim is online now
Advanced Staff Users
 

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

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

Quote:
Originally Posted by PhilJ
Oh, I wasn't aware of that, is it still happening? Nothing mentioned in the roadmap.
All I did was upgraded to PHP v7 (7.1.0RC2 in fact) and tried a fresh v4.7.6 install. Everything else seems to be working ok, just add to cart is not.

Please have a look
https://forum.x-cart.com/showpost.php?p=399346&postcount=101

Thank you.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote

The following user thanks aim for this useful post:
PhilJ (10-05-2016)
  #103  
Old 10-05-2016, 08:12 AM
  PhilJ's Avatar 
PhilJ PhilJ is offline
 

X-Guru
  
Join Date: Nov 2002
Location: UK
Posts: 3,585
 

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

ok, I reverted to PHP 7.0.11, applied the patch and add to cart's working now

I was unable to apply the patch in PHP 7.1.0RC2... It just hung at the file checking stage.

I'll post back if I find anything else.

Thank you!
Reply With Quote

The following 2 users thank PhilJ for this useful post:
chamberinternet (10-05-2016), herber@wirehub.nl (10-05-2016)
  #104  
Old 10-05-2016, 09:24 AM
 
herber@wirehub.nl herber@wirehub.nl is offline
 

eXpert
  
Join Date: Nov 2002
Posts: 289
 

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

Quote:
Originally Posted by PhilJ
ok, I reverted to PHP 7.0.11, applied the patch and add to cart's working now

I was unable to apply the patch in PHP 7.1.0RC2... It just hung at the file checking stage.

I'll post back if I find anything else.

Thank you!
How is the performance in PHP7 vs PHP5, anything noticeable?
__________________
X-Cart 4.7.9
Reply With Quote
  #105  
Old 10-05-2016, 11:05 AM
  PhilJ's Avatar 
PhilJ PhilJ is offline
 

X-Guru
  
Join Date: Nov 2002
Location: UK
Posts: 3,585
 

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

Quote:
How is the performance in PHP7 vs PHP5, anything noticeable?
Early days yet, but here's my benchmarks.
Reply With Quote

The following user thanks PhilJ for this useful post:
aim (10-06-2016)
  #106  
Old 10-05-2016, 11:26 AM
 
herber@wirehub.nl herber@wirehub.nl is offline
 

eXpert
  
Join Date: Nov 2002
Posts: 289
 

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

Quote:
Originally Posted by PhilJ
Early days yet, but here's my benchmarks.
Thanks, that is AMAZING.
Does it feel faster on the frontend too?

I tested on our testserver with Apache mod_pagespeed, but the benchmarks didn't show any improvement.
PHP7 might just be the speedup we're looking for.
Not that our site is slow (VPS, Xeon 4 cores, 8,5GB, SSD's) but I'm always looking for speedups. I'm having PHP7 & MariaDB in my mind right now since mod_pagespeed was a letdown.
__________________
X-Cart 4.7.9
Reply With Quote
  #107  
Old 10-10-2016, 04:54 PM
  YakMan's Avatar 
YakMan YakMan is offline
 

Advanced Member
  
Join Date: Sep 2005
Location: Baytown, Texas
Posts: 54
 

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

Upgraded from 4.7.4 to 4.7.6 today. Got the following error,
SQL PATCH ``patch.sql'' FAILED AT QUERIES:


Quote:
...
File xps_cron.php successfully patched
File xps_subscriptions.php successfully patched

SQL PATCH ``patch.sql'' FAILED AT QUERIES:

CREATE TABLE xcart_amazon_feeds ( id mediumint( unsigned NOT NULL
AUTO_INCREMENT, filename varchar(255) NOT NULL , submit_date int(11) NOT
NULL DEFAULT '0', status varchar(30) NOT NULL DEFAULT '', status_date
int(11) NOT NULL DEFAULT '0', feedid varchar(36) NOT NULL DEFAULT '',
response text NOT NULL , is_processed tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (id) ) ENGINE=MyISAM
...

What should I do?
__________________
xCart Gold
Version 5.2 - Total Solutions UNIX VPS

Quote:
  • There are 10 kind of people in the world. Those who know binary and those who don't.
  • He who throws mud loses ground.
  • Always remember, where ever you go, there you are.
Reply With Quote
  #108  
Old 10-10-2016, 09:01 PM
 
aim aim is online now
Advanced Staff Users
 

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

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

Quote:
Originally Posted by YakMan
Upgraded from 4.7.4 to 4.7.6 today. Got the following error,
SQL PATCH ``patch.sql'' FAILED AT QUERIES:



What should I do?

You should check the file
var/log/x-errors_sql-<date>.php

Thank you.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote
  #109  
Old 10-11-2016, 06:16 PM
  YakMan's Avatar 
YakMan YakMan is offline
 

Advanced Member
  
Join Date: Sep 2005
Location: Baytown, Texas
Posts: 54
 

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

Ok, looks like xcart does not have permission to drop tables.

Quote:
Error code : 1142
Description : DROP command denied to user 'xcart'@'localhost' for table 'xcart_xmonitoring_fsystem'

If I fix the sql permissions then, can I run the sql patch again? Do I do that with the admin sql patch tool?

Thanks for the help.
__________________
xCart Gold
Version 5.2 - Total Solutions UNIX VPS

Quote:
  • There are 10 kind of people in the world. Those who know binary and those who don't.
  • He who throws mud loses ground.
  • Always remember, where ever you go, there you are.
Reply With Quote
  #110  
Old 10-11-2016, 08:25 PM
 
aim aim is online now
Advanced Staff Users
 

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

Default Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes

Quote:
Originally Posted by YakMan
Ok, looks like xcart does not have permission to drop tables.



If I fix the sql permissions then, can I run the sql patch again? Do I do that with the admin sql patch tool?

Thanks for the help.

Could you post your
var/upgrade/4.7.4-4.7.6/patch.log file ?

I will check other upgrade steps

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 09:40 AM.

   

 
X-Cart forums © 2001-2018