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!  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  Kevin |