Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Error with posting after db restore
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error with posting after db restore
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Topic: Error with posting after db restore
    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
"When it gets dark enough, you can see the stars"
-Charles A. Beard
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.