https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 07:12:44 +0000 Mon, 20 Feb 2006 18:58:13 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18425 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/sql-server-migration-issues_topic18425_post99810.html#99810 Author: Brolin99
Subject: 18425
Posted: 20 February 2006 at 6:58pm

Thanks Borg - it's now working perfectly.

Cheers]]> Mon, 20 Feb 2006 18:58:13 +0000 https://forums.webwiz.net/sql-server-migration-issues_topic18425_post99810.html#99810 https://forums.webwiz.net/sql-server-migration-issues_topic18425_post99776.html#99776 Author: WebWiz-Bruce
Subject: 18425
Posted: 20 February 2006 at 9:34am

Try giving these tables default values as it looks like you may not have imported the default values into the new database.

The column 'Votes' in the 'PollChoice' table should have the default value of '0' and the same for the 'Locked' column in the 'Topics' table.
]]> Mon, 20 Feb 2006 09:34:07 +0000 https://forums.webwiz.net/sql-server-migration-issues_topic18425_post99776.html#99776 https://forums.webwiz.net/sql-server-migration-issues_topic18425_post99678.html#99678 Author: Brolin99
Subject: 18425
Posted: 18 February 2006 at 7:16am

Hi there,

I have recently migrated my forums from one database to another. Everything is working perfectly, except when trying to add new topics. I have checked that the settings on the database tables are the same (i.e. what tables are identity and nulls etc.) but get this message (when trying to post with a poll):

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft>[ODBC SQL Server Driver>[SQL Server>Cannot insert the value NULL into column 'Votes', table 'sportsfreak-forum.dbo.tblForumPollChoice'; column does not allow nulls. INSERT fails.

/forum/post-message.asp, line 527


And this one with no poll:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft>[ODBC SQL Server Driver>[SQL Server>Cannot insert the value NULL into column 'Locked', table 'sportsfreak-forum.dbo.tblForumTopic'; column does not allow nulls. INSERT fails.

/forum/post-message.asp, line 578

Please help!!]]> Sat, 18 Feb 2006 07:16:55 +0000 https://forums.webwiz.net/sql-server-migration-issues_topic18425_post99678.html#99678