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.

Newbie

Posts

Joined
Tue Dec 30, 2014 5:38 pm

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 2.6.1 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
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

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.

Image
Black Friday Specials Active Now https://www.evolvewebhost.com/blog/blac ... riday_2020
Detailed guide on how to install Opencart


User avatar
Active Member

Posts

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

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.

Newbie

Posts

Joined
Tue Dec 30, 2014 5:38 pm

User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

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 2.6.1 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
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

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

Please don't send me OC Forum Personal Messages, just contact: jti@jacob.ch
---
OC 1.5.6.5 LIGHT Test Site: http://www.bigmax.ch/shop/
OC 1.5.6.5 V-PRO Test Site: http://www.openshop.li/shop/
My Github OC Site: https://github.com/IP-CAM
2'600+ FREE OC Extensions on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

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 2.6.1 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
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

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 7482 times


OC 2.3.0.2 | OC 3.0.3.6 | Extensions converted by me | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

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 2.6.1 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
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

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 2.6.1 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
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK
Who is online

Users browsing this forum: No registered users and 8 guests