We've recently upgraded from DotNetNuke 5.0.0 to 5.0.1. (Windows 2003, SQL 2003) Since then we've discovered a few problems that we can not seem to work around.

When attempting to get into the File Manager:
A critical error has occurred.
The stored procedure 'dbo.dnn_NPC_GetPermissionsByFolderPath' doesn't exist.
Can’t add a new page or get into page settings:

When attempting to Add a 'New Page':
A critical error has occurred.
The stored procedure 'dbo.dnn_NPC_GetPermissionsByTabID' doesn't exist.
 
Both of these 'database tables' aren't in the SQL server (in both current and back up copies of our database).

The only info I can dig up is http://support.dotnetnuke.com/issue/ViewIssue.aspx?id=9149&PROJID=2

Can anyone explain/assit with working through this issue?
 

I upgraded using DotNetNuke_Community_05.00.01_Upgrade.zip.
http://www.co.nezperce.id.us/Install/InstallWizard.aspx

DNN 5.0.0 (Before Upgrade):
        <add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="dnn_NPC_" databaseOwner="dbo" />

DNN 5.0.1 (After):
        <add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="dnn_NPC_" databaseOwner="dbo" />

I even exported all my tables into CSV and did a 'find' from both 5.0.0 and 5.0.1 neither has the GetPermissionsByXYZ databases.

05.00.01.SqlDataProvider:
 -I 'Find and Replaced' databaseOwner & objectQualifier with dbo & dnn_NPC_

 I copied and pasted the script into a Mangment Studio Query - and received the following errors:
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '}'.
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '}'.
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '{'.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'PackageID'.
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '{'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '{'.
Msg 137, Level 15, State 2, Line 13
Must declare the scalar variable "@ViewOrder".
...
...
...
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'URL'.

 Here is an example of the first few lines of the script:
IF (SELECT COUNT(*) FROM {dbo}{dnn_NPC_}PackageTypes WHERE [PackageType] = N'DashboardControl') = 0
    BEGIN
        INSERT INTO {dbo}{dnn_NPC_}PackageTypes
            ([PackageType], [Description], [SecurityAccessLevel])
            VALUES(N'DashboardControl', N'Dashboard Control', 3)
    END

---
DotNetNuke.Schema.SqlDataProvider:

I copied and pasted the script into a Mangment Studio Query - and received the following errors:
...
...
...
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '{'.
Msg 102, Level 15, State 1, Line 34
Incorrect syntax near '}'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '{'.
The query has exceeded the maximum number of error messages. Only  the first 1000 messages will be displayed.

Example of the script:
GO
ALTER TABLE {dbo}[{dnn_NPC_}Lists]
    ADD
    CONSTRAINT [PK_{dnn_NPC_}Lists]
    PRIMARY KEY
    ([ListName], [Value], [Text], [ParentID])
GO