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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Deleting files manuallyDeleting files manually
Previous
 
Next
New Post
10/17/2011 11:51 AM
 
I am currently experiencing an error with File Manager.  I believe what has happened is that we have uploaded too many files for it to calculate space in the application itself.  Because of this, we are unable to delete files to clear up this situation.  Is there a way to manually remove the file links in the database?  I can see the physical file on the server but obviously just moving that does not take care of  the link and thus the calculation problem still exists. 
 
New Post
10/17/2011 8:15 PM
 
What is the File Manager error? Just not being able to see the files?

What happens when you try to delete a file?

Have you tried a recursive sync?

Are folders and files all lowercase or are some uppercase?

What DNN version? I've noticed some quirks in DNN 6, but cannot swear it is a bug yet.

I know, not much help............
 
New Post
10/18/2011 9:25 AM
 
I had a previous post regarding this error "File Manager error".   Here is the error message:
Anyone ever run across this and know what it means and how to fix it?

Error: File Manager is currently unavailable.
DotNetNuke.ModuleLoadException: Arithmetic overflow error converting expression to data type int. ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting expression to data type int. at System.Data.SqlClient.SqlDataReader.Read() at DotNetNuke.PortalController.GetPortalSpaceUsed(Int32 PortalId) at DotNetNuke.FileManager.BindData() at DotNetNuke.FileManager.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---









Basically, we have a very old version of DNN 2.1.2 with the GetPortalSpaceUsed field being too small to hold the calculation to handle the number of files we have on the site.  Solution was to upgrade which YES we definitely need to, however, at this point I cannot access file manager at all for this portal and need to be able to go through the back door to do some file cleanup.  I'm wondering if I can remove the links that are stored in the database ie. the pointers to the files, which would then reduce the calculation held in GetPortalSpaceUsed.  If I can't do it manually, we cannot manage files any longer since File Manager is not working.  And ideas?
 
New Post
10/19/2011 6:30 PM
 
Don't know how many files you have, but you should be able to find them in dbo.Files table of your DB. I'm guessing it's the same on all DNN versions.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Deleting files manuallyDeleting files manually


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