Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - CDate problem in some posts
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

CDate problem in some posts
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
jurgen View Drop Down
Newbie
Newbie


Joined: 16 January 2005
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jurgen Quote  Post ReplyReply Direct Link To This Post Topic: CDate problem in some posts
    Posted: 16 January 2005 at 9:46am		 
Microsoft VBScript runtime error '800a000d'

Type mismatch: 'CDate' 
/functions/functions_format_post.asp, line 839
 
this problem occurs sometimes on opening posts.
It occurs always on the same posts, but not all posts get this error.
 
 
The rest of the forum seems to work properly.
 
Is anyone familiar with this problem?
 
Thx,
 
Jürgen
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 January 2005 at 9:48am
Turn off the fetaure to display who the post was edited by.

This can be done in the admin area under the 'forum configuration' page.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jurgen View Drop Down
Newbie
Newbie


Joined: 16 January 2005
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jurgen Quote  Post ReplyReply Direct Link To This Post Posted: 16 January 2005 at 9:55am
No, that didn't do it.
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 January 2005 at 10:53am
The problem is with the date that is being converted to show the time the post is edited. It is within this function that the error on line 839 of the /functions/functions_format_post.asp is occuring.

If you disable the option to have the edit date and person being displayed at the bottom of posts it will prevent this error from occuring.

The option can be dispabled from:-

'forum configuration' found in the admin area
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jurgen View Drop Down
Newbie
Newbie


Joined: 16 January 2005
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jurgen Quote  Post ReplyReply Direct Link To This Post Posted: 16 January 2005 at 11:29am
Originally posted by jurgen jurgen wrote:

No, that didn't do it.
 
As I said, changing this configuration didn't solve the problem.
Why?
Back to Top
jurgen View Drop Down
Newbie
Newbie


Joined: 16 January 2005
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jurgen Quote  Post ReplyReply Direct Link To This Post Posted: 16 January 2005 at 4:41pm
The problem seems to be occuring on the old posts which have been edited.
Changing the configuration doesn't solve that because the editor's message is already in the database.
There is some problem configuring the date/time written with the old version of WWF.
Has anyone a solution for this problem?
Back to Top
sfd19 View Drop Down
Senior Member
Senior Member


Joined: 20 December 2004
Status: Offline
Points: 263 		Post Options Post Options   Thanks (0) Thanks(0)   Quote sfd19 Quote  Post ReplyReply Direct Link To This Post Posted: 17 January 2005 at 5:03am
We had the same problem after switching from an American server to a German server and then back to an American. It was annoying
 
Right before this line in /functions/functions_format_post.asp
 
If isNumeric(dtmEditedDate) Then dtmEditedDate = CDate(dtmEditedDate) Else dtmEditedDate = 0
 
add a new line.
 
When your server is using "." in the date format (eg German servers) then add
dtmEditedDate = Replace(dtmEditedDate,",",".")
or when your server is using "," in the date format (eg American servers) then add
 
dtmEditedDate = Replace(dtmEditedDate,".",",")
 
When you are not sure what format your current server is using then check for a message in your database that has been edited with the current server settings and see if that server is using "," or "." in the number of the edited date. Then apply the fitting code line from above.
 
That should help.


Edited by sfd19 - 17 January 2005 at 11:32am
Politics, economy & social issues: StudentsforDemocracy.net
Back to Top
martionline View Drop Down
Groupie
Groupie


Joined: 13 January 2005
Location: Turkey
Status: Offline
Points: 54 		Post Options Post Options   Thanks (0) Thanks(0)   Quote martionline Quote  Post ReplyReply Direct Link To This Post Posted: 20 January 2005 at 6:17pm
in common.asp line 56
 
'Set the date time format to your own if you are getting a CDATE error
'Session.LCID = 1033 ==>make this Session.LCID = 1033 erase single quota
Back to Top
 Post Reply Post Reply Page  12>

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.