Changing webhostings question

[Paul T]

Hello, I wanted to change the web host that hosts my vbulletin and I bought a new web hosting & domain with godaddy and uploaded the files onto there. Now when I got to the site it just gives me a database error. What did I do wrong?

[borbole]

Originally Posted by Paul T

Hello, I wanted to change the web host that hosts my vbulletin (it is currently hosted at heaven-pkz.info) and I bought a new web hosting & domain with godaddy (hpkz.org) and uploaded the files onto there. Now when I got to the site it just gives me a database error. What did I do wrong?

You should import the database at the new host as well and then edit the db details to reflect those of the new db at the config.php file and you should be all set.

[Paul T]

I have done that, my new website is http://hpkz.org. I keep getting an error :S

[borbole]

Originally Posted by Paul T

I have done that, my new website is http://hpkz.org. I keep getting an error :S

This is the error you are getting when viewing the page source for your forum:

Invalid SQL:

			SELECT *
			FROM datastore
			WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','adv_modules','adv_portal_cale','adv_portal_home','adv_portal_opts','adv_portal_page','adv_portal_pars','adv_portal_stat','attachmentcache','bbcodecache','birthdaycache','eventcache','iconcache','maxloggedin','prefixcache','ranks','tagcloud','smiliecache','userstats');

MySQL Error   : Table 'heavenpkz.datastore' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, August 25th 2010 @ 02:02:21 AM
Error Date    : Wednesday, August 25th 2010 @ 02:02:21 AM
Script        : http://hpkz.org/
Referrer      : https://vborg.vbsupport.ru/showthread.php?t=249251
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version :

And this tells me 2 things. Either the datastore table doesn''t exist in your db or the db prefix is not entered correct at the config.php file. I am inclining towards the latter. So doublecheck it at the config.php file and make sure that it is set correct.
If that is the case, then check the db table for the datastore table. If it doesn''t exist, export it from the db at your old host and import it at the same db in the new host where your vb forum resides.

[Paul T]

Could this be because I'm already hosting another vBulletin on another webhost with another domain?

[borbole]

Originally Posted by Paul T

Could this be because I'm already hosting another vBulletin on another webhost with another domain?

I don''t see how that can be related to this... .

[toonysnn]

Double check your database information, not the login info or the hostname, but the table prefix. It's possible you (or whomever set up your board) set a prefix, such as vb_, vb3_, or vbulletin_
That's probably the only cause, if not, there is one other thing I can think of, but it's highly improbable.