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

  New Posts New Posts RSS Feed - Member Profile Problem
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Member Profile Problem
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post Topic: Member Profile Problem
    Posted: 25 August 2007 at 2:17am
Not sure exactly what happened but earlier today I was able to update member profiles and now I can't go into anyone's profile except the one I am logged in as (which is an administrator). All other member profiles get this error:
 
 Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CBool'

/member_profile.asp, line 174

Any ideas? No code has changed whatsoever in the site recently and as far as I know there have been no new upgrades on the server (hosting company usually notifies me if there is).


Edited by ToJaRo - 25 August 2007 at 2:26am
ToJaRo
The SoupBone Community
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post Posted: 25 August 2007 at 4:07pm
After further review it seems to only be happening on profiles that where created before the v9 upgrade with the exception of my profile and a test member profile I use... I have a few new users since the upgrade and they work fine. 
ToJaRo
The SoupBone Community
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post Posted: 27 August 2007 at 4:06am
I uploaded a fresh copy of member_profile.asp and that didn't either... so I've ruled out a corrupt file.  Any ideas anyone?
ToJaRo
The SoupBone Community
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post Posted: 27 August 2007 at 4:09am
This is the line it is related too:
 
blnNewsletter = CBool(rsCommon("Newsletter"))
 
 
ToJaRo
The SoupBone Community
Back to Top
MortiOli View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MortiOli Quote  Post ReplyReply Direct Link To This Post Posted: 27 August 2007 at 9:25am
On v9, a new field is added to allow a member to say yes or no to a newsletter subscription (option only appears if you turn on Newspad intergration).  Looks like some of the fields are blank (null), rather than a yes or no / 1 or 0 etc.

Might want to check out that field in your Author table, to see if any are blank.  I assume during the database upgrade, this field would be added to the table, and then populated - have you run the database upgrade from v8 to v9?
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post Posted: 27 August 2007 at 1:49pm
Yes, I had issues with the upgrade:
 
I ended up having to create the fields manually per borgs instructions. It corrected the registration problem and I just found this issue... any idea on what I need to do at this point?  Is there a script I can run in SQL to update those fields?
ToJaRo
The SoupBone Community
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post Posted: 27 August 2007 at 1:50pm
Oh and thank you for your help Big%20smile
ToJaRo
The SoupBone Community
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2007 at 1:10am

Any help would be greatly appreciated....

ToJaRo
The SoupBone Community
Back to Top
 Post Reply Post Reply Page  12>

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.