Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2020, 03:34 AM
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Posts: 303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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!
Reply With Quote
  #2  
Old 12-01-2020, 06:39 AM
z3r0's Avatar
z3r0 z3r0 is offline
 
Join Date: Apr 2005
Posts: 339
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In your includes/config.php you need to change the database type to mysqli

Code:
$config['Database']['dbtype'] = 'mysqli';
Reply With Quote
Благодарность от:
puertoblack2003
  #3  
Old 12-01-2020, 04:09 PM
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Posts: 303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 :
Reply With Quote
  #4  
Old 12-01-2020, 04:52 PM
yilmaz's Avatar
yilmaz yilmaz is offline
 
Join Date: Sep 2004
Posts: 751
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Access denied for user
Match database info should be an error
Reply With Quote
  #5  
Old 12-01-2020, 05:13 PM
z3r0's Avatar
z3r0 z3r0 is offline
 
Join Date: Apr 2005
Posts: 339
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by shibby2 View Post
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.
Reply With Quote
  #6  
Old 12-03-2020, 08:06 PM
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Posts: 303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:16 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04172 seconds
  • Memory Usage 2,214KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (1)post_thanks_box_bit
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete