Post by rudolphmaria » Thu Oct 06, 2022 12:21 am

Hello,
I have to move an OpenCart 1.5.6 shop running on PHP 7.2 and MySQL 5.6 to a new server using MySQL 5.7. Before I do this I want to make sure that there are no incompatiblilties with MySQL 5.7. I have searched for it on this forum and on the web but found neither "it work's" nor "it doesn't work". Does anyone here have any experiences with this?
Regards, Rudolph

Newbie

Posts

Joined
Wed Apr 16, 2014 8:27 pm

Post by johnp » Thu Oct 06, 2022 12:28 am

rudolphmaria wrote:
Thu Oct 06, 2022 12:21 am
Hello,
I have to move an OpenCart 1.5.6 shop running on PHP 7.2 and MySQL 5.6 to a new server using MySQL 5.7. Before I do this I want to make sure that there are no incompatiblilties with MySQL 5.7. I have searched for it on this forum and on the web but found neither "it work's" nor "it doesn't work". Does anyone here have any experiences with this?
Regards, Rudolph
Why not clone your site and database and try running it on MySQL 5.7. You'll soon know if it works.

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by OSWorX » Thu Oct 06, 2022 12:20 pm

rudolphmaria wrote:
Thu Oct 06, 2022 12:21 am
Hello,
I have to move an OpenCart 1.5.6 shop running on PHP 7.2 ..
Please, forget php 7.x - is end of life this year!
Only php 8.x should be used - why, search this forum (few post about why to use 8.x over 7.x)

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by rudolphmaria » Thu Oct 06, 2022 6:57 pm

Thanks for your replies.
As far as I have researched OpenCart 1.5.6 doesn't run with any PHP above 7.2. So I have to stick with PHP 7.2. Although EoL it will be available on the server for a much longer time.
I would set up OpenCart 1.5.6 with MySQL 5.7 for testing on the current server. Unfortunately 5.7 is NOT available. Only on the new server.
Is there anyone out there who has set up OpenCart 1.5.6 with MySQL 5.7 and can tell me if there are any incompatibilities? Your help is much appreciated!!!
Regards, Rudolph

Newbie

Posts

Joined
Wed Apr 16, 2014 8:27 pm

Post by johnp » Thu Oct 06, 2022 7:34 pm

rudolphmaria wrote:
Thu Oct 06, 2022 6:57 pm
Thanks for your replies.
As far as I have researched OpenCart 1.5.6 doesn't run with any PHP above 7.2. So I have to stick with PHP 7.2. Although EoL it will be available on the server for a much longer time.
I would set up OpenCart 1.5.6 with MySQL 5.7 for testing on the current server. Unfortunately 5.7 is NOT available. Only on the new server.
Is there anyone out there who has set up OpenCart 1.5.6 with MySQL 5.7 and can tell me if there are any incompatibilities? Your help is much appreciated!!!
Regards, Rudolph
Set up a clean install of OC on the new server. You'll easily see if there are any problems. I suggest using the 1.5.6.5 version. I have it running on PHP 7.4:

https://github.com/condor2/Opencart-1.5.6.5_RC

If you have a pretty clean installation with little or no extensions consider upgrading to a later OC version.

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by rudolphmaria » Thu Oct 06, 2022 11:30 pm

Upgrading OC unfortunately is not an option as it has been massively customized. Testing on a virtual server didn't work as it didn't offer the combination of PHP 7.2 and MySQL 5.7. The new server is part of an upgrade and will only be accessible after the shop has been transferred. Hmm...
So I'm looking for someone out there who has set up OpenCart 1.5.6 with MySQL 5.7 and can tell me if there are any incompatibilities?
Regards, Rudolph

Newbie

Posts

Joined
Wed Apr 16, 2014 8:27 pm

Post by johnp » Thu Oct 06, 2022 11:48 pm

rudolphmaria wrote:
Thu Oct 06, 2022 11:30 pm
Upgrading OC unfortunately is not an option as it has been massively customized. Testing on a virtual server didn't work as it didn't offer the combination of PHP 7.2 and MySQL 5.7. The new server is part of an upgrade and will only be accessible after the shop has been transferred. Hmm...
So I'm looking for someone out there who has set up OpenCart 1.5.6 with MySQL 5.7 and can tell me if there are any incompatibilities?
Regards, Rudolph
Set me up a test account on your new server and I'll upload a copy and give it a go. As for customization. I'm sure what you've had done on your 1.5.6.4 site can be replicated on say 2.3.0.2.

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by johnp » Fri Oct 07, 2022 12:45 am

Just checked a couple of my client's sites. They're running OC 1.5.6.5 on PHP 7.4 and MySQL 5.7.39 with no problems. They won't run on PHP 8.

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by IP_CAM » Fri Oct 07, 2022 1:36 am

Encryption.php File, to make make v.1.5.6.5 installable with PHP v.7.4.30 Versions :
https://www.opencart.com/index.php?rout ... n_id=38012

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by johnp » Fri Oct 07, 2022 1:39 am

Just had a play. I've got this version running on PHP 8.0 and MySQL 5.7.23-23:

https://github.com/IP-CAM/Opencart-v.1. ... 29-Version

It runs on PHP 8.1 but shows a rounding error in /catalog/model/catalog/product.php on line 50

Removing the round function stops this error. Have also installed Vqmod 2.6.6 and Vqmod Manager.

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by IP_CAM » Fri Oct 07, 2022 2:32 am

I also have two other encryption.php files, and both of them work:

Code: Select all

first
-----

<?php
final class Encryption {
	private $key;
	private $iv;
	
	public function __construct($key) {
		$this->key = $key;
	}
	
	public function encrypt($value) {
		return strtr(base64_encode(openssl_encrypt($value, 'aes-128-cbc', hash('sha256', $this->key, true))), '+/=', '-_,');
	}
	
	public function decrypt($value) {
		return trim(openssl_decrypt(base64_decode(strtr($value, '-_,', '+/=')), 'aes-128-cbc', hash('sha256', $this->key, true)));
	}
}
?>

--------------------------------------------------------------------
second
--------

<?php
final class Encryption {
	
	private $cipher = 'aes-256-ctr';
	private $digest = 'sha256';
	private $key;
	
	public function __construct($key) {
		$this->key = $key;
	}

	public function encrypt($value) {
		$key       = openssl_digest($this->key, $this->digest, true);
		$iv_length = openssl_cipher_iv_length($this->cipher);
		$iv        = openssl_random_pseudo_bytes($iv_length);
		return base64_encode($iv . openssl_encrypt($value, $this->cipher, $key, OPENSSL_RAW_DATA, $iv));
	}
	
	public function decrypt($value) {
		$key       = openssl_digest($this->key, $this->digest, true);
		$iv_length = openssl_cipher_iv_length($this->cipher);
		$value     = base64_decode($value);
		$iv        = substr($value, 0, $iv_length);
		$value     = substr($value, $iv_length);
		return openssl_decrypt($value, $this->cipher, $key, OPENSSL_RAW_DATA, $iv);
	}
}
?>

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by johnp » Fri Oct 07, 2022 3:17 am

Just noticed on my test site you can't checkout.

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by johnp » Fri Oct 07, 2022 4:23 am

I've installed the OC Bootstrap Pro theme and it now works fine.

https://www.opencart.com/index.php?rout ... n_id=15752

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by IP_CAM » Fri Oct 07, 2022 4:57 am

Fine, because they both work in two of my bootstrap themed Installs.

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by johnp » Fri Oct 07, 2022 5:17 am

With the upgrade and bootstrap theme 1.5.6.4 store owners should get a bit more life from their store. :)

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK
Who is online

Users browsing this forum: Bing [Bot], mhglobal and 67 guests