Print Page | Close Window

New User Login

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=21739
Printed Date: 08 April 2026 at 5:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: New User Login
Posted By: kcuk
Subject: New User Login
Date Posted: 26 October 2006 at 5:40pm
Hey all...

anyone seen this when a new user signs up they get this lovely message!

error '80020009'

/forum/register.asp, line 977

http://www.sotoncityexplorers.co.uk/forum/ - http://www.sotoncityexplorers.co.uk/forum/

Using MS SQL 2000 and Server 2003

Help?



Replies:
Posted By: WebWiz-Bruce
Date Posted: 26 October 2006 at 6:16pm
In the version you are using 8.04 the line 977 of register.asp should just be 'End With' which should never throw up this error.

This suggests that maybe you have a corrupted file and you should re-upload your files again to the server.


-------------
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: kcuk
Date Posted: 27 October 2006 at 10:44am
Have downloaded and unzipped the forum directly on the server but still no luck still getting the same error message.

From register.asp

994   Response.Cookies(strCookieName)("UID") = strUserCode
995   Call saveSessionItem("UID", strUserCode)
996
997              'If the user has selected to be remebered when they next 99                      login then set the expiry date for the cookie for 1 year
998               If blnAutoLogin = True Then



Posted By: WebWiz-Bruce
Date Posted: 27 October 2006 at 11:43am
The line you mention the error is on is 977 not line 997

-------------
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: kcuk
Date Posted: 27 October 2006 at 11:56am
Doh never ask a dyslexic to count! LOL

sorry!!!

964    If Err.Number <> 0 AND strMode = "new" Then
965    Call errorMsg("An error has occured while writing to the
          database.",  "register_USR", "register.asp")
966    ElseIf Err.Number <> 0 Then
967    Call errorMsg("An error has occured while writing to the database.",
           "update_USR", "register.asp")
968    End If
969
970   'Disable error trapping
971   On Error goto 0
972
973   'Re-run the query to read in the updated recordset from the
         database
974   .Requery
975
976       'Read back in the user ID for the activation email
977        lngUserProfileID = CLng(.Fields("Author_ID"))
978
979              'Close rs
980              .Close
981               End With

Once again sorry i can count (sort of)

Kev


Posted By: kcuk
Date Posted: 27 October 2006 at 12:01pm
I think there might be a corruption or something wrong with the SQL tables just had this error and repeats when a new thread is added by a guest on the Help forum (the only Thread that is allowed by public user)

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_save_new_post_data
File Name:- new_post.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'tblThread_FK00'. The conflict occurred in database 'forum', table 'tblAuthor', column 'Author_ID'.

Just odd that line 977 refers to the same field on that table.

Thoughts?

** update**i dont have a guest account in that tabel is that right?***


Posted By: WebWiz-Bruce
Date Posted: 27 October 2006 at 12:05pm
It looks like your SQL Server database is not setup correctly and is failing to set a default value for the Author_ID in the tblAuthor.

If this table is failing to set default values then no-doubt other default values will not be set in the database.

The best solution will be to drop your current database and then use the database setup file to re-create the database again on the SQL Server, making sure that you get no error messages from the database setup tool.


-------------
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: kcuk
Date Posted: 27 October 2006 at 12:10pm
Ok thats cool, is it feasible to create a new database on there check to see if it works then copy exsisting tables onto new database excluding tblauthor?


Posted By: WebWiz-Bruce
Date Posted: 27 October 2006 at 12:50pm
No, as your database is not populated anyway with any data, you need to delete the entire database and start again.

When you run the database setup tool on your new clean database make sure that it doesn't report any errors, if you get errors let us know what they are so we can tell you what to change on the SQL Server, as the file must be run with no errors.


-------------
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: kcuk
Date Posted: 27 October 2006 at 1:15pm
No errors now, just setting up the forum again... doh!

thank you very much.... shall be paying for full version later on Wink

Kevin



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net