Info Starting Installation - Module
Failure ExceptionSystem.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleDefinitions'. Cannot insert duplicate key in object 'dbo.ModuleDefinitions'. 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.AddModuleDefinition(Int32 DesktopModuleId, String FriendlyName, Int32 DefaultCacheTime, Int32 createdByUserID) at DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionController.SaveModuleDefinition(ModuleDefinitionInfo moduleDefinition, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Entities.Modules.DesktopModuleController.SaveDesktopModule(DesktopModuleInfo desktopModule, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Services.Installer.Installers.ModuleInstaller.Install()
Failure Installation Failed - Module
Info Rolling back component install - Script
Info Component rolled back successfully - Script
Info Installation Failed - DNNMasters.XMod.GoogleMap
Info Deleted temporary install folder
EndJob Installation Failed

any ideas?

Looks like you already have the module installed but with different definitions.
Uninstall / install should solve the problem

This is very strange. I have never installed it before. And definitely not on this installation, i started from scratch a week ago. I looked at the module definitions table in the database to see if anything was written. No definitions for DNNMasters.

Any thoughts?
Should I try to install an older version?

Cannot insert duplicate key in object dbo.ModuleDefinitions - this points to duplicate module definition, like the same module but different folder.
I tested the install on fresh DNN 5.1.2 and:
Info Installation committed
Info Installation successful. - DNNMasters.XMod.GoogleMap
Info Deleted temporary install folder
EndJob Installation successful.

I was installing DNNMasters.XMod.GoogleMap_PA_03.00.12.090331_dnn4902_XMod_5.5.zip

that version isn't in the download area..

i received your email. tried it, failed. opened the database, no dnnmasters in dbo.moduledefinitions. i found two tables from the install, and deleted them. also deleted all the stored proceedures, and the folder in desktop modules directory. And tried the install again. still no luck.

This is the error:


Install Extension
Package Installation Report

See below for the results of the package installation
Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - DNNMasters.XMod.GoogleMap
Info Starting Installation - Script
Info Begin Sql execution
Info Folder Created - C:\inetpub\vhosts\planetservo.com\httpdocs\DesktopModules\DNNMasters.XMod.GoogleMap\
Info Created - 01.00.01.SqlDataProvider
Info Executing 01.00.01.SqlDataProvider
Info Start Sql execution: 01.00.01.SqlDataProvider file
Info End Sql execution: 01.00.01.SqlDataProvider file
Info Created - 01.00.02.SqlDataProvider
Info Executing 01.00.02.SqlDataProvider
Info Start Sql execution: 01.00.02.SqlDataProvider file
Info End Sql execution: 01.00.02.SqlDataProvider file
Info Created - 01.00.06.SqlDataProvider
Info Executing 01.00.06.SqlDataProvider
Info Start Sql execution: 01.00.06.SqlDataProvider file
Info End Sql execution: 01.00.06.SqlDataProvider file
Info Created - 02.00.00.SqlDataProvider
Info Executing 02.00.00.SqlDataProvider
Info Start Sql execution: 02.00.00.SqlDataProvider file
Info End Sql execution: 02.00.00.SqlDataProvider file
Info Created - 03.00.00.SqlDataProvider
Info Executing 03.00.00.SqlDataProvider
Info Start Sql execution: 03.00.00.SqlDataProvider file
Info End Sql execution: 03.00.00.SqlDataProvider file
Info Created - 03.00.07.SqlDataProvider
Info Executing 03.00.07.SqlDataProvider
Info Start Sql execution: 03.00.07.SqlDataProvider file
Info End Sql execution: 03.00.07.SqlDataProvider file
Info Created - Uninstall.SqlDataProvider
Info Finished Sql execution
Info Component installed successfully - Script
Info Starting Installation - Module
Failure ExceptionSystem.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleDefinitions'. Cannot insert duplicate key in object 'dbo.ModuleDefinitions'. 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.AddModuleDefinition(Int32 DesktopModuleId, String FriendlyName, Int32 DefaultCacheTime, Int32 createdByUserID) at DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionController.SaveModuleDefinition(ModuleDefinitionInfo moduleDefinition, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Entities.Modules.DesktopModuleController.SaveDesktopModule(DesktopModuleInfo desktopModule, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Services.Installer.Installers.ModuleInstaller.Install()
Failure Installation Failed - Module
Info Rolling back component install - Script
Info Component rolled back successfully - Script
Info Installation Failed - DNNMasters.XMod.GoogleMap
Info Deleted temporary install folder
EndJob Installation Failed

-------------------------------------------------------------------------

And this is what's in the dbo.moduledefinitions table:

ModuleDefID FriendlyName DesktopModuleID DefaultCacheTime CreatedByUserID CreatedOnDate LastModifiedByUserID LastModifiedOnDate
12 Security Roles 10 0 NULL NULL NULL NULL
13 Tabs 11 0 NULL NULL NULL NULL
14 Site Settings 22 0 NULL NULL NULL NULL
15 User Accounts 10 0 NULL NULL NULL NULL
19 Vendors 14 0 NULL NULL NULL NULL
20 Banners 15 0 NULL NULL NULL NULL
21 File Manager 16 0 NULL NULL NULL NULL
27 Site Log 18 0 NULL NULL NULL NULL
28 Newsletters 19 0 NULL NULL NULL NULL
63 Portals 22 0 NULL NULL NULL NULL
65 SQL 24 0 NULL NULL NULL NULL
72 Host Settings 30 0 NULL NULL NULL NULL
74 Account Login 49 -1 NULL NULL NULL NULL
75 User Account 10 0 NULL NULL NULL NULL
76 Recycle Bin 34 0 NULL NULL NULL NULL
79 Log Viewer 37 0 NULL NULL NULL NULL
80 Scheduler 38 0 NULL NULL NULL NULL
85 Search Admin 43 0 NULL NULL NULL NULL
86 Search Input 44 0 NULL NULL NULL NULL
87 Search Results 45 0 NULL NULL NULL NULL
88 Site Wizard 46 0 NULL NULL NULL NULL
90 Lists 48 0 NULL NULL NULL NULL
93 Feed Explorer 51 -1 NULL NULL NULL NULL
94 Extensions 52 0 NULL NULL NULL NULL
95 Solutions 53 0 NULL NULL NULL NULL
101 Skin Designer 59 0 -1 2009-09-22 20:50:49.393 -1 2009-09-22 20:50:49.393
97 WhatsNew 55 0 NULL NULL NULL NULL
98 Gooddogs Dashboard 56 0 -1 2009-09-22 20:50:47.267 -1 2009-09-22 20:50:47.267
99 Languages 57 0 -1 2009-09-22 20:50:48.760 -1 2009-09-22 20:50:48.760
100 Skins 58 0 -1 2009-09-22 20:50:49.180 -1 2009-09-22 20:50:49.180
102 Console 60 0 -1 2009-09-22 20:50:49.783 -1 2009-09-22 20:50:49.783
103 GoogleAnalytics 61 0 -1 2009-09-22 20:50:49.987 -1 2009-09-22 20:50:49.987
104 Text/HTML 62 1200 -1 2009-09-22 20:50:55.710 -1 2009-09-22 20:50:55.710
105 ZLDNNFriend 63 0 1 2009-09-23 10:28:34.117 1 2009-09-23 10:28:34.117
106 ZLDNNUserProfile 64 0 1 2009-09-23 10:52:12.313 1 2009-09-23 10:52:12.313
107 ZLDNNAction 65 0 1 2009-09-23 10:53:13.960 1 2009-09-23 10:53:13.960
108 MyUserMediaGallery 66 0 1 2009-09-23 11:29:34.040 1 2009-09-23 11:29:34.040
109 MyMediaView 67 0 1 2009-09-23 11:30:13.860 1 2009-09-23 11:30:13.860
110 MediaComment 67 0 1 2009-09-23 11:30:13.967 1 2009-09-23 11:30:13.967
111 MediaRating 67 0 1 2009-09-23 11:30:14.013 1 2009-09-23 11:30:14.013
112 MediaListOfSameAlbum 67 0 1 2009-09-23 11:30:14.060 1 2009-09-23 11:30:14.060
113 SendMedia 67 0 1 2009-09-23 11:30:14.110 1 2009-09-23 11:30:14.110
114 MyMediaList 68 0 1 2009-09-23 11:30:52.000 1 2009-09-23 11:30:52.000
115 MyMediaGallerySearch 69 0 1 2009-09-23 11:31:34.443 1 2009-09-23 11:31:34.443
116 Result 69 0 1 2009-09-23 11:31:34.513 1 2009-09-23 11:31:34.513
117 MyMediaGalleryManagement 70 0 1 2009-09-23 11:34:18.600 1 2009-09-23 11:34:18.600
118 Managemedia 71 0 1 2009-09-23 11:36:11.470 1 2009-09-23 11:36:11.470
119 MyMediaGallery 71 0 1 2009-09-23 11:36:11.487 1 2009-09-23 11:36:11.487
120 MyMediaAlbumList 72 0 1 2009-09-23 11:36:51.527 1 2009-09-23 11:36:51.527
121 MyAlbumList 73 0 1 2009-09-23 20:39:41.820 1 2009-09-23 20:39:41.820
122 UsersOnline 74 0 1 2009-09-23 21:54:25.367 1 2009-09-23 21:54:25.367
123 Silverlight Photo Gallery 75 0 1 2009-09-23 22:06:59.010 1 2009-09-23 22:06:59.010
124 Silverlight Photo Gallery Category 76 0 1 2009-09-23 22:06:59.553 1 2009-09-23 22:06:59.553
125 Custom Properties 77 0 1 2009-09-23 22:08:58.277 1 2009-09-23 22:08:58.277
126 Events Calendar 78 0 1 2009-09-23 22:16:24.563 1 2009-09-23 22:16:24.563
127 Events Calendar Quick Add 79 0 1 2009-09-23 22:16:25.127 1 2009-09-23 22:16:25.127
128 Events Calendar-Satellite 80 0 1 2009-09-23 22:16:25.253 1 2009-09-23 22:16:25.253
129 Events Calendar-Flash 81 0 1 2009-09-23 22:16:25.360 1 2009-09-23 22:16:25.360
130 Events Calendar Payment 82 0 1 2009-09-23 22:16:25.457 1 2009-09-23 22:16:25.457
131 EasyMod 83 0 1 2009-09-23 23:21:27.337 1 2009-09-28 16:27:27.860
132 Announcements 84 3600 1 2009-09-28 15:50:56.640 1 2009-09-28 15:50:56.640
133 View_Blog 85 -1 1 2009-09-28 15:51:07.810 1 2009-09-28 15:51:07.810
134 Blog_List 85 -1 1 2009-09-28 15:51:07.860 1 2009-09-28 15:51:07.860
135 New_Blog 85 -1 1 2009-09-28 15:51:07.873 1 2009-09-28 15:51:07.873
136 Search_Blog 85 -1 1 2009-09-28 15:51:07.907 1 2009-09-28 15:51:07.907
137 Blog_Archive 85 -1 1 2009-09-28 15:51:07.923 1 2009-09-28 15:51:07.923
138 Documents 86 0 1 2009-09-28 15:51:11.713 1 2009-09-28 15:51:11.713
139 FAQs 87 0 1 2009-09-28 15:51:12.777 1 2009-09-28 15:51:12.777
140 Feedback 88 0 1 2009-09-28 15:51:15.957 1 2009-09-28 15:51:15.957
141 Feedback Comments 88 0 1 2009-09-28 15:51:16.003 1 2009-09-28 15:51:16.003
142 Help 89 0 1 2009-09-28 15:51:22.797 1 2009-09-28 15:51:22.797
143 Category 89 0 1 2009-09-28 15:51:22.830 1 2009-09-28 15:51:22.830
144 IFrame 90 0 1 2009-09-28 15:51:24.863 1 2009-09-28 15:51:24.863
145 Links 91 0 1 2009-09-28 15:51:27.967 1 2009-09-28 15:51:27.967
146 Map 92 -1 1 2009-09-28 15:51:30.697 1 2009-09-28 15:51:30.697
147 News Feeds (RSS) 93 0 1 2009-09-28 15:51:32.383 1 2009-09-28 15:51:32.383
148 Reports 94 -1 1 2009-09-28 15:51:35.177 1 2009-09-28 15:51:35.177
149 Repository 95 0 1 2009-09-28 15:51:57.593 1 2009-09-28 15:51:57.593
150 Repository Dashboard 96 0 1 2009-09-28 15:51:58.377 1 2009-09-28 15:51:58.377
151 Survey 97 0 1 2009-09-28 15:52:04.693 1 2009-09-28 15:52:04.693
152 XML/XSL 98 0 1 2009-09-28 15:52:07.423 1 2009-09-28 15:52:07.423
153 XMod 99 0 1 2009-09-28 16:14:46.437 1 2009-09-28 16:14:46.437
154 XMod FormView 100 0 1 2009-09-28 16:15:20.677 1 2009-09-28 16:15:20.677
155 ALLDNN_MSNHistory 101 0 1 2009-09-28 16:18:50.743 1 2009-09-28 16:18:50.743
166 XModIDE 112 0 1 2009-09-30 18:46:29.483 1 2009-09-30 18:46:29.483
157 NetismMapExt 103 0 1 2009-09-28 16:24:31.747 1 2009-09-28 16:24:31.747
158 CISS.FlashCharts 104 0 1 2009-09-28 16:24:33.353 1 2009-09-28 16:24:33.353
159 CISS.FlashPlayers 105 0 1 2009-09-28 16:24:38.157 1 2009-09-28 16:24:38.157
160 CISS.PagePeel 106 0 1 2009-09-28 16:24:39.110 1 2009-09-28 16:24:39.110
161 Form and List 107 -1 1 2009-09-28 16:24:51.107 1 2009-09-28 16:24:51.107
162 XMod Detail View 108 0 1 2009-09-28 19:37:01.297 1 2009-09-28 19:37:01.297
164 Adsense 110 1200 1 2009-09-30 15:13:16.070 1 2009-09-30 15:13:16.070
165 Media 111 0 1 2009-09-30 15:13:18.097 1 2009-09-30 15:13:18.097

-----------------------------------------------------------------------

I started looking at some of the sql that runs during install (not that i know a hellofalot about what i'm looking at).

In [01.00.01.SqlDataProvider], what is <-- CREATE TABLE #DNNMasters_Jetkey_GoogleMap_Point ( --> ??

And further down that page: <-- create table #dnn_kb_xmod_modules --> ??

The conflict is with core Map module.
Either remove it or edit the .dnn file in XGM changing Map to something else

I took out the core Map module. Installation went smoothly after that. thankyou.

fyi...took me a while to figure out which fields were required and which not on the xmod integration values. the update button just wouldn't work...and only reported two fields as being required - when it's more like 4-6 required fields.

could you post a list of all required fields (for the config to submit) and another list of minimum required fields data types/examples (for the map to work (show anything). i am trying to use this map to show listings in DNN Professors Business.Directory module.

Thanks!

Hi
The module requires a bit of work to make it operate with minimal set of fields configured. It works good with all fields defined, but weird things happen when they aren't. Please give us several days, we'll make some fixes.
Thanks