Web Wiz Support and Community Forums : Error post upgrade - Invalid use of Null https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 06:39:20 +0000 Tue, 30 Jan 2007 10:48:39 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22556 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Error post upgrade - Invalid use of Null : Can you not just set the field...]]> https://forums.webwiz.net/error-post-upgrade-invalid-use-of-null_topic22556_post120032.html#120032 Author: MrMellie
Subject: 22556
Posted: 30 January 2007 at 10:48am

Can you not just set the field in SQL as an identity field? You should be able to, either with Enterprise Manager if you have access to it, or via some T-SQL script.]]> Tue, 30 Jan 2007 10:48:39 +0000 https://forums.webwiz.net/error-post-upgrade-invalid-use-of-null_topic22556_post120032.html#120032 <![CDATA[Error post upgrade - Invalid use of Null : I&#039;ve figured out my problem....]]> https://forums.webwiz.net/error-post-upgrade-invalid-use-of-null_topic22556_post120017.html#120017 Author: Darryld
Subject: 22556
Posted: 29 January 2007 at 10:32pm

I've figured out my problem. The access database I was using originally had become corrupted. I managed to export the data out using SQL server 2005 integration services into a fresh copy. This lost the primary key information and autonumbering.
 
Access doesnt want to put an autonumber back on existing data. I also cant re-import the data into an autonumber field.
 
Anyone got any ideas of a way around this?
 
Cheers
Darryl
]]> Mon, 29 Jan 2007 22:32:00 +0000 https://forums.webwiz.net/error-post-upgrade-invalid-use-of-null_topic22556_post120017.html#120017 <![CDATA[Error post upgrade - Invalid use of Null : Hi, I get the following error...]]> https://forums.webwiz.net/error-post-upgrade-invalid-use-of-null_topic22556_post119999.html#119999 Author: Darryld
Subject: 22556
Posted: 29 January 2007 at 9:25pm

Hi,
 
I get the following error after upgrading a 7.x forum using the access upgrade utility. Everything seem to work completely fine locally. But after upgrading my live site I realise I didnt test posting a message... doh.
 
I guess from other posts something may have gone wrong with the DB upgrade.
 
Help! Error below.
 
Darryl
 
Microsoft VBScript runtime (0x800A005E)
Invalid use of Null: 'CLng'
/forum/forum_posts.asp, line 755
 
Relevant line of code
 
  'Read in threads details for the topic from the database
  lngMessageID = CLng(sarryPosts(0,intCurrentRecord))


Edited by Darryld - 29 January 2007 at 9:26pm]]> Mon, 29 Jan 2007 21:25:44 +0000 https://forums.webwiz.net/error-post-upgrade-invalid-use-of-null_topic22556_post119999.html#119999