Web Wiz Support and Community Forums : 80020009 - register.asp https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 15:07:03 +0000 Mon, 27 Nov 2006 12:46:38 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21818 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[80020009 - register.asp : Brilliant! I commented outlngUserProfileID...]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post117597.html#117597 Author: MortiOli
Subject: 21818
Posted: 27 November 2006 at 12:46pm

Brilliant!
 
I commented out lngUserProfileID = CLng(.Fields("Author_ID")) (line 977) and it's now working fine!
 
Thanks Michel!
 
Why does that cause an error on some servers?
]]> Mon, 27 Nov 2006 12:46:38 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post117597.html#117597 <![CDATA[80020009 - register.asp : OK, I got it to work, as follows.I...]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post117578.html#117578 Author: Michel_K17
Subject: 21818
Posted: 26 November 2006 at 9:30pm

OK, I got it to work, as follows.

I tried #2 above >> Same problem

I commented out lines 973 to 977 (requery & reload of authorID). I felt pretty confident that it would be fine because the authorID is reloaded later in the code before sending the e-mail anyway.  I tested it and it worked OK for me.

Cheers!
]]> Sun, 26 Nov 2006 21:30:53 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post117578.html#117578 <![CDATA[80020009 - register.asp : Am having the same problem with...]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post117576.html#117576 Author: Michel_K17
Subject: 21818
Posted: 26 November 2006 at 9:08pm

Am having the same problem with an Access database. Here are a couple of solutions posted elsewhere on this forum:

1. This is a problem that effects only a few servers, if you remove line 977 of register.asp it should fix the issue.

2. Another option is to replace line 977 with this:
If NOT isNull(.Fields("Author_ID")) Then lngUserProfileID = CLng(.Fields("Author_ID"))

2. Make sure that you have correctly set the forum orders within the admin section so that forums display correctly.


]]> Sun, 26 Nov 2006 21:08:07 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post117576.html#117576 <![CDATA[80020009 - register.asp : Please, does anyone have any ideas...]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post117545.html#117545 Author: MortiOli
Subject: 21818
Posted: 26 November 2006 at 1:05am

Please, does anyone have any ideas whatsoever?]]> Sun, 26 Nov 2006 01:05:20 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post117545.html#117545 <![CDATA[80020009 - register.asp : Unfortunately I can&#039;t see...]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post117239.html#117239 Author: MortiOli
Subject: 21818
Posted: 19 November 2006 at 12:41pm

Unfortunately I can't see anything on there which could cause / solve the problem]]> Sun, 19 Nov 2006 12:41:24 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post117239.html#117239 <![CDATA[80020009 - register.asp : Don&#039;t know if this helps...]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post117225.html#117225 Author: dpyers
Subject: 21818
Posted: 18 November 2006 at 3:59pm

Don't know if this helps or not:
http://classicasp.aspfaq.com/general/why-do-i-get-80020009-errors.html
]]> Sat, 18 Nov 2006 15:59:40 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post117225.html#117225 <![CDATA[80020009 - register.asp : Is there anyway of adding some...]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post117212.html#117212 Author: MortiOli
Subject: 21818
Posted: 18 November 2006 at 10:31am

Is there anyway of adding some code to show more information on the error?
 
I really need to get this working, because new members don't receive any email etc, and never return because of this.
]]> Sat, 18 Nov 2006 10:31:09 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post117212.html#117212 <![CDATA[80020009 - register.asp : Anyone have any ideas please? ]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post117010.html#117010 Author: MortiOli
Subject: 21818
Posted: 13 November 2006 at 9:18pm

Anyone have any ideas please?]]> Mon, 13 Nov 2006 21:18:27 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post117010.html#117010 <![CDATA[80020009 - register.asp : Yeah I&#039;m using Microsoft...]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post116829.html#116829 Author: MortiOli
Subject: 21818
Posted: 08 November 2006 at 8:15pm

Yeah I'm using Microsoft SQL Server Management Studio - that table was pulled off Enterprise Manager though, as it's easier to export info.

The Incr is found under;
 
Identity Specification
   (Is Indentity)             Yes
   Identity Increment    1
   Identity Seed            1
]]> Wed, 08 Nov 2006 20:15:51 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post116829.html#116829 <![CDATA[80020009 - register.asp : Whats Incr 1 all about, I&#039;ve...]]> https://forums.webwiz.net/80020009-register-asp_topic21818_post116724.html#116724 Author: WebWiz-Bruce
Subject: 21818
Posted: 06 November 2006 at 6:41pm

Whats Incr 1 all about, I've not seen this before, are you using Microsoft's SQL Server management Studio to work on the database?
]]> Mon, 06 Nov 2006 18:41:39 +0000 https://forums.webwiz.net/80020009-register-asp_topic21818_post116724.html#116724