Well, we fixed the wrong database problem . . . Totally recreated the site. I was getting antsy with so many different errors since switching to 5.1 anyway.
So we're up and running and the UI is installed, BUT!
I get this error in the log after it manages to import some of the records . . . how can that be?
AssemblyVersion: 5.1.0
PortalID: 0
PortalName: Adirondack Mountain Club
UserID: 1
UserName: host
ActiveTabID: 70
ActiveTabName: Import
RawURL: /portal/Tools/Import/tabid/70/windex/2/wid/1/Default.aspx
AbsoluteURL: /portal/Default.aspx
AbsoluteURLReferrer: http://adk.org/portal/Tools/Import/...fault.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.12) Gecko/2009070611 Firefox/3.0.12 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 1443eb98-5274-4e56-89fc-f681e2dc8ba2
InnerException: 'Sheet1$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling
StackTrace:
Message: System.Data.OleDb.OleDbException: 'Sheet1$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at DataSprings.DNN.Modules.UserImport.Business.UserImportController.ImportFile(String FileName, Byte[] FileContent, String SheetName)
Source:
Server Name: DEDI253