Derek Bruyere
 New Member Posts:49
 |
| 11 Feb 2010 05:20 PM |
|
I have tried every way I can think of to install this and I'm getting the error below. Please Help. Info Start Sql execution: 01.00.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole) if exists (select * from dbo.sysusers where name='public') begin declare @exec nvarchar(2000) declare @name varchar(150) declare sp_cursor cursor for select o.name as name from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name while @@fetch_status >= 0 begin select @exec = 'grant EXECUTE on [' + @name + '] to [public]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end
|
|
|
|
|
Inven Manager
 Senior Member Posts:6761

 |
|
Derek Bruyere
 New Member Posts:49
 |
| 12 Feb 2010 02:58 AM |
|
I have sent the account info. I have removed all traces of event calendar from the db and uploaded the files into the install/modules directory. DNN: 5.2 .net 3.5 Windows Server 2008 x64/IIS7
|
|
|
|
|
Derek Bruyere
 New Member Posts:49
 |
|
Inven Manager
 Senior Member Posts:6761

 |
|
Inven Manager
 Senior Member Posts:6761

 |
|
Derek Bruyere
 New Member Posts:49
 |
| 19 Feb 2010 03:00 PM |
|
This is not a server/portal problem. I have 6 servers and to prove a point I used a clean install of Windows Server 2008. A clean install of SQL Server 2008. A clean install of DNN 5.2.3. All unaltered, default installations. I added maxRequestLength="2097151" requestLengthDiskThreshold="500000" to the web.config. I tried to install the Event Calendar & Registration module. SAME ERROR. I tried to install from the Extensions/Install Available Extensions. Error. I tried to install from the Install new module. Error. You cannot tell me that this is an unusual occurrance. I set up a virtual environment locally with clean installs of all and I'm have the same problem. |
|
|
|
|
Inven Manager
 Senior Member Posts:6761

 |
|
Inven Manager
 Senior Member Posts:6761

 |
|
Derek Bruyere
 New Member Posts:49
 |
| 20 Feb 2010 10:45 AM |
|
I had turned off the site. I finally gave up on what I was trying and I did one last "repair" install of the module. It installed with no errors but wouldn't work because the scripts didn't run. I ended up running them one at a time manually and making sure everything as far as the files were in place. It seems to be working ok now. I haven't tried a full even entry/registration/payment yet, but I was able to add a simple event.I'll keep putting it to testing for now and hope I can launch with it in the next few days. I wish I had known to try installing a previous version before I spent hours on the manual route. |
|
|
|
|
Derek Bruyere
 New Member Posts:49
 |
| 20 Feb 2010 10:51 AM |
|
I should point out that while this is all fairly frustrating, the support and the attempts at trying to help solve the problems have been very appreciated. |
|
|
|
|
Inven Manager
 Senior Member Posts:6761

 |
|