1

Closed

Error on fresh install

description

I am getting this below error when I install this module with host permission with a custom "dnn_" as the objectQualifier.
 
any suggestions or help will be appreciated.
 
thank you,
Wasay

 

Error: Code Camp is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'dnn_cc1_vCodecamps'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dnn_cc1_vCodecamps'. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at EPCanada.DNN.Modules.CodeCamp.Data.SqlDataProvider.GetCodecampsByModuleID(Int32 moduleID) at EPCanada.DNN.Modules.CodeCamp.Business.CodecampsController.GetByModuleID(Int32 moduleID) at EPCanada.DNN.Modules.CodeCamp.CodeCamp.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Closed Nov 12, 2008 at 5:57 PM by chrduf

comments

wasay wrote Nov 4, 2008 at 6:54 AM

Found issue with this code

ALTER TABLE {databaseOwner}[{objectQualifier}cc1_Codecamps] WITH NOCHECK ADD CONSTRAINT [FK_{objectQualifier}cc1_Codecamps_Modules] FOREIGN KEY([ModuleID])
REFERENCES {databaseOwner}[Modules] ([ModuleID])
ON DELETE CASCADE
NOT FOR REPLICATION

GO

This code is missing the {objectQualifier}.

wasay wrote Nov 4, 2008 at 6:58 AM

Another error in left outer join, missing the object qualifier

CREATE VIEW dbo.[dnn_cc1_vCodecampSessions]
AS
SELECT
s.SessionID, 
s.CodecampID, 
s.Title, 
s.[Description], 
s.SpeakerID,
sp.SpeakerName,
sp.CompanyName,
s.Room, 
s.TrackID,
tr.Title as TrackTitle, 
tr.SessionCssClass, 
s.TimeslotID,
ts.StartTime,
ts.StopTime, 
s.MaximumCapacity, 
s.NumberRegistered, 
u.FirstName + ' ' + u.LastName as CreatedByUser,
s.CreatedDate 
FROM
dnn_cc1_CodecampSessions s
left outer join dnn_Users u on s.CreatedByUser = u.UserId
left outer join dnn_cc1_Speakers sp on s.SpeakerID = sp.SpeakerID
left outer join dnn_cc1_CodecampTracks tr on tr.TrackID = s.TrackID
left outer join dnn_cc1_CodecampTimeslots ts on ts.TimeslotID = s.TimeslotID

GO

wasay wrote Nov 4, 2008 at 6:59 AM

Third issue with object qualifier


CREATE VIEW dbo.[dnn_cc1_vCodecampTimeslots]
as

SELECT
[TimeslotID], 
[CodecampID], 
[StartTime], 
[StopTime], 
[AgendaText], 
[AgendaCssClass], 
[SpanAllTracks], 
[IncludeInDropdowns],
u.FirstName + ' ' + u.LastName as CreatedByUser,
[CreatedDate] 
FROM
dnn_cc1_CodecampTimeslots t
left outer join dnn_Users u on t.CreatedByUser = u.UserId
GO

wasay wrote Nov 4, 2008 at 7:06 AM

Ok I had to fix atleast 8 places and the tables, views and store procedures that are missing object qualifier is "Users and Files".

All the above issues are in the file version 02.00.00.SqlDataProvider

wasay wrote Nov 4, 2008 at 7:08 AM

The object qualifier issue also exists in 02.01.00.SqlDataProvider version file.

chrduf wrote Nov 12, 2008 at 5:57 PM

I have updated the database scripts in Release 2.1 to fix the probems with {objectQualifer}.

wrote Nov 12, 2008 at 5:57 PM

wrote Jan 31, 2013 at 8:54 PM

wrote May 14, 2013 at 5:40 AM