When trying to install I get this SQL error StartJob Start Sql execution: 02.08.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 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.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) --* TRIGGER UPDATE ON THE UserGeoLookup TABLE, USING THE GeoLookup TABLE UPDATE dbo.GeoLookup SET Country = 'Undefined' WHERE GeoLookup = -1 UPDATE p SET PropertyValue = PropertyValue FROM userProfile as p inner join profilePropertyDefinition as pd on p.propertyDefinitionID = pd.propertyDefinitionID and pd.PropertyName in ('City', 'Region', 'Country') --* ADD THE COUNTRY ONLINE VIEW SET QUOTED_IDENTIFIER ON EndJob End Sql execution: 02.08.00.SqlDataProvider file

Is this an upgrade from an earlier version of GoMap, or are you installing GoMap on your DNN instance? Also, is a fresh DNN 4.5.1 install or is this a new DNN install?

Thanks

Fresh GoMap install and Upgraded 4.5.1 from 4.35>4.41>4.50>4.5.1

Hi dschaening,

We have just released 2.8.1. Can you try installing this update and let us know if it resolves your issue?

Should I uninstall first? SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_UserGeoLookup'. Cannot insert duplicate key in object 'UserGeoLookup'. 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.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) --* TRIGGER UPDATE ON THE UserGeoLookup TABLE, USING THE GeoLookup TABLE UPDATE dbo.GeoLookup SET Country = NULL WHERE GeoLookup IS NULL --* ADD THE COUNTRY ONLINE VIEW SET QUOTED_IDENTIFIER ON

ok I uninstalled the last version and installed this version and we have a working copy! Thanks
What I would like to do with this module is probably typical. Use the user base and be able to enter an address and display users within a radius of the address input. Can you point me in the right direction to accomplish that feat?

Hi dschaening, the default search options when GoMap is set to Directory mode has an Address search box. Take a look at the settings in the Wizard as starting point.

I have that working, but it will not display the directory items...I used the defaults and copied the css file to the Module root from the sample. What am I missing? There are no instructions on this part.

When I try to plot points to be added to a new table created by gomap, the 'fetching data' runs and never gives me any options, maybe that is the issue?

That may be the issue. Have you gotten either of the default views to work?

Yes I have the vwPersonOnline working for plotting and such. Two issue remain though.

The directory does not display, but the search does, and works. (using default templates)
The plotted locations are way off. Went into the table and checked the lat/long which are correct, but they are rendered off on the map, maybe 150 miles or so.

Anyway to get this to look like your demo on this site? That is exactly what I am looking for?

GoMap needs a text area on the page (a div) defined somewhere on the page to insert its results.

Try adding this HTML to the page:


You need one DIV with the id myResults, and a second with id myPager to display a pager in case multiple results are returned.

Here is that HTML again:
<div id="myResults" style="width: 100%; font-family: arial; font-size: 11px;"></div>
<br>
<div id="myPager" style="width: 100%; font-family: arial; font-size: 11px;"></div>

I thought it rendered and this was an override value, so it lists everything, but the points are still off

oh, and it is rendering multples per point and there are no addresses like in your demo.

Can you post a link to your example? There may be an issue with the logic in calculating the search radius.

I still need to clean up some formatiing but here you go.,

http://intranet.mymcteam.com/Home/EMPMap/tabid/384/Default.aspx

Seems as if only the Country and State are plotted, but I am using the Persons View? Do I need to create this procedure myself, because the lat/long are correct.

If you look at the views that ship with GoMap plot an address, they lookup the country, region, and city from the GeoLookup table on a best effort basis. GoMap populates this table with countries and states, but it does not contain any data for cities. If you need more accuracy, you will need to add more records to the GeoLookup table , or lookup the latitude and longitude for your points using a different method.

I was just looking at that. If I add those columns, is the logic already there to lookup those items, or do I need to rewrite some code?

vwPeopleOnline and vwCountriesOnline will automatically pick the most detailed match in this order: city, state, country, so yes, if you add city data, it will automatically work.