[Vtigercrm-developers] timezone issue
Manu urs
manu.k at vtiger.com
Tue Jul 14 15:57:53 GMT 2015
Hi
Let me make it clear .There are two separate topics discussed in this
thread .
1) Email Related list view issue in 630
<http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573>
The Related email list from contact module showing only three header
field , Subject , Parentid , fields are missing.and sent time is not
showing properly . To fix this issue I have already updated the patch in
this thread.
2) Time is storing in Default_timezone format
<http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8592>
As we are not providing an entry to edit default timezone in Config
Editor, We wont recommend to Edit of config.inc.php to change the default
timezone .Time data should be saved into database in UTC format only.
Regards,
Manu Urs
On Tue, Jul 14, 2015 at 8:44 PM, Garry Brighton <garryatbrighton at gmail.com>
wrote:
> Dont get it Manu.. it means that timezone issue in mentioned emails can
> not be fixed?
> I read thread and it suit perfectly to my case. Emails are attached in UTC
> where my timezone is UTC + 4
> It is not correct obviously. Does the same appear in OnDemand? If not
> maybe just copy piece of code and paste it to open source?
>
> Cheers
>
> On Mon, Jul 13, 2015 at 1:13 PM, Manu urs <manu.k at vtiger.com> wrote:
>
>> Hi
>>
>> Editing config.inc.php for change in default timezone is not allowed, As
>> we are providing an entry to edit configuration changes through Config
>> Editor. Where we not letting user edits the Timezone value. Time data
>> should be saved into database in UTC format only.
>>
>> Regards,
>> Manu Urs
>>
>> On Sat, Jul 11, 2015 at 5:06 AM, Stacey Johnson <
>> stacey.johnson110 at gmail.com> wrote:
>>
>>> Manu, dont you think this is very important issue for those who working
>>> worldwide?
>>> CRM is not for use solely in same timezone. It is hard to catch order in
>>> threads if time is that mixed.
>>> I will be wise to attend to this issue asap
>>>
>>> cheers
>>>
>>> On Thu, Jul 2, 2015 at 12:32 AM, Manu urs <manu.k at vtiger.com> wrote:
>>>
>>>> Hi
>>>>
>>>> Thanks for notifying us. As of now the data's are storing to Database
>>>> in $default_timezone format. We will check the cause of the issue and
>>>> update it in this thread, It is also reported it in trac
>>>> <http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8592> .
>>>>
>>>>
>>>> Regards,
>>>> Manu Urs
>>>>
>>>>
>>>> On Wed, Jul 1, 2015 at 9:43 PM, Phasaphon Kwanrutai <
>>>> sunkohchangresort at gmail.com> wrote:
>>>>
>>>>> Have the same problem here. Additionally each time I click Emails
>>>>> related list link, records are sorted in different pattern - kind of lucky
>>>>> dip...
>>>>> anybody got same issue with vtiger_activity?
>>>>>
>>>>> On Tue, Jun 30, 2015 at 11:51 PM, Stacey Johnson <
>>>>> stacey.johnson110 at gmail.com> wrote:
>>>>>
>>>>>> wrong time is recorded in vtiger_activity, I just cant get where is
>>>>>> code responsible for passing UTC instead of default timezone to this table.
>>>>>>
>>>>>> On Tue, Jun 30, 2015 at 10:53 PM, Stacey Johnson <
>>>>>> stacey.johnson110 at gmail.com> wrote:
>>>>>>
>>>>>>> This did't change issue. System still recording GMT time instead of
>>>>>>> my server time
>>>>>>> Any clue?
>>>>>>>
>>>>>>> Stacey
>>>>>>>
>>>>>>> On Tue, Jun 30, 2015 at 9:59 PM, Manu urs <manu.k at vtiger.com> wrote:
>>>>>>>
>>>>>>>> Hi to resolve the
>>>>>>>> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573 issue
>>>>>>>>
>>>>>>>> In the /modules/Vtiger/models/Module.php replace the (Line no
>>>>>>>> 561-566)
>>>>>>>>
>>>>>>>>
>>>>>>>> *foreach ($list_fields as $key => $fieldInfo) {
>>>>>>>> $columnName = $fieldInfo[1];
>>>>>>>> if(array_key_exists($key, $list_fields_name)){
>>>>>>>> $relatedListFields[$columnName] = $list_fields_name[$key];
>>>>>>>> }
>>>>>>>> }*
>>>>>>>> with the
>>>>>>>>
>>>>>>>>
>>>>>>>> *foreach ($list_fields as $key => $fieldInfo) {
>>>>>>>> foreach ($fieldInfo as $columnName) {
>>>>>>>> if(array_key_exists($key, $list_fields_name)){
>>>>>>>> $relatedListFields[$columnName] = $list_fields_name[$key];
>>>>>>>> }
>>>>>>>> } }*
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> We will address #8282 enhancement in the next release.
>>>>>>>>
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Manu Urs
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Jun 30, 2015 at 7:49 PM, Stacey Johnson <
>>>>>>>> stacey.johnson110 at gmail.com> wrote:
>>>>>>>>
>>>>>>>>> I meant #8282
>>>>>>>>>
>>>>>>>>> On Tue, Jun 30, 2015 at 9:18 PM, Stacey Johnson <
>>>>>>>>> stacey.johnson110 at gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> sure is reproducible but why ticket is open 9 months?
>>>>>>>>>> can you guys look at it before releasing new version please
>>>>>>>>>>
>>>>>>>>>> cheers
>>>>>>>>>> Stacey
>>>>>>>>>>
>>>>>>>>>> On Thu, Jun 11, 2015 at 8:59 PM, Manu urs <manu.k at vtiger.com>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi Stacey,
>>>>>>>>>>>
>>>>>>>>>>> This issue is reproducible due to wrong entry in the related
>>>>>>>>>>> list header fields. Here is a trac link regarding the issue .
>>>>>>>>>>> http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8573
>>>>>>>>>>>
>>>>>>>>>>> Regards,
>>>>>>>>>>> Manu Urs
>>>>>>>>>>>
>>>>>>>>>>> On Thu, Jun 11, 2015 at 9:46 AM, Stacey Johnson <
>>>>>>>>>>> stacey.johnson110 at gmail.com> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> I got set timezone correctly in config.inc and php.ini and
>>>>>>>>>>>> system
>>>>>>>>>>>> Despite that, emails attached to records have UTC time.
>>>>>>>>>>>> Server is in Kuala Lumpur and this causing confusion.
>>>>>>>>>>>> Email is sent from Gmail account where timezone is also set
>>>>>>>>>>>> correctly.
>>>>>>>>>>>> Where to look?
>>>>>>>>>>>>
>>>>>>>>>>>> Stacye
>>>>>>>>>>>>
>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>> http://www.vtiger.com/
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> Regards,
>>>>>>>>>>> Manu
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> http://www.vtiger.com/
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> http://www.vtiger.com/
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Regards,
>>>>>>>> Manu
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> http://www.vtiger.com/
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> http://www.vtiger.com/
>>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> http://www.vtiger.com/
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Manu
>>>>
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>>
>> --
>> Regards,
>> Manu
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
--
Regards,
Manu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150714/7954b86a/attachment.html>
More information about the vtigercrm-developers
mailing list