Developer forum

Forum » Development » SqlDateTime overflow.

SqlDateTime overflow.


Reply
Hi,



I installed a local copy of dynamicweb on our test server using sql server 2005.



When trying to add a paragraph on any given page, I get this exception:



Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.



Exception Details:
System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.



Source Error:



[SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.]
System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +1382028
System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +46
System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) +1747
System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) +40
System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) +183
System.Data.Common.DbDataAdapter.Update(DataSet dataSet) +12
Dynamicweb.Core.Paragraph.Save() +276
Dynamicweb.Core.Paragraph.SaveWithAutoCreateOfPage() +48
Dynamicweb.Admin.Core.Paragraph.ParagraphEdit.SaveParagraph() +5634
Dynamicweb.Admin.Core.Paragraph.ParagraphEdit.Page_Load(Object sender, EventArgs e) +49
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061



I'm using the lastest source and sql files.



oh btw: could you please add the Files directory to the DefaultEmptyDataSQL.zip, it seems odd that you have to get the DefaultEmptyData.zip to get those.

Replies

 
Nicolai Høeg Pedersen
Reply

Hi


 


It seems like you have activated a not released module in Dynamicweb. In "module" table of Dynamicweb database find the module LanguageControl and disable it by setting field ModuleAccess to 0 or false. Reset IIS and login to Dynamicweb again. That should help.

 
Reply
I disabled all beta modules , since disabling just LanguageControl didn't do the trick, it works now, thanks



/Morten





NP wrote:



Hi




 




It seems like you have activated a not released module in Dynamicweb. In "module" table of Dynamicweb database find the module LanguageControl and disable it by setting field ModuleAccess to 0 or false. Reset IIS and login to Dynamicweb again. That should help.


 

You must be logged in to post in the forum