New User Login

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?

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

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

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.