Web Wiz Support and Community Forums : Complicated CDATE Problem https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 16 Apr 2026 02:25:30 +0000 Tue, 29 Nov 2005 13:13:25 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17345 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Complicated CDATE Problem : This is common problem when moving...]]> https://forums.webwiz.net/complicated-cdate-problem_topic17345_post94564.html#94564 Author: WebWiz-Bruce
Subject: 17345
Posted: 29 November 2005 at 1:13pm

This is common problem when moving from one server to another server with a different locale settings.

This is becuase the old server would use a dot (.) in double numbers and your new server a comma (,)

To fix this problem 7.6 has been changed so that the date is tored in a different format.

Update to version 7.6 will sortout your problem.
]]> Tue, 29 Nov 2005 13:13:25 +0000 https://forums.webwiz.net/complicated-cdate-problem_topic17345_post94564.html#94564 <![CDATA[Complicated CDATE Problem : Hello, Im running version 7.9...]]> https://forums.webwiz.net/complicated-cdate-problem_topic17345_post94335.html#94335 Author: hgurol
Subject: 17345
Posted: 25 November 2005 at 1:41pm

Hello,
 
Im running version 7.9 on msSQL. I was hosting my site on a English set server(US). I have set my SQL collation as Turkish, manually added Turkish Codepage directive on every page and the Turkish meta tags was inplace, as well as the Turkish LCID setting. I thought that I have totally configured my forum to work with Turkish characters and date/time settings. Never had a problem for the last 1.5 years.
 
Recently I have moved my site on a Turkish server. When I say Turkish server actually it is an English Windows Server with Turkish Regional Settings configured. Now the problems Im having is with the edited posts. Not the new posts that are being edit after the move, but the older posts that have been edited while on the English set server are returning Type mismatch: 'CDATE' error.
 
After following a few asp pages for debugging(with my poor programing knowledge), I guess I have figured out the problem. The time of the edit action is not directly kept on the database but it is attached to the end of the each post as a string. A function parses that string and convert it to the date/time format to display it. The numeric string Im talking about is a little allien to me since the string is something like "38371.8296759259" however it converts to date like "19.01.2005 19:54:44".
 
What I believe is the function(s) that writes and reads that string is somehow regional setting depended. Well honestly I must say that Im a little disapponted if it is regional settings depanded after all that CodePage and LCID settings configured. And since the US date format on the old server was MM/DD/YYYY and the new date format on my Turkish server is DD/MM/YYYY the function parses that string is messing up all of my previously edited posts.
 
...so what you think about my issue? What can be the best approach to solve the problem?
 
Thanks,
Halil
 
]]> Fri, 25 Nov 2005 13:41:53 +0000 https://forums.webwiz.net/complicated-cdate-problem_topic17345_post94335.html#94335