The last upgrade deleted all past events (on my test system), this latest one threw an error on the install (see below), brought down the whole site until it was rebooted, and shows a critical error on the page with the calendar (see below also). What can I do to resolve this????
Thanks
Mike
DNN 5.1.4
SQL 2000
Events previous version 4.0.2
Events updated version 5.0.2
Install results:
StartJob Starting Installation
Info Starting Installation - DNN_Events
Info Starting Installation - Script
Info Begin Sql execution
Info Created - 04.01.00.SqlDataProvider
Info Executing 04.01.00.SqlDataProvider
Info Start Sql execution: 04.01.00.SqlDataProvider file
Warning SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 13: Incorrect syntax near 'max'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /************************************************************/ /***** *****/ /***** Correct Invalid data *****/ /***** *****/ /************************************************************/ /************************************************************/ /* Change EventName to nVarchar since it should be and isn't from old versions */ ALTER TABLE dbo.[Events] ALTER COLUMN [EventName] NVARCHAR (max)
Info End Sql execution: 04.01.00.SqlDataProvider file
Info Created - 04.01.01.SqlDataProvider
Info Executing 04.01.01.SqlDataProvider
Info Start Sql execution: 04.01.01.SqlDataProvider file
Info End Sql execution: 04.01.01.SqlDataProvider file
Info Created - 04.01.02.SqlDataProvider
Info Executing 04.01.02.SqlDataProvider
Info Start Sql execution: 04.01.02.SqlDataProvider file
Info End Sql execution: 04.01.02.SqlDataProvider file
Info Created - 05.00.00.SqlDataProvider
Info Executing 05.00.00.SqlDataProvider
Info Start Sql execution: 05.00.00.SqlDataProvider file
Info End Sql execution: 05.00.00.SqlDataProvider file
Info Created - 05.00.01.SqlDataProvider
Info Executing 05.00.01.SqlDataProvider
Info Start Sql execution: 05.00.01.SqlDataProvider file
Info End Sql execution: 05.00.01.SqlDataProvider file
Info Created - 05.00.02.SqlDataProvider
Info Executing 05.00.02.SqlDataProvider
Info Start Sql execution: 05.00.02.SqlDataProvider file
Info End Sql execution: 05.00.02.SqlDataProvider file
Info Creating backup of previous version - Uninstall.SqlDataProvider
Info Created - Uninstall.SqlDataProvider
Info Finished Sql execution
Info Component installed successfully - Script
Info Starting Installation - Cleanup
Info Processing Cleanup File - 4.1.0
Info Completed Processing of Cleanup File - 4.1.0
Info Component installed successfully - Cleanup
Info Starting Installation - Cleanup
Info Processing Cleanup File - 4.1.1
Info Completed Processing of Cleanup File - 4.1.1
Info Component installed successfully - Cleanup
Info Starting Installation - Cleanup
Info Processing Cleanup File - 4.1.2
Info Completed Processing of Cleanup File - 4.1.2
Info Component installed successfully - Cleanup
Info Starting Installation - Cleanup
Info Processing Cleanup File - 5.0.0
Info Completed Processing of Cleanup File - 5.0.0
Info Component installed successfully - Cleanup
Info Starting Installation - Cleanup
Info Processing Cleanup File - 5.0.1
Info Completed Processing of Cleanup File - 5.0.1
Info Component installed successfully - Cleanup
Info Starting Installation - Cleanup
Info Processing Cleanup File - 5.0.2
Info Completed Processing of Cleanup File - 5.0.2
Info Component installed successfully - Cleanup
Info Starting Installation - Module
Info Module registered successfully - DNN_Events
Info Component installed successfully - Module
Info Starting Installation - Assembly
Info Assembly registered - bin\DotNetNuke.Events.ScheduleControl.dll
Info Creating backup of previous version - bin\DotNetNuke.Events.ScheduleControl.dll
Info Created - bin\DotNetNuke.Events.ScheduleControl.dll
Info Assembly registered - bin\DotNetNuke.Events.WebControls.dll
Info Creating backup of previous version - bin\DotNetNuke.Events.WebControls.dll
Info Created - bin\DotNetNuke.Events.WebControls.dll
Info Assembly registered - bin\DotNetNuke.Modules.Events.dll
Info Creating backup of previous version - bin\DotNetNuke.Modules.Events.dll
Info Created - bin\DotNetNuke.Modules.Events.dll
Info Assembly registered - bin\DotNetNuke.Modules.Events.SqlDataProvider.dll
Info Creating backup of previous version - bin\DotNetNuke.Modules.Events.SqlDataProvider.dll
Info Created - bin\DotNetNuke.Modules.Events.SqlDataProvider.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - EditEvents.ascx
Info Created - EditEvents.ascx
Info Creating backup of previous version - EventDay.ascx
Info Created - EventDay.ascx
Info Creating backup of previous version - EventDetails.ascx
Info Created - EventDetails.ascx
Info Creating backup of previous version - EventEditCategories.ascx
Info Created - EventEditCategories.ascx
Info Creating backup of previous version - EventEditLocations.ascx
Info Created - EventEditLocations.ascx
Info Created - EventIcons.ascx
Info Creating backup of previous version - EventIPN.aspx
Info Created - EventIPN.aspx
Info Creating backup of previous version - EventList.ascx
Info Created - EventList.ascx
Info Creating backup of previous version - EventModerate.ascx
Info Created - EventModerate.ascx
Info Creating backup of previous version - EventMonth.ascx
Info Created - EventMonth.ascx
Info Creating backup of previous version - EventMyEnrollments.ascx
Info Created - EventMyEnrollments.ascx
Info Creating backup of previous version - EventPPEnroll.ascx
Info Created - EventPPEnroll.ascx
Info Created - EventRSS.aspx
Info Creating backup of previous version - Events.ascx
Info Created - Events.ascx
Info Created - EventTemplateHelp.ascx
Info Creating backup of previous version - EventTZUpdate.ascx
Info Created - EventTZUpdate.ascx
Info Creating backup of previous version - EventVCal.aspx
Info Created - EventVCal.aspx
Info Creating backup of previous version - EventWeek.ascx
Info Created - EventWeek.ascx
Info Creating backup of previous version - Module.css
Info Created - Module.css
Info Creating backup of previous version - SelectCategory.ascx
Info Created - SelectCategory.ascx
Info Creating backup of previous version - Settings.ascx
Info Created - Settings.ascx
Info Creating backup of previous version - Tooltip.js
Info Created - Tooltip.js
Info Created - Validation.js
Info Creating backup of previous version - App_LocalResources\EditEvents.ascx.resx
Info Created - App_LocalResources\EditEvents.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventDay.ascx.resx
Info Created - App_LocalResources\EventDay.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventDetails.ascx.resx
Info Created - App_LocalResources\EventDetails.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventEditCategories.ascx.resx
Info Created - App_LocalResources\EventEditCategories.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventEditLocations.ascx.resx
Info Created - App_LocalResources\EventEditLocations.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventList.ascx.resx
Info Created - App_LocalResources\EventList.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventModerate.ascx.resx
Info Created - App_LocalResources\EventModerate.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventMonth.ascx.resx
Info Created - App_LocalResources\EventMonth.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventMyEnrollments.ascx.resx
Info Created - App_LocalResources\EventMyEnrollments.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventPPEnroll.ascx.resx
Info Created - App_LocalResources\EventPPEnroll.ascx.resx
Info Creating backup of previous version - App_LocalResources\Events.ascx.resx
Info Created - App_LocalResources\Events.ascx.resx
Info Created - App_LocalResources\EventTemplateHelp.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventTZUpdate.ascx.resx
Info Created - App_LocalResources\EventTZUpdate.ascx.resx
Info Creating backup of previous version - App_LocalResources\EventWeek.ascx.resx
Info Created - App_LocalResources\EventWeek.ascx.resx
Info Creating backup of previous version - App_LocalResources\SelectCategory.ascx.resx
Info Created - App_LocalResources\SelectCategory.ascx.resx
Info Creating backup of previous version - App_LocalResources\Settings.ascx.resx
Info Created - App_LocalResources\Settings.ascx.resx
Info Creating backup of previous version - App_LocalResources\SharedResources.resx
Info Created - App_LocalResources\SharedResources.resx
Info Folder Created - D:\Sites\DotNetNuke\website\DesktopModules\Events\Images
Info Created - Images\bell.gif
Info Created - Images\bgcolor.gif
Info Created - Images\cal-add.gif
Info Created - Images\cal-bar.gif
Info Created - Images\cal-enroll.gif
Info Created - Images\cal-list.gif
Info Created - Images\cal-month.gif
Info Created - Images\cal-week.gif
Info Created - Images\dn-curve.gif
Info Created - Images\enroll.gif
Info Created - Images\EnrollFull.gif
Info Created - Images\false.gif
Info Created - Images\HighPrio.gif
Info Created - Images\LowPrio.gif
Info Created - Images\moderate.gif
Info Created - Images\navlink.gif
Info Created - Images\paypal.gif
Info Created - Images\rec.gif
Info Created - Images\rss.gif
Info Created - Images\SmallCalendar.gif
Info Created - Images\true.gif
Info Created - Images\vCalendar.gif
Info Created - Images\view.gif
Info Creating backup of previous version - Themes\Default\Default.css
Info Created - Themes\Default\Default.css
Info Creating backup of previous version - Themes\Default\gradient_Default.jpg
Info Created - Themes\Default\gradient_Default.jpg
Info Creating backup of previous version - Themes\Events\Events.css
Info Created - Themes\Events\Events.css
Info Creating backup of previous version - Themes\FixedBlue\FixedBlue.css
Info Created - Themes\FixedBlue\FixedBlue.css
Info Creating backup of previous version - Themes\FixedBlue\gradient_LtBlue.jpg
Info Created - Themes\FixedBlue\gradient_LtBlue.jpg
Info Creating backup of previous version - Themes\Gray\gradient_Gray.jpg
Info Created - Themes\Gray\gradient_Gray.jpg
Info Creating backup of previous version - Themes\Gray\Gray.css
Info Created - Themes\Gray\Gray.css
Info Creating backup of previous version - Themes\Small\gradient_Small.jpg
Info Created - Themes\Small\gradient_Small.jpg
Info Creating backup of previous version - Themes\Small\Small.css
Info Created - Themes\Small\Small.css
Info Component installed successfully - File
Info Installation committed
Info Installation successful. - DNN_Events
Info Deleted temporary install folder
EndJob Installation successful.
Event Log entry on citical error:
AssemblyVersion: 5.1.4
PortalID: 2
PortalName: City of Manchester NH Official Web Site
UserID: -1
UserName:
ActiveTabID: 936
ActiveTabName: Recreational Calendar
RawURL: /website/CityCalendars/RecreationalCalendar/tabid/936/Default.aspx
AbsoluteURL: /website/Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: dcf2a48c-701f-40b0-97fa-bb5db0af1c7b
InnerException: Argument 'Length' must be greater or equal to zero.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.VisualBasic.Strings.Left
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Argument 'Length' must be greater or equal to zero. ---> System.ArgumentException: Argument 'Length' must be greater or equal to zero. at Microsoft.VisualBasic.Strings.Left(String str, Int32 Length) at DotNetNuke.Modules.Events.EventRecurMasterController.DecomposeRRULE(String strRRULE, DateTime DTStart) at DotNetNuke.Modules.Events.TokenReplaceControllerClass.TokenReplaceEvent(EventInfo eventInfo, String sourceText, Dictionary`2 dict, EventSignupsInfo eventSignupsInfo, Boolean addsubmodulename) at DotNetNuke.Modules.Events.EventMonth.EventCalendar_DayRender(Object sender, DayRenderEventArgs e) at System.Web.UI.WebControls.Calendar.OnDayRender(TableCell cell, CalendarDay day) at DotNetNuke.Events.WebControls.DNNCalendar.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.UpdatePanel.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.UpdatePanel.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) at DotNetNuke.UI.Modules.ModuleHost.RenderContents(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.portals__default_containers_bodycontainer_nofooter_bodycontainer_nofooter_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.Htmlform.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.HtmlControls.Htmlform.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.HtmlControls.Htmlform.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.default_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at DotNetNuke.Framework.PageBase.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: WY