New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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 ForumsEventsEventsEvents Module 03.03.00 Beta UploadedEvents Module 03.03.00 Beta Uploaded
Previous
 
Next
New Post
2/7/2007 1:34 PM
 

Yup I'm getting the same problem when I actually click on "Enroll for this event":

Error: Event Detail is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.EventsSignupsSave' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.EventsSignupsSave' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Events.Data.SqlDataProvider.EventsSignupsSave(Int32 EventID, Int32 SignupID, Int32 ModuleID, Int32 UserID, Boolean Approved, String PayPalStatus, String PayPalReason, String PayPalTransID, String PayPalPayerID, String PayPalPayerStatus, String PayPalRecieverEmail, String PayPalUserEmail, String PayPalPayerEmail, String PayPalFirstName, String PayPalLastName, String PayPalAddress, String PayPalCity, String PayPalState, String PayPalZip, String PayPalCountry, String PayPalCurrency, DateTime PayPalPaymentDate, Double PayPalAmount, Double PayPalFee, DateTime EventTimeBegin, Int32 TimeZoneOffset) at DotNetNuke.Modules.Events.EventSignupsController.EventsSignupsSave(EventSignupsInfo objEventSignup) at DotNetNuke.Modules.Events.EventDetails.cmdSignup_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

but as you stated you forgot to include a stored proc in the package..so I'm definitely looking forward to the next update.  Thanks so much!!!

 
New Post
2/7/2007 10:00 PM
 
Ok everybody more dogfood...woof...I put up another version that fixes most of the issues you've been reporting.  You know were to get it...version 03.03.02.  Please post any issues here for others to learn from.  thanks.
 
New Post
2/7/2007 11:18 PM
 

Testing of the DNN_Events_03.03.02_Beta1 resulted in the following:

1) Error during installation:

StartJob Begin Sql execution
Info Executing 03.03.02.SqlDataProvider
StartJob Start Sql execution: 03.03.02.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'EventTimeBegin' in table 'dbo.DNN_EventsSignups' is specified more than once. 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) /* Database Tables */ ALTER TABLE dbo.DNN_EventsSignups ADD EventTimeBegin DateTime NULL System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'TimezoneOffset' in table 'dbo.DNN_EventsSignups' is specified more than once. 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) ALTER TABLE dbo.DNN_EventsSignups ADD TimezoneOffset int NULL 
EndJob End Sql execution: 03.03.02.SqlDataProvider file

2) I Appreciate the change to show the details view along with other modules using the page rather than admin skin. However, I would prefer to see the details displayed below the calendar (month) view rather than alone.  If displaying the details view alone, I would suggest adding a link to return from the details view to the calendar view as some users may not think to use their back button and since there will be no chance to select the calendar view from a menue in the module title bar if the calendar view has been set as the ONLY view in Module Settings.

3) I noticed this in the first two beta's but forgot to mention it: The .zip contains two image files with the same name - "gradient_LtBlue.jpg" which causes a file already exists error message during extraction. Surprisingly, there is no problem with this during install as the image file is simply extracted twice.

Otherwise, it looks like you're close to being ready for the release process!


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
2/8/2007 4:22 AM
 
favance wrote

For the Enrollment links to work:

1) Turn on Enrollments Checkbox on the Settings Page
2) Turn on Enrollments on the Event Edit and Set the Max # of Enrollments (also select Free or Paid)
3) After this Users (Registered Users) will see the Enrollment Link on the Detailed Event Page (only the first time the hit the page).  They can then select it and be enrolled (pending approval, if moderated)

 

Hi Alan,

Using the latest events beta (03.03.02) I cannot seem to get the enrollment link for a paid type of enrollment to work. If I select a free type of enrollment the enrollment hyperlink (Enroll for this Event?) displays fine but if it is a paid type of enrollment there is only red text (You are not enrolled for this event...press this link to enroll!) but no hyperlink to enrol is displayed on the page.  Is this a bug or am I missing something obvious?

Thanks,
Craig

 
New Post
2/8/2007 8:18 AM
 

This is my take on the issues you reported.

1) My guess this was not a clean install...This is a Beta Program.  My recommendation is not to install over top of an existing Beta.  This SQL Error will not occur if you install over an earlier Events Module or on a Clean DNN Install.  It's very difficut to maintain a install path for Beta over Beta over Beta....remember what we are testing.  Others will not install over the previous betas...they will be installing over a previous Events module or on a clean DNN install.  Please re-test in this mode and let me know if there are errors on the install.

2) I eliminated the Day List displaying under the Month View because others did not want.  I intend on creating a more detailed "Day View", similar to the "Week View", in the next few releases.  Eventually, the Views will be tied together, using a Tab Control (at the top of the page)...Currently, they display using the DNN Content Action below the View...All Views do not require a "Return" button by convention...I would consider addiing the return only to the Detailed Event View...convince me some more...anybody else have a take on this?

3) Thanks...I will eliminate the duplicate on the intall.

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsEvents Module 03.03.00 Beta UploadedEvents Module 03.03.00 Beta Uploaded


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.