XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / PHP & MySQL Upgrade Killed NewBB
Register
1
Cifug
PHP & MySQL Upgrade Killed NewBB

  • 2016/6/11 1:58

  • Cifug

  • Quite a regular

  • Posts: 208

  • Since: 2007/12/13


Old spec
XOOPS Version XOOPS 2.5.7.2
PHP Version 5.3.29
mySQL Version can't remember??
NewBB Version 4.33 RC12

New spec
XOOPS Version XOOPS 2.5.7.2
PHP Version 5.6.22
mySQL Version 5.6.30
NewBB Version 4.33 RC12

Hi, I had NewBB running fine on the old spec and then upgraded my PHP and MySQL to the latest stable versions. All other parts of the website is running as it should but I'm now getting a blank page at mysite/modules/newbb/ with no errors in debug mode but has an error at the top of the blank page. I have 20 other websites on this server that have been unaffected however I only have one website with NewBB installed so I have nothing to compare this problem to.

The error at the top of the page is:

Quote:
Fatal error: Call to undefined function mysqli_get_server_info() in /home/***/public_html/modules/newbb/class/online.php on line 237
None All Errors (0) Deprecated (0) Queries (42) Blocks (7) Extra (2) Timers(6)


I'm assuming it has to do with the database and I can't for the life of me remember the old version number of MySQL and I just don't understand this error and the associated code. Can anyone help out?

Best regards,
Marty
2
zyspec
Re: PHP & MySQL Upgrade Killed NewBB

  • 2016/6/11 2:50

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


This has to do with the MySQL installation. MySQL has been replaced with MySQLi so you need to make sure you enable it in your PHP installation.

make sure your php.ini has this line:

extension = php_mysqli.dll


NewBB 4.33 RC12 attempts to contact the SQL engine (MYSQLi) in this case directly so that's why it's failing.
3
Cifug
Re: PHP & MySQL Upgrade Killed NewBB

  • 2016/6/11 4:44

  • Cifug

  • Quite a regular

  • Posts: 208

  • Since: 2007/12/13


Hi Zyspec, thank you so much for your help, I did what you said but got the same error.

So, I added the ";" at the beginning and remove the spaces before and after the "=" so it looks the same as the rest of the entries all ready in there.

Like this:
;extension=php_mysqli.dll

This didn't help either... Still same blank page and error:
Fatal error: Call to undefined function mysqli_get_server_info() in /home/***/public_html/modules/newbb/class/online.php on line 237
None All Errors (0) Deprecated (0) Queries (44) Blocks (7) Extra (2) Timers(6)


[edit]Oh and cleared site and browser cache's and have template changes on[/edit]

Cheers,
Marty
4
Mamba
Re: PHP & MySQL Upgrade Killed NewBB

  • 2016/6/11 6:08

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Quote:
So, I added the ";" at the beginning

No, you have to remove ";", so it looks like this:
extension = php_mysqli.dll


And you have to restart the sever, so php_mysqli.dll can kick-in. Right now the server is still not aware of it .
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
5
Cifug
Re: PHP & MySQL Upgrade Killed NewBB

  • 2016/6/11 13:38

  • Cifug

  • Quite a regular

  • Posts: 208

  • Since: 2007/12/13


Thank you Mamba, I thought maybe Zyspec was just speaking in general terms and just thought that I would know how to make it work, as every entry in php.ini has a ";" at the beginning and no spaces in the code so it was an easily recognisable difference for me... Like this code was easily different from "every" piece of code in the php.ini file. Maybe this is a clue??

However, I did what you said and changed my php.ini file back to Zyspec's specification and rebooted my server and still I get the same error:
Fatal error: Call to undefined function mysqli_get_server_info() in /home/***/public_html/modules/newbb/class/online.php on line 237
None All Errors (0) Deprecated (0) Queries (45) Blocks (7) Extra (2) Timers(6)


Is there any other info that might help for diagnosis?

Cheers,
Marty
6
zyspec
Re: PHP & MySQL Upgrade Killed NewBB

  • 2016/6/11 13:44

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


Maybe this will help....

http://php.net/manual/en/mysqli.installation.php
7
Cifug
Re: PHP & MySQL Upgrade Killed NewBB

  • 2016/6/12 2:06

  • Cifug

  • Quite a regular

  • Posts: 208

  • Since: 2007/12/13


Thanks Zyspec, from that document I think
extension = php_mysqli.dll

is for windows, is that right?

I have CentOS 6 so maybe I need to do something else.

I'm so confused lmao.
8
Cifug
Re: PHP & MySQL Upgrade Killed NewBB

  • 2016/6/12 2:52

  • Cifug

  • Quite a regular

  • Posts: 208

  • Since: 2007/12/13


Spoke to the techs at my data center and they are going to recompile with mysqli included. Hopefully this will sort it all out.
9
Mamba
Re: PHP & MySQL Upgrade Killed NewBB

  • 2016/6/12 4:50

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Quote:
On CentOS, the php-mysql package also installs these three PHP extensions.


This is from the link given by Zyspec:
http://php.net/manual/en/mysqli.installation.php

Don't worry about being confused - it happens all the time to me!
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
10
Cifug
Re: PHP & MySQL Upgrade Killed NewBB

  • 2016/6/12 6:42

  • Cifug

  • Quite a regular

  • Posts: 208

  • Since: 2007/12/13


Installed the mysqli extension on my server and everything is now working as it should

Cheers,
Marty

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

262 user(s) are online (155 user(s) are browsing Support Forums)

Members: 0

Guests: 262

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits