Bad Sal, bad bad Sal... *grin*

This one is simple.  You deleted a file in the file system directly that had already been synched in the DNN database ( rather than deleting it through the File Manager ).  Likely the file that would normally appear as the first ( and thus selected ) item in the picker.  I'm guessing this file was probably aspnet.gif or one of those.  The easiest thing to do would be to put those back, and then delete them through the file manager... otherwise you have a little hunt and peck to do through the DB table to delete entries you know are no longer there.

You might be tempted to ask why we don't handle this for you on the synch.  But the reason is simply that although synching the addition of new files is pretty straightforward, understanding why a file does not exist can be much harder ( it could be moved or renamed ).  And for existing files, which may already be linked to other things... we just don't force that.  I'm sure there's room for enhancement in here... but its not my area so I can't speak to it directly.

Cheers

Scott Willhite, Co-Founder DNN

Still more info..

Ok... so here's the latest.  I have gone through (file by file) in the files table and the folders table and reconciled each entry to a physical file/folder under the dnn/portals structure.   There were a couple of references for folders in the folders table that did not exist in the directory... a few portals had the /skins folder that did not exist on disk.  So, I removed the rows from the database.   I am still getting the error referenced in the beginning of this thread.   So, I restored the database back to a prior date and copied the dotnetnuke directory from an earlier point in time, and I still get the error.   Could it be that there is something else happening to cause this?   The error appears anywhere in a DNN portal where there is a  file lookup control.   Otherwise, the file manager and all other aspects of the portals are working fine.   Here's the error when navigating to the site settings tab and the error for after selecting a folder from file location listbox control:

Basic Settings In this section, you can set up the basic settings for your site.   Site Details Title: This is the Title for your portal. The text you enter will show up in the Title Bar. Description: Enter a description about your site here. Key Words: Enter some keywords for your site (separated by commas). These keywords are used by search engines to help index your site.   Appearance Logo: Depending on the skin chosen, this image will appear in the top left corner of the page. File Location: Root 2005 2005/images images Press SEC SEC/10-KSB SEC/10-QSB SEC/8-K SEC/Form-4 SEC/governance SEC/proxy File Name: Upload New FileUpload Selected File Select An Existing File An error has occurred. DotNetNuke.Services.Exceptions.ModuleLoadException: Folder ---> System.IndexOutOfRangeException: Folder at System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName) at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) at System.Data.SqlClient.SqlDataReader.get_Item(String name) at DotNetNuke.Common.Globals.GetFileList(Int32 PortalId, String strExtensions, Boolean NoneSpecified, String Folder, Boolean includeHidden) at DotNetNuke.UI.UserControls.UrlControl.GetFileList(String strExtensions, Boolean NoneSpecified, String Folder) at DotNetNuke.UI.UserControls.UrlControl.ShowControls() at DotNetNuke.UI.UserControls.UrlControl.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

And from after the file location listbox control:

You are here:  AdminSite Settings

A critical error has occurred. Folder Site Settings      Basic Settings In this section, you can set up the basic settings for your site.   Site Details Title: This is the Title for your portal. The text you enter will show up in the Title Bar. Description: Enter a description about your site here. Key Words: Enter some keywords for your site (separated by commas). These keywords are used by search engines to help index your site.   Appearance Logo: Depending on the skin chosen, this image will appear in the top left corner of the page. File Location: Root 2005 2005/images images Press SEC SEC/10-KSB SEC/10-QSB SEC/8-K SEC/Form-4 SEC/governance SEC/proxy File Name: Upload New FileUpload Selected File Select An Existing File An error has occurred. DotNetNuke.Services.Exceptions.ModuleLoadException: Folder ---> System.IndexOutOfRangeException: Folder at System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName) at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) at System.Data.SqlClient.SqlDataReader.get_Item(String name) at DotNetNuke.Common.Globals.GetFileList(Int32 PortalId, String strExtensions, Boolean NoneSpecified, String Folder, Boolean includeHidden) at DotNetNuke.UI.UserControls.UrlControl.GetFileList(String strExtensions, Boolean NoneSpecified, String Folder) at DotNetNuke.UI.UserControls.UrlControl.ShowControls() at DotNetNuke.UI.UserControls.UrlControl.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---