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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsSetup of DNN events 6.1.1 abortsSetup of DNN events 6.1.1 aborts
Previous
 
Next
New Post
10/12/2013 9:21 AM
 
My config is  DNN 0.2.06 with Framework  asp 3.x 

 the events DNN_Events_06.01.01 aborts installation with a log message when installing

The start of the message i5.0  is  :

02.00.SqlDataProviderSystem.Data.SqlClient.SqlException: Invalid column name 'RecurMasterID'. Invalid column name 'CreatedByID'. Invalid column name 'DetailPage'. Invalid column name 'DetailNewWin'. Invalid column name 'DetailURL' ............

and invalid path\Install\Temp\ranmj3cn\DNN_Events.dnn6'

Thanks for help

 
New Post
10/12/2013 1:43 PM
 
This looks like you have a failed install prior to this one, which has left the database in an inconsistent state. This can happen if you click 'Install' (or whatever the button is) in the installation dialogue twice because the dialogue gives no feedback that it is doing anything...

Download the installation pack, then unzip it. Find 'Uninstall.SqlDataProvider' in the Installation folder, copy the contents of this into the Host/SQL dialogue, click run as script and Execute (or similar names). Then re-install. Ensure you click the final install button only once.

Report back if this doesn't work.

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
10/13/2013 7:59 AM
 

That's true a previous install, i'l follow your advice and post the result.

Thanks

 
New Post
10/13/2013 10:35 AM
 
I assume you had no data in the previous install...

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
10/13/2013 11:33 AM
 

I did the actions

1. Uninstall.SqlDataProvider'  SQL Script  was successful
2. Checked no Install repertory winthin the DesktopModulesL
3. Checked  No  events entry within the extensions list
4. Module Loading ok  Until Agee the licence
Then Next and > Loading failure Hera after  log in french (Sorry)

Etape en cours :               Début de l'installation

info        Début de l'installation - DNN_Events

info        Début de l'installation - Script

info        Début de traitement SQL

info        Fichier créé - Installation\Install.05.02.04.SqlDataProvider

info        Traitement en coursInstall.05.02.04.SqlDataProvider

info        Début de traitement de script Sql : Install.05.02.04.SqlDataProvider

Echec    Erreur pendant la génération SQL : System.Data.SqlClient.SqlException: There is already an object named 'EventsSave' in the database. à System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) à System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) à System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) à System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) à System.Data.SqlClient.SqlCommand.ExecuteNonQuery() à DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) à DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* EventsSave */ CREATE PROCEDURE usr34036e458772e9e131066f387c23aabc.[EventsSave] ( @PortalID INT , @EventID INT , @RecurMasterID INT , @ModuleID INT , @EventTimeBegin DATETIME , @Duration INT , @EventName NVARCHAR(100) , @EventDesc NTEXT , @Importance INT , @CreatedByID INT , @Notify NVARCHAR(2048) , @Approved BIT , @Signups BIT , @MaxEnrollment INT , @EnrollRoleID INT , @EnrollFee MONEY , @EnrollType VARCHAR(10) , @PayPalAccount NVARCHAR(100) , @Cancelled BIT , @DetailPage BIT , @DetailNewWin BIT , @DetailURL NVARCHAR(100) , @ImageURL NVARCHAR(100) , @ImageType VARCHAR(1) , @ImageWidth INT , @ImageHeight INT , @ImageDisplay BIT , @Location INT , @Category INT , @Reminder NVARCHAR(2048) , @TimezoneOffset INT , @SendReminder BIT , @ReminderTime INT , @ReminderTimeMeasurement VARCHAR(2) , @ReminderFrom NVARCHAR(100) , @SearchSubmitted BIT , @CustomField1 NVARCHAR(100) , @CustomField2 NVARCHAR(100) , @EnrollListView BIT , @DisplayEndDate BIT , @AllDayEvent BIT , @OwnerID INT , @LastUpdatedID INT , @OriginalDateBegin DATETIME , @NewEventEmailSent BIT , @SaveOnly BIT ) AS SET DATEFORMAT mdy IF @Location = -1 SELECT @Location = NULL IF @Category = -1 SELECT @Category = NULL IF @EnrollRoleID = -1 SELECT @EnrollRoleID = NULL IF @ImageURL = N'' SELECT @ImageURL = NULL IF @ImageType = '' SELECT @ImageType = NULL IF @DetailURL = N'' SELECT @DetailURL = NULL IF @EventID = -1 OR @EventID IS NULL INSERT usr34036e458772e9e131066f387c23aabc.[Events] ( PortalID , RecurMasterID , ModuleID , EventTimeBegin , Duration , EventName , EventDesc , Importance , CreatedByID , Notify , Approved , Signups , MaxEnrollment , EnrollRoleID , EnrollFee , EnrollType , PayPalAccount , Cancelled , DetailPage , DetailNewWin , DetailURL , ImageURL , ImageType , ImageWidth , ImageHeight , ImageDisplay , Location , Category , Reminder , TimezoneOffset , SendReminder , ReminderTime , ReminderTimeMeasurement , ReminderFrom , SearchSubmitted , CustomField1 , CustomField2 , EnrollListView , DisplayEndDate , AllDayEvent , OwnerID , LastUpdatedAt , LastUpdatedID , OriginalDateBegin , NewEventEmailSent ) VALUES ( @PortalID , @RecurMasterID , @ModuleID , @EventTimeBegin , @Duration , @EventName , @EventDesc , @Importance , @CreatedByID , @Notify , @Approved , @Signups , @MaxEnrollment , @EnrollRoleID , @EnrollFee , @EnrollType , @PayPalAccount , @Cancelled , @DetailPage , @DetailNewWin , @DetailURL , @ImageURL , @ImageType , @ImageWidth , @ImageHeight , @ImageDisplay , @Location , @Category , @Reminder , @TimezoneOffset , @SendReminder , @ReminderTime , @ReminderTimeMeasurement , @ReminderFrom , @SearchSubmitted , @CustomField1 , @CustomField2 , @EnrollListView , @DisplayEndDate , @AllDayEvent , @OwnerID , GETUTCDATE() , @LastUpdatedID , @OriginalDateBegin , @NewEventEmailSent ) ELSE UPDATE usr34036e458772e9e131066f387c23aabc.[Events] SET PortalID = @PortalID , RecurMasterID = @RecurMasterID , EventTimeBegin = @EventTimeBegin , Duration = @Duration , EventName = @EventName , EventDesc = @EventDesc , Importance = @Importance , Notify = @Notify , Approved = @Approved , Signups = @Signups , MaxEnrollment = @MaxEnrollment , EnrollRoleID = @EnrollRoleID , EnrollFee = @EnrollFee , EnrollType = @EnrollType , PayPalAccount = @PayPalAccount , Cancelled = @Cancelled , DetailPage = @DetailPage , DetailNewWin = @DetailNewWin , DetailURL = @DetailURL , ImageURL = @ImageURL , ImageType = @ImageType , ImageWidth = @ImageWidth , ImageHeight = @ImageHeight , ImageDisplay = @ImageDisplay , Location = @Location , Category = @Category , Reminder = @Reminder , TimezoneOffset = @TimezoneOffset , SendReminder = @SendReminder , ReminderTime = @ReminderTime , ReminderTimeMeasurement = @ReminderTimeMeasurement , ReminderFrom = @ReminderFrom , SearchSubmitted = @SearchSubmitted , CustomField1 = @CustomField1 , CustomField2 = @CustomField2 , EnrollListView = @EnrollListView , DisplayEndDate = @DisplayEndDate , AllDayEvent = @AllDayEvent , OwnerID = @OwnerID , LastUpdatedAt = GETUTCDATE() , LastUpdatedID = @LastUpdatedID , OriginalDateBegin = @OriginalDateBegin , NewEventEmailSent = @NewEventEmailSent WHERE EventID = @EventID AND ModuleID = @ModuleID IF @SaveOnly = 0 SELECT E.PortalID , EventID , E.RecurMasterID , E.ModuleID , E.EventDateBegin , E.EventDateEnd , E.EventTimeBegin , E.Duration , E.EventName , E.EventDesc , E.Importance , E.CreatedDate , CreatedBy = U.DisplayName , E.CreatedByID , E.Every , E.Period , E.RepeatType , E.Notify , E.Approved , E.Signups , E.MaxEnrollment , ( SELECT COUNT(*) FROM usr34036e458772e9e131066f387c23aabc.[EventsSignups] WHERE EventID = E.EventID AND E.Signups = 1 ) AS Enrolled , ( SELECT COUNT(*) FROM usr34036e458772e9e131066f387c23aabc.[Events] AS E2 WHERE E2.RecurMasterID = E.RecurMasterID AND E2.Cancelled = 0 AND E2.Approved = 1 ) AS NoOfRecurrences , ( SELECT MAX(EventDateBegin) FROM usr34036e458772e9e131066f387c23aabc.[Events] AS E2 WHERE E2.RecurMasterID = E.RecurMasterID AND E2.Cancelled = 0 AND E2.Approved = 1 ) AS LastRecurrence , E.EnrollRoleID , E.EnrollFee , E.EnrollType , E.PayPalAccount , E.Cancelled , E.DetailPage , E.DetailNewWin , E.DetailURL , E.ImageURL , E.ImageType , E.ImageWidth , E.ImageHeight , E.ImageDisplay , c.Location , c.LocationName , c.MapURL , b.Category , b.CategoryName , b.Color , b.FontColor , E.Reminder , E.TimezoneOffset , E.SendReminder , E.ReminderTime , E.ReminderTimeMeasurement , E.ReminderFrom , E.CustomField1 , E.CustomField2 , E.EnrollListView , E.DisplayEndDate , E.AllDayEvent , E.OwnerID , OwnerName = O.DisplayName , E.LastUpdatedAt , LastUpdatedBy = L.DisplayName , E.LastUpdatedID , r.RRULE , RMOwnerID = r.OwnerID , E.OriginalDateBegin , E.NewEventEmailSent FROM usr34036e458772e9e131066f387c23aabc.[Events] E INNER JOIN usr34036e458772e9e131066f387c23aabc.[EventsRecurMaster] AS r ON E.RecurMasterID = r.RecurMasterID LEFT OUTER JOIN usr34036e458772e9e131066f387c23aabc.[Users] U ON E.CreatedByID = U.UserID LEFT OUTER JOIN usr34036e458772e9e131066f387c23aabc.[Users] O ON E.OwnerID = O.UserID LEFT OUTER JOIN usr34036e458772e9e131066f387c23aabc.[Users] L ON E.LastUpdatedID = L.UserID LEFT JOIN usr34036e458772e9e131066f387c23aabc.[EventsCategory] b ON E.Category = b.Category LEFT JOIN usr34036e458772e9e131066f387c23aabc.[EventsLocation] c ON E.Location = c.Location WHERE EventID = SCOPE_IDENTITY() System.Data.SqlClient.SqlException: There is already an object named 'EventsSignupsMyEnrollments' in the database. à System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) à System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) à System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) à System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) à System.Data.SqlClient.SqlCommand.ExecuteNonQuery() à DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) à DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** EventsSignupsMyEnrollments **/ CREATE PROCEDURE usr34036e458772e9e131066f387c23aabc.EventsSignupsMyEnrollments ( @ModuleID INT , @UserID INT ) AS SET DATEFORMAT mdy SELECT DISTINCT s.EventID , s.SignupID , s.ModuleID , s.Userid , s.Approved , u.displayName AS UserName , u.Email , c.EventTimeBegin , DATEADD(mi, c.Duration, c.EventTimeBegin) AS EventTimeEnd , c.EventName , c.Importance , c.Approved AS EventApproved , c.MaxEnrollment , ( SELECT SUM(NoEnrolees) FROM usr34036e458772e9e131066f387c23aabc.EventsSignups WHERE EventID = c.EventID AND c.Signups = 1 ) AS Enrolled , PayPalStatus , PayPalReason , PayPalTransID , PayPalPayerID , PayPalPayerStatus , PayPalRecieverEmail , PayPalUserEmail , PayPalPayerEmail , PayPalFirstName , PayPalLastName , PayPalAddress , PayPalCity , PayPalState , PayPalZip , PayPalCountry , PayPalCurrency , PayPalPaymentDate , PayPalAmount , PayPalFee , c.TimeZoneOffset , NoEnrolees FROM usr34036e458772e9e131066f387c23aabc.EventsSignups s LEFT JOIN usr34036e458772e9e131066f387c23aabc.Users u ON s.UserID = u.UserID LEFT JOIN usr34036e458772e9e131066f387c23aabc.Events c ON s.EventID = c.EventID LEFT OUTER JOIN usr34036e458772e9e131066f387c23aabc.EventsMaster e ON s.ModuleID = e.SubEventID WHERE s.Userid = @UserID AND ( s.ModuleID = @ModuleID OR e.ModuleID = @ModuleID ) ORDER BY c.EventTimeBegin DESC

info        Exécution SQL terminée : fichier Install.05.02.04.SqlDataProvider

info        Fin de traitement SQL

Echec    Echec de l'installation - Script

info        Echec de l'installation - DNN_Events

info        Suppression du dossier d'installation temporaire

Etape Terminée :            Echec de l'installation

 

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsSetup of DNN events 6.1.1 abortsSetup of DNN events 6.1.1 aborts


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.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out