Joomla! Discussion Forums



It is currently Thu Nov 26, 2009 6:48 am (All times are UTC )

 




Post new topic Reply to topic  [ 2 posts ] 
Author Message
Posted: Thu May 24, 2007 8:14 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Thu May 17, 2007 2:48 pm
Posts: 4
Sorry, I'm still a major noob, but this just doesn't make sense.

My joomla server settings are set to EST for time.  My server is set to EST.  Yet when I post a new article, the create date & publish date shows: 2007-05-24 15:08:34 - which is one hour before the current time. 

And, to top it off, my articles aren't publishing because of this for some reason. Now, if I change the publish date to yesterday, or just plain today (without the time)... the article publishes.

Anyone?

THX!


Top
  E-mail  
 
Posted: Fri May 25, 2007 1:21 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Mar 25, 2007 8:30 am
Posts: 12
I'm having the same problem, however mine are being stored in the database with about an 8 hour difference.

I have the "Locale Settings" under Configuration -> Server set to Pacific (UTC - 8) and the admin account time zone is set to is set to Pacific (UTC -8). 

Testing I've done:
Created a test article and noted the Created Date as: 2007-05-24 16:57:20 on the New Article creation screen.

After saving the item, I checked the database and the item shows a created date of: 5/25/2007 12:57:20 AM.

So it looks like the date/time is being stored in GMT time, which makes sense.  However it appears that it is not taking into account daylights savings time since the real time I created that item was 2007-05-25 17:57:20.  I would expect that item to be visible on my sight in approx one hour.

That being said, I have created some items earlier today that are not displaying.

It almost seems like when the page is being rendered, it isn't converting the GMT times back to local times thus not displaying the item.

To test this, I did:
UPDATE jos_content
SET publish_up=NOW()
WHERE id = 78;

and then went to my site and my article was visible. So it seems that the time being stored is not being converted to local time when retrieved.

Any suggestions on what is causing this or do I have something mis-configured?


Top
   
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

Quick reply

 



Who is online

Users browsing this forum: AMD11, keliix06 and 32 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group