Wrong date and times on orders

[billo007]

Virtuemart 3.2.8 joomla 3.8.2 all of a sudden time is wrong on orders about 3 hours off. Checked time zone in joomla and server and they are both correct any ideas what could of caused it?

[Jörgen]

Hello If i remember correctly virtuemart does not store servertime it stores universal timezone. This is not adjusted for printout.
Regards
Jörgen @ Kreativ Fotografi

[jenkinhill]

Hello If i remember correctly virtuemart does not store servertime it stores universal timezone.

And was eloquently described in https://forum.virtuemart.net/index.php?topic=134222.0

[Mike J]

Hi billo007,

After updating to Virtuemart 3.2.8 / Joomla 3.8.2 my order times are now also out (1 of these 2 updates responsible).

As Virtuemart does not store servertime I take it that Joomla is the culprit... Did you find a solution?

If so could you share?

[Milbo]

Virtuemart should always store in GMT. But there is a bug in vmjsapi.php around line 878 function "date".

just add a "false" as new parameter to the JHtml functions. For example

$formatedDate = JHtml::_('date', $date, vmText::_('DATE_FORMAT_'.$format));

to

$formatedDate = JHtml::_('date', $date, vmText::_('DATE_FORMAT_'.$format),false);

[Mike J]

Many thanks Milbo,

That sorted mine out. Muchly appreciated.

For others:

administrator/components/com_virtuemart/helpers/vmjsapi.php

Line 884 (changed 'null' to 'true') as per:

$formatedDate = JHtml::_('date', $date, vmText::_('DATE_FORMAT_'.$format),null);

to:

$formatedDate = JHtml::_('date', $date, vmText::_('DATE_FORMAT_'.$format),true);

[billo007]

Worked like a charm

Many Thanks

[Milbo]

I am sorry, it is false (I corrected my post). True takes the timezone of the user. false takes the time of timezone of the shop. But okey, most time, it makes no difference if you use true or false

[Mike J]

Ok, nice to know. Many thanks... Awesome work as always!