Databace Error : Error Number : 1146 , pls help me

[hamid268]

Hi
i need your help
my last version of vb was 3.6.4 , i moved it to new host then at new host i did upgrade it to 3.8.4
all parts work correctly only when that want watch users profile at forum i get this error

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT blockid, requirement
FROM profileblockprivacy
WHERE userid = 1813;

MySQL Error : Table '*****_vb.profileblockprivacy' doesn't exist
Error Number : 1146
Request Date : Tuesday, October 27th 2009 @ 08:31:55 PM
Error Date : Tuesday, October 27th 2009 @ 08:31:55 PM
Script : http://www.****.com/test1/member.php?u=1813
Referrer : http://www.*****.com/test1/index.php
IP Address : 81.12.28.114
Username : admin
Classname : vB_Database
MySQL Version : 5.0.85-community


pls help me how i solve this problem

[snakes1100]

Well, this would most likely be caused because you failed to up date your templates after you upgraded vb.

1. Revert/Update (MEMBERINFO) your templates in each style you have installed.

2. Remove any old files related to hacks that reside in /includes/xml

[hamid268]

hi
thank you for your answer

but my problem not solved

too now i get another one error

SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
WHERE forumprefixset.forumid = 70
ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error : Table '******_vb.prefixpermission' doesn't exist
Error Number : 1146
Request Date : Wednesday, October 28th 2009 @ 06:49:11 AM
Error Date : Wednesday, October 28th 2009 @ 06:49:11 AM
Script : http://www.******/test1/forumdisplay.php?f=70
Referrer : http://www.*****/test1/?langid=3
IP Address : *****
Username : admin
Classname : vB_Database
MySQL Version : 5.0.85-community


pls pls help me

--------------- Added [DATE]1256745078[/DATE] at [TIME]1256745078[/TIME] ---------------

pls help me

[Lynne]

Did you create a backup of your database and then restore it to the new host database? Did you verify that you actually have a complete dump of your database?

[hamid268]

Originally Posted by Lynne

Did you create a backup of your database and then restore it to the new host database? Did you verify that you actually have a complete dump of your database?

hello
thank you for your answer

yes i got full backup by mysqldumper then restore at new database

[Lynne]

And is that table in there?

[hamid268]

Originally Posted by Lynne

And is that table in there?

sorry , i not underestand your question

[Lynne]

When you look at the backup database, is that table in there? Did you import the database and then do an upgrade? Was everything successful during the upgrade process?

[hamid268]

Originally Posted by Lynne

When you look at the backup database, is that table in there? Did you import the database and then do an upgrade? Was everything successful during the upgrade process?

hi thank you for your answer

yes restore backup wassuccessful
the first i did import database then upgrade process

[Lynne]

For some reason, it sounds like that table, prefixpermission, was not created. Can you see it in your database? You may have to look in the mysql-schema.php file for the details to create the table. Or, you can put in a Support Ticket over at vb.com and they can probably go do it for you.