Post by insomniagam3s » Tue Nov 05, 2019 7:27 am

Hello, I have an extension which is bringing me up a Mysqli issue.

"public_html/catalog/controller/feed/google_base_techsleuth.php on line 2560Unknown: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in"

Here is where the issue is" ... ge=default"

I don't know how to fix this and I tried changing my config.php file in admin/public to mysqli but that did nothing. Techsleuth site is down and there is nobody to talk to so I was wondering if you guys have had any experience with putting your products on google merchant center and getting this issue and what did you do to resolve it.



Tue Nov 05, 2019 7:25 am

Active Member


Tue Jul 17, 2012 10:35 pm
Location - RO

Post by IP_CAM » Thu Nov 07, 2019 8:53 am

And in order to make your OC Version also function with PHP7, either use this Code,
to replace the existing 1.5.6.x Version encryption.php Content:
system/library/encryption.php File Content for PHP v.7+:

Code: Select all

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);
Or use this Mod, it uses a different way of doing it's job, but both Versions of Code will work:
Opencart 1.5.6.x & PHP 7 - PHP 7.2 ... n_id=34428

just to be prepared ... ;)

I don't use Forum Mail, to reach me, contact:
Server Q & A Basic Information on Code + Settings
Demoversion OpenCart LIGHT v.
1'300+ FREE OC Extensions - from OC v.1.5.x up,
on the world's largest OC-related Github Site:

User avatar
Legendary Member


Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 8 guests