X-Cart forums

[aim]

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]

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]

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]

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]

How is the performance in PHP7 vs PHP5, anything noticeable?

Early days yet, but here's my benchmarks.

[herber@wirehub.nl]

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]

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

...
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?

[aim]

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]

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

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]

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.