 |
|
|
|
 |
|
 |
|
|
|
 |
|
 |
 |
|
 |
 |
|
|
Please Note: Only registered users can post to this forum. To register, use the link a the top of this page.
 | SearchForum Home | |
| | |
| | |
| | |
 | | |
|
|
|
|
Getting the following failure messages during module install:
| StartJob |
Begin Sql execution |
| Info |
Executing 01.00.00.SqlDataProvider |
| StartJob |
Start Sql execution: 01.00.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Foreign key 'FK_ArrowPortalSettings_Portals' references invalid table 'dbo.Portals'. Could not create constraint. See previous errors. 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) ALTER TABLE [dbo].[ArrowCustomControlPanel] ADD CONSTRAINT [FK_ArrowPortalSettings_Portals] FOREIGN KEY ( [PortalID] ) REFERENCES [dbo].[Portals] ( [PortalID] ) System.Data.SqlClient.SqlException: Constraint 'FK_ArrowPortalSettings_Portals' does not exist. Could not enable or disable the constraint. See previous errors. 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) alter table [dbo].[ArrowCustomControlPanel] nocheck constraint [FK_ArrowPortalSettings_Portals] |
| EndJob |
End Sql execution: 01.00.00.SqlDataProvider file |
| |
| Info |
Executing 01.01.00.SqlDataProvider |
| StartJob |
Start Sql execution: 01.01.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot alter table 'dbo.DNN_ArrowCustomControlPanel' because this table does not exist in database 'IADMD_Web1'. 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) --add the field for HideIcons ALTER TABLE dbo.DNN_ArrowCustomControlPanel ADD HideIcons bit null --RM drop and recreate the stored procs /* ===================================================================================== / TABLE: CustomControlPanel / ===================================================================================== */ /****** Object: Stored Procedure dbo.DNN_ArrowCustomControlPanelGet Script Date: Thursday, September 21, 2006 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'dbo.DNN_ArrowCustomControlPanelGet') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.DNN_ArrowCustomControlPanelGet |
| EndJob |
End Sql execution: 01.01.00.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
The job ends with "Installation Successful" but I'm not sure that it is installed correctly |
|
|
|
| |
|
|
| Re: Sql Errors on Install |
|
|
Thanks for your post.
The error you have means that the control panel never installed into the database. Download the most recent version from ArrowNuke.com to resolve this issue.
Thanks, |
|
|
|
| |
| | |
| | |
| | |
|
|
|
2006 Arrow Consulting & Design, Inc
Terms Of Use Privacy Statement
|
 |
|
|
|
|