Web Wiz Forums - Error to access

Print Page | Close Window

Error to access

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=11830
Printed Date: 09 April 2026 at 3:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error to access

Posted By: Raistlin
Subject: Error to access
Date Posted: 16 September 2004 at 4:27am

Hy all:

Few days ago, i change my default.asp to get a table with the top posters and the last post. All was ok and suddenly after 5 days without problems i get this error trying to access

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'CDate'

/forum/common.asp, line 448

My hosting service told me they didn't make changes in the host. And i only change to version 7.9 and the default.asp. I put the old one (a backup) and the problem continue.

The code of the line is this (in common.asp):

'Read in the Last Visit Date for the user from the db if we haven't already
  If Session("ViRead") = "" Then
   If isDate(rsCommon("Last_visit")) Then Session("dtmLastVisit") = CDate(rsCommon("Last_visit"))
   Session("ViRead") = True
  End If

  'Check that there is a last visit date in the db or we will get an error
  If isDate(rsCommon("Last_visit")) Then

   'If the Last Visit date in the db is older than 5 minutes for the user then update it
   If CDate(rsCommon("Last_visit")) < DateAdd("n", -5, Now()) Then

    'Initilse sql statement
    If strDatabaseType = "SQLServer" Then
     strSQL = "EXECUTE " & strDbProc & "UpdateLasVisit @lngUserID = " & lngLoggedInUserID
    Else
     strSQL = "UPDATE " & strDbTable & "Author SET " & strDbTable & "Author.Last_visit = Now() WHERE " & strDbTable & "Author.Author_ID=" & lngLoggedInUserID & ";"
    End If

    'Write to database
    adoCon.Execute(strSQL)

End If

Please i need some help.

Thank u

Replies:

Posted By: WebWiz-Bruce
Date Posted: 16 September 2004 at 4:30am

Please refer to the forum documentation on this error for a solution.

-------------
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: Raistlin
Date Posted: 16 September 2004 at 10:20am

ok.... i have installed again all 7.9 web wiz forums, i read about the cdate error and i replaced the lCID to 1034 (Spain). I cleaned out cookies and the forum begins to load.... i can see the logo and the navigation buttons ... and ... today is.... and the date and time... but now i get this error:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'CDate'

/forum/Default.asp, line 154

The default is the same that comes in the v7.9 forum. Have i to change anything else in this archive?.

Thank u

Posted By: Raistlin
Date Posted: 21 September 2004 at 10:40am

Please, i still have this error. Can someone help me?. I checked this a lot of times... and i can't solve it.

Thank u

Posted By: WebWiz-Bruce
Date Posted: 21 September 2004 at 11:01am

Check with your hosts what there locale settings are on their servers, then check you have set the correct LICID value and uncommented the line.

-------------
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: Raistlin
Date Posted: 21 September 2004 at 11:51am

Thank u Borg... i was surfing on internet and i found the lcid for spain is 7178... now it works perfectly.

Thank u again