X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   News and Announcements (https://forum.x-cart.com/forumdisplay.php?f=28)
-   -   X-Cart 4.7.6 released: Improved Performance, Bugfixes (https://forum.x-cart.com/showthread.php?t=74080)

aim 10-05-2016 08:02 AM

Re: X-Cart 4.7.6 released: Improved Performance, Bugfixes
 
1 Attachment(s)
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.

aim 10-05-2016 08:09 AM

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.

PhilJ 10-05-2016 08:12 AM

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!

herber@wirehub.nl 10-05-2016 09:24 AM

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?

PhilJ 10-05-2016 11:05 AM

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.

herber@wirehub.nl 10-05-2016 11:26 AM

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.

YakMan 10-10-2016 04:54 PM

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(8) 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?

aim 10-10-2016 09:01 PM

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.

YakMan 10-11-2016 06:16 PM

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.

aim 10-11-2016 08:25 PM

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.


All times are GMT -8. The time now is 12:23 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.