Time Zone

[lemur1]

If the timezone is set to Timezone: UTC+2, how are yvComment, Acajoom reacting?
Olaf

See example:
http://test2.frustless.de/index.php/not ... /2513.html

j conf +2
personal +2
serv +2

article displays time +2 hours relatively local (right) time

yvcomment creates comment with created time -2 hours relatively local (right) time and displays it with right local time by setting above (so, if article displays time +2 hours).

either article has a right time, nor a comment :-((

Leon

[ooffick]

ok, so set it to the correct option +2, and leave it there.

With this setting the time of the comments are correct, right?

If so, use the following output overwrite, to create the right time for the article:

1. create a folder in your template folder called "html" (if it doesn't exists)
2. create a folder in that html folder called "com_content" (if it doesn't exists)
3. create a folder in that com_content folder called "article" (if it doesn't exists)
4. copy the file .../components/com_content/views/article/tmpl/default.php in this .../templates/[your-template]/html/com_content/article/ folder
5. open that file
6. find the following lines:

   Code: Select all

   <?php echo JHTML::_('date', $this->article->created, JText::_('DATE_FORMAT_LC2')) ?>

7. and replace it with the following:

   Code: Select all

   <?php echo JHTML::_('date', $this->article->created, JText::_('DATE_FORMAT_LC2'),0) ?>

8. save the file

This should fix the creation date of the article in the article view.
You might need to play around with the last value:

Code: Select all

<?php echo JHTML::_('date', $this->article->created, JText::_('DATE_FORMAT_LC2'),-2) ?>

Olaf

[yvolk]

Hello, let me add 2 Eurocents to your discussion
1. Please see my recent bug report at JoomlaCode
- it clearly shows that Joomla! code is not consistent in dealing with "created" and "modified" dates of the Articles. Hence the bug in Joomla! core.

To fix it we need to patch Joomla! in the places where it set that "created" and "modified" dates.

2. As I figured out from your discussion, yvComment acts as expected now, so we may safely use this code to determine the rigth value for current date in MySQL format:

Code: Select all

jimport('joomla.utilities.date');
$jnow = new JDate();
$now = $jnow->toMySQL();

The resulted value: $now - may be used to set "created" and "modified" dates,
e.g. in file "components/com_content/models/article.php" you should change

Code: Select all

$article->created = gmdate('Y-m-d H:i:s');

to

Code: Select all

jimport('joomla.utilities.date');
$jnow = new JDate();
$now = $jnow->toMySQL();
$article->created = $now;

Changing template file, as Olaf proposed, is only partial solution, because you will still have inconsistency (in fact, erroneous dates) in the database...

[lemur1]

Hi, Olaf!

Thank you very much!

At least, I have hidden the problem with your solution: the site now looks "normal" out.

But this is only "view" .
The inner is unfortunately not to be changed: there are settings in Joomla that are not understandable and do not work properly.

It really should be a general "joomla-time" , on which must be based all its extensions.

But you have nothing to do with this.

Thanks again!

[lemur1]

Hello, let me add 2 Eurocents to your discussion

Hi, Yury.

I have not seen your post before I replied Olaf.

Now I will test your solution.

Thank you very much!

[ooffick]

I never had any problems with the date and time. But your suggested changes just changing the output to MySQL, right?

Olaf

[yvolk]

I never had any problems with the date and time. But your suggested changes just changing the output to MySQL, right?

Olaf

The example above effectively change date, that is stored in the database. So article, added through the frontend will have correct time now (the code is from the frontend model file).
PS: I never noticed the problem before also

[lemur1]

The resulted value: $now - may be used to set "created" and "modified" dates,
e.g. in file "components/com_content/models/article.php" you should change

Code: Select all

$article->created = gmdate('Y-m-d H:i:s');

to

Code: Select all

jimport('joomla.utilities.date');
$jnow = new JDate();
$now = $jnow->toMySQL();
$article->created = $now;

Changing template file, as Olaf proposed, is only partial solution, because you will still have inconsistency (in fact, erroneous dates) in the database...

Hi,

I'm sorry,
but this solution does not work.
without olaf's changing a created date is shown as +2 hours relative real time (with my setting, see above).

Also in DB has created date for a new article + 2 hours.

Thanks.

P.S.

You can test it here: http://test.frustless.de/index.php/notr ... l?inf=3,16

[ooffick]

You said earlier that the "inner view" is not changed? What do you mean by that?

Olaf

[lemur1]

You said earlier that the "inner view" is not changed? What do you mean by that?

Olaf

I meant exactly what Yuri said:

Changing template file is only partial solution, because there is inconsistency (in fact, erroneous dates) in the database...

I get false created time (+ 2 hours) for an article in DB, if I create it by frontend.
And with you solution (I use it, thanks ) is changed only "view".

Leon

[ooffick]

The time in the database is AFAIK treated as GMT time in the database.

My guess would be that there is a plugin which listens on onBeforeContentSave and modifies the date. But I don't know.

Olaf

[yvolk]

You said earlier that the "inner view" is not changed? What do you mean by that?

Olaf

I meant exactly what Yuri said:

Changing template file is only partial solution, because there is inconsistency (in fact, erroneous dates) in the database...

I get false created time (+ 2 hours) for an article in DB, if I create it by frontend.
And with you solution (I use it, thanks ) is changed only "view".

Leon

Hi Leon, I may suggest 2 things:
1. Debug the code, something like this:

Code: Select all

global $mainframe;
$message = 'point 001, date="' . $article->created  . '"';
$mainframe->enqueueMessage($message, 'notice');

1) just after it is set,
2) before end of the function
...
- to see, what time is stores

2. Try different ways to define the $now date, see e.g. examples in my bug report: there are three different ways to set date of the article, one of them involves timezone offset...

[lemur1]

Thanks to all who took part in the discussion of the problem.
Unfortunately, for working reasons, I can not now continue the experiments (I will use the Olaf's "solution").

Maybe someone else is ready to offer a general solution.

I hope, however, that the problem (will be) noticed by the main developers of Joomla, and will be resolved in the next version of Joomla.

It may be determined a "general"/"single" "Joomla time" for all extensions and a clear algorithm will be presented for computing of this time on the basis of:
- Server time (Zone)
- Joomla -> configuration -> server time Zone
- user -> parameter -> time zone

Leon