Web Wiz Forums - Upgrading DB from 8 to 9

Print Page | Close Window

Upgrading DB from 8 to 9

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=23833
Printed Date: 07 April 2026 at 5:47am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Upgrading DB from 8 to 9

Posted By: ohiopbx
Subject: Upgrading DB from 8 to 9
Date 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

Replies:

Posted By: ohiopbx
Date 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! :)

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

Posted By: WebWiz-Bruce
Date Posted: 19 July 2007 at 7:23pm

This has been fixed in version 9 beta 2. Try downloading this new version.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

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