OpenCart Community

Hi there,

I have recently received this error message on my website

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/winter-light.nl/public_html/login/system/database/mysql.php on line 6

I have added no new modules or upgraded. I am currently using 1.5 but planning to upgrade in the next few weeks. I tried to replace the file in question with a back-up file that i had made before the error message.

Any ideas would be much appreciated.

Many thanks.

winter

there is no file in question to change, just change:
// DB
define('DB_DRIVER', 'mysql');
TO:
// DB
define('DB_DRIVER', 'mysqli');
in BOTH of your config.php files, to make it work again.

And make sure, to read the uncounted amount of Forum Postings, on that so-called UPGRADE, because such
has neither been planned, nor does it exist, by default at least. (Exept possibly for OC v.2.3.x, but I don't know about this) OC-2.x is a NEW Version, and not an upgraded v.1.5.x! Otherways, you will find yourselfs confronted with a broken Shop, and DB, and you will have to get ALL your existing Extensions + Theme, replaced by New One's anyway, matching the Version, you plan to use.

Good Luck
Ernie

Hi Ernie,

Thanks for the prompt response.
I edited BOTH config files but received the following error message:-

Error: Could not load database file mysqli!

Re: the upgrade I meant OC 2 but thank you for the heads up.

Regards,
Mark

well, you probably still use an older V.1.5 Version, in later 1.5.x Versions, mysqli is part of the default software.
But Some Extensions exist, so, you would just have to upload such a file, and then, it works again!
Good Luck
Ernie
https://www.opencart.com/index.php?rout ... rch=mysqli

Go ahead and get your upgrade done sooner rather than later and you won't have anything to worry about. If I'm not mistaken, you can upload the system/database/mysqli.php file from the 1.5.6.4 download and that should work with your current version.

Resolved - thanks guys for the assistance. Used the patch