Dear all,
I have successfully uploaded and installed DNN 4.7 at my web hosters. I got some errors when the installation was installing some of the modules. One of the affected modules is the suvey module. Because of this, the survey module does not behave properly.
I have manualy uninstalled the survey module and tried installing it again.
I got the following error:
StartJob
Start Sql execution: 03.03.00.SqlDataProvider file
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name 'dbo191008941.sysobjects'. 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) if exists (select * from dbo191008941.sysobjects where id = object_id(N'dbo191008941.[GetSurvey]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo191008941.GetSurvey System.Data.SqlClient.SqlException: There is already an object named 'GetSurvey' in the database. 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 dbo191008941.GetSurvey @SurveyID int, @ModuleID int as select SurveyID, ModuleID, Question, ViewOrder, OptionType, CreatedByUser, CreatedDate, 'Votes' = ( select sum(Votes) from SurveyOptions where SurveyOptions.SurveyID = Surveys.SurveyID ) from Surveys where SurveyID = @SurveyID and ModuleID = @ModuleID
EndJob
End Sql execution: 03.03.00.SqlDataProvider file
When I add the survey module on a page, it acts normally and I can create a new survey, a question and answer options.
But when I got to view mode, the survey does not display in the container. I get the following error:
A critical error has occurred.
Input string was not in a correct format.
Does anyone have an idea what might be going on wrong?
Thanks
|