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 » Sat Aug 25, 2018 6:41 am

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: 21723
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: SQL ERROR [ mysqli ]

Post by Mick » Sat Aug 25, 2018 7:01 am

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

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 » Sat Aug 25, 2018 9:29 am

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
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: SQL ERROR [ mysqli ]

Post by RMcGirr83 » Sat Aug 25, 2018 9:47 am

Having read answers on here I changed to mysqli on config.php and purged the cache.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

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 » Sat Aug 25, 2018 9:58 am

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 » Sat Aug 25, 2018 7:38 pm

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 » Sat Aug 25, 2018 7:49 pm

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 » Sat Aug 25, 2018 7:58 pm

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 » Sat Aug 25, 2018 8:00 pm

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: 50916
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: SQL ERROR [ mysqli ]

Post by stevemaury » Sat Aug 25, 2018 9:07 pm

Your phpBB version appears to be 3.0.14, for which support ended over a year ago. We can help you upgrade, though.
For REALLY good and VERY inexpensive hosting CLICK HERE

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: 21723
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: SQL ERROR [ mysqli ]

Post by Mick » 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 more connected we get the more alone we become" - Kyle Broflovski

User avatar
3Di
Former Team Member
Posts: 14454
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: SQL ERROR [ mysqli ]

Post by 3Di » Sun Aug 26, 2018 7:11 am

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
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
✒️ Black Friday 2019 @ The Studio ▪️◾️

eddster411
Registered User
Posts: 12
Joined: Sat Aug 25, 2018 6:30 am

Re: SQL ERROR [ mysqli ]

Post by eddster411 » 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

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10347
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: SQL ERROR [ mysqli ]

Post by Noxwizard » Sun Aug 26, 2018 3:23 pm

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: 50916
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: SQL ERROR [ mysqli ]

Post by stevemaury » Sun Aug 26, 2018 3:39 pm

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'
For REALLY good and VERY inexpensive hosting CLICK HERE

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”