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 ForumsSurveySurveySurvey 04.00.70 Upgrade errorSurvey 04.00.70 Upgrade error
Previous
 
Next
New Post
4/14/2007 4:53 PM
 

I'm using 4.4.1 and the Module definitions page tells me I have version 03.03.00 of the Survey module.

I tried installing the latest version and got this error on the install:

StartJob Starting Installation
StartJob Reading files
Info Loading EditSurvey.ascx.resx
Info File EditSurvey.ascx.resx read successfully
Info Loading Settings.ascx.resx
Info File Settings.ascx.resx read successfully
Info Loading Survey.ascx.es-ES.resx
Info File Survey.ascx.es-ES.resx read successfully
Info Loading Survey.ascx.resx
Info File Survey.ascx.resx read successfully
Info Loading 03.01.00.SqlDataProvider
Info File 03.01.00.SqlDataProvider read successfully
Info Loading 03.03.00.SqlDataProvider
Info File 03.03.00.SqlDataProvider read successfully
Info Loading 04.00.20.SqlDataProvider
Info File 04.00.20.SqlDataProvider read successfully
Info Loading 04.00.60.SqlDataProvider
Info File 04.00.60.SqlDataProvider read successfully
Info Loading 04.00.70.SqlDataProvider
Info File 04.00.70.SqlDataProvider read successfully
Info Loading EditSurvey.ascx
Info File EditSurvey.ascx read successfully
Info Loading EditSurvey.ascx.vb
Info File EditSurvey.ascx.vb read successfully
Info Loading icon_survey_32px.gif
Info File icon_survey_32px.gif read successfully
Info Loading module.css
Info File module.css read successfully
Info Loading red.gif
Info File red.gif read successfully
Info Loading Settings.ascx
Info File Settings.ascx read successfully
Info Loading Settings.ascx.vb
Info File Settings.ascx.vb read successfully
Info Loading Survey.ascx
Info File Survey.ascx read successfully
Info Loading Survey.ascx.vb
Info File Survey.ascx.vb read successfully
Info Loading Uninstall.SqlDataProvider
Info File Uninstall.SqlDataProvider read successfully
Info Loading SqlDataProvider.vb
Info File SqlDataProvider.vb read successfully
Info Loading DataProvider.vb
Info File DataProvider.vb read successfully
Info Loading SurveyController.vb
Info File SurveyController.vb read successfully
Info Loading SurveyInfo.vb
Info File SurveyInfo.vb read successfully
Info Loading SurveyOptionController.vb
Info File SurveyOptionController.vb read successfully
Info Loading SurveyOptionInfo.vb
Info File SurveyOptionInfo.vb read successfully
Info Loading DNN_Survey.dnn
Info File DNN_Survey.dnn read successfully
Info Loading 04.00.70.txt
Info File 04.00.70.txt read successfully
EndJob Reading files done.
 
StartJob Reading DNN file
Info DNN file is in valid 3.0 format.
Info xml loaded.
Info Loading files info
Info Found valid path (App_LocalResources) for EditSurvey.ascx.resx.
Info Found valid path (App_LocalResources) for Settings.ascx.resx.
Info Found valid path (App_LocalResources) for Survey.ascx.es-ES.resx.
Info Found valid path (App_LocalResources) for Survey.ascx.resx.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 03.01.00.SqlDataProvider.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 03.03.00.SqlDataProvider.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 04.00.20.SqlDataProvider.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 04.00.60.SqlDataProvider.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 04.00.70.SqlDataProvider.
Info Found valid path ([app_code]Providers\DataProviders\SqlDataProvider) for SqlDataProvider.vb.
Info Found valid path ([app_code]) for DataProvider.vb.
Info Found valid path ([app_code]) for SurveyController.vb.
Info Found valid path ([app_code]) for SurveyInfo.vb.
Info Found valid path ([app_code]) for SurveyOptionController.vb.
Info Found valid path ([app_code]) for SurveyOptionInfo.vb.
Info Loading Modules info
Info Loading Control info for 'Survey' module
EndJob Dnn load finished successfully
 
StartJob Begin Sql execution
Info Executing 04.00.20.SqlDataProvider
StartJob Start Sql execution: 04.00.20.SqlDataProvider file
EndJob End Sql execution: 04.00.20.SqlDataProvider file
 
Info Executing 04.00.60.SqlDataProvider
StartJob Start Sql execution: 04.00.60.SqlDataProvider file
EndJob End Sql execution: 04.00.60.SqlDataProvider file
 
Info Executing 04.00.70.SqlDataProvider
StartJob Start Sql execution: 04.00.70.SqlDataProvider file
EndJob End Sql execution: 04.00.70.SqlDataProvider file
 
EndJob Finished Sql execution
 
StartJob Creating files
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\App_LocalResources\EditSurvey.ascx.resx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\App_LocalResources\Settings.ascx.resx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\App_LocalResources\Survey.ascx.es-ES.resx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\App_LocalResources\Survey.ascx.resx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\03.03.00.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\04.00.20.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\04.00.60.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\04.00.70.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\04.00.70.txt
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\EditSurvey.ascx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\EditSurvey.ascx.vb
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\icon_survey_32px.gif
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\module.css
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\red.gif
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Settings.ascx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Settings.ascx.vb
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Survey.ascx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Survey.ascx.vb
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Uninstall.SqlDataProvider
Failure ExceptionSystem.Configuration.ConfigurationErrorsException: An error occurred loading a configuration file: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (machine.config) ---> System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at System.Configuration.Internal.InternalConfigHost.StaticOpenStreamForRead(String streamName) at System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName, Boolean assertPermissions) at System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName) at System.Configuration.Internal.DelegatingConfigHost.OpenStreamForRead(String streamName) at System.Configuration.UpdateConfigHost.OpenStreamForRead(String streamName) at System.Configuration.BaseConfigurationRecord.InitConfigFromFile() The action that failed was: Demand The type of the first permission that failed was: System.Security.Permissions.FileIOPermission The Zone of the assembly that failed was: MyComputer --- End of inner exception stack trace --- at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal) at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors) at System.Configuration.Configuration..ctor(String locationSubPath, Type typeConfigHost, Object[] hostInitConfigurationParams) at System.Configuration.Internal.InternalConfigConfigurationFactory.System.Configuration.Internal.IInternalConfigConfigurationFactory.Create(Type typeConfigHost, Object[] hostInitConfigurationParams) at System.Web.Configuration.WebConfigurationHost.OpenConfiguration(WebLevel webLevel, ConfigurationFileMap fileMap, VirtualPath path, String site, String locationSubPath, String server, String userName, String password, IntPtr tokenHandle) at System.Web.Configuration.WebConfigurationManager.OpenWebConfigurationImpl(WebLevel webLevel, ConfigurationFileMap fileMap, String path, String site, String locationSubPath, String server, String userName, String password, IntPtr userToken) at System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(String path) at DotNetNuke.Common.Utilities.Config.AddCodeSubDirectory(String name) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateModuleFile(PaFile File, PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install() 

My host tells me I'm running in medium trust.

Anyone else having this issue? Is there a fix available?

thanks


Steve White
 
New Post
4/14/2007 5:25 PM
 

I just installed Survey 03.03.00 in DNN 4.5 and then upgraded to Survey 04.00.70 and it upgraded fine so I think this is just a permissions issue that somehow got set on one of the files or directories over time.

If you delete the files (not the directories) in "App_Code/Survey" and "Desktopmodules/Survey" and remove:

bin\DotNetNuke.Modules.Survey.dll
bin\DotNetNuke.Modules.Survey.SqlDataProvider.dll

and upload the install file again it should work.



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
4/14/2007 5:37 PM
 

It does look like a permissions issue but that didn't work.

- There were no files in "App_Code/Survey" (there's no such directory)
- I delete all files in "DesktopModules/Survey"
- I tried to install again
- same error
- I then uninstalled the existing Survey module
- I tried to install again
- same error

From the error is says this:

"The action that failed was: Demand The type of the first permission that failed was: System.Security.Permissions.FileIOPermission The Zone of the assembly that failed was: MyComputer"

Why would it be trying to look in MyComputer of my hosts? I think the problem is something to do with Medium Trust isn't it?

 


Steve White
 
New Post
4/14/2007 6:01 PM
 

Oh I just saw that you have DNN 4.4.1 not 4.5. I think there was a bug with application root and the installer. Can you upgrade to 4.5?



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
4/15/2007 7:12 AM
 

I just performed the heart-stopping upgrade to 4.5. I then installed the latest Survey module and this is the install log:

StartJob Starting Installation
StartJob Reading files
Info Loading EditSurvey.ascx.resx
Info File EditSurvey.ascx.resx read successfully
Info Loading Settings.ascx.resx
Info File Settings.ascx.resx read successfully
Info Loading Survey.ascx.es-ES.resx
Info File Survey.ascx.es-ES.resx read successfully
Info Loading Survey.ascx.resx
Info File Survey.ascx.resx read successfully
Info Loading 03.01.00.SqlDataProvider
Info File 03.01.00.SqlDataProvider read successfully
Info Loading 03.03.00.SqlDataProvider
Info File 03.03.00.SqlDataProvider read successfully
Info Loading 04.00.20.SqlDataProvider
Info File 04.00.20.SqlDataProvider read successfully
Info Loading 04.00.60.SqlDataProvider
Info File 04.00.60.SqlDataProvider read successfully
Info Loading 04.00.70.SqlDataProvider
Info File 04.00.70.SqlDataProvider read successfully
Info Loading EditSurvey.ascx
Info File EditSurvey.ascx read successfully
Info Loading EditSurvey.ascx.vb
Info File EditSurvey.ascx.vb read successfully
Info Loading icon_survey_32px.gif
Info File icon_survey_32px.gif read successfully
Info Loading module.css
Info File module.css read successfully
Info Loading red.gif
Info File red.gif read successfully
Info Loading Settings.ascx
Info File Settings.ascx read successfully
Info Loading Settings.ascx.vb
Info File Settings.ascx.vb read successfully
Info Loading Survey.ascx
Info File Survey.ascx read successfully
Info Loading Survey.ascx.vb
Info File Survey.ascx.vb read successfully
Info Loading Uninstall.SqlDataProvider
Info File Uninstall.SqlDataProvider read successfully
Info Loading SqlDataProvider.vb
Info File SqlDataProvider.vb read successfully
Info Loading DataProvider.vb
Info File DataProvider.vb read successfully
Info Loading SurveyController.vb
Info File SurveyController.vb read successfully
Info Loading SurveyInfo.vb
Info File SurveyInfo.vb read successfully
Info Loading SurveyOptionController.vb
Info File SurveyOptionController.vb read successfully
Info Loading SurveyOptionInfo.vb
Info File SurveyOptionInfo.vb read successfully
Info Loading DNN_Survey.dnn
Info File DNN_Survey.dnn read successfully
Info Loading 04.00.70.txt
Info File 04.00.70.txt read successfully
EndJob Reading files done.
 
StartJob Reading DNN file
Info DNN file is in valid 3.0 format.
Info xml loaded.
Info Loading files info
Info Found valid path (App_LocalResources) for EditSurvey.ascx.resx.
Info Found valid path (App_LocalResources) for Settings.ascx.resx.
Info Found valid path (App_LocalResources) for Survey.ascx.es-ES.resx.
Info Found valid path (App_LocalResources) for Survey.ascx.resx.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 03.01.00.SqlDataProvider.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 03.03.00.SqlDataProvider.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 04.00.20.SqlDataProvider.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 04.00.60.SqlDataProvider.
Info Found valid path (Providers\DataProviders\SqlDataProvider) for 04.00.70.SqlDataProvider.
Info Found valid path ([app_code]Providers\DataProviders\SqlDataProvider) for SqlDataProvider.vb.
Info Found valid path ([app_code]) for DataProvider.vb.
Info Found valid path ([app_code]) for SurveyController.vb.
Info Found valid path ([app_code]) for SurveyInfo.vb.
Info Found valid path ([app_code]) for SurveyOptionController.vb.
Info Found valid path ([app_code]) for SurveyOptionInfo.vb.
Info Loading Modules info
Info Loading Control info for 'Survey' module
EndJob Dnn load finished successfully
 
StartJob Begin Sql execution
Info Executing 03.01.00.SqlDataProvider
StartJob Start Sql execution: 03.01.00.SqlDataProvider file
EndJob End Sql execution: 03.01.00.SqlDataProvider file
 
Info Executing 03.03.00.SqlDataProvider
StartJob Start Sql execution: 03.03.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'IsCorrect' in table 'dbo.DNN_SurveyOptions' is specified more than once. 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.DNN_SurveyOptions ADD IsCorrect bit NOT NULL CONSTRAINT DF_DNN_SurveyOptions_IsCorrect DEFAULT 0 
EndJob End Sql execution: 03.03.00.SqlDataProvider file
 
Info Executing 04.00.20.SqlDataProvider
StartJob Start Sql execution: 04.00.20.SqlDataProvider file
EndJob End Sql execution: 04.00.20.SqlDataProvider file
 
Info Executing 04.00.60.SqlDataProvider
StartJob Start Sql execution: 04.00.60.SqlDataProvider file
EndJob End Sql execution: 04.00.60.SqlDataProvider file
 
Info Executing 04.00.70.SqlDataProvider
StartJob Start Sql execution: 04.00.70.SqlDataProvider file
EndJob End Sql execution: 04.00.70.SqlDataProvider file
 
EndJob Finished Sql execution
 
StartJob Creating files
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\App_LocalResources\EditSurvey.ascx.resx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\App_LocalResources\Settings.ascx.resx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\App_LocalResources\Survey.ascx.es-ES.resx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\App_LocalResources\Survey.ascx.resx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\03.03.00.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\04.00.20.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\04.00.60.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider\04.00.70.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\04.00.70.txt
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\EditSurvey.ascx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\EditSurvey.ascx.vb
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\icon_survey_32px.gif
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\module.css
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\red.gif
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Settings.ascx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Settings.ascx.vb
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Survey.ascx
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Survey.ascx.vb
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\Uninstall.SqlDataProvider
Info Created D:\domains\domainname\wwwroot\DNN\App_Code\Survey\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb
Info Created D:\domains\domainname\wwwroot\DNN\App_Code\Survey\DataProvider.vb
Info Created D:\domains\domainname\wwwroot\DNN\App_Code\Survey\SurveyController.vb
Info Created D:\domains\domainname\wwwroot\DNN\App_Code\Survey\SurveyInfo.vb
Info Created D:\domains\domainname\wwwroot\DNN\App_Code\Survey\SurveyOptionController.vb
Info Created D:\domains\domainname\wwwroot\DNN\App_Code\Survey\SurveyOptionInfo.vb
Info Created D:\domains\domainname\wwwroot\DNN\DesktopModules\Survey\DNN_Survey.dnn.config
EndJob Files created
 
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
 
EndJob Installation successful.

It tells me the install was successful, but there's also an error in the 03.03.00.SqlDataProvider file. Will the Module still work regardless of this error?


Steve White
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveySurvey 04.00.70 Upgrade errorSurvey 04.00.70 Upgrade error


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