Web Wiz Forums - Error on Post.

Print Page | Close Window

Error on Post.

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12758
Printed Date: 11 April 2026 at 2:47pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error on Post.

Posted By: wavemaster
Subject: Error on Post.
Date 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

Replies:

Posted By: WebWiz-Bruce
Date 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)

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wavemaster
Date 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

Posted By: wavemaster
Date 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

Posted By: WebWiz-Bruce
Date 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 the MS_sql_server_setup.asp file a find all the default values and place them in your database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wavemaster
Date 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.

Posted By: wavemaster
Date 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

Posted By: wavemaster
Date Posted: 30 November 2004 at 10:44am

I got the errors sorted out.

Thanks for the pointers Borg