[SOLVED] - Website not compatible with PHP7.2, MySQLi issue

Quote

Post by hslee5 » Tue Nov 26, 2019 5:18 pm

Hi all, my website was down.

Here is where the error shown on my website.
"

Code: Select all

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/orange2y/public_html/system/database/mysql.php:7 Stack trace: #0 /home/orange2y/public_html/vqmod/vqcache/vq2-system_library_db.php(13): DBMySQL->__construct('localhost', 'orange2y_ocar16...', 'abc123ZZ#', 'orange2y_ocar16...') #1 /home/orange2y/public_html/index.php(46): DB->__construct('mysql', 'localhost', 'orange2y_ocar16...', 'abc123ZZ#', 'orange2y_ocar16...') #2 {main} thrown in /home/orange2y/public_html/system/database/mysql.php on line 7
"

I was told by my hosting provider
"
As per checking, the PHP version that your website is previously running is on version 7.2 which is not compatible with your current website scripts.

Therefore, you are required to check with your website developer and make sure that your website is able to run with the PHP version 7.2 with the MySQLi connection instead of MySQL.
"

May I know how can I solve that issue by myself? As my website developer is no longer running the business.

If anyone know how to solve it, can you please help me, really appreciate if you can help me.
Last edited by straightlight on Wed Feb 26, 2020 9:07 am, edited 1 time in total.
hslee5
Newbie
Posts
5
Joined
Tue Dec 30, 2014 5:38 pm
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by johnp » Tue Nov 26, 2019 9:21 pm

This has been covered plenty of times. Either upload the library file for PHP7 or ask your host to roll back PHP on your account to 5.6.

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
johnp
Active Member
Posts
1412
Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by EvolveWebHosting » Sat Dec 14, 2019 5:17 am

johnp wrote: ↑
Tue Nov 26, 2019 9:21 pm
 This has been covered plenty of times. Either upload the library file for PHP7 or ask your host to roll back PHP on your account to 5.6.
I would not suggest anyone roll back or run a website using PHP 5.6. This version has been EOL (End of Life) for over a year now and its highly susceptible to being hacked. Work with a developer if needed and upgrade properly to a version of Opencart that supports PHP 7.2 or 7.3 as they are the only 2 versoins that aren't EOL and actively receive any necessary security patches.

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
EvolveWebHosting
Active Member
Posts
1468
Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by hslee5 » Tue Feb 25, 2020 5:54 pm


hi, i had tried the replacing the default system/library/encryption.php file provided by @IP_CAM method. (viewtopic.php?t=201657)

But I get this error

Code: Select all

2020-02-25 8:33:53 - PHP Warning:  mysqli::close(): Couldn't fetch mysqli in /home/XXXX/public_html/system/database/mysqli.php on line 58
Anyone can help me on this?
Last edited by straightlight on Wed Feb 26, 2020 9:07 am, edited 1 time in total.
Reason: Added code tags.
hslee5
Newbie
Posts
5
Joined
Tue Dec 30, 2014 5:38 pm
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by xxvirusxx » Tue Feb 25, 2020 6:01 pm

viewtopic.php?t=143241

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

User avatar
xxvirusxx
Expert Member
Posts
4157
Joined
Tue Jul 17, 2012 10:35 pm
Location - România
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by johnp » Tue Feb 25, 2020 6:08 pm

Try PHP7.0. My sites run on that but nothing higher.

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
johnp
Active Member
Posts
1412
Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by IP_CAM » Wed Feb 26, 2020 7:13 am

Well, then better get a decent Hoster, PHP 7.0 is already no longer a supported Version. ;)
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
IP_CAM
Legendary Member
Posts
13060
Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by johnp » Wed Feb 26, 2020 5:51 pm

They've got PHP 7.1 on the server Ernie. If I switch to that the sites won't run. They only run on PHP 7.0. I updated the library/encryption.php file but no luck on 7.1

Is anyone else having this problem? I'm using OC 1.5.6.5 plus VQMOD 2.6.1.
Last edited by johnp on Wed Feb 26, 2020 6:31 pm, edited 1 time in total.

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
johnp
Active Member
Posts
1412
Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by xxvirusxx » Wed Feb 26, 2020 6:06 pm

What errors?
And you should update Vqmod to 2.6.4.

Attachments

Screenshot_2020-02-26_12-07-12.png

Screenshot_2020-02-26_12-07-12.png (44.83 KiB) Viewed 11623 times

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

User avatar
xxvirusxx
Expert Member
Posts
4157
Joined
Tue Jul 17, 2012 10:35 pm
Location - România
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by johnp » Wed Feb 26, 2020 6:23 pm

Thanks xxvirusxx. I'll do that now.

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
johnp
Active Member
Posts
1412
Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK
Top

Re: Website not compatible with PHP7.2, MySQLi issue

Quote

Post by johnp » Wed Feb 26, 2020 6:33 pm

Ok. I've updated VQMOD to 2.6.4 on one of my sites and it now runs on PHP7.1. There is no 7.2 on the server. I'll contact my host today and ask them to add it on. Thanks xxvirusxx. :)

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
johnp
Active Member
Posts
1412
Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK
Top
Post Reply
Return to “Installation, Upgrade, & Config Support”
Who is online

Users browsing this forum: No registered users and 17 guests