PDA

View Full Version : Timestamps are all 01/01/70 12:00


dbryar
04-10-2008, 07:26 AM
Hi,

I've got this installed on Mac OS X Server and it runs quite well. Only 3 hours to get completely set up and customised which is pretty neat.

The problem I am seeing is that all the timestamps on announcements are 01/01/70 12:00am
In the DB the announcement_timestamp and announcement_poster fields are NULL

I had a quick look through \components\com_announcements\announcements.php and I can't find anything that is pushing a timestamp on a POST for 'new' or 'edit' tasks

mallgood
04-10-2008, 10:19 AM
The reason the dates are appearing as that date, is because that is basically a date of zero.

As for a reason why you are ending up with a NULL in those 2 fields.. thats a different question.

I believe the timestamp is automatically generated by the SQL database. You may want to pop into your DB tools and verify that the automatic timestamping is turned on.

vendictive
04-15-2008, 11:25 PM
Search the fourms. It's already been explained and fixed a million times in various posts.