Wrong 'created date' for cases created in portal

💬 General Discussion
1

Hello,

When a portal user creates a new case, the ‘Created’ date/time is always 01/01/1970 00:00 . Can anybody confirm this problem? or is it something that I did wrong?

You can check the screenshot to understand better what I mean:

Thanks for any related info provided.

Kind Regards,
George

2

Hi George,

Which Joomla version are you using? Is this issue just from the portal interface and not SugarCRM? Was the portal user created from SugarCRM?

Thanks,

Will.

3

Any fix for this?

I too have an incorrect date listed on the portal, something like 31/12/1969 19:00.

CRM shows the created date as missing. Case updates from CRM on the portal show the date 5 hours in the future. Joomla local date set correctly, underlying linux for both CRM and Joomla also correct.

4

Attached is my portal List Cases menu item. Seems that the created date is completely blank in SuiteCRM and defaulted to 1969 in Joomla Portal. Updated date and time is for some reason defaulting to 6 hours later than US/Eastern. US/Eastern is the timezone setting in both CLI and Apache php.ini files.

5

Any thoughts on this Will?

6

Hi nbouwsma,

This looks like a bug. What version of SuiteCRM/Joomla! are you running? Have you tried creating cases from SuiteCRM? Does this function as required?

Thanks,

Will.

7

Using 7.0.2 SuiteCRM and todays latest Joomla (3.2.2 I think) and the most recent AOPortal extension for Joomla as of today.

SuiteCRM internal functions seem to work just fine, no date issues that I have observed.

Let me know if you need me to provide anything else, happy to help.

-Nate

8

Do you think that I will have better luck using the 2.x version of joomla?

9

Hi Nate,

I am going to upload the Joomla packages to confirm that they are the up to date versions. I will update this topic once I have done so. If you could test the packages once I have done so that would be great.

Thanks,

Will.

10

No problem at all. I will be happy to test.

11

I still have this problem too, so if there is any test you would like me to do to provide more info, I’ll be glad to do it.

My SuiteCRM version is 7.0.1 (I will update to 7.0.2 one of these days), Joomla is 3.2.1 (will update too) and AOP 1 (I remember downloading 1.1 but inside joomla extensions manager it appears as version ‘1’).

Thanks in advance for any info.

12

Hi guys,

It seems the latest version of AOP is up on the website. This bug will be fixed but I cannot give a definitive date. Thanks for the support.

Will.

1 Like
13

Thanks Will.

14

Hey Will,

Is the Portal “Created Date” Bug impacting 2.5 as well as 3.0 Joomla? Is this impacting only LAMP users?

I am trying to get a solution going and the customer based portal is the final hurdle for me. Time stamps are of course critical from a Case perspective so until this is resolved I can’t migrate my technical staff to SuiteCRM. Any further details regarding roadmap and resolution to the Portal issues would be extremely helpful for me to bubble up to my leadership.

-Nate

15

Tested with 2.5 Joomla as well. Issue persists.

16

Hi Nate,

Thanks for helping to test this out. These bugs will be addressed in future releases.

Thanks,

Will.

17

Hey Will,

Got te email on today’s launch of 7.1 Beta 2. Enhancements included mention the Portal and case creation. Can you please validate if the creation date bug this thread outlines will be squashed or not? I will get my lab updated with the new code from Git today if it does.

Great work on the upcoming release schedule!

-Nate

18

Suite Team confirmed the bug and helped me fix the issue. It will be included in a later release of the Joomla Component.

To fix this date issue-

Add the following key: “update_date_entered”=> true,

To the below array in the Joomla Server /components/com_advancedopenportal/models/SugarCasesConnection.php

public function newCase($contact_id,$subject, $description,$type,$priority,$files){

    $data = array("contact_id"=>$contact_id,
                    "name" => $subject,
                    "status" => 'New',
                    "description" => $description,
                    "type" => $type,
                    "priority" => $priority,
                    [b]"update_date_entered"=> true,[/b]
                );
19

This issue has been fixed in the latest (v1.1.1) portal joomla connectors. They can be found on the suite downloads page.

Thanks to George (RodGer) and Nate (nbouwsma) for highlighting this.

Jim