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

  New Posts New Posts RSS Feed - 80020009 - register.asp
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

80020009 - register.asp
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
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 Topic: 80020009 - register.asp
    Posted: 02 November 2006 at 9:25pm
Borg,
 
I did a search on this, and came across a couple of topics, but nothing with a definate fix, so I was hoping I might be able to provide you with the info you need to get to the bottom of this error...
 
When a user registers, they receive the following error after they submit, and do not receive a welcome email;
 
error '80020009'

/forum/register.asp, line 977

 
Line 977 is the one in red;
 
   'Disable error trapping
   On Error goto 0
                        'Re-run the query to read in the updated recordset from the database
                        .Requery
                        'Read back in the user ID for the activation email
                  lngUserProfileID = CLng(.Fields("Author_ID"))
                  'Close rs
                  .Close
                End With
 
 
Now in the past I've upgraded from Snitz to WWF 7.x, and then from 7.x to 8.x
 
I'm currently running version 8.04, and only noticed this error recently (ie, in version 8.x).
 
My server is Windows Server 2003, running IIS v6.0
My database is MS SQL v8.0.2039
 
I've re-uploaded register.asp to make sure it's not a corrupt file, and still receive the same error.
 
I've also posted a topic regarding a difference in my SQL database to what it should be, even after upgrading my WWF and database from 7 to 8.  Is there anything I can run to tell me if anything is different to a blank WWF install, than to the install I have?  Ie, incase of corruption in upgrading etc.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 03 November 2006 at 9:18am
As I recall from a previous post you made your default values in your database where not correct and so where coursing the problem.

The same seems true for this error.

The best course of action would be to go through the database and make sure you have correctly set default values for all those fields that require them
Web Wiz Forums Hosting
ASP.NET Web Hosting
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: 03 November 2006 at 9:41pm
That's right, some seem to be different.
 
Is there anyway I can run the msSQL_server_setup.asp page, to update the tables, instead of creating them?
 
Ie, if I went through the file and changed CREATE to ALTER?
 
I'm not too sure on SQL, so don't know what would do what etc.
 
EDIT - Maybe if someone could write a script to compare what the database should have set, and what it is actually set to, it would help a lot of people after upgrades / migrations?  Hopefully someone might jump up and lend a hand Wink


Edited by MortiOli - 03 November 2006 at 9:42pm
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: 04 November 2006 at 11:09pm
Right, I've gone through my whole database, and checked everything against a clean install - there was a number of differences, but everything has now been rectified.
 
However, when registering a new user again, I'm still receiving the following error;
 
error '80020009'

/forum/register.asp, line 977

 
Any ideas what could be causing this?
 
Just another question...can I remove all the stored procedures in my MS SQL database now, as I read that version 8.x doesn't use these anymore?
 
Cheers Borg.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 06 November 2006 at 9:33am
Check in the database that an ID number for the new member has been created.

You can also remove any stored procedures from the database
Web Wiz Forums Hosting
ASP.NET Web Hosting
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: 06 November 2006 at 6:19pm
Yeah, an Author_ID number has been created.
 
The user is created ok (apart from the error), but no activation email is sent.  If I try and login, and tell it to resend the email, it sends ok and I can continue to use the account.
 
Here's what the record looks like for the new user;
 
Author_ID Group_ID Username Real_name User_code Password Salt Author_email Homepage Location MSN Yahoo ICQ AIM Occupation Interests DOB Signature No_of_posts Join_date Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 06 November 2006 at 6:25pm
It's really difficult to say what the problem is, the error looks database related.

The line in question reads back in the new users ID from the database after the new user has been created, this is used for activation emails etc.

If this line doesn't run then the rest of the page can not run correctly.

Because you have made so many changes to the database converting from one type to another etc. it's going to be very hard getting to the bottom of the problem.

The only way I can suggest is keep trying till you find the answer.
Web Wiz Forums Hosting
ASP.NET Web Hosting
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: 06 November 2006 at 6:32pm
I'm a bit stumped.  I don't know what else could be causing it, as I've corrected all the database discrepancies.
 
If you or anyone else has any more suggestions, please fire them this way...
 
Just as a double check, this is what my tblAuthor looks like;
 
Key Ident Seed Incr Column Name Data Type Allow Nulls
Checked Checked 1 1 Author_ID int Unchecked
Unchecked Unchecked 0 0 Group_ID int Unchecked
Unchecked Unchecked 0 0 Username nvarchar(25) Unchecked
Unchecked Unchecked 0 0 Back to Top
 Post Reply Post Reply Page  123>

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.