Web Wiz Support and Community Forums : Upgrading DB from 8 to 9 https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 05:50:44 +0000 Sat, 21 Jul 2007 00:02:15 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23833 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Upgrading DB from 8 to 9 : I have this problem as well, using...]]> https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post125126.html#125126 Author: rowdyvdveen
Subject: 23833
Posted: 21 July 2007 at 12:02am

I have this problem as well, using version 9 beta 2.

For now I've just fixed it myself:
If IsNumeric(sarryForums(15, intTempRecord)) Then
  lngSubTopicID = CLng(sarryForums(15, intTempRecord))
Else
  lngSubTopicID = 0
End If



Edited by rowdyvdveen - 21 July 2007 at 12:05am]]> Sat, 21 Jul 2007 00:02:15 +0000 https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post125126.html#125126 <![CDATA[Upgrading DB from 8 to 9 : This has been fixed in version...]]> https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post125030.html#125030 Author: WebWiz-Bruce
Subject: 23833
Posted: 19 July 2007 at 7:23pm

This has been fixed in version 9 beta 2. Try downloading this new version.]]> Thu, 19 Jul 2007 19:23:10 +0000 https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post125030.html#125030 <![CDATA[Upgrading DB from 8 to 9 : my only question is &#034;Last_topic_ID&#034;...]]> https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post125024.html#125024 Author: ohiopbx
Subject: 23833
Posted: 19 July 2007 at 6:41pm

my only question is "Last_topic_ID" on the conversion is null which doesn't fly well w/version 9

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CLng'

/v9/default.asp, line 592


got anything to update the Last_topic_ID column]]> Thu, 19 Jul 2007 18:41:05 +0000 https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post125024.html#125024 <![CDATA[Upgrading DB from 8 to 9 : Just for anyone who wants to know,...]]> https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post125009.html#125009 Author: ohiopbx
Subject: 23833
Posted: 19 July 2007 at 3:54pm

Just for anyone who wants to know, i ran the update "msSQL_server_8x_update.asp" on my version 8 db to convert to 9 and my version 8 code still works! :)]]> Thu, 19 Jul 2007 15:54:45 +0000 https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post125009.html#125009 <![CDATA[Upgrading DB from 8 to 9 : I was looking at the upgrade tool...]]> https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post124983.html#124983 Author: ohiopbx
Subject: 23833
Posted: 18 July 2007 at 8:13pm

I was looking at the upgrade tool from 8 to 9 and i do not see any DB deletions. I was wondering if i update my DB from 8 to 9 but still use 8's code for the forum, will i have any issues?

Thanks
]]> Wed, 18 Jul 2007 20:13:28 +0000 https://forums.webwiz.net/upgrading-db-from-8-to-9_topic23833_post124983.html#124983