Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Error to access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error to access

 Post Reply Post Reply
Author
Raistlin View Drop Down
Newbie
Newbie


Joined: 13 January 2004
Location: Spain
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote Raistlin Quote  Post ReplyReply Direct Link To This Post Topic: Error to access
    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

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 16 September 2004 at 4:30am
Please refer to the forum documentation on this error for a solution.
Back to Top
Raistlin View Drop Down
Newbie
Newbie


Joined: 13 January 2004
Location: Spain
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote Raistlin Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Raistlin View Drop Down
Newbie
Newbie


Joined: 13 January 2004
Location: Spain
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote Raistlin Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Raistlin View Drop Down
Newbie
Newbie


Joined: 13 January 2004
Location: Spain
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote Raistlin Quote  Post ReplyReply Direct Link To This Post 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  

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.