| Author |
 Topic  |
|
ajb
New Member
Australia
81 Posts |
 Posted - 02 April 2001 : 20:05:28
|
Second time I have posted this in the last few days. Please somebody must know what this is, it's going to drive me mad!
It is now April 3 here and the date now shows You last visited on 04 Mar 2001 09:35:44 AM
On April 2 it showed "You last visited on 04 Feb 2001 06:28:08 AM"
On April 1 it showed "You last visited on 04 Jan 2001 05:15:42 AM"
Again I am assuming this is reading an American style of date and will eventually forward date itself to say that I visited in the future. (Back to the Future, sounds like a good story line for a movie!)
All other dates on the forum appear to be OK. The last post date example is "with the last post on 01 Apr 2001 08:31:50 AM by: ANDREW."
Have been trying to think of what may have caused it and the only thing I can come up with is that I was playing with the 'Chat and OurChat' Mods. Both have now been un-installed, however is it possible that they may have changed the format of the last visited date?
Can I change that format back manually?
I have now run the forum from 4 different computers and they all show the same thing. Obviously it is being sent from the server in the cookie.
I downloaded the database to have a look it and it tells me the database was created in an earlier version of Access, is it ok to convert it to Access 2000?
Again, TIA and I look forward to someone being able to help, it is very hard to keep up with posts if it shows all of them as new everytime you visit.
Thanks ...
John  |
|
|
Giapai
New Member
92 Posts |
Posted - 02 April 2001 : 20:13:51
|
might have something to do with the timezone you in and the one you used in your forum?
|
 |
|
|
ajb
New Member
Australia
81 Posts |
Posted - 02 April 2001 : 20:23:08
|
Hi GaiPai
Thanks for the thought.
All other dates on the machine are working fine. Only the last visited date is out.
The time is spot on.
Wish it was that easy, thanks again
John
John |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 02 April 2001 : 20:32:19
|
ajb, try deleting your cookies, see if that makes any difference.
|
|
|
|
ajb
New Member
Australia
81 Posts |
Posted - 02 April 2001 : 20:37:36
|
Hi HuwR
One of the first things I tried, made no difference. The other machines I tried it on had never been into the forum before, so they had no pre-issued cookies and they all came up the same.
John |
|
|
|
RaiderUK
Average Member
United Kingdom
577 Posts |
Posted - 02 April 2001 : 20:41:24
|
have you checked to see if the date and time are set correctly on the server the forum is held on?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 02 April 2001 : 20:42:10
|
In answer to your other question, it is ok to convert your db to 2000.
check the lastheredate filed, and post the string contained in it.
|
|
|
|
ajb
New Member
Australia
81 Posts |
Posted - 02 April 2001 : 20:54:19
|
To RaiderUK ...
Yeah, Date and Time on server are OK
To HuwR ...
Thanks for the info about the conversion. Will post the string very shortly.
John |
|
|
|
ajb
New Member
Australia
81 Posts |
Posted - 02 April 2001 : 23:56:20
|
Hi HuwR
String for the M_LASTTHEREDATE is
20010403100848
Hope this helps
John |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 03 April 2001 : 04:26:02
|
That indicates that the date in the db is correct 3rd April.
try changing the date format used by the forum to see if it makes a difference, I think I had this problem once before if I changed the forums date format after it had been running for a while.
|
|
|
|
ajb
New Member
Australia
81 Posts |
Posted - 03 April 2001 : 06:26:31
|
HuwR
Tried that a few days ago.
Have just tried three different date formats again, without success.
Actually deleted cookies after each change, then logged in again.
No luck. Just downloaded and checked the database again and the format is still the same as my previous post.
Any clues where I go from here ....
John |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 03 April 2001 : 06:35:10
|
do you have a url I can look at ?
|
|
|
|
ajb
New Member
Australia
81 Posts |
Posted - 03 April 2001 : 06:56:25
|
Hi Again HuwR
I have just emailed the link, login, password
Regards and Thanks ....
John |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 03 April 2001 : 07:01:49
|
Cheers, I also registered. interrestingly, if you hit the mark all as read, it gets the date the wrong way round.
Could you tell me the date format the forum is using, and could you send me your inc_top and active.asp files.
|
|
|
|
ajb
New Member
Australia
81 Posts |
Posted - 04 April 2001 : 21:32:43
|
Hi HuwR
Any luck sorting this one out yet ?
As I expected, today is April 5 and my last visited date now shows as May 4th and all topics show as being already read ...
John |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 04 April 2001 : 22:48:37
|
could you save this code as an asp file, copy it to your forum directory and execute it.
then post the results here.
Datetest.asp
<!--#INCLUDE FILE="config.asp" -->
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE FILE="inc_top_short.asp" -->
<div align=left></div>
<b>Raw dates </b><br>
<% lastDate = Session(strCookieURL & "last_here_date") %>
<%= "session var : " & lastDate %><br>
<%= "date in db : " & ReadLastHereDate(strDBNTUserName) %><br><br>
<b>strToDate function</b><br>
<%= "session var : " & strToDate(lastDate) %><br>
<%= "date in db : " & strToDate(ReadLastHereDate(strDBNTUserName)) %><br><br>
<b>chkDate functions</b><br>
<%= "session var : " & chkDate(strToDate(lastDate)) & chkTime(strToDate(lastDate)) %><br>
<%= "date in db : " & chkDate(strToDate(ReadLastHereDate(strDBNTUserName))) & chkTime(strToDate(ReadLastHereDate(strDBNTUserName)))%><br>
</div>
<!--#include file="inc_footer_short.asp"-->
|
|
|
|
Topic |
|
Topic Locked
