Forums

 
  Support Forum  Modules  Engage: Events  Errors during Install
Previous Previous
 
Next Next
New Post 7/10/2009 8:28 AM
  brian ge
2 posts
No Ranking


Errors during Install 

I've got warnings and errors duing the install and uninstall of the Event module on to DNN 5.0.1

What I did was: install, got some SQL error and failed, then i got busy on something else and tried to install again about half day later, and somehow got the module installed with warnings. I then put it on a page but nothing shows up so i thought the install was messed up. so i decided to uninstall it and try install again.

during uninstall, i got the following error message:

Info

Start Sql execution: Uninstall.SqlDataProvider file

Failure

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Could not drop object 'dbo.Engage_Event' because it is referenced by a FOREIGN KEY constraint. 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) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[Engage_Event]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table dbo.[Engage_Event]

Info

End Sql execution: Uninstall.SqlDataProvider file

Info

Deleted - Uninstall.SqlDataProvider

Info

Folder Deleted - EngageEvents

Info

End Sql UnInstall

Info

Component uninstalled successfully - Script

Warning

Component Uninstalled with Warnings - Script

Info

Starting Component Uninstall - Cleanup

Info

Component uninstalled successfully - Cleanup

Info

Component Uninstall Successful - Cleanup

Info

Starting Component Uninstall - Cleanup

Info

Component uninstalled successfully - Cleanup

Info

Component Uninstall Successful - Cleanup

Info

Starting Component Uninstall - Module

Info

Module un-registered successfully - Engage: Events

Info

Component uninstalled successfully - Module

Info

Component Uninstall Successful - Module

Info

Starting Component Uninstall - Assembly

Info

Assembly unregistered - bin\EngageEvents.dll

Info

Deleted - bin\EngageEvents.dll

Info

Assembly unregistered - bin\Engage.Events.dll

Info

Deleted - bin\Engage.Events.dll

Info

Assembly unregistered - bin\Engage.Framework.dll

Info

Deleted - bin\Engage.Framework.dll

Info

Assembly unregistered - bin\Engage.Dnn.Framework.dll

Info

Deleted - bin\Engage.Dnn.Framework.dll

Info

Assembly unregistered - bin\Telerik.Web.UI.dll

Info

Deleted - bin\Telerik.Web.UI.dll

Info

Component uninstalled successfully - Assembly

Info

Component Uninstall Successful - Assembly

Warning

Uninstalled with Warnings - Engage: Events

EndJob

Uninstalled with Warnings

So the module uninstalled, although with warnings. I tried to installed it again. failed with the following messages.

Error loading files from temporary folder - see below

StartJob

Starting Installation

Info

Starting Installation - Engage: Events

Info

Starting Installation - ResourceFile

Info

Expanding Resource file

Info

Created - Actions/App_LocalResources/AddToCalendarAction.ascx.resx

Info

Created - Actions/App_LocalResources/ButtonAction.ascx.resx

Info

Created - Actions/App_LocalResources/CancelAction.ascx.resx

Info

Created - Actions/App_LocalResources/DeleteAction.ascx.resx

Info

Created - Actions/App_LocalResources/RegisterAction.ascx.resx

Info

Created - Actions/App_LocalResources/SortAction.ascx.resx

Info

Created - Actions/App_LocalResources/StatusFilterAction.ascx.resx

Info

Created - Actions/AddToCalendarAction.ascx

Info

Created - Actions/ButtonAction.ascx

Info

Created - Actions/CancelAction.ascx

Info

Created - Actions/DeleteAction.ascx

Info

Created - Actions/RegisterAction.ascx

Info

Created - Actions/SortAction.ascx

Info

Created - Actions/StatusFilterAction.ascx

Info

Created - Admin/App_LocalResources/LicenseError.ascx.resx

Info

Created - Admin/App_LocalResources/NotConfigured.ascx.resx

Info

Created - Admin/LicenseError.ascx

Info

Created - Admin/NotConfigured.ascx

Info

Created - App_LocalResources/ChooseDisplay.ascx.resx

Info

Created - App_LocalResources/EmailAFriend.ascx.resx

Info

Created - App_LocalResources/EmailEdit.ascx.resx

Info

Created - App_LocalResources/EventEdit.ascx.resx

Info

Created - App_LocalResources/ItemPreview.ascx.resx

Info

Created - App_LocalResources/PrinterFriendly.aspx.resx

Info

Created - App_LocalResources/Register.ascx.resx

Info

Created - App_LocalResources/Respond.ascx.resx

Info

Created - App_LocalResources/ResponseDetail.ascx.resx

Info

Created - App_LocalResources/ResponseSummaryDisplay.ascx.resx

Info

Created - App_LocalResources/Settings.ascx.resx

Info

Created - App_LocalResources/SharedResources.resx

Info

Created - App_LocalResources/UserContainer.ascx.resx

Info

Created - Controls/App_LocalResources/EditTypeDialog.aspx.resx

Info

Created - Controls/App_LocalResources/RecurrenceEditor.ascx.resx

Info

Created - Controls/App_LocalResources/TemplatePicker.ascx.resx

Info

Created - Controls/EditTypeDialog.aspx

Info

Created - Controls/ModuleMessage.ascx

Info

Created - Controls/RecurrenceEditor.ascx

Info

Created - Controls/TemplatePicker.ascx

Info

Created - Display/App_LocalResources/CalendarDisplayOptions.ascx.resx

Info

Created - Display/App_LocalResources/EventCalendar.ascx.resx

Info

Created - Display/App_LocalResources/EventListing.ascx.resx

Info

Created - Display/App_LocalResources/EventToolTip.ascx.resx

Info

Created - Display/App_LocalResources/RsvpDisplay.ascx.resx

Info

Created - Display/App_LocalResources/TemplateDisplayOptions.ascx.resx

Info

Created - Display/CalendarDisplayOptions.ascx

Info

Created - Display/EventCalendar.ascx

Info

Created - Display/EventDetail.ascx

Info

Created - Display/EventDisplay.ascx

Info

Created - Display/EventListingItem.ascx

Info

Created - Display/EventToolTip.ascx

Info

Created - Display/ResponseDisplay.ascx

Info

Created - Display/TemplateDisplayOptions.ascx

Info

Created - Images/add_event.gif

Info

Created - Images/add_event_disabled.gif

Info

Created - Images/approve.gif

Info

Created - Images/attending_icon.gif

Info

Created - Images/back.gif

Info

Created - Images/bt_create_account.gif

Info

Created - Images/bt_login.gif

Info

Created - Images/calendar.png

Info

Created - Images/cancel.gif

Info

Created - Images/cancel_disabled.gif

Info

Created - Images/cancel_go_home.gif

Info

Created - Images/choose_display.gif

Info

Created - Images/comments.gif

Info

Created - Images/createnew.gif

Info

Created - Images/CreateNewDisabled.gif

Info

Created - Images/create_another_event.gif

Info

Created - Images/delete.gif

Info

Created - Images/dn.gif

Info

Created - Images/edit.gif

Info

Created - Images/EmptyStar.png

Info

Created - Images/enrollment.gif

Info

Created - Images/enrollment_disabled.gif

Info

Created - Images/errorSmallIcon.png

Info

Created - Images/exit.gif

Info

Created - Images/export_to_csv.gif

Info

Created - Images/export_to_excel.gif

Info

Created - Images/fancy_closebox.png

Info

Created - Images/fancy_left.gif

Info

Created - Images/fancy_progress.png

Info

Created - Images/fancy_right.gif

Info

Created - Images/fancy_shadow_e.png

Info

Created - Images/fancy_shadow_n.png

Info

Created - Images/fancy_shadow_ne.png

Info

Created - Images/fancy_shadow_nw.png

Info

Created - Images/fancy_shadow_s.png

Info

Created - Images/fancy_shadow_se.png

Info

Created - Images/fancy_shadow_sw.png

Info

Created - Images/fancy_shadow_w.png

Info

Created - Images/fancy_title_left.png

Info

Created - Images/fancy_title_main.png

Info

Created - Images/fancy_title_right.png

Info

Created - Images/FilledStar.png

Info

Created - Images/greenBody.gif

Info

Created - Images/greenBt.gif

Info

Created - Images/greenTop.gif

Info

Created - Images/home.gif

Info

Created - Images/home_disabled.gif

Info

Created - Images/import.gif

Info

Created - Images/info.png

Info

Created - Images/lt.gif

Info

Created - Images/manage_events.gif

Info

Created - Images/manage_events_disabled.gif

Info

Created - Images/manage_RSVPs.gif

Info

Created - Images/manage_RSVPs_disabled.gif

Info

Created - Images/not_attending_icon.gif

Info

Created - Images/no_response_icon.gif

Info

Created - Images/progressbar_green.gif

Info

Created - Images/recurring_icon.gif

Info

Created - Images/redBody.gif

Info

Created - Images/redBt.gif

Info

Created - Images/redTop.gif

Info

Created - Images/responses.gif

Info

Created - Images/responses_disabled.gif

Info

Created - Images/rsRecurrence.gif

Info

Created - Images/rt.gif

Info

Created - Images/s.gif

Info

Created - Images/save.gif

Info

Created - Images/SavedStar.png

Info

Created - Images/save_create_new.gif

Info

Created - Images/save_create_new_disabled.gif

Info

Created - Images/save_disabled.gif

Info

Created - Images/settings.gif

Info

Created - Images/settingsdisabled.gif

Info

Created - Images/submit.gif

Info

Created - Images/successSmallIcon.png

Info

Created - Images/thumbnail.gif

Info

Created - Images/trash.gif

Info

Created - Images/up.gif

Info

Created - Images/update.gif

Info

Created - Images/updatedisabled.gif

Info

Created - Images/vcalendar.png

Info

Created - Navigation/App_LocalResources/GlobalNavigation.ascx.resx

Info

Created - Navigation/GlobalNavigation.ascx

Info

Created - Samples/AttendingReminder.htm

Info

Created - Samples/NoResponseReminder.htm

Info

Created - Samples/NotAttendingReminder.htm

Info

Created - Templates/Admin/ManageEvents/App_LocalResources/Template.resx

Info

Created - Templates/Admin/ManageEvents/default.jpg

Info

Created - Templates/Admin/ManageEvents/Item.Listing.html

Info

Created - Templates/Admin/ManageEvents/Manifest.xml

Info

Created - Templates/Admin/ManageEvents/Template.css

Info

Created - Templates/Default/App_LocalResources/Template.resx

Info

Created - Templates/Default/default.jpg

Info

Created - Templates/Default/Item.Listing.html

Info

Created - Templates/Default/Manifest.xml

Info

Created - Templates/Default/Template.css

Info

Created - Templates/Default-Single/App_LocalResources/Template.resx

Info

Created - Templates/Default-Single/Detail.Item.html

Info

Created - Templates/Default-Single/Manifest.xml

Info

Created - Templates/Default-Single/single-item-default.jpg

Info

Created - Templates/Default-Single/Template.css

Info

Created - Templates/Legacy-ListingAll/App_LocalResources/Template.resx

Info

Created - Templates/Legacy-ListingAll/Item.Listing.html

Info

Created - Templates/Legacy-ListingAll/legacy.jpg

Info

Created - Templates/Legacy-ListingAll/Manifest.xml

Info

Created - Templates/Legacy-ListingAll/Template.css

Info

Created - Templates/ListingShort/Item.ListingShort.html

Info

Created - Templates/ListingShort/Manifest.xml

Info

Created - Templates/ListingShort/short-listing.jpg

Info

Created - Templates/ListingShort/Template.css

Info

Created - Templates/MiniList/App_LocalResources/Template.resx

Info

Created - Templates/MiniList/Manifest.xml

Info

Created - Templates/MiniList/MiniList.htm

Info

Created - Templates/MiniList/minilist.jpg

Info

Created - Templates/MiniList/Template.css

Info

Created - Templates/Narrow/App_LocalResources/Template.resx

Info

Created - Templates/Narrow/Manifest.xml

Info

Created - Templates/Narrow/Narrow.htm

Info

Created - Templates/Narrow/narrow.jpg

Info

Created - Templates/Narrow/Template.css

Info

Created - Templates/Engage Events Templates.pdf

Info

Created - Templates/EngageManifest.xsd

Info

Created - util/App_LocalResources/BreadCrumb.cs.resx

Info

Created - util/Approval.ascx

Info

Created - ChooseDisplay.ascx

Info

Created - EmailAFriend.ascx

Info

Created - EmailEdit.ascx

Info

Created - EventEdit.ascx

Info

Created - MainContainer.ascx

Info

Created - Module.css

Info

Created - Register.ascx

Info

Created - Respond.ascx

Info

Created - RespondPage.aspx

Info

Created - ResponseDetail.ascx

Info

Created - ResponseSummaryDisplay.ascx

Info

Created - Settings.ascx

Info

Resource Files created

Info

Component installed successfully - ResourceFile

Info

Starting Installation - Script

Info

Begin Sql execution

Info

Created - 00.00.01.SqlDataProvider

Info

Executing 00.00.01.SqlDataProvider

Info

Start Sql execution: 00.00.01.SqlDataProvider file

Failure

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Insert Error: Column name or number of supplied values does not match table definition. 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) INSERT INTO dbo.[Schedule] VALUES ('Engage.Dnn.Events.Components.EmailScheduler', 5, 'm', 60, 's', 25, '', 0, 1, '', NULL)

Info

End Sql execution: 00.00.01.SqlDataProvider file

Info

Finished Sql execution

Failure

Installation Failed - Script

Info

Rolling back component install - ResourceFile

Failure

Exception - Could not find file 'C:\projects\Revolution\DotNetNuke\Install\Temp\2nw15xlfResources.zip'.

Info

Component rolled back successfully - ResourceFile

Info

Installation Failed - Engage: Events

Info

Deleted temporary install folder

EndJob

Installation Failed

 

 

Please help.

 

 
New Post 7/10/2009 9:02 AM
  Brian Dukes
480 posts
4th Level Poster


Re: Errors during Install 

We recently became aware of a breaking change in DNN 5.1 which causes this error that you are seeing.  We're working to get a new package out that works with this version of DNN.

In the meantime, it should be fairly simple to make the change yourself, if you'd prefer to get moving without waiting for us.

Unzip the install package for the module.  Find the 00.00.01.SqlDataProvider file.  Find the line with "[{objectQualifier}Schedule]" in it (around line 1229) and remove that line and the "GO" after it.  Then zip the files back up, and try to install it.

(Note that this will only work for a clean install, not an upgrade).

Hope that helps,


Brian Dukes
Engage Software
St. Louis, MO
314.966.4000

The leading provider of DotNetNuke support, training and custom module development.
 
New Post 7/10/2009 9:24 AM
  brian ge
2 posts
No Ranking


Re: Errors during Install 

I updated the following line in 00.00.01.sqlprovider file

 INSERT INTO dbo.[Schedule] VALUES ('Engage.Dnn.Events.Components.EmailScheduler', 5, 'm', 60, 's', 25, '', 0, 1, '', NULL , NULL, NULL, NULL, NULL)

now install runs just fine.

 

 
New Post 7/10/2009 9:35 AM
  Brian Dukes
480 posts
4th Level Poster


Re: Errors during Install 

Alright, I'm glad you got it working.


Brian Dukes
Engage Software
St. Louis, MO
314.966.4000

The leading provider of DotNetNuke support, training and custom module development.
 
New Post 7/10/2009 11:56 AM
  Brian Dukes
480 posts
4th Level Poster


Re: Errors during Install 

FYI, version 1.2.1 includes this fix, and is availalbe from the Downloads page on this site.

Hope it helps,


Brian Dukes
Engage Software
St. Louis, MO
314.966.4000

The leading provider of DotNetNuke support, training and custom module development.
 
Previous Previous
 
Next Next
  Support Forum  Modules  Engage: Events  Errors during Install

Purchase

Please click here to buy now.
Payment will be processed via credit card or PayPal.

Please click here to buy now.
Payment will be processed via credit card or PayPal.

Test Drive!

Want to find out how it works? Visit our demo site to see the modules in actions!

Want to find out how it works? Visit our demo site to see the modules in actions!

Subscribe

Sign up for our newsletter and get the latest product updates!

Sign up for our newsletter and get the latest product updates!

Online Support

Powered by DotNetNuke