vb.org Archive - Database error after changing hosts.. please take a look.

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Database error after changing hosts.. please take a look. (https://vborg.vbsupport.ru/showthread.php?t=328384)

shibby2

12-01-2020 03:34 AM

Database error after changing hosts.. please take a look.

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

Code:

$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

Quote:

Originally Posted by shibby2 (Post 2604965)

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

All times are GMT. The time now is 09:58 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01013 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: