Community Forums

ATutor Bug Reports

Timestamp in Announcements


You must be signed-in to post.

AuthorSubject
 
Page: 1 | 2
pmink
Subject: Timestamp in AnnouncementsQuote this post in your reply
We have noticed that when an announcement is added to a course using the Announcements module the date seems to be way off (By 6+ months or so). The date field in the AT_news table does however contain the correct date and the other modules on our site are displaying the date information properly.

ATutor version: 1.5.3.3 using a LAMP config.
Posted: 2007-01-05 15:22:19
cdwise
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
I have the same problem with 15.3.3 but with form posts and content that is added as well. Same type configuraiton Linux, Apache, MySQL.
Posted: 2007-01-07 15:43:12
greg

Avatar for greg
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
ATutor relies on the server time. Make sure the system time is set properly.

type "date" at the command prompt
Posted: 2007-01-07 16:12:30
cdwise
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
My access to the MySQL server is through PHPAdmin only. The web server itself has teh correct time because it shows up correctly when in the classroom.. I have been doing more checking and the host uses MySQL 4.0.
Posted: 2007-01-07 16:19:31
greg

Avatar for greg
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
If the server date is correct, I'm not sure what to tell you. The time seems to be working fine on all the systems I checked.

Have you changed the timezone settings in the ATutor System Preferences?

ATutor 1.5.3.3 does requrie MySQL 4.0.2+,
Posted: 2007-01-08 09:13:31
Johan
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
I have the same problem with timestamp in the forum:

In the forum list, the "last post" column prints :
20070206220232

So, despite the ugly printing, the date is correct.
But, when I enter in this forum, then the "Last comment" column prints: Fri Aug 22 23:00

I think there is a mistake between months and days...

Regards,
Posted: 2007-02-06 16:15:12
greg

Avatar for greg
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
What language are you using?

It could be the translator did not set the date variable correctly. See the translation documentation for details about setting date variables, then you can fix the problem using the admin's language manager.

www.atutor.ca/atutor/docs/translate.php#replace
Posted: 2007-02-07 08:46:26
cdwise
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
I am using English - default language

My dates on the forum page for last updated print as:
20070205094807

This ist the correct date

But on the forum itself it prints as
2008-08-12 08:00

Which is not the correct date and no matter what format I tell it to display in language settings it is always the August 12, 2008 date and not Feb 5 2007 date

Any other suggestions?

In reply to:
What language are you using?

It could be the translator did not set the date variable correctly. See the translation documentation for details about setting date variables, then you can fix the pr...

Posted: 2007-02-07 10:17:38
cdwise
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
I should have added that if I simply check the server date on a php page outside of the atutor install it reports correctly.

In reply to:
I am using English - default language

My dates on the forum page for last updated print as:
20070205094807

This ist the correct date

But on the forum itself it prints as
2008-08-12 08:00
...

Posted: 2007-02-07 10:19:14
greg

Avatar for greg
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
Are other dates throughout ATutor correct? If not, then the server's time is probably incorrect.

At the command line on the server type "date".
Posted: 2007-02-07 10:46:39
cdwise
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
Server time is correct I've already tested this using date(), as I said on the page that lists all the forums and the date last updated the foramt is wrong but the date is correct. while other pages such on the messages themselves the date is wrong.

It seems to me that the dates as they are added to the database are sent incorrectly since content shows timestamps like this:

Last Modified: Friday Oct 19, 2007 - 11:00. Revision: 6. Release Date: Thursday Jan 4, 2007 - 00:00.

Content was created on Dec 28, 2006.and properly released on the date specified.

In reply to:
Are other dates throughout ATutor correct? If not, then the server's time is probably incorrect.

At the command line on the server type "date".

Posted: 2007-02-07 11:22:32
greg

Avatar for greg
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
Tell me if you can reproduce the problem on our demo site. I'm unable to reproduce this problem myself.

All dates are generated by the server. ATutor does not itself generate dates, apart from adjusting the timezone offset if it has been set.
Posted: 2007-02-07 12:05:50
cdwise
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
Greg,

This is a default install with no changes except to the stylesheets hosted on 1and1.com. Until I tried changing the date format per this thread no changes had been made at all.

I have not had this problem before or on your demo site. Dates that are entered automatically on form submission are in error but those that are manually selected such as release date are fine.

I'm willing to let you take a look at it you want.
Posted: 2007-02-07 13:25:35
greg

Avatar for greg
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
We generally charge for this type of service, if you want us to logon to your system and investigate. You might look into a service package or perhaps a one time Login Installation.
Posted: 2007-02-08 10:24:46
berger
Subject: Re: Timestamp in AnnouncementsQuote this post in your reply
Hello,

I work together with Johan on our ATutor, I found the bug:
in the AT_forums_threads table, there are two datetime colums, in our system these columns where declared as TIMESTAMP... I changed the table structure and it works.
I seems too be a bug of the dev team, no ? or maybe the installer that sucks with some versions of MySql ? (our is mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386) - Debian stable)

good luck
Posted: 2007-02-08 17:08:18
 
Page: 1 | 2

You must be signed-in to post.

Related Articles