The Arcive of Official vBulletin Modifications Site.

Hiatus- · #1 04-09-2013, 09:53 PM

Hello,

I recently transferred to a new hosting company, and I have decided to install a fresh install of vbulletin. I installed the same plugins / mods as I had on my other one. I dumped the SQL file from the old DB and executed it into the new DB with no errors. When I go to my website none of the forums, users, etc. was restored but everything is in the database. It still only said 1 user registered which was "Administrator". I decided to search for Administrator in the user table and there was no match. I have spent countless hours trying to figure out what the problem is here and I cannot seem to get it. If anyone could help me out I would appreciate it greatly. Thanks in advance.

http://pictify.me/info/5438 (Admin account)

http://pictify.me/info/5439 (Search query for it in user table)

Thank you.

kh99 · #2 04-09-2013, 10:14 PM

Seems like it can't be using the restored database. Did you use the same database name and table prefix on the new site? I guess if you have phpMyAdmin or something like that it would be obvious, you'd have 2 databases or else you'd have two of every table.

Hiatus- · #3 04-10-2013, 12:03 AM

Quote:

Originally Posted by kh99

Seems like it can't be using the restored database. Did you use the same database name and table prefix on the new site? I guess if you have phpMyAdmin or something like that it would be obvious, you'd have 2 databases or else you'd have two of every table.

I am using the same table prefix, but not database name. I will try that and get back to you, thanks for the reply.

edit : turns out my webhost doesn't allow me to change database prefix names so i will have to talk to them, because then the database names will always remain different

kh99 · #4 04-10-2013, 12:31 AM

Well, I don't want to mislead you - as far as I know the database name can be whatever you want, but it has to match what's in the config.php. I guess I was thinking that if you were still seeing only the one user, maybe you need to change the database name in the config.php.

snakes1100 · #5 04-10-2013, 02:16 AM

Some servers like whm/cpanel are going to be tagged with a prefix for the account name, thats not changeable by the end user.

accountname_thiscanbewhatyouwant

The prefix in config.php doesnt apply to the above, it only applies the to table prefix names in the database itself.

Hiatus- · #6 04-10-2013, 02:25 AM

the config.php file has all of the correct information

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10133 seconds Memory Usage 2,206KB Queries Executed 11 (?)
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_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (6)post_thanks_box (6)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (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_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 post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!