4.2.5 Database error

[HZG]

Yesterday I decided to upgrade to 4.2.5 from 4.2.4 due to the final release. Upon updating I found that my forum works fine with PHP 5.6, but gives out a database error on PHP 7 (without any details as to what the error is, it also didn't write anything to the error.log). So for now I've reverted back to PHP 5.6 and left the forum running on that, but I would like to make use of the performance advantages PHP 7 offers.

I've tried disabling the Plugin/Hook System to make sure it wasn't any of my plugins, but that didn't seem to make any difference. I've also tried running it on both PHP 7 and 7.1, but both continue giving out a database error.

Anyone have any idea how I can fix this?

[Wayne Luke]

Anyone have any idea how I can fix this?

No... We would need to know what error is occuring. Put the site in debug mode. Is more information shown?

Add this line to your config.php file to turn on debug mode:

$config['debug'] = true;

[Alshalan]

on config change this

$config['MasterServer']['username'] = 'root';
$config['MasterServer']['password'] = '[COLOR=#FF0000]xxx'[/COLOR];

to

$config['MasterServer']['username'] = 'root';
[B]$config['MasterServer']['password'] = '';[/B]

[Wayne Luke]

This reply doesn't seem relevant to the issue at hand. The change referred to will just create more errors unless you're running a horribly insecure MySQL server.

[HZG]

No... We would need to know what error is occuring. Put the site in debug mode. Is more information shown?

Add this line to your config.php file to turn on debug mode:

$config['debug'] = true;

Tried that and it did not give more information. Just the standard vBulletin "Database error" page.

on config change this

$config['MasterServer']['username'] = 'root';
$config['MasterServer']['password'] = '[COLOR=#FF0000]xxx'[/COLOR];

to

$config['MasterServer']['username'] = 'root';
[B]$config['MasterServer']['password'] = '';[/B]

Why would I remove the password? Then it won't be able to access the database at all.

[Wayne Luke]

Don't see an error when I visit your site. Does it only happen on specific pages?

[HZG]

Don't see an error when I visit your site. Does it only happen on specific pages?

That is because, as stated in the original post, I reverted to PHP 5.6 instead of PHP 7. It works fine on 5.6, just not on 7.

[Mark.B]

Without knowing what the database error is, we have no way of resolving the issue.
Database errors will be in the server logs somewhere. You will need to ask your host.

If you set the technical email address in the config.php file, any future database errors should be emailed to you.

[HZG]

Without knowing what the database error is, we have no way of resolving the issue.
Database errors will be in the server logs somewhere. You will need to ask your host.

If you set the technical email address in the config.php file, any future database errors should be emailed to you.

Just gave that a shot and it gave me the following information:

Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME'
*REMOVED FOR SECURITY REASONS*/forums/includes/class_core.php on line 6153

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 5948
#1 catch_db_error() called in [path]/includes/class_core.php on line 6153
#2 vbulletin_exception_handler() called in on line

[Wayne Luke]

That is because, as stated in the original post, I reverted to PHP 5.6 instead of PHP 7. It works fine on 5.6, just not on 7.

I would suspect the error is in some plugin then. I have no problems running 4.2.5 on PHP 7.X. However, I also have no third-party plugins or addons installed either.

Just gave that a shot and it gave me the following information:

Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME'
*REMOVED FOR SECURITY REASONS*/forums/includes/class_core.php on line 6153

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 5948
#1 catch_db_error() called in [path]/includes/class_core.php on line 6153
#2 vbulletin_exception_handler() called in on line

Someone else had the same error... It was caused by a third-party plugin.

https://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-installations-and-upgrades/4369814-4-2-5-database-error-and-php-question

If you have that plugin installed, then you will want to uninstall it until it is compliant with PHP 7.

[HZG]

I would suspect the error is in some plugin then. I have no problems running 4.2.5 on PHP 7.X. However, I also have no third-party plugins or addons installed either.



Someone else had the same error... It was caused by a third-party plugin.

https://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-installations-and-upgrades/4369814-4-2-5-database-error-and-php-question

If you have that plugin installed, then you will want to uninstall it until it is compliant with PHP 7.

I've previously already tried disabling all the plugins, but that didn't seem the trick.The error continues to exist on PHP 7.

[Paul M]

What error exactly are you referring to, as this thread is very confusing.

[HZG]

What error exactly are you referring to, as this thread is very confusing.

It displays the standard vBulletin "Database error" page. I stated that in an earlier post as well.

What is confusing about it? I can clarify any details necessary to help remove any confusion.

[Paul M]

What error is e-mailed to you ?

In debug mode, what details are shown (if necessary, right click, and view the source).