 |
|
|
Joined: 6/6/2007
Posts: 16
|
|
|
Hi,
I'm having trouble upgrading from 04.09.01 to 05.00.00.
I keep getting the error: 00:00:00.999 - Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
And here's the log file:
System.Data.SqlClient.SqlException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/***********************************************************/
/* End Update Admin Modules to conform to Module Standards */
/***********************************************************/
/* Update Packages */
/*******************/
ALTER TABLE dbo.Packages
ADD PortalID int NULL
ALTER TABLE dbo.Packages
ALTER COLUMN Description nvarchar(2000) NULL
ALTER TABLE dbo.Packages
ALTER COLUMN License ntext NULL
ALTER TABLE dbo.Packages
ALTER COLUMN Manifest ntext NULL
ALTER TABLE dbo.Packages
ADD Owner nvarchar(100) NULL
ALTER TABLE dbo.Packages
ADD Organization nvarchar(100) NULL
ALTER TABLE dbo.Packages
ADD Url nvarchar(250) NULL
ALTER TABLE dbo.Packages
ADD Email nvarchar(100) NULL
ALTER TABLE dbo.Packages
ADD ReleaseNotes ntext NULL
ALTER TABLE dbo.Packages
ADD IsSystemPackage bit NOT NULL CONSTRAINT DF_Packages_IsSystemPackage DEFAULT 0
DROP INDEX IX_Packages ON dbo.Packages
CREATE UNIQUE NONCLUSTERED INDEX IX_Packages ON dbo.Packages ( Owner, Name, PortalID )
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[AddPackage]
@PortalID int,
@Name nvarchar(50),
@FriendlyName nvarchar(250),
@Description nvarchar(2000),
@PackageType nvarchar(50),
@Version nvarchar(50),
@License ntext,
@Manifest ntext,
@Owner nvarchar(100),
@Organization nvarchar(100),
@Url nvarchar(250),
@Email nvarchar(100),
@ReleaseNotes ntext,
@IsSystemPackage bit
AS
INSERT INTO dbo.Packages
(
PortalID,
[Name],
FriendlyName,
[Description],
PackageType,
Version,
License,
Manifest,
ReleaseNotes,
[Owner],
Organization,
Url,
Email,
IsSystemPackage
)
VALUES (
@PortalID,
@Name,
@FriendlyName,
@Description,
@PackageType,
@Version,
@License,
@Manifest,
@ReleaseNotes,
@Owner,
@Organization,
@Url,
@Email,
@IsSystemPackage
)
SELECT SCOPE_IDENTITY()
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[UpdatePackage]
@PortalID int,
@Name nvarchar(50),
@FriendlyName nvarchar(250),
@Description nvarchar(2000),
@PackageType nvarchar(50),
@Version nvarchar(50),
@License ntext,
@Manifest ntext,
@Owner nvarchar(100),
@Organization nvarchar(100),
@Url nvarchar(250),
@Email nvarchar(100),
@ReleaseNotes ntext,
@IsSystemPackage bit
AS
UPDATE dbo.Packages
SET
PortalID = @PortalID,
FriendlyName = @FriendlyName,
[Description] = @Description,
PackageType = @PackageType,
Version = @Version,
License = @License,
Manifest = @Manifest,
[Owner] = @Owner,
Organization = @Organization,
Url = @Url,
Email = @Email,
ReleaseNotes = @ReleaseNotes,
IsSystemPackage = @IsSystemPackage
WHERE [Name] = @Name
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[GetPackages]
@PortalID int
AS
SELECT *
FROM dbo.Packages
WHERE (PortalID = @PortalID OR @PortalID IS NULL OR PortalID IS NULL)
ORDER BY PackageType ASC, [FriendlyName] ASC
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[GetPackagesByType]
@PortalID int,
@PackageType nvarchar(50)
AS
SELECT *
FROM dbo.Packages
WHERE (PortalID = @PortalID OR @PortalID IS NULL OR PortalID IS NULL)
AND PackageType = @PackageType
ORDER BY [FriendlyName] ASC
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.GetPackageByName
@PortalID int,
@Name nvarchar(250)
AS
SELECT *
FROM dbo.Packages
WHERE [Name] = @Name
AND (PortalID = @PortalID OR @PortalID IS NULL)
Error: The stored procedure 'dbo.AddPackage' doesn't exist.
I'm running Windows Server 2003 ent with SQL 2000 Ent.
What could I try to resolve this issue?
|
| |
|
|
 | |
|
|
|
please validate, that table dbo.Packages exist in your database and post here the columns it contains. you will need to fix the structure and rerun the affected part of the upgrade script.
|
| |
|
|
| |
|
|
Joined: 6/6/2007
Posts: 16
|
|
|
The table exists and contains the following columns:
Name,Data Type,Size
PackageID,int,4 (id&key)
Name,nvarchar,50
FriendlyName,nvarchar,250
Description,,nvarchar,2000
PackageType,nvarchar,50
version,nvarchar,50
Licence,ntext,16
Manifest,ntext,16
msrepl_tran_version,uniqueidentifier,16
rowguid,uniqueidentifier,16
hope this nfo helps
|
| |
|
|
| |
|
|
Joined: 6/6/2007
Posts: 16
|
|
|
I've copied the db and did some testing.
I've manualy run the 05.00.00.SqlDataOrivider.
Here on in Query Analyzer, parse Query gives the following error:
Server: Msg 159, Level 15, State 1, Line 41
For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
Line that failes:
DROP INDEX IX_Packages ON dbo.Packages
If I change the line to:
DROP INDEX dbo.IX_Packages ON dbo.Packages
I get:
Server: Msg 156, Level 15, State 1, Line 41
Incorrect syntax near the keyword 'ON'.
So I just commented it out.
When I run the script I get error 1:
Server: Msg 4928, Level 16, State 1, Line 17
Cannot alter column 'License' because it is 'ntext'.
Line that failes:
ALTER TABLE dbo.Packages
ALTER COLUMN License ntext NULL
Error 2:
Server: Msg 207, Level 16, State 1, Procedure AddPackage, Line 18
Invalid column name 'ReleaseNotes'
Line that failes:
INSERT INTO dbo.Packages
(
PortalID,
[Name],
FriendlyName,
[Description],
PackageType,
Version,
License,
Manifest,
ReleaseNotes,
[Owner],
Organization,
Url,
Email,
IsSystemPackage
)
Error 3:
Server: Msg 207, Level 16, State 1, Procedure UpdatePackage, Line 18
Invalid column name 'Owner'.
Line that Failes:
UPDATE dbo.Packages
SET
PortalID = @PortalID,
FriendlyName = @FriendlyName,
[Description] = @Description,
PackageType = @PackageType,
Version = @Version,
License = @License,
Manifest = @Manifest,
[Owner] = @Owner,
Organization = @Organization,
Url = @Url,
Email = @Email,
ReleaseNotes = @ReleaseNotes,
IsSystemPackage = @IsSystemPackage
WHERE [Name] = @Name
After the script the Packages table contains the folloing columns:
3 PackageID int 4 0
0 Name nvarchar 50 0
0 FriendlyName nvarchar 250 0
0 Description nvarchar 2000 1
0 PackageType nvarchar 50 0
0 Version nvarchar 50 0
0 License ntext 16 0
0 Manifest ntext 16 0
0 msrepl_tran_version uniqueidentifier 16 0
0 rowguid uniqueidentifier 16 0
0 PortalID int 4 -1
|
| |
|
|
| |
|
|
Joined: 6/6/2007
Posts: 16
|
|
|
Any idea what I could do to resolve this issue? Or should I wat for the next release of dnn?
|
| |
|
|
| |