[Forum] Database error on test forum

[Danny M]

Hey,

Before I upgrade my vBulletin forum from 4.0.3. to 4.1.11, I wanted to create a test site to see if the upgrade would work without any problems, as my forum is quite active.

I followed these steps here: https://www.vbulletin.com/forum/cont...ng-A-Test-Site

1. I downloaded a backup of my current forum database.
2. I created a new database with a new user and password.
3. I restored the backup I downloaded to my new database.
4. I created a new directory on my server called "testvb".
5. I copied all of my current forums files from "forums" to "testvb".
6. I edited the config.php file with my new database name, the new database username, the new database password, and changed the cookie prefix from "bb" to "testvb".

Now when I go to my test site I get a "Database error". I checked the source and this is the message that appears at the bottom:

 
<!--
Database error in vBulletin 4.0.3:

Invalid SQL:

        SELECT username, userid, birthday, showbirthday
        FROM user
        WHERE (birthday LIKE '03-17-%' OR birthday LIKE '03-18-%')
        AND usergroupid IN (0, 6, 5, 2, 7, 17, 20, 16)
        AND showbirthday IN (2, 3);

MySQL Error   : Table 'dannym_vbtest.user' doesn't exist
Error Number  : 1146
Request Date  : Sunday, March 18th 2012 @ 01:58:11 AM
Error Date    : Sunday, March 18th 2012 @ 01:58:11 AM
Script        : http://www.lilwaynehq.com/testvb/
Referrer      : 
IP Address    : 82.2.76.157
Username      : Unregistered
Classname     : vB_Database
MySQL Version : 
-->

Does anyone know what this problem is? I can't access any page of my test site, not even the admin panel. I've double-checked my config.php file and everything seems to match.

I'm not sure if I have missed a step or not done something which I should have, even though I did follow them instructions on the link above.

My current forum is: http://www.lilwaynehq.com/forums/
My test site is: http://www.lilwaynehq.com/testvb/

You probably can't see the test forum as I created the .htaccess like I was supposed to, but I don't think you will need to see it as I have shown the error that displays above.

Anyone any ideas?

Thanks

[Wayne Luke]

Your backup wasn't complete and at least one table is missing.

[Danny M]

Your backup wasn't complete and at least one table is missing.

Thank you.

I now have another problem.

When I go to login to my test board, it says I have successfully logged in, but then just re-directs me to the previous page not logging me in.

I've uploaded tools.php to my admincp folder, then removed it, but still no luck

Do you or anyone else have any ideas?

Thanks

---

UPDATE: My bad, I have fixed it now