Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListError loading files from temporary folderError loading files from temporary folder
Previous
 
Next
New Post
5/24/2009 3:37 PM
 

Hi - I'm trying to install form and List Module 5 and getting this error message.  Any help would be really, really appreciated.

I'm running DNN 5.0.1 and everything else is currently running fine.  I have upgraded from DNN 4.x.x

Error loading files from temporary folder

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.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 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='xxxx') 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 [xxxx]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end

(xxxx replaces username)

 
New Post
5/24/2009 5:50 PM
 

My answer might not be very helpfull, all I can tell you is that it is not directly caused by form and List. I never saw this error before. I did not yet upgrade any of my productive sites to DNN5, I only started new projects. For all others I am waiting for DNN5.1.

I suggest that you post your issue to Gemini as an core issue, however if I were you, I would run a restore to DNN4.9.x and try in a month again.

 
New Post
5/24/2009 6:18 PM
 

Thanks Stefan - I wonder, how do you know this isn't caused by form and List?  Any info you can give about why this isn't a module specific error would help me.  I tried installing the latest Survey module just to ensure that I was not having problems installing all modules.  Survey installed fine first time so that's why I thought this was a problem specific to the form and List module.

I tried removing the old version of Fom and List (User Defined Table) and then installing again, but I got the same error message.

 
New Post
5/24/2009 9:32 PM
 

I seem to have got around the problem!  I still don't know what caused it but I'll post what I did here in case it helps anyone else.

Firstly I removed User Defined Tables module.  Then I reinstalled UserDefinedTable (03.05.01) through the Batch Install Extensions page.  Then I downloaded form and List Module from the DotNetNuke website and installed it through Host - Module Definitions - Install Module

I'm not sure if the order of doing things made any difference or if there was something else going on at the server.  When it worked it was at a time of day when my portals would have had practically no traffic and I ensured I had no other connections to the SQL server open.

Thanks for your help - I hope this may give some inspiration to someone else if they hit this problem.

 
New Post
5/25/2009 5:13 AM
 

matt@special.co.uk wrote
 

Thanks Stefan - I wonder, how do you know this isn't caused by form and List? 

The stored procedure "GrantStoredProceduresPermission" is part of the core installer,  not of the module itself. The module has no influence on this step. I don't know why you did run into a timeout in the first place - however if you remove the module, you are also removing all related database objects and permissions, it provides an fresh start.

It did not matter whether you installed UDT or FnL afterwards.

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListError loading files from temporary folderError loading files from temporary folder


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out