Database error The database has encountered a problem.

[silverf0x]

It's started after i did a apt-get dist-upgrade on debian 7.

My php version is PHP Version 5.6.7-1

MariaDB 5.5.43-MariaDB

[donald1234]

What version of Vbulletin are you running? you need to be on the latest 4.2.3 release for that version of PHP to work.

[silverf0x]

I'm running the latest from site... upgraded the last week.

vbulletinsuite_4-2-2_Patch_Level_4_VBXXXXXXXX

[Wayne Luke]

MariaDB should be a drop in replacement. However your issue may be that the mysql libraries in PHP are deprecated in 5.5.0. Open your config.php file and switch the database class to mysqli and see if that correct your connection error.

However, your version of vBulletin is not rated for that version of PHP. To use PHP 5.6.X, you'll need to upgrade to vBulletin 4.2.3 Beta 4.

[silverf0x]

I already tried to use the mysqli, but the errors keep the same
I'm uploading the new version to check that

[silverf0x]

Wayne Luke

Just did the install of this new version, whitout any sucess... same error

There's any place, where i can find a log of this errors of vbb?

Because on my nginx and mysql there's nothing about that

[Wayne Luke]

If that is the only thing in the error, then it can't connect to the database.

Create a new text file call checkmysql.php and put the following contents into it:

<?php

$database_server="localhost";
$database_name='vb5';
$database_username='root';
$database_password='';

$connection = mysql_connect($database_server,$database_username,$database_password);

if(!$connection) {
    die ("Cannot connect to the database – incorrect details");
} else{
    echo "<b>MySQL Information and Test Script</b><br><br>";
    echo "Successfull  Connection!<br>";
    echo "Version: " . mysql_get_server_info ($connection) . "<br>";
    echo "Host: " . mysql_get_host_info ($connection) . "<br>";
    echo "Protocol: " . mysql_get_proto_info ($connection) . "<br>";
    echo "Client: " . mysql_get_client_info () . "<br>";
    mysql_close($connection);
}
?>

Upload it to your vBulletin directory and load it in your browser. What are the results?

A successful connection should output something like:

MySQL Information and Test Script

Successfull Connection!
Version: 5.6.21
Host: localhost via TCP/IP
Protocol: 10
Client: mysqlnd 5.0.11-dev - 20120503 - $Id: f373ea5dd5538761406a8022a4b8a374418b240e $

Make sure to update the variables at the top with your own connection information.

[Wayne Luke]

Next replace the code in your file with this code:

<?php

$database_server="localhost";
$database_name='vb5';
$database_username='root';
$database_password='';

$connection = mysqli_connect($database_server,$database_username,$database_password);

if(!$connection) {
    die ("Cannot connect to the database – incorrect details");
} else{
    echo "<b>MySQL Information and Test Script</b><br><br>";
    echo "Successfull  Connection!<br>";
    echo "Version: " . mysqli_get_server_info ($connection) . "<br>";
    echo "Host: " . mysqli_get_host_info ($connection) . "<br>";
    echo "Protocol: " . mysqli_get_proto_info ($connection) . "<br>";
    echo "Client: " . mysqli_get_client_info () . "<br>";
    mysqli_close($connection);
}
?>

And run it again after updating the variables at the top with your connection information.

[silverf0x]

Weird,

I changed the configuration from use the socket to port, for mysql, and it started to work again.

Do you know if there's any issues on this new PHP to user sockets instead of ports?

If i'm using port on includes/config.php it's all OK
If i try to use socket, i get this message error

[silverf0x]

Here's the output from ur codes

#1

[B]MySQL Information and Test Script[/B]

[COLOR=#000000][FONT=Times New Roman]Successfull Connection![/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Version: 5.5.43-MariaDB-1~wheezy-log[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Host: Localhost via UNIX socket[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Protocol: 10[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Client: 5.5.43-MariaDB[/FONT][/COLOR]

#2

[B]MySQL Information and Test Script[/B]

[COLOR=#000000][FONT=Times New Roman]Successfull Connection![/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Version: 5.5.43-MariaDB-1~wheezy-log[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Host: Localhost via UNIX socket[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Protocol: 10[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Client: 5.5.43-MariaDB[/FONT][/COLOR]

[Wayne Luke]

vBulletin has always prefered using the port method. You're sure the socket is available after upgrading?

[silverf0x]

Here is how my.cnf is configured

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc_messages_dir = /usr/share/mysql
lc_messages     = en_US
skip-external-locking

That way, shouldn't accept port and socket?

[silverf0x]

vBulletin has always prefered using the port method. You're sure the socket is available after upgrading?

I haven't checked it, but i've been using socket for that, in the last year at least.