server error

Help Support SkidSteer Forum:

skidsteer.ca

skidsteer.ca

Well-known member
Joined
Jan 20, 2006
Messages
3,853
This occured while trying to acess the second page or posts using the bottom link mark next page on the new loader thread in the NH forum

Server Error in '/' Application.

Input string was not in a correct format.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.FormatException: Input string was not in a correct format.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Code: 
[FormatException: Input string was not in a correct format.]
   System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +0
   AspNetForums.Controls.Paging.PrevNext_Click(Object sender, EventArgs e) +58
   System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
   System.Web.UI.Page.ProcessRequestMain() +1292

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 [/FONT]
 
OP
OP
skidsteer.ca

skidsteer.ca

Well-known member
Joined
Jan 20, 2006
Messages
3,853
owensge said:
Thanks, I'll take a look at it...
Click to expand...
Here is another one.

Server Error in '/' Application.

Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Code: 
[Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The statement has been terminated.]
   AspNetForums.Data.SqlDataProvider.AddPost(Post postToAdd, String username) +1019
   AspNetForums.Posts.AddPost(Post postToAdd) +101
   AspNetForums.Controls.CreateEditPost.PostButton_Click(Object sender, EventArgs e) +1567
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1292
[/FONT]
[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300[/FONT]
 
owensge

owensge

Well-known member
Joined
Oct 17, 2003
Messages
326
skidsteer.ca said:
Here is another one.

Server Error in '/' Application.

Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.
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.Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.

Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Stack Trace:



[Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The statement has been terminated.]
AspNetForums.Data.SqlDataProvider.AddPost(Post postToAdd, String username) +1019
AspNetForums.Posts.AddPost(Post postToAdd) +101
AspNetForums.Controls.CreateEditPost.PostButton_Click(Object sender, EventArgs e) +1567
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292






Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
Click to expand...
Thanks Ken.. Were you trying to Pin? Or reply to a Pin?
 
OP
OP
skidsteer.ca

skidsteer.ca

Well-known member
Joined
Jan 20, 2006
Messages
3,853
owensge said:
Thanks :)
Click to expand...
Here is another one I got when trying to follow a link I just fixed in this thread.
DIY stump bucket
This is the link.
Ken
http://www.skidsteerforum.com/DesktopDefault.aspx?tabid=52&gallerypage=1¤titem=3&path=Root%20bucket%202

Server Error in '/' Application.

Input string was not in a correct format.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.FormatException: Input string was not in a correct format.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Code: 
[FormatException: Input string was not in a correct format.]
   Microsoft.VisualBasic.CompilerServices.DoubleType.Parse(String Value, NumberFormatInfo NumberFormat) +195
   Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String Value) +97

[InvalidCastException: Cast from string "1¤titem=3" to type 'Integer' is not valid.]
   Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String Value) +212
   DotNetNuke.TTT_GalleryDispatch.Page_Load(Object sender, EventArgs e) in N:\BobcatDNN\DesktopModules\TTTGallery\TTT_GalleryDispatch.ascx.vb:47
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Page.ProcessRequestMain() +750

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 [/FONT]
 
owensge

owensge

Well-known member
Joined
Oct 17, 2003
Messages
326
skidsteer.ca said:
Here is another one I got when trying to follow a link I just fixed in this thread.
DIY stump bucket
This is the link.
Ken
http://www.skidsteerforum.com/DesktopDefault.aspx?tabid=52&gallerypage=1¤titem=3&path=Root%20bucket%202

Server Error in '/' Application.

Input string was not in a correct format.
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.FormatException: Input string was not in a correct format.

Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Stack Trace:



[FormatException: Input string was not in a correct format.]
Microsoft.VisualBasic.CompilerServices.DoubleType.Parse(String Value, NumberFormatInfo NumberFormat) +195
Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String Value) +97

[InvalidCastException: Cast from string "1¤titem=3" to type 'Integer' is not valid.]
Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String Value) +212
DotNetNuke.TTT_GalleryDispatch.Page_Load(Object sender, EventArgs e) in N:\BobcatDNN\DesktopModules\TTTGallery\TTT_GalleryDispatch.ascx.vb:47
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +750





Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
Click to expand...
Thanks Ken... That url looks funky. Here's the one I replaced it with: http://www.skidsteerforum.com/DesktopDefault.aspx?tabid=52&gallerypage=0&path=Root%20bucket%202
How did that: ¤titem= get in there? That's what caused the problem...
 
OP
OP
skidsteer.ca

skidsteer.ca

Well-known member
Joined
Jan 20, 2006
Messages
3,853
owensge said:
Thanks Ken... That url looks funky. Here's the one I replaced it with: http://www.skidsteerforum.com/DesktopDefault.aspx?tabid=52&gallerypage=0&path=Root%20bucket%202
How did that: ¤titem= get in there? That's what caused the problem...
Click to expand...
I don't know, I only worked on the ends of it.
Ken
 
OP
OP
skidsteer.ca

skidsteer.ca

Well-known member
Joined
Jan 20, 2006
Messages
3,853
sterlclan said:
I think that link was mine....don't know where the funny symbol came from I copy and pasted it with firefox thanks Jeff
Click to expand...
Here is another one. I got this twice in a row. I save the second post attempt to a email. I can forward to you if you send me yours again. The only thing unusually about it was i used 4 or 5 spaces to separate 2 numbers I did not want to apear as one.

Ken at skidsteer.ca

Server Error in '/' Application.

Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Code: 
[Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The statement has been terminated.]
   AspNetForums.Data.SqlDataProvider.AddPost(Post postToAdd, String username) +1019
   AspNetForums.Posts.AddPost(Post postToAdd) +101
   AspNetForums.Controls.CreateEditPost.PostButton_Click(Object sender, EventArgs e) +1566
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1292
[/FONT]
 
owensge

owensge

Well-known member
Joined
Oct 17, 2003
Messages
326
skidsteer.ca said:
Here is another one. I got this twice in a row. I save the second post attempt to a email. I can forward to you if you send me yours again. The only thing unusually about it was i used 4 or 5 spaces to separate 2 numbers I did not want to apear as one.

Ken at skidsteer.ca

Server Error in '/' Application.

Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.
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.Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.

Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Stack Trace:



[Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The statement has been terminated.]
AspNetForums.Data.SqlDataProvider.AddPost(Post postToAdd, String username) +1019
AspNetForums.Posts.AddPost(Post postToAdd) +101
AspNetForums.Controls.CreateEditPost.PostButton_Click(Object sender, EventArgs e) +1566
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
Click to expand...
Thanks again Ken... I'll take a look at that right now...
 
T

Tazza

Moderator
Staff member
Joined
Dec 7, 2004
Messages
16,835
owensge said:
Thanks again Ken... I'll take a look at that right now...
Click to expand...

Server Error in '/' Application.

Object cannot be cast from DBNull to other types.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.InvalidCastException: Object cannot be cast from DBNull to other types.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Code: 
[InvalidCastException: Object cannot be cast from DBNull to other types.]
   System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) +48
   System.Convert.ToInt32(Object value) +36
   AspNetForums.Data.SqlDataProvider.PopulateThreadFromSqlDataReader(SqlDataReader reader) +560
   AspNetForums.Data.SqlDataProvider.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +657
   AspNetForums.Threads.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +483
   AspNetForums.Controls.ThreadView.OnPreRender(EventArgs e) +390
   System.Web.UI.Control.PreRenderRecursiveInternal() +62
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Page.ProcessRequestMain() +1499

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

This was when i tried to access the Bobcat/general questions area.[/FONT]
 
mllud

mllud

Well-known member
Joined
Jun 29, 2007
Messages
635
Tazza said:
Server Error in '/' Application.

Object cannot be cast from DBNull to other types.
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.InvalidCastException: Object cannot be cast from DBNull to other types.

Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Stack Trace:



[InvalidCastException: Object cannot be cast from DBNull to other types.]
System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) +48
System.Convert.ToInt32(Object value) +36
AspNetForums.Data.SqlDataProvider.PopulateThreadFromSqlDataReader(SqlDataReader reader) +560
AspNetForums.Data.SqlDataProvider.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +657
AspNetForums.Threads.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +483
AspNetForums.Controls.ThreadView.OnPreRender(EventArgs e) +390
System.Web.UI.Control.PreRenderRecursiveInternal() +62
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1499





Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

This was when i tried to access the Bobcat/general questions area.
Click to expand...
I kept getting this when trying to open a thread. It was under Bobcat [general questions] posted at 7;40 pm on 5/12/08

Server Error in '/' Application.

Object cannot be cast from DBNull to other types.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.InvalidCastException: Object cannot be cast from DBNull to other types.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Code: 
[InvalidCastException: Object cannot be cast from DBNull to other types.]
   System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) +48
   System.Convert.ToInt32(Object value) +36
   AspNetForums.Data.SqlDataProvider.PopulateThreadFromSqlDataReader(SqlDataReader reader) +560
   AspNetForums.Data.SqlDataProvider.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +657
   AspNetForums.Threads.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +483
   AspNetForums.Controls.ThreadView.OnPreRender(EventArgs e) +390
   System.Web.UI.Control.PreRenderRecursiveInternal() +62
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Page.ProcessRequestMain() +1499

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 [/FONT]
 
OP
OP
skidsteer.ca

skidsteer.ca

Well-known member
Joined
Jan 20, 2006
Messages
3,853
mllud said:
I kept getting this when trying to open a thread. It was under Bobcat [general questions] posted at 7;40 pm on 5/12/08
Server Error in '/' Application.

Object cannot be cast from DBNull to other types.
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.InvalidCastException: Object cannot be cast from DBNull to other types.

Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Stack Trace:



[InvalidCastException: Object cannot be cast from DBNull to other types.]
System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) +48
System.Convert.ToInt32(Object value) +36
AspNetForums.Data.SqlDataProvider.PopulateThreadFromSqlDataReader(SqlDataReader reader) +560
AspNetForums.Data.SqlDataProvider.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +657
AspNetForums.Threads.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +483
AspNetForums.Controls.ThreadView.OnPreRender(EventArgs e) +390
System.Web.UI.Control.PreRenderRecursiveInternal() +62
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1499





Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
Click to expand...
While trying tomove the 1st Myths post from Suggestions to Myths

Server Error in '/' Application.

Object cannot be cast from DBNull to other types.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.InvalidCastException: Object cannot be cast from DBNull to other types.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Code: 
[InvalidCastException: Object cannot be cast from DBNull to other types.]
   System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) +48
   System.Convert.ToInt32(Object value) +36
   AspNetForums.Data.SqlDataProvider.PopulateThreadFromSqlDataReader(SqlDataReader reader) +560
   AspNetForums.Data.SqlDataProvider.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +657
   AspNetForums.Threads.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +483
   AspNetForums.Controls.WhereAmI.RenderPostsMenu() +92
   AspNetForums.Controls.WhereAmI.InitializeSkin(Control skin) +1423
   AspNetForums.Controls.SkinnedForumWebControl.CreateChildControls() +25
   System.Web.UI.Control.EnsureChildControls() +100
   System.Web.UI.Control.PreRenderRecursiveInternal() +38
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Page.ProcessRequestMain() +1499
[/FONT]
Ken
 
mllud

mllud

Well-known member
Joined
Jun 29, 2007
Messages
635
skidsteer.ca said:
While trying tomove the 1st Myths post from Suggestions to Myths

Server Error in '/' Application.

Object cannot be cast from DBNull to other types.
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.InvalidCastException: Object cannot be cast from DBNull to other types.

Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Stack Trace:



[InvalidCastException: Object cannot be cast from DBNull to other types.]
System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) +48
System.Convert.ToInt32(Object value) +36
AspNetForums.Data.SqlDataProvider.PopulateThreadFromSqlDataReader(SqlDataReader reader) +560
AspNetForums.Data.SqlDataProvider.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +657
AspNetForums.Threads.GetAllThreads(Int32 forumID, Int32 pageSize, Int32 pageIndex, DateTime endDate, String username, Boolean unreadThreadsOnly) +483
AspNetForums.Controls.WhereAmI.RenderPostsMenu() +92
AspNetForums.Controls.WhereAmI.InitializeSkin(Control skin) +1423
AspNetForums.Controls.SkinnedForumWebControl.CreateChildControls() +25
System.Web.UI.Control.EnsureChildControls() +100
System.Web.UI.Control.PreRenderRecursiveInternal() +38
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1499



Ken
Click to expand...
Im still getting that error on two of the babcat forums. Bobcat [General Questions]and Bobcat[General Repairs]. Mike
 
owensge

owensge

Well-known member
Joined
Oct 17, 2003
Messages
326
mllud said:
Im still getting that error on two of the babcat forums. Bobcat [General Questions]and Bobcat[General Repairs]. Mike
Click to expand...
All the time or randomly? Never mind. Looks like there's a problem. I'm going to try a reboot and see if that clears things up...
 
T

Tazza

Moderator
Staff member
Joined
Dec 7, 2004
Messages
16,835
owensge said:
All the time or randomly? Never mind. Looks like there's a problem. I'm going to try a reboot and see if that clears things up...
Click to expand...
Druing a reply to http://www.skidsteerforum.com/DesktopDefault.aspx?tabid=54&frmView=ShowPost&PostID=15988


Server Error in '/' Application.

Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Code: 
[Exception: Cannot insert the value NULL into column 'PinnedDate', table 'BobcatDNN.dbo.AdverFRM_Posts'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'TotalPosts', table 'BobcatDNN.dbo.AdverFRM_Forums'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The statement has been terminated.]
   AspNetForums.Data.SqlDataProvider.AddPost(Post postToAdd, String username) +1019
   AspNetForums.Posts.AddPost(Post postToAdd) +101
   AspNetForums.Controls.CreateEditPost.PostButton_Click(Object sender, EventArgs e) +1568
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1292
[/FONT]
[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300[/FONT]
 

Similar threads

skidsteerforum
April 5th, Tuesday - server maintenance
Replies
0
Views
520
skidsteerforum
skidsteerforum
Gazza
Upload error
Replies
3
Views
1K
owensge
owensge
G
server error
Replies
4
Views
1K
owensge
owensge
G
server error
Replies
0
Views
1K
glenbell
G

Latest posts

Top