Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Upgrading DB from 8 to 9
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Upgrading DB from 8 to 9
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
ohiopbx View Drop Down
Groupie
Groupie


Joined: 21 February 2005
Location: United States
Status: Offline
Points: 124 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ohiopbx Quote  Post ReplyReply Direct Link To This Post Topic: Upgrading DB from 8 to 9
    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
Back to Top
ohiopbx View Drop Down
Groupie
Groupie


Joined: 21 February 2005
Location: United States
Status: Offline
Points: 124 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ohiopbx Quote  Post ReplyReply Direct Link To This Post 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! :)
Back to Top
ohiopbx View Drop Down
Groupie
Groupie


Joined: 21 February 2005
Location: United States
Status: Offline
Points: 124 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ohiopbx Quote  Post ReplyReply Direct Link To This Post 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
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: 19 July 2007 at 7:23pm
This has been fixed in version 9 beta 2. Try downloading this new version.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
rowdyvdveen View Drop Down
Newbie
Newbie


Joined: 24 February 2006
Status: Offline
Points: 24 		Post Options Post Options   Thanks (0) Thanks(0)   Quote rowdyvdveen Quote  Post ReplyReply Direct Link To This Post 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
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.