| Author |
 Topic Search  Topic Options
|
wavemaster 
Newbie
Joined: 30 January 2003
Location: United States
Status: Offline
Points: 24
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Error on Post.
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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)
|
|
|
|
wavemaster
Newbie
Joined: 30 January 2003
Location: United States
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
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
|
|
wavemaster
Newbie
Joined: 30 January 2003
Location: United States
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
wavemaster
Newbie
Joined: 30 January 2003
Location: United States
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
wavemaster
Newbie
Joined: 30 January 2003
Location: United States
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
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
|
|
wavemaster
Newbie
Joined: 30 January 2003
Location: United States
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
Posted: 30 November 2004 at 10:44am |
I got the errors sorted out.
Thanks for the pointers Borg
|
|
