Web Wiz Support and Community Forums : New User Login https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 18:02:51 +0000 Fri, 27 Oct 2006 13:15:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21739 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[New User Login : No errors now, just setting up...]]> https://forums.webwiz.net/new-user-login_topic21739_post116253.html#116253 Author: kcuk
Subject: 21739
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
]]> Fri, 27 Oct 2006 13:15:32 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116253.html#116253 <![CDATA[New User Login : No, as your database is not populated...]]> https://forums.webwiz.net/new-user-login_topic21739_post116252.html#116252 Author: WebWiz-Bruce
Subject: 21739
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.
]]> Fri, 27 Oct 2006 12:50:33 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116252.html#116252 <![CDATA[New User Login : Ok thats cool, is it feasible...]]> https://forums.webwiz.net/new-user-login_topic21739_post116251.html#116251 Author: kcuk
Subject: 21739
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?
]]> Fri, 27 Oct 2006 12:10:54 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116251.html#116251 <![CDATA[New User Login : It looks like your SQL Server...]]> https://forums.webwiz.net/new-user-login_topic21739_post116250.html#116250 Author: WebWiz-Bruce
Subject: 21739
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.
]]> Fri, 27 Oct 2006 12:05:43 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116250.html#116250 <![CDATA[New User Login : I think there might be a corruption...]]> https://forums.webwiz.net/new-user-login_topic21739_post116249.html#116249 Author: kcuk
Subject: 21739
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
INSERTstatement 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?***


Edited by kcuk - 27 October 2006 at 12:04pm]]> Fri, 27 Oct 2006 12:01:25 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116249.html#116249 <![CDATA[New User Login : Doh never ask a dyslexic to count!...]]> https://forums.webwiz.net/new-user-login_topic21739_post116247.html#116247 Author: kcuk
Subject: 21739
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
]]> Fri, 27 Oct 2006 11:56:38 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116247.html#116247 <![CDATA[New User Login : The line you mention the error...]]> https://forums.webwiz.net/new-user-login_topic21739_post116243.html#116243 Author: WebWiz-Bruce
Subject: 21739
Posted: 27 October 2006 at 11:43am

The line you mention the error is on is 977 not line 997]]> Fri, 27 Oct 2006 11:43:55 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116243.html#116243 <![CDATA[New User Login : Have downloaded and unzipped...]]> https://forums.webwiz.net/new-user-login_topic21739_post116239.html#116239 Author: kcuk
Subject: 21739
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



Edited by kcuk - 27 October 2006 at 11:09am]]> Fri, 27 Oct 2006 10:44:18 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116239.html#116239 <![CDATA[New User Login : In the version you are using 8.04...]]> https://forums.webwiz.net/new-user-login_topic21739_post116207.html#116207 Author: WebWiz-Bruce
Subject: 21739
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.
]]> Thu, 26 Oct 2006 18:16:48 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116207.html#116207 <![CDATA[New User Login : Hey all...anyone seen this when...]]> https://forums.webwiz.net/new-user-login_topic21739_post116202.html#116202 Author: kcuk
Subject: 21739
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/

Using MS SQL 2000 and Server 2003

Help?
]]> Thu, 26 Oct 2006 17:40:30 +0000 https://forums.webwiz.net/new-user-login_topic21739_post116202.html#116202