It's when I run it. Install seemed to be ok, I have not looked at the install logs in details but there was no red. Now, when I want to create an event, I get this error. Of course, my first thought was : we're after the 12th of the month, looks like a MM/DD/AAAA or DD/MM/AAAA problem. So I tried to insert an event on 1/2/2006, or 2/2/2006. Same error. I tried to set my user language as english.  Same. The default  dates in the begin and end date and time text boxes are : 1/3/2006  9pm and 9:30pm. I just confirm that. Error. The time zone is UTC -8. This is not my time zone (we're on UTC+1 here). The default language of the SQL database is french. The web.config is fr-FR and the website default is french.

Here is the full error message :

 Erreur: Editer un événement inconnue.
DotNetNuke.Services.Exceptions.ModuleLoadException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Calendar.Data.SqlDataProvider.CalendarSave(Int32 PortalID, Int32 EventID, Int32 ModuleID, DateTime EventDateBegin, DateTime EventDateEnd, DateTime EventTimeBegin, Int32 Duration, String EventName, String EventDesc, Int32 Importance, String CreatedBy, String CreatorID, Int32 Every, String Period, String RepeatType, String Notify, Boolean Approved, Boolean Signups, Int32 MaxEnrollment, String EnrollRoleID, Double EnrollFee, String EnrollType, String PayPalAccount, String PayPalPassword, Boolean Cancelled, String ImageURL, String ImageType, Int32 ImageWidth, Int32 ImageHeight, Boolean ImageDisplay, Int32 Location, String LocationName, String MapURL, Int32 Category, String CategoryName, String Color, String Reminder, Int32 TimezoneOffset, Boolean SendReminder, Int32 ReminderTime, String ReminderTimeMeasurement, String ReminderFrom) at DotNetNuke.Modules.Calendar.Business.CalendarController.CalendarSave(CalendarInfo objCalendar) at DotNetNuke.Modules.Calendar.CalendarEdit.updateButton_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

Alan,

I've set my sql database to english, my web.config to en-US and my website default to english ... same error.

Now I think it has someting to do with the local language preference on my desktop. So I set my windows preference to english, and I get a different error : an error has occured, edit event unknown

Now, here is the strange thing ( I'm thinking of something like a double conversion ) :

- when I'm french in my windows desktop preference, the default date and time in avcalendar display like us english (MM/DD/AAAA   xx:yy am/pm )

when I'm US in my windows desktop preference, they appear ... the european way (DD/MM/AAAA  - 24h times)

Please note that this is EXACTLY the OPPOSITE to what you would expect.

I have opened my dev site for public tests on avcalendar, it here : www.regordane.fr first menu option calendar.

Would you please insert an event there from your desktop ?

Thanks

Benoit Sarton

www.dotnetnuke.fr

Alan, I would not dare bother you if I had the least doubt that the problem could on my side, or related to french only.  

I've just spent 1 hour on the phone with David, my co-admin of dotnetnuke.fr

He is on a dev site under DNN 4.0.2 and AvC 3.20.0 and gets the same problem. We have been suspecting  a problem with the javascript date picker. If you do not type a title and change the start date, you get a javascript error when the script copies the start date into the end date. I do not know if this is related to the insert problem.

Error is line 230, car 3, 'null' has a Null value or is not an object

Code: 0 

Would you publish an intermediate version with a text box instead of the date/time picker ? I feel like it would help everybody find out what's wrong there.

Thanks

Benoit Sarton