You are here:   Support > User Forum
Register   |  Login

Invenmanager User Forum

Minimize
SQL errors on install
Last Post 20 Feb 2010 01:09 PM by Inven Manager. 11 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Derek Bruyere
New Member
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
Senior Member
Posts:6761
Avatar

--
12 Feb 2010 02:35 AM  
I believe you are running on DNN 5.x?

Please send the host account to support @ invenmanager .com and we will try to help you to install it.
========================================
Delivering high value DotnetNuke Modules to save your time and resources
Derek Bruyere
New Member
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
New Member
Posts:49

--
15 Feb 2010 09:38 AM  
??
Inven Manager
Senior Member
Senior Member
Posts:6761
Avatar

--
16 Feb 2010 04:17 AM  
Derek,

As we communicated via email, we tried many times installing on your portal, it always timed out....
========================================
Delivering high value DotnetNuke Modules to save your time and resources
Inven Manager
Senior Member
Senior Member
Posts:6761
Avatar

--
16 Feb 2010 04:18 AM  
Derek,

As we communicated via email, we tried many times installing on your portal, it always timed out....
========================================
Delivering high value DotnetNuke Modules to save your time and resources
Derek Bruyere
New Member
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
Senior Member
Posts:6761
Avatar

--
20 Feb 2010 03:03 AM  
Derek,

let me try again installing on your site.

I have the last resort, which is to install earlier version 2.4.2 first, then upgrade to the latest version... will keep you informed.
========================================
Delivering high value DotnetNuke Modules to save your time and resources
Inven Manager
Senior Member
Senior Member
Posts:6761
Avatar

--
20 Feb 2010 04:22 AM  
Derek,

I tried to access http://stage.swimfreedom.com/ again, but it gives a 500 - Internal server error.
========================================
Delivering high value DotnetNuke Modules to save your time and resources
Derek Bruyere
New Member
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
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
Senior Member
Posts:6761
Avatar

--
20 Feb 2010 01:09 PM  
Derek,

I apologize for the inconvenience and frustration.

We will seek solutions to this problem, whether it is from the module PA, or DotnetNuke itself.

Thanks for your understanding and let me know if you need any help.
========================================
Delivering high value DotnetNuke Modules to save your time and resources
You are not authorized to post a reply.

Active Forums 4.1