What is the purpose of this table and is it needed for Go Map to function properly if I am not plotting my users on a map? This table prevents me from deleting any users from my site. I have to go into the database and delete the UserGeoLookup reference to the user first and then I can remove the user. The user's GeoLookup is set to -1. Help is appreciated, Thanks.

Hi Watcher44,

We will look into this problem.

Hi Watcher44,
The issue here is in a foreign key on the UserGeoLookup table. If you recreate the FK_UserGeoLookup_Users such that a delete in the User table cascades to the UserGeoLookup table, deleting a DNN user will work again.
This is the SQL that should change this behavior (assuming you don't have an object qualifier)
[quote]
ALTER TABLE UserGeoLookup
DROP CONSTRAINT FK_UserGeoLookup_Users
GO

ALTER TABLE UserGeoLookup ADD CONSTRAINT
FK_UserGeoLookup_Users FOREIGN KEY
(
UserID
) REFERENCES Users
(
UserID
) ON UPDATE NO ACTION
ON DELETE CASCADE
[/quote]

This change will be included in the next release of GoMap.

Worked like a champ. Thanks!