1
Vote

Error Installing 4.0.0 on DNN 7.2.1

description

When I try to install I get a number of errors like the following and the module will not function.

Install Package::DNNspot-Maps
Info::Starting Installation
Info::Starting Installation - DNNspot-Maps
Info::Starting Installation - Script
Info::Begin Sql execution
Info::Folder Created - C:\HostingSpaces\RBF-Attorneys\rbf-attorneys.com\wwwroot\DesktopModules\DNNspot-Maps\
Info::Created - 01.00.00.SqlDataProvider
Info::Executing 01.00.00.SqlDataProvider
Info::Start Sql execution: 01.00.00.SqlDataProvider file
Info::End Sql execution: 01.00.00.SqlDataProvider file
Info::Created - 01.00.01.SqlDataProvider
Info::Executing 01.00.01.SqlDataProvider
Info::Start Sql execution: 01.00.01.SqlDataProvider file
Info::SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.DNNspot_Maps_Markers" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:76801277-1d45-4701-b514-23a5fab703a2 ALTER TABLE dbo.[DNNspot_Maps_Markers] ADD [CustomField] varchar NULL
Info::End Sql execution: 01.00.01.SqlDataProvider file

file attachments

comments

djamell wrote Feb 6, 2014 at 12:51 PM

After further investigation it appears it has to do with the way the DNNspot_Maps_Markers table is created.

In previous versions, it gets created as;

dbo.DNNspot_Maps_Markers

But on DNN7 it gets created as;

[databasename].DNNspot_Maps_Markers

kTpeterson wrote Feb 25, 2014 at 3:34 PM

How did you fix this problem?

djamell wrote Feb 25, 2014 at 3:47 PM

@kTpeterson - I got your email and decided to respond here so all could see.

In my case it created the table, it just didn't name it correctly. I think I fixed the problem (partially) by renaming the table.

Is there anyone who could take a look at this. I think it would be an easy fix, but I'm not capable.

colbyDNN wrote Mar 3, 2014 at 8:16 PM

I changed the schema on 7.2.1, however adding the module to a page results in an error. Also I see the DNNSpot site is down, so no documentation on this.

Oh well...

djamell wrote Mar 3, 2014 at 9:45 PM

Yes, I will be very sad to see this module go.

How about it DNNSpot. Are you still there? Please let us know if you can help.

dnnspot wrote Mar 5, 2014 at 3:14 PM

Still here and alive! I can take a look at the issue.

dnnspot wrote Mar 5, 2014 at 3:32 PM

Try this updated version. Seems to be working for me.

dnnspot wrote Mar 5, 2014 at 3:34 PM

I'll post it on the downloads page

djamell wrote Mar 5, 2014 at 3:39 PM

Great! I'll try to take a look and will report back hopefully by tomorrow.

Thanks!

djamell wrote Mar 22, 2014 at 12:03 PM

Sorry it took so long to get back on this.

I can confirm that on a fresh install of DNN 7.2.2 the module installs properly.

Thanks!