Web Wiz Support and Community Forums : Error on Post. https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 14:52:54 +0000 Tue, 30 Nov 2004 10:44:18 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12758 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Error on Post. : I got the errors sorted out. Thanks...]]> https://forums.webwiz.net/error-on-post_topic12758_post70625.html#70625 Author: wavemaster
Subject: 12758
Posted: 30 November 2004 at 10:44am

I got the errors sorted out.
 
Thanks for the pointers Borg
]]> Tue, 30 Nov 2004 10:44:18 +0000 https://forums.webwiz.net/error-on-post_topic12758_post70625.html#70625 <![CDATA[Error on Post. : Well that was fun. I can now post...]]> https://forums.webwiz.net/error-on-post_topic12758_post70623.html#70623 Author: wavemaster
Subject: 12758
Posted: 30 November 2004 at 10:14am

 Well that was fun. I can now post reply etc.
 
I still get this error when trying to edit or create a forum in the forum admin. This one has been ongoing and a previous post never got any replies. Any Ideas on how to troubleshoot?
 
Thanks
 
Microsoft OLE DB Provider for SQL Server error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/sqlforum/forum/admin/forum_details.asp, line 161

]]> Tue, 30 Nov 2004 10:14:30 +0000 https://forums.webwiz.net/error-on-post_topic12758_post70623.html#70623 <![CDATA[Error on Post. : Thanks Borg. I&#039;m running...]]> https://forums.webwiz.net/error-on-post_topic12758_post70616.html#70616 Author: wavemaster
Subject: 12758
Posted: 30 November 2004 at 8:53am

Thanks Borg. I'm running into some other DB issues as well and I'm pretty sure this will be the case with most of the tables.
 
We hired someone off the board here to do the upgrade/upsize and it looks like I got a hit and run.
 
I just installed a new forum (that works perfect OOTB) to compare against.
 
Thanks again.
]]> Tue, 30 Nov 2004 08:53:57 +0000 https://forums.webwiz.net/error-on-post_topic12758_post70616.html#70616 <![CDATA[Error on Post. : It looks like none of the default...]]> https://forums.webwiz.net/error-on-post_topic12758_post70615.html#70615 Author: WebWiz-Bruce
Subject: 12758
Posted: 30 November 2004 at 8:38am

It looks like none of the default values where carried across when you moved across to MS SQL Server.

Probably the simplest thing is to go through theMS_sql_server_setup.asp file a find all the default values and placethem in your database.]]> Tue, 30 Nov 2004 08:38:33 +0000 https://forums.webwiz.net/error-on-post_topic12758_post70615.html#70615 <![CDATA[Error on Post. : Microsoft VBScript runtime error...]]> https://forums.webwiz.net/error-on-post_topic12758_post70614.html#70614 Author: wavemaster
Subject: 12758
Posted: 30 November 2004 at 8:30am

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CInt'

/sqlforum/forum/forum_topics.asp, line 384

This error now shows up when hitting the forum again after trying to post. As soon as you get the posting error, if you go back to the forum, the page bombs with the error above. This is the first time that just viewing the forum threw an error.
 
Thanks 
]]> Tue, 30 Nov 2004 08:30:32 +0000 https://forums.webwiz.net/error-on-post_topic12758_post70614.html#70614 <![CDATA[Error on Post. : Thanks Borg, I made that change...]]> https://forums.webwiz.net/error-on-post_topic12758_post70613.html#70613 Author: wavemaster
Subject: 12758
Posted: 30 November 2004 at 8:25am

Thanks Borg,
 
I made that change and now I get this error when trying to submit a post,

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CLng'

/sqlforum/forum/forum_posts.asp, line 310

]]> Tue, 30 Nov 2004 08:25:11 +0000 https://forums.webwiz.net/error-on-post_topic12758_post70613.html#70613 <![CDATA[Error on Post. : There maybe a default value on...]]> https://forums.webwiz.net/error-on-post_topic12758_post70589.html#70589 Author: WebWiz-Bruce
Subject: 12758
Posted: 30 November 2004 at 4:07am

There maybe a default value on this field, the field should be set to:-

[Locked] [bit] NOT NULL DEFAULT (0)
]]> Tue, 30 Nov 2004 04:07:20 +0000 https://forums.webwiz.net/error-on-post_topic12758_post70589.html#70589 <![CDATA[Error on Post. : When trying to post to a forum...]]> https://forums.webwiz.net/error-on-post_topic12758_post70583.html#70583 Author: wavemaster
Subject: 12758
Posted: 29 November 2004 at 10:43pm

When trying to post to a forum on our updated board (6.3 access to 7.9 SQL) we get the following error,
 
Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column 'Locked', table 'TonerForum.dbo.tblTopic'; column does not allow nulls. INSERT fails.

/sqlforum/forum/post_message.asp, line 614

Any ideas what causes this error?
 
Thanks
]]> Mon, 29 Nov 2004 22:43:53 +0000 https://forums.webwiz.net/error-on-post_topic12758_post70583.html#70583