SQL ERROR [ mysqli ]

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
eddster411
Registered User
Posts: 12
Joined: Sat Aug 25, 2018 6:30 am

SQL ERROR [ mysqli ]

Post by eddster411 »

HI

My webhosts recently upgraded. Message from them as below

'We'd like to notify you about our planned software upgrades to all our managed services using cPanel / Cloudlinux, where we will be upgrading cPanel to the latest version, which currently is release 74, due in Q3 2018. This means that all our servers (shared hosting, VPS, dedicated), will need to be migrated from EasyApache 3 to EasyApache 4 and from MySQL 5.5+ to MariaDB 10.2, among other new cPanel features available.'

Since the I have been unable to access my forum (main website it fine).

Error Message

'
General Error
SQL ERROR [ mysqli ]

mysql_connect function does not exist, is mysql extension installed? []

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.'

Having read answers on here I changed to mysqli on config.php and purged the cache. Error message now is as above apart from mysqli. My forum was running the up to date version of phpbb.

Can anyone offer some help? I am not an expert and need to have very basic info please!

Thank you
Nicola
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26505
Joined: Fri Aug 29, 2008 9:49 am

Re: SQL ERROR [ mysqli ]

Post by Mick »

Good morning,

I would suggest you speak to your host in the first place as they seem to have messed things up with their server upgrade. In the meantime we need a little more information, please fill out the Support Request Template and post it back here to enable us to assist you better.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
User avatar
canonknipser
Registered User
Posts: 2096
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: SQL ERROR [ mysqli ]

Post by canonknipser »

I suspect your host also changed your php version from 5.x to 7.x.
With php 7.0, the long time deprecated mysql-interface was finally deleted. So, open your config.php with a good editor and change mysql to mysqli (it's also save to do when you are running php 5.x)
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB
User avatar
RMcGirr83
Former Team Member
Posts: 22016
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: SQL ERROR [ mysqli ]

Post by RMcGirr83 »

Having read answers on here I changed to mysqli on config.php and purged the cache.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
User avatar
canonknipser
Registered User
Posts: 2096
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: SQL ERROR [ mysqli ]

Post by canonknipser »

Ups, just looked at his error message
eddster411 wrote: Sat Aug 25, 2018 6:41 am mysql_connect function does not exist, is mysql extension installed?
which clearly states missing mysql functions.

That message doesn't fit to his description of changing the driver.

So maybe his new server setup is missing the mysqli driver also?
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB
eddster411
Registered User
Posts: 12
Joined: Sat Aug 25, 2018 6:30 am

Re: SQL ERROR [ mysqli ]

Post by eddster411 »

Thanks everyone for your replies. My host is insistent that it's nothing to do with them and apparently I am the only customer with the problem. I will fill out the template as soon as pos.
eddster411
Registered User
Posts: 12
Joined: Sat Aug 25, 2018 6:30 am

Re: SQL ERROR [ mysqli ]

Post by eddster411 »

Select allSupport Request Template
What version of phpBB are you using? phpBB 3.2.0
What is your board's URL? http://Www.poetsgraves.co.uk/forum
Who do you host your board with? Ukwebsolutions
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.0-B1
What styles do you currently have installed? No answer given
What language(s) is your board currently using? English
Which database type/version are you using? I Don't Know
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? I am not sure what version I am running. It said I was up to date. I haven't updated for quite a while and the problem started after webhosts upgraded..see original post
Please describe your problem. See original post. Mysql error.
Generated
User avatar
canonknipser
Registered User
Posts: 2096
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: SQL ERROR [ mysqli ]

Post by canonknipser »

create a file called phpinfo.php in the root-folder of your board (where config.php is) with following content:

Code: Select all

<?php
phpinfo();
, call it with http://www.poetsgraves.co.uk/forum/phpinfo.php
and check the output for your php version and the myslqi-extension
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB
eddster411
Registered User
Posts: 12
Joined: Sat Aug 25, 2018 6:30 am

Re: SQL ERROR [ mysqli ]

Post by eddster411 »

Ok thank you. Am out in wilds of Norfolk at moment. Will do that tomorrow. Thanks for your help
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: SQL ERROR [ mysqli ]

Post by stevemaury »

Your phpBB version appears to be 3.0.14, for which support ended over a year ago. We can help you upgrade, though.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26505
Joined: Fri Aug 29, 2008 9:49 am

Re: SQL ERROR [ mysqli ]

Post by Mick »

The PHP version is 5.6.37 and I see a 503 service unavailable error. As far as I can tell your board at http://www.poetsgraves.co.uk/forum/ is unreachable/doesn’t exist. Using FTP what do you see inside the /forum folder?
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: SQL ERROR [ mysqli ]

Post by 3Di »

Mick wrote: Sun Aug 26, 2018 6:53 am The PHP version is 5.6.37 and I see a 503 service unavailable error. As far as I can tell your board at http://www.poetsgraves.co.uk/forum/ is unreachable/doesn’t exist. Using FTP what do you see inside the /forum folder?
The link is http://www.poetsgraves.co.uk/forum/, there is a 503 and the response is:
Screenshot_poetsgraves.png
Which means there are issue with the PHP there, that should and could be solved by the hoster.
If the OP got access to the PHP configuration he/she can enable such PHP extension directly though.

I mean the "mysqli_connect" one, see also: https://stackoverflow.com/questions/621 ... ot-working
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
eddster411
Registered User
Posts: 12
Joined: Sat Aug 25, 2018 6:30 am

Re: SQL ERROR [ mysqli ]

Post by eddster411 »

I've created a phpinfo.php file

PHP Version is 5.6.37
I can't see anything about mysql or mysqli

How can I find out the version of phpbb? I did regularly update it but haven't for a while as it has been saying it's up to date.

Thanks for your ongoing help.. very much appreciated
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10551
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: SQL ERROR [ mysqli ]

Post by Noxwizard »

You will need to speak to your host. It looks like PHP's MySQL module isn't correctly enabled.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: SQL ERROR [ mysqli ]

Post by stevemaury »

eddster411 wrote: Sun Aug 26, 2018 2:59 pm I've created a phpinfo.php file

PHP Version is 5.6.37
I can't see anything about mysql or mysqli

How can I find out the version of phpbb? I did regularly update it but haven't for a while as it has been saying it's up to date.

Thanks for your ongoing help.. very much appreciated
I looked at the prosilver version in /styles/prosilver/style.cfg and it is for 3.0.14. To get a definitive answer to the phpBB version, run this SQL ( Executing SQL Queries in phpMyAdmin )

If your table extensiomn is not phpbb_ (look in the config.php file), change that accordingly:

Code: Select all

SELECT config_value FROM phpbb_config WHERE config_name = 'version'
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Post Reply

Return to “[3.2.x] Support Forum”