Member Profile Problem
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=24261
Printed Date: 06 April 2026 at 9:13pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Member Profile Problem
Posted By: ToJaRo
Subject: Member Profile Problem
Date 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). ------------- ToJaRo http://www.thesoupbone.com - The SoupBone Community |
Replies:
Posted By: ToJaRo
Date 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 http://www.thesoupbone.com - The SoupBone Community |
Posted By: ToJaRo
Date 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 http://www.thesoupbone.com - The SoupBone Community |
Posted By: ToJaRo
Date Posted: 27 August 2007 at 4:09am
|
This is the line it is related too:
blnNewsletter = CBool(rsCommon("Newsletter"))
------------- ToJaRo http://www.thesoupbone.com - The SoupBone Community |
Posted By: MortiOli
Date 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? |
Posted By: ToJaRo
Date Posted: 27 August 2007 at 1:49pm
|
Yes, I had issues with the upgrade:
http://forums.webwiz.net/forum_posts.asp?TID=23976 - 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? ------------- ToJaRo http://www.thesoupbone.com - The SoupBone Community |
Posted By: ToJaRo
Date Posted: 27 August 2007 at 1:50pm
Oh and thank you for your help  ------------- ToJaRo http://www.thesoupbone.com - The SoupBone Community |
Posted By: ToJaRo
Date Posted: 28 August 2007 at 1:10am
|
Any help would be greatly appreciated.... ------------- ToJaRo http://www.thesoupbone.com - The SoupBone Community |
Posted By: WebWiz-Bruce
Date Posted: 28 August 2007 at 8:35am
|
Try using:- If isNull(rsCommon("Newsletter")) = False Then blnNewsletter = CBool(rsCommon("Newsletter")) Else blnNewsletter = False ------------- 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: ToJaRo
Date Posted: 28 August 2007 at 5:42pm
|
That did the trick! Thanks again for your support!!! ------------- ToJaRo http://www.thesoupbone.com - The SoupBone Community |