Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveyError installing modules...Error installing modules...
Previous
 
Next
New Post
12/28/2006 10:30 AM
 
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
 
New Post
12/30/2006 8:31 AM
 

obiously there is an issue with the installation script, check for the *.sqldataprovider files in the package, open them with a text editor, to make sure that each "if exists (select * from {databaseowner}.sysobjects..." is replaced with "if exists (select * from dbo.sysobjects..." 


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
1/1/2007 8:07 PM
 
I updated the survey module to my DNN 4.4.0 and I also had a critical error that nearly crashed my entire website, and to uninstall the survey module.

If God does not live in Colorado, I bet he visits there a lot!!
 
New Post
1/1/2007 9:46 PM
 

leemedic wrote
I updated the survey module to my DNN 4.4.0 and I also had a critical error that nearly crashed my entire website, and to uninstall the survey module.

Can you tell us what version of the Survey module you installed and exactly what happened? Also, how did you uninstall it?

Thank you



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
1/24/2007 7:16 PM
 

Same problem. DNN 4.4.0, Please HELP!!!

Compiler Error Message: BC30560: 'DataProvider' es ambiguo en el espacio de nombres 'DotNetNuke.Modules.Survey'.

 
Line 27: 
Line 28:         ' singleton reference to the instantiated object 
Line 29:         Private Shared objProvider As DataProvider = Nothing
Line 30: 
Line 31:         ' constructor

Source File: D:\Downloads\Asp .net Componentes\DotNetNuke\Version 4.4.0\DotNetNuke_4.4.0_Install\App_Code\Survey\DataProvider.vb    Line: 29

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveyError installing modules...Error installing modules...


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out