Web Wiz Forums - Error with posting after db restore

Print Page | Close Window

Error with posting after db restore

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=19110
Printed Date: 12 April 2026 at 3:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error with posting after db restore

Posted By: iSec
Subject: Error with posting after db restore
Date 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

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard

Replies:

Posted By: WebWiz-Bruce
Date 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 IDENTITY with a SEED of 1 so that an ID number is automatically set by the database.

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

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard

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

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

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard