Php upgrade causes 500 error in VB 5.2.2

[frank47]

Updated to php 5.6 and now entire forum (vb 5.2.2) is completely down...HTTP 500 Internal Sever Error

Do I needc to upgrade to solve this or is there another way?

[Mark.B]

Please upgrade to 5.2.5 in the first instance.

[frank47]

Gee that worked well...
Uploaded 5.2.5 and now get:

2: mysqli_real_connect() expects parameter 6 to be long, string given

from ../core/install/upgrade.php

[Joe D.]

Verify you are using mysqli (i at the end) in the database type -

 $config['Database']['dbtype'] = 'mysqli';

Then verify your database name, username, password are all properly formatted. Did you create a new config.php file or use the same one from 5.2.2?

[frank47]

Neither can be the problem because the forum is actually working with the new uploaded files but does not upgrade as per above..

Trying to log ointo the admincp, says vBulletin 5.1.7 Admin Control Panel

[Joe D.]

The max PHP version for VB 5.1.7 is below the minimum PHP version of VB 5,2,5. Make sure you have upgraded to at least PHP 5.6.x before upgrading. PHP 5.6.x will no longer work with the mysql version in the config.php gile. It must be changed to mysqli and you must ensure php is compiled with mysqli support.

Of course make a database backup before running the upgrade.php file.

[Glenn Vergara]

Check the core config.php and make sure the database server port is set to a number (3306 is the default) and not a string.

$config['MasterServer']['port'] = 3306; 

[frank47]

None of this makes sense ...

Running php 5.6.x
Uploaded all files for 4.2.5

The forum is working but...

1. upgrade.php just gives the error:
"2: mysqli_real_connect() expects parameter 6 to be long, string given"

2. Delete the install directory and try to access Admincp and

Says "vBulletin 5.1.7 Admin Control Panel"
Does not accept my login either

So, if db is working, I must have mysqli enabled - that is not the issue
I do not see amy config.php file within core

[Necrophyte]

Not true. Mysqli and mysql are not the same, which is why it won't move further.
Config.php is in core/includes
You may need to add the php library for mysqli as well.
If you run a PHP script with just phpinfo();
Then do a search for mysqli on the page with CTRL+F. You should see something like below:

mysqli

Client API library version	mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Active Persistent Links	0
Inactive Persistent Links	0
Active Links	0

mysqli.allow_local_infile	On	On
mysqli.allow_persistent	On	On
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	/var/lib/mysql/mysql.sock	/var/lib/mysql/mysql.sock
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.max_persistent	Unlimited	Unlimited
mysqli.reconnect	Off	Off
mysqli.rollback_on_cached_plink	Off	Off

[Joe D.]

config.php is in /core/includes/ directory.

[frank47]

Ok, we are not connecting here.
mysqli is configured in php. I knwo tyhgis because I recompiled and ALSO I have vb 5.2.5 running on another site on the same server.

The config.php does not have

 $config['Database']['dbtype'] = 'mysqli';
OR
$config['MasterServer']['port'] = 3306; 

If I can get to admicp on another site, it is not a mysqli issue

Also it does not let me log into admincp. Doesn't say anything just reloads page
URL is .../loginerror=badlogin_strikes_logintypeemail&strikes=2&vb_login_username=Admin


PHP Version 5.6.28

fyi:

Client API library version	5.5.52
Active Persistent Links
Inactive Persistent Links
Active Links
Client API header version	5.5.52
MYSQLI_SOCKET	/var/lib/mysql/mysql.sock

mysqli.allow_local_infile	On	On
mysqli.allow_persistent	On	On
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	/var/lib/mysql/mysql.sock	/var/lib/mysql/mysql.sock
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.max_persistent	Unlimited	Unlimited
mysqli.reconnect	Off	Off
mysqli.rollback_on_cached_plink	Off	Off

[frank47]

Figured it out .... thanx