Post by winter » Wed Oct 26, 2016 10:43 pm

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
Last edited by winter on Sat Nov 19, 2016 6:51 pm, edited 1 time in total.

New member

Posts

Joined
Wed May 16, 2012 6:10 pm

Post by IP_CAM » Thu Oct 27, 2016 12:27 am

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

My Github OC Site: https://github.com/IP-CAM
5'600 + 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 winter » Mon Oct 31, 2016 6:52 pm

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

New member

Posts

Joined
Wed May 16, 2012 6:10 pm

Post by IP_CAM » Mon Oct 31, 2016 7:56 pm

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

My Github OC Site: https://github.com/IP-CAM
5'600 + 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 EvolveWebHosting » Mon Oct 31, 2016 9:51 pm

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.

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhosting.com


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA

Post by winter » Sat Nov 19, 2016 6:51 pm

Resolved - thanks guys for the assistance. Used the patch O0

New member

Posts

Joined
Wed May 16, 2012 6:10 pm
Who is online

Users browsing this forum: No registered users and 177 guests