Databace Error : Error Number : 1146 , pls help me
 

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:(

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

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

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

And is that table in there?

sorry , i not underestand your question

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

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.