Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - UBOUND error on profile page
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

UBOUND error on profile page

 Post Reply Post Reply
Author
zebi View Drop Down
Newbie
Newbie


Joined: 09 January 2004
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote zebi Quote  Post ReplyReply Direct Link To This Post Topic: UBOUND error on profile page
    Posted: 10 January 2004 at 8:26am
Hi,
I stupidly installed the ?7.03 beta version and had to upgrade- i made all the database changes some morning and had a few niggles which i ironed out. Now the only thing thats not working is the pop up profile which gives the following error (when logged in)

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'UBound'

/niclubbing/forum/pop_up_profile.asp, line 182

the url for the disc forum is http://forum.niclubbing.com/

I think it to do with the active users and this bit of code :

    'Get the users online status
    For intArrayPass = 1 To UBound(saryActiveUsers, 2)
        If saryActiveUsers(1, intArrayPass) = lngProfileNum Then blnIsUserOnline = True
    Next

Now the magical question: dies anyone know which part of the database ive screwed over?

Any helpful feedback would be appreciated.
Thanks!




Edited by zebi
Back to Top
tim_r View Drop Down
Newbie
Newbie


Joined: 05 January 2004
Status: Offline
Points: 24
Post Options Post Options   Thanks (0) Thanks(0)   Quote tim_r Quote  Post ReplyReply Direct Link To This Post Posted: 10 January 2004 at 9:44am
I've got this error on version 7.7 just now.  Will diagnose and get back to you
Back to Top
tim_r View Drop Down
Newbie
Newbie


Joined: 05 January 2004
Status: Offline
Points: 24
Post Options Post Options   Thanks (0) Thanks(0)   Quote tim_r Quote  Post ReplyReply Direct Link To This Post Posted: 10 January 2004 at 10:38am

I'm a Java guy and new to asp so some of this might not be 100% accurate but you'll get the idea...

This occurs when you turn "Active Users List" off.  If it is off then includes/active_users_inc.asp is never run from common.asp and hence saryActiveUsers is never set up. 

Thus the profile page is trying to dispay the users online status but through Admin, we have configured it not to keep track of the online users. 

I am just doing a fix for my pop_up_profile.asp.  Will put it up here when done

Back to Top
tim_r View Drop Down
Newbie
Newbie


Joined: 05 January 2004
Status: Offline
Points: 24
Post Options Post Options   Thanks (0) Thanks(0)   Quote tim_r Quote  Post ReplyReply Direct Link To This Post Posted: 10 January 2004 at 11:02am

This is the fix I am going with.  It will always show offline if the administrator has configured the forum to not track online users

In pop_up_profile.asp replace

   'Get the users online status
    For intArrayPass = 1 To UBound(saryActiveUsers, 2)
        If saryActiveUsers(1, intArrayPass) = lngProfileNum Then  lnIsUserOnline = True
    Next

with

 'Get the users online status if we track them
 'Otherwise, just let it always display the OFFLINE text
 If blnActiveUsers Then
  For intArrayPass = 1 To UBound(saryActiveUsers, 2)
   If saryActiveUsers(1, intArrayPass) = lngProfileNum Then blnIsUserOnline = True
  Next
 End If

Hope this helps

Back to Top
zebi View Drop Down
Newbie
Newbie


Joined: 09 January 2004
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote zebi Quote  Post ReplyReply Direct Link To This Post Posted: 10 January 2004 at 11:29am
Hi Tim,
Cheers for the quick fix and the response!

Zebi
Back to Top
tim_r View Drop Down
Newbie
Newbie


Joined: 05 January 2004
Status: Offline
Points: 24
Post Options Post Options   Thanks (0) Thanks(0)   Quote tim_r Quote  Post ReplyReply Direct Link To This Post Posted: 10 January 2004 at 11:31am
No worries mate
Back to Top
Eftie View Drop Down
Groupie
Groupie


Joined: 17 March 2003
Location: Netherlands
Status: Offline
Points: 140
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eftie Quote  Post ReplyReply Direct Link To This Post Posted: 10 January 2004 at 2:32pm

Hi Zebi,

This was posted yesterday already!
http://forums.webwiz.net/forum_posts.asp?TID=8644&a mp;TPN=4

And Tim, your solution is nicer than my 'comment it out'. Thanks!

Eftie
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.