Web Wiz Support and Community Forums : Error with posting after db restore https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 15:56:58 +0000 Fri, 07 Apr 2006 14:36:53 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19110 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Error with posting after db restore : One of my instructors suggested...]]> https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103578.html#103578 Author: iSec
Subject: 19110
Posted: 07 April 2006 at 2:36pm

One of my instructors suggested that I write an sql statemen: Select start from thread where thread_ID is null

but my hosting is down... I wonder if I can do it offline but I don't know how to connect the locally-hosted copy of my forum to the backup that i have in enterprise manager....
]]> Fri, 07 Apr 2006 14:36:53 +0000 https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103578.html#103578 <![CDATA[Error with posting after db restore : Because of the issue you had you...]]> https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103349.html#103349 Author: WebWiz-Bruce
Subject: 19110
Posted: 04 April 2006 at 11:07am

Because of the issue you had you may have some rows in the table that have a null value for Topic_ID, this will course the error as the field needs to be populated.

You may need to delete all rows that are not correctly setup.
]]> Tue, 04 Apr 2006 11:07:59 +0000 https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103349.html#103349 <![CDATA[Error with posting after db restore : Ok done, now I&#039;m getting...]]> https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103313.html#103313 Author: iSec
Subject: 19110
Posted: 03 April 2006 at 10:37pm

Ok done, now I'm getting this error:
 

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CLng'

/iv/forum/post_message.asp, line 624

]]> Mon, 03 Apr 2006 22:37:46 +0000 https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103313.html#103313 <![CDATA[Error with posting after db restore : This looks like an issue with...]]> https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103241.html#103241 Author: WebWiz-Bruce
Subject: 19110
Posted: 03 April 2006 at 10:39am

This looks like an issue with your database.

The Topic_ID column in the tblTopic table needs to be set to IDENTITYwith a SEED of 1 so that an ID number is automatically set by thedatabase.
]]> Mon, 03 Apr 2006 10:39:50 +0000 https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103241.html#103241 <![CDATA[Error with posting after db restore : After restoring the db wwf v 7x...]]> https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103177.html#103177 Author: iSec
Subject: 19110
Posted: 02 April 2006 at 11:37am

After restoring the db wwf v 7x (ms sql) when trying to post a new topic or post in an existing one, the following error occurs:
 

Microsoft OLE DB Provider for SQL Server error '80040e2f'

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

/iv/forum/post_message.asp, line 618



Edited by Info_Tech - 02 April 2006 at 2:46pm]]> Sun, 02 Apr 2006 11:37:05 +0000 https://forums.webwiz.net/error-with-posting-after-db-restore_topic19110_post103177.html#103177