Web Wiz Support and Community Forums : Cdate error after migration https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 05 Apr 2026 02:54:40 +0000 Sun, 13 Feb 2005 20:18:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=13632 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Cdate error after migration : Info_Tech wrote:dj air,to see...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76251.html#76251 Author: sfd19
Subject: 13632
Posted: 13 February 2005 at 8:18pm

Originally posted by Info_Tech Info_Tech wrote:

dj air, to see the forum of my website: http://www.iraqvoice.com/justa/aforum/default.asp
 
sfd19, No it wasn't clear enough "to me"...It would be great if you give me an explaination as if you're talking to a beginner that is facing this issue for the first time. Thanks.
 
That is how I tried to explain it. Which part was not 'beginner-like'?
 
 
Originally posted by sfd19 sfd19 wrote:

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.
 
]]> Sun, 13 Feb 2005 20:18:32 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76251.html#76251 <![CDATA[Cdate error after migration : with the number of posts (60 thosand)...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76246.html#76246 Author: dj air
Subject: 13632
Posted: 13 February 2005 at 6:29pm

with the number of posts (60 thosand) i would recommend the SQL version.


]]> Sun, 13 Feb 2005 18:29:16 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76246.html#76246 <![CDATA[Cdate error after migration : dj air,to see theforum of my website:...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76241.html#76241 Author: iSec
Subject: 13632
Posted: 13 February 2005 at 5:41pm

dj air, to see the forum of my website: http://www.iraqvoice.com/justa/aforum/default.asp
 
sfd19, No it wasn't clear enough "to me"...It would be great if you give me an explaination as if you're talking to a beginner that is facing this issue for the first time. Thanks.
]]> Sun, 13 Feb 2005 17:41:21 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76241.html#76241 <![CDATA[Cdate error after migration : Info_Tech wrote: -boRg- wrote:The...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76239.html#76239 Author: sfd19
Subject: 13632
Posted: 13 February 2005 at 5:32pm

Originally posted by Info_Tech Info_Tech wrote:

Originally posted by -boRg- -boRg- wrote:

The CDate error on the forum_posts.asp page is usually cousred by the edit date, if the post has been edited.

The problem comes when changing servers etc. from a server that uses a period (.) in decimal numbers and those servers that use (,) in decimal numbers eg:-

123456.55
123456,55

If you have access to the server, changing the servers settings to use (.) instead of (,) or vise versa would sortout this issue.
I do not have access to the server. Could you tell me where specifically to look in the forum and what to edit? Thanks.
 
Was my post right above yours not clear enough - where I explained what to do when you do not have access to the server?
]]> Sun, 13 Feb 2005 17:32:20 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76239.html#76239 <![CDATA[Cdate error after migration : you have 1000 members , what sort...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76238.html#76238 Author: dj air
Subject: 13632
Posted: 13 February 2005 at 5:22pm

you have 1000 members , what sort of traffic, users do you get on at once?

also how many forums, topics and threads do you have, likely to get if its quite a few i would recommend going back to SQL.
]]> Sun, 13 Feb 2005 17:22:20 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76238.html#76238 <![CDATA[Cdate error after migration : Ok but before we do this, do you...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76235.html#76235 Author: iSec
Subject: 13632
Posted: 13 February 2005 at 5:18pm

Ok but before we do this, do you think I should go back to MS SQL as I have about 1000 forum mebers? By the way, I can zip the db and upload it on my webspace and you can download it from there.

Edited by Info_Tech - 13 February 2005 at 5:45pm]]> Sun, 13 Feb 2005 17:18:25 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76235.html#76235 <![CDATA[Cdate error after migration : if you can are able to / security...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76232.html#76232 Author: dj air
Subject: 13632
Posted: 13 February 2005 at 5:14pm

if you can are able to / security i mean . you can send a copy of thedatabase to me at aaron [@] emagine-hosts.com and i wil download andlook tomorrow.?]]> Sun, 13 Feb 2005 17:14:34 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76232.html#76232 <![CDATA[Cdate error after migration : Ok I can&#039;t do this I will...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76229.html#76229 Author: iSec
Subject: 13632
Posted: 13 February 2005 at 5:11pm

Ok I can't do this Confused I will try to go back to MS SQL, my friend has an MS SQL db. I will keep you informed if I get any errors while doing that.]]> Sun, 13 Feb 2005 17:11:38 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76229.html#76229 <![CDATA[Cdate error after migration : you need to make sure all tables...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76228.html#76228 Author: dj air
Subject: 13632
Posted: 13 February 2005 at 5:08pm

you need to make sure all tables default values are correct, you wiull have to compare them to a default/blank database.]]> Sun, 13 Feb 2005 17:08:45 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76228.html#76228 <![CDATA[Cdate error after migration : Do I do this for every single...]]> https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76226.html#76226 Author: iSec
Subject: 13632
Posted: 13 February 2005 at 5:04pm

Do I do this for every single table or just for the ones that you mentioned (PM_Message_Date, join dates, post count within the tblauthor table)?]]> Sun, 13 Feb 2005 17:04:35 +0000 https://forums.webwiz.net/cdate-error-after-migration_topic13632_post76226.html#76226