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 ForumsEventsEventsUpgrade to 5.1.4 failedUpgrade to 5.1.4 failed
Previous
 
Next
New Post
8/19/2010 9:02 PM
 
Hi,
After upgrading to DNN5.5, I tried to upgrade Events module from 5.0.3 to 5.1.4 . But the upgrade failed from available resources.
so I downloaded Events 5.1.4 and retried to install module like this. I can see the error from the log (view below) due to existing event permissions.
Do you know who to fix it please ?
------------
Package Installation Report

See below for the results of the package installation
Error loading files from temporary folder - see below
StartJob Début de l'installation
Info Début de l'installation - DNN_Events
Info Début de l'installation - Script
Info Début de traitement SQL
Info Création de la sauvegarde de la version précédente - Installation\05.01.00.SqlDataProvider
Info Fichier créé - Installation\05.01.00.SqlDataProvider
Info Traitement en cours05.01.00.SqlDataProvider
Info Début de traitement de script Sql : 05.01.00.SqlDataProvider
Info Exécution SQL terminée : fichier 05.01.00.SqlDataProvider
Info Création de la sauvegarde de la version précédente - Installation\05.01.01.SqlDataProvider
Info Fichier créé - Installation\05.01.01.SqlDataProvider
Info Traitement en cours05.01.01.SqlDataProvider
Info Début de traitement de script Sql : 05.01.01.SqlDataProvider
Info Exécution SQL terminée : fichier 05.01.01.SqlDataProvider
Info Création de la sauvegarde de la version précédente - Installation\05.01.02.SqlDataProvider
Info Fichier créé - Installation\05.01.02.SqlDataProvider
Info Traitement en cours05.01.02.SqlDataProvider
Info Début de traitement de script Sql : 05.01.02.SqlDataProvider
Info Exécution SQL terminée : fichier 05.01.02.SqlDataProvider
Info Création de la sauvegarde de la version précédente - Installation\05.01.03.SqlDataProvider
Info Fichier créé - Installation\05.01.03.SqlDataProvider
Info Traitement en cours05.01.03.SqlDataProvider
Info Début de traitement de script Sql : 05.01.03.SqlDataProvider
Info Exécution SQL terminée : fichier 05.01.03.SqlDataProvider
Info Création de la sauvegarde de la version précédente - Installation\05.01.04.SqlDataProvider
Info Fichier créé - Installation\05.01.04.SqlDataProvider
Info Traitement en cours05.01.04.SqlDataProvider
Info Début de traitement de script Sql : 05.01.04.SqlDataProvider
Info Exécution SQL terminée : fichier 05.01.04.SqlDataProvider
Info Création de la sauvegarde de la version précédente - Installation\Uninstall.SqlDataProvider
Info Fichier créé - Installation\Uninstall.SqlDataProvider
Info Fin de traitement SQL
Info Composant installé avec succès - Script
Info Début de l'installation - Module
Failure AnomalieSystem.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_dnn_Permission'. Cannot insert duplicate key in object 'dbo.dnn_Permission'. The statement has been terminated. 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.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddPermission(String permissionCode, Int32 moduleDefID, String permissionKey, String permissionName, Int32 createdByUserID) at DotNetNuke.Security.Permissions.PermissionController.AddPermission(PermissionInfo objPermission) in C:\PlayModule\Library\Security\Permissions\PermissionController.vb:line 37 at DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionController.SaveModuleDefinition(ModuleDefinitionInfo moduleDefinition, Boolean saveChildren, Boolean clearCache) in C:\PlayModule\Library\Entities\Modules\Definitions\ModuleDefinitionController.vb:line 210 at DotNetNuke.Entities.Modules.DesktopModuleController.SaveDesktopModule(DesktopModuleInfo desktopModule, Boolean saveChildren, Boolean clearCache) in C:\PlayModule\Library\Entities\Modules\DesktopModuleController.vb:line 374 at DotNetNuke.Services.Installer.Installers.ModuleInstaller.Install() in C:\PlayModule\Library\Services\Installer\Installers\ModuleInstaller.vb:line 174
Failure Echec de l'installation - Module
Info Restauration du composant - Script
Info Restauration de la version précédente - Installation\05.01.00.SqlDataProvider
Info Restauration de la version précédente - Installation\05.01.01.SqlDataProvider
Info Restauration de la version précédente - Installation\05.01.02.SqlDataProvider
Info Restauration de la version précédente - Installation\05.01.03.SqlDataProvider
Info Restauration de la version précédente - Installation\05.01.04.SqlDataProvider
Info Restauration de la version précédente - Installation\Uninstall.SqlDataProvider
Info Composant restauré avec succès - Script
Info Echec de l'installation - DNN_Events
Info Suppression du dossier d'installation temporaire
EndJob Echec de l'installation
 
 
New Post
8/20/2010 2:55 AM
 
Can you try running this in Host SQL dialogue, and post back the results.

select * from Permission where {databaseOwner}{objectQualifier}PermissionCode like 'EVENTS%' or PermissionKey like 'EVENTS%'

Cheers
Roger


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
8/20/2010 4:19 AM
 
Hi Roger, Thank you for help. This is the sql results :

14 EVENTS_MODULE 113 EVENTSMOD Events Moderator 9999 -1 2009-12-27 12:16:34.780 -1 2009-12-27 12:16:34.780
15 EVENTS_MODULE 113 EVENTSCAT Global Category Editor 9999 -1 2009-12-27 12:16:34.780 -1 2009-12-27 12:16:34.780
16 EVENTS_MODULE 113 EVENTSLOC Global Location Editor 9999 -1 2009-12-27 12:16:34.780 -1 2009-12-27 12:16:34.780
27 EVENTS_MODULE 195 EVENTSMOD Events Moderator 9999 -1 2010-03-30 15:03:44.607 -1 2010-03-30 15:03:44.607
28 EVENTS_MODULE 195 EVENTSCAT Global Category Editor 9999 -1 2010-03-30 15:03:44.623 -1 2010-03-30 15:03:44.623
29 EVENTS_MODULE 195 EVENTSLOC Global Location Editor 9999 -1 2010-03-30 15:03:44.623 -1 2010-03-30 15:03:44.623
31 EVENTS_MODULE 113 EVENTSSET Edit Settings 9999 1 2010-08-20 01:05:59.687 1 2010-08-20 03:00:42.297

Bye,
Etienne.
 
New Post
8/20/2010 4:41 AM
 
Thanks for correcting my SQL ;-)

Well, there should only be one record for the Key and Code pairs (e.g. EVENTS_MODULE and EVENTSMOD), and I'm not sure how it has managed to create the extra rows. For some reason the core ModulePermissions handling code checks to see if there is 1 (and it must be 1 not 2) record. If there is 1 it does an update, if there is 0 or >1 it does an add. In theory this should be valid code, but if you have more than 1.... it will fail.

The thing is, you have two different ModuleDefIDs in the list (113 and 195). This implies you have the module installed twice somehow. I think I would want to understand what is happening on your site. I'd investigate the ModuleDefinitions table to see what the difference is between the two versions of the Events module on yoru site (it shouldn't be possible). Looks like you installed one on 27/12/2009 and another on 30/03/2010.

Try to investigate and see what is going on. You can mail me at webmaster @ the domain in my profile if you want to chat more.

Cheers
Roger

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
8/20/2010 5:44 AM
 
Ok, the upgrade was done correctly now after deleting lines of ModuleDefID=195 in dnn_permission. Thank you very much, Roger, for all infos.
See below how can i obtain this error.

After investigation, i observed ModuleDefID=195 is orphan. No relation exist out of dnn_permission.
This is a potentiel method I made to obtain that :
1. Some time ago, from Host > ModuleDefinitions, I renamed the friendly name (Events) of the module definition  (id 113) to get name in french. In fact, I should have to renamed the package friendy name, i did a mistake.
2. A day, I made an upgrade of the module ; so, it had been installed twice (id 113 and 195 during upgrade) because the definition title has changed
3. After this upgrade, I detected the second instance of the module and I understood my mistake. So, firstly, I deleted this parasit second instance and, secondly, for the unique instance now, I renamed package title instead of module definition title. During deletion, it seems dnn_permission had not been deleted due to my special config (two module definitions).

Bye,
Etienne.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsUpgrade to 5.1.4 failedUpgrade to 5.1.4 failed


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