Web Wiz Support and Community Forums : Member Profile Problem

Web Wiz Support and Community Forums : Member Profile Problem https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 21:15:27 +0000 Tue, 28 Aug 2007 17:42:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24261 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Member Profile Problem : That did the trick! Thanks again...]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126920.html#126920 Author: ToJaRo
Subject: 24261
Posted: 28 August 2007 at 5:42pm

That did the trick! Thanks again for your support!!!]]> Tue, 28 Aug 2007 17:42:09 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126920.html#126920 <![CDATA[Member Profile Problem : Try using:-If isNull(rsCommon("Newsletter"))...]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126898.html#126898 Author: WebWiz-Bruce
Subject: 24261
Posted: 28 August 2007 at 8:35am

Try using:-

If isNull(rsCommon("Newsletter")) = False Then blnNewsletter = CBool(rsCommon("Newsletter")) Else blnNewsletter = False
]]> Tue, 28 Aug 2007 08:35:37 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126898.html#126898 <![CDATA[Member Profile Problem : Any help would be greatly appreciated.......]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126895.html#126895 Author: ToJaRo
Subject: 24261
Posted: 28 August 2007 at 1:10am

Any help would be greatly appreciated....

]]> Tue, 28 Aug 2007 01:10:33 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126895.html#126895 <![CDATA[Member Profile Problem : Oh and thank you for your help...]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126874.html#126874 Author: ToJaRo
Subject: 24261
Posted: 27 August 2007 at 1:50pm

Oh and thank you for your help

]]> Mon, 27 Aug 2007 13:50:25 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126874.html#126874 <![CDATA[Member Profile Problem : Yes, I had issues with the upg...]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126873.html#126873 Author: ToJaRo
Subject: 24261
Posted: 27 August 2007 at 1:49pm

Yes, I had issues with the upgrade:

http://forums.webwiz.net/forum_posts.asp?TID=23976

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?

]]> Mon, 27 Aug 2007 13:49:53 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126873.html#126873 <![CDATA[Member Profile Problem : On v9, a new field is added to...]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126863.html#126863 Author: MortiOli
Subject: 24261
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?
]]> Mon, 27 Aug 2007 09:25:53 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126863.html#126863 <![CDATA[Member Profile Problem : This is the line it is related...]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126861.html#126861 Author: ToJaRo
Subject: 24261
Posted: 27 August 2007 at 4:09am

This is the line it is related too:

blnNewsletter = CBool(rsCommon("Newsletter"))

]]> Mon, 27 Aug 2007 04:09:24 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126861.html#126861 <![CDATA[Member Profile Problem : I uploaded a fresh copy of member_profile.asp...]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126860.html#126860 Author: ToJaRo
Subject: 24261
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?]]> Mon, 27 Aug 2007 04:06:44 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126860.html#126860 <![CDATA[Member Profile Problem : After further review it seemsto...]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126839.html#126839 Author: ToJaRo
Subject: 24261
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. ]]> Sat, 25 Aug 2007 16:07:33 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126839.html#126839 <![CDATA[Member Profile Problem : Not sure exactly what happened...]]> https://forums.webwiz.net/member-profile-problem_topic24261_post126834.html#126834 Author: ToJaRo
Subject: 24261
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]]> Sat, 25 Aug 2007 02:17:55 +0000 https://forums.webwiz.net/member-profile-problem_topic24261_post126834.html#126834