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.rudolphmaria wrote: ↑Thu Oct 06, 2022 12:21 amHello,
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
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
Please, forget php 7.x - is end of life this year!rudolphmaria wrote: ↑Thu Oct 06, 2022 12:21 amHello,
I have to move an OpenCart 1.5.6 shop running on PHP 7.2 ..
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.
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:rudolphmaria wrote: ↑Thu Oct 06, 2022 6:57 pmThanks 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
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
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.rudolphmaria wrote: ↑Thu Oct 06, 2022 11:30 pmUpgrading 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
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
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
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.
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
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.
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
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
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.
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
Users browsing this forum: No registered users and 295 guests