PDA

View Full Version : Database error after changing hosts.. please take a look.


shibby2
12-01-2020, 03:34 AM
Hey guys, I just changed hosts from HostGator to BlueHost for my VB 3.8.4 forum. Worked fine on HostGator, but I keep getting a database error page on BlueHost when trying to access my forum.

I also get this email sent to me at the same time:

Database error in vBulletin :

mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
/home1/myhosting/myforum/includes/class_core.php on line 311

Any idea why this is happening, and how to fix it? I'm really not good with this stuff at all, so I'm really clueless with this.

Thanks!

z3r0
12-01-2020, 06:39 AM
In your includes/config.php you need to change the database type to mysqli

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

shibby2
12-01-2020, 04:09 PM
Is that the only place I need to edit? I did that, and still get an error message, this one now:

Database error in vBulletin :

mysqli_real_connect(): (HY000/1045): Access denied for user 'myname'@'localhost' (using password: YES)
/home1/mysite/includes/class_core.php on line 1138

MySQL Error :
Error Number :
Request Date : Tuesday, December 1st 2020 @ 11:04:50 AM
Error Date : Tuesday, December 1st 2020 @ 11:04:50 AM
Script : http://
Referrer :
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version :

yilmaz
12-01-2020, 04:52 PM
Access denied for user
Match database info should be an error

z3r0
12-01-2020, 05:13 PM
Is that the only place I need to edit? I did that, and still get an error message, this one now:

Database error in vBulletin :

mysqli_real_connect(): (HY000/1045): Access denied for user 'myname'@'localhost' (using password: YES)
/home1/mysite/includes/class_core.php on line 1138

MySQL Error :
Error Number :
Request Date : Tuesday, December 1st 2020 @ 11:04:50 AM
Error Date : Tuesday, December 1st 2020 @ 11:04:50 AM
Script : http://
Referrer :
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version :

You now need to set the username and password in config.php to match whatever you have set your database to at your new host.

shibby2
12-03-2020, 08:06 PM
Ok yea I figured it out. The DB name/Username were all correct in the config file, but it wouldn't work unless I changed the password for the user in cpanel. Very strange. The password was always correct in config, but it wouldn't work unless I changed it again in cpanel. Happened twice like that!

Anyway, finally got it all worked out. Thanks so much for the help everyone, I really appreciate it! The host had no clue and wanted to charge me $165 for a tech to look deeper into it! lol