Bug #118171 for RT-Extension-AssetSQL: Weird error

Fri Sep 30 12:00:54 2016 rroginela [...] AmeriCashLoans.net - Ticket created

Subject:	Weird error
Date:	Fri, 30 Sep 2016 16:00:28 +0000
To:	"bug-RT-Extension-AssetSQL [...] rt.cpan.org" <bug-RT-Extension-AssetSQL [...] rt.cpan.org>
From:	Rafal Roginela <rroginela [...] AmeriCashLoans.net>

When navigating to Asset Search: An internal RT error has occurred. Your administrator can find more details in RT's log files. In httpd/err_log: [error]: Can't use an undefined value as a HASH reference at /opt/rt4/local/plugins/RT-Extension-AssetSQL/html/Asset/Search/Elements/BuildFormatString line 58 Nothing else in any logs I can find. If anything else is needed please let me know and thank you for your help. Thank you, Rafal Roginela Manager of Information Systems AmeriCash Loans, LLC 880 Lee Street, Suite 302 Des Plaines, IL 60016 Office (847) 827-9740 x109 Fax (847) 493-8031 rroginela@americashloans.net Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.

Fri Sep 30 13:10:34 2016 cbrandt [...] cpan.org - Correspondence added

Hi Rafal, Can you tell us: 1) What version are you running? 2) What does your AssetSearchFormat configuration option look like? Thanks, Jim On Fri Sep 30 12:00:54 2016, rroginela@AmeriCashLoans.net wrote: Show quoted text

> When navigating to Asset Search: > > An internal RT error has occurred. Your administrator can find more > details in RT's log files. > > In httpd/err_log: > > [error]: Can't use an undefined value as a HASH reference at > /opt/rt4/local/plugins/RT-Extension- > AssetSQL/html/Asset/Search/Elements/BuildFormatString line 58 > > Nothing else in any logs I can find. If anything else is needed please > let me know and thank you for your help. > > > > Thank you, > Rafal Roginela > Manager of Information Systems > AmeriCash Loans, LLC > 880 Lee Street, Suite 302 > Des Plaines, IL 60016 > Office (847) 827-9740 x109 > Fax (847) 493-8031 > rroginela@americashloans.net > > Disclaimer > > The information contained in this communication from the sender is > confidential. It is intended solely for use by the recipient and > others authorized to receive it. If you are not the recipient, you are > hereby notified that any disclosure, copying, distribution or taking > action in relation of the contents of this information is strictly > prohibited and may be unlawful. > > This email has been scanned for viruses and malware, and may have been > automatically archived by Mimecast Ltd, an innovator in Software as a > Service (SaaS) for business. Providing a safer and more useful place > for your human generated data. Specializing in; Security, archiving > and compliance. To find out more visit the Mimecast website.

Fri Sep 30 13:10:34 2016 The RT System itself - Status changed from 'new' to 'open'

Fri Sep 30 13:34:31 2016 rroginela [...] AmeriCashLoans.net - Correspondence added

Subject:	RE: [rt.cpan.org #118171] Weird error
Date:	Fri, 30 Sep 2016 17:34:08 +0000
To:	"bug-RT-Extension-AssetSQL [...] rt.cpan.org" <bug-RT-Extension-AssetSQL [...] rt.cpan.org>
From:	Rafal Roginela <rroginela [...] AmeriCashLoans.net>

Hi, 1) We are running 4.4.0 and we did apply the patch in the article 2) Not sure where that is set and I have not set anything like that, just followed the steps from the article here: https://metacpan.org/pod/distribution/RT-Extension-AssetSQL/lib/RT/Extension/AssetSQL.pm Thank you, Rafal Roginela Manager of Information Systems AmeriCash Loans, LLC 880 Lee Street, Suite 302 Des Plaines, IL 60016 Office (847) 827-9740 x109 Fax (847) 493-8031 rroginela@americashloans.net Show quoted text

-----Original Message----- From: Jim Brandt via RT [mailto:bug-RT-Extension-AssetSQL@rt.cpan.org] Sent: Friday, September 30, 2016 12:11 PM To: Rafal Roginela <rroginela@AmeriCashLoans.net> Subject: [rt.cpan.org #118171] Weird error <URL: https://rt.cpan.org/Ticket/Display.html?id=118171 > Hi Rafal, Can you tell us: 1) What version are you running? 2) What does your AssetSearchFormat configuration option look like? Thanks, Jim On Fri Sep 30 12:00:54 2016, rroginela@AmeriCashLoans.net wrote:

> When navigating to Asset Search: > > An internal RT error has occurred. Your administrator can find more > details in RT's log files. > > In httpd/err_log: > > [error]: Can't use an undefined value as a HASH reference at > /opt/rt4/local/plugins/RT-Extension- > AssetSQL/html/Asset/Search/Elements/BuildFormatString line 58 > > Nothing else in any logs I can find. If anything else is needed please > let me know and thank you for your help. > > > > Thank you, > Rafal Roginela > Manager of Information Systems > AmeriCash Loans, LLC > 880 Lee Street, Suite 302 > Des Plaines, IL 60016 > Office (847) 827-9740 x109 > Fax (847) 493-8031 > rroginela@americashloans.net > > Disclaimer > > The information contained in this communication from the sender is > confidential. It is intended solely for use by the recipient and > others authorized to receive it. If you are not the recipient, you are > hereby notified that any disclosure, copying, distribution or taking > action in relation of the contents of this information is strictly > prohibited and may be unlawful. > > This email has been scanned for viruses and malware, and may have been > automatically archived by Mimecast Ltd, an innovator in Software as a > Service (SaaS) for business. Providing a safer and more useful place > for your human generated data. Specializing in; Security, archiving > and compliance. To find out more visit the Mimecast website.

Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.

Fri Sep 30 13:48:37 2016 cbrandt [...] cpan.org - Correspondence added

On Fri Sep 30 13:34:31 2016, rroginela@AmeriCashLoans.net wrote: Show quoted text

> Hi, > > 1) We are running 4.4.0 and we did apply the patch in the article > 2) Not sure where that is set and I have not set anything like that, > just followed the steps from the article here: > https://metacpan.org/pod/distribution/RT-Extension- > AssetSQL/lib/RT/Extension/AssetSQL.pm >

Thanks. And version of the extension?

Fri Sep 30 13:51:20 2016 rroginela [...] AmeriCashLoans.net - Correspondence added

Subject:	RE: [rt.cpan.org #118171] Weird error
Date:	Fri, 30 Sep 2016 17:51:04 +0000
To:	"bug-RT-Extension-AssetSQL [...] rt.cpan.org" <bug-RT-Extension-AssetSQL [...] rt.cpan.org>
From:	Rafal Roginela <rroginela [...] AmeriCashLoans.net>

Sorry.. cpan[2]> install RT::Extension::AssetSQL Reading '/root/.cpan/sources/authors/01mailrc.txt.gz' ............................................................................DONE Reading '/root/.cpan/sources/modules/02packages.details.txt.gz' Database was generated on Fri, 30 Sep 2016 16:53:44 GMT ............................................................................DONE Fetching with LWP: http://www.cpan.org/modules/03modlist.data.gz Reading '/root/.cpan/sources/modules/03modlist.data.gz' DONE Writing /root/.cpan/Metadata Running install for module 'RT::Extension::AssetSQL' Fetching with LWP: http://www.cpan.org/authors/id/B/BP/BPS/RT-Extension-AssetSQL-0.03.tar.gz CPAN: Digest::SHA loaded ok (v5.95) Checksum for /root/.cpan/sources/authors/id/B/BP/BPS/RT-Extension-AssetSQL-0.03.tar.gz ok Scanning cache /root/.cpan/build for sizes ............................................................----------------DONE Thank you, Rafal Roginela Manager of Information Systems AmeriCash Loans, LLC 880 Lee Street, Suite 302 Des Plaines, IL 60016 Office (847) 827-9740 x109 Fax (847) 493-8031 rroginela@americashloans.net Show quoted text

-----Original Message----- From: Jim Brandt via RT [mailto:bug-RT-Extension-AssetSQL@rt.cpan.org] Sent: Friday, September 30, 2016 12:49 PM To: Rafal Roginela <rroginela@AmeriCashLoans.net> Subject: [rt.cpan.org #118171] Weird error <URL: https://rt.cpan.org/Ticket/Display.html?id=118171 > On Fri Sep 30 13:34:31 2016, rroginela@AmeriCashLoans.net wrote:

> Hi, > > 1) We are running 4.4.0 and we did apply the patch in the article > 2) Not sure where that is set and I have not set anything like that, > just followed the steps from the article here: > https://metacpan.org/pod/distribution/RT-Extension- > AssetSQL/lib/RT/Extension/AssetSQL.pm >

Thanks. And version of the extension? Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.

Thu Oct 06 14:55:02 2016 cbrandt [...] cpan.org - Correspondence added

It looks like some extra configuration snuck in there. For now, try adding this to RT_SiteConfig.pm: Set($CustomDateRanges, {}); On Fri Sep 30 13:51:20 2016, rroginela@AmeriCashLoans.net wrote: Show quoted text

> Sorry.. > > cpan[2]> install RT::Extension::AssetSQL > Reading '/root/.cpan/sources/authors/01mailrc.txt.gz' > ............................................................................DONE > Reading '/root/.cpan/sources/modules/02packages.details.txt.gz' > Database was generated on Fri, 30 Sep 2016 16:53:44 GMT > ............................................................................DONE > Fetching with LWP: > http://www.cpan.org/modules/03modlist.data.gz > Reading '/root/.cpan/sources/modules/03modlist.data.gz' > DONE > Writing /root/.cpan/Metadata > Running install for module 'RT::Extension::AssetSQL' > Fetching with LWP: > http://www.cpan.org/authors/id/B/BP/BPS/RT-Extension-AssetSQL- > 0.03.tar.gz > CPAN: Digest::SHA loaded ok (v5.95) > Checksum for /root/.cpan/sources/authors/id/B/BP/BPS/RT-Extension- > AssetSQL-0.03.tar.gz ok > Scanning cache /root/.cpan/build for sizes > ............................................................---------------- > DONE > > > > Thank you, > > Rafal Roginela > Manager of Information Systems > > AmeriCash Loans, LLC > 880 Lee Street, Suite 302 > Des Plaines, IL 60016 > > Office (847) 827-9740 x109 > Fax (847) 493-8031 > > rroginela@americashloans.net > > -----Original Message----- > From: Jim Brandt via RT [mailto:bug-RT-Extension- > AssetSQL@rt.cpan.org] > Sent: Friday, September 30, 2016 12:49 PM > To: Rafal Roginela <rroginela@AmeriCashLoans.net> > Subject: [rt.cpan.org #118171] Weird error > > <URL: https://rt.cpan.org/Ticket/Display.html?id=118171 > > > On Fri Sep 30 13:34:31 2016, rroginela@AmeriCashLoans.net wrote:

> > Hi, > > > > 1) We are running 4.4.0 and we did apply the patch in the article > > 2) Not sure where that is set and I have not set anything like that, > > just followed the steps from the article here: > > https://metacpan.org/pod/distribution/RT-Extension- > > AssetSQL/lib/RT/Extension/AssetSQL.pm > >

> > Thanks. And version of the extension? > > Disclaimer > > The information contained in this communication from the sender is > confidential. It is intended solely for use by the recipient and > others authorized to receive it. If you are not the recipient, you are > hereby notified that any disclosure, copying, distribution or taking > action in relation of the contents of this information is strictly > prohibited and may be unlawful. > > This email has been scanned for viruses and malware, and may have been > automatically archived by Mimecast Ltd, an innovator in Software as a > Service (SaaS) for business. Providing a safer and more useful place > for your human generated data. Specializing in; Security, archiving > and compliance. To find out more visit the Mimecast website.

Thu Oct 06 15:01:08 2016 rroginela [...] AmeriCashLoans.net - Correspondence added

Subject:	RE: [rt.cpan.org #118171] Weird error
Date:	Thu, 6 Oct 2016 19:00:46 +0000
To:	"bug-RT-Extension-AssetSQL [...] rt.cpan.org" <bug-RT-Extension-AssetSQL [...] rt.cpan.org>
From:	Rafal Roginela <rroginela [...] AmeriCashLoans.net>

Looks good, thanks so much for your help! Thank you, Rafal Roginela Manager of Information Systems AmeriCash Loans, LLC 880 Lee Street, Suite 302 Des Plaines, IL 60016 Office (847) 827-9740 x109 Fax (847) 493-8031 rroginela@americashloans.net Show quoted text

-----Original Message----- From: Jim Brandt via RT [mailto:bug-RT-Extension-AssetSQL@rt.cpan.org] Sent: Thursday, October 6, 2016 1:55 PM To: Rafal Roginela <rroginela@AmeriCashLoans.net> Subject: [rt.cpan.org #118171] Weird error <URL: https://rt.cpan.org/Ticket/Display.html?id=118171 > It looks like some extra configuration snuck in there. For now, try adding this to RT_SiteConfig.pm: Set($CustomDateRanges, {}); On Fri Sep 30 13:51:20 2016, rroginela@AmeriCashLoans.net wrote:

> Sorry.. > > cpan[2]> install RT::Extension::AssetSQL Reading > '/root/.cpan/sources/authors/01mailrc.txt.gz' > ...................................................................... > ......DONE Reading > '/root/.cpan/sources/modules/02packages.details.txt.gz' > Database was generated on Fri, 30 Sep 2016 16:53:44 GMT > ...................................................................... > ......DONE > Fetching with LWP: > http://www.cpan.org/modules/03modlist.data.gz > Reading '/root/.cpan/sources/modules/03modlist.data.gz' > DONE > Writing /root/.cpan/Metadata > Running install for module 'RT::Extension::AssetSQL' > Fetching with LWP: > http://www.cpan.org/authors/id/B/BP/BPS/RT-Extension-AssetSQL- > 0.03.tar.gz > CPAN: Digest::SHA loaded ok (v5.95) > Checksum for /root/.cpan/sources/authors/id/B/BP/BPS/RT-Extension- > AssetSQL-0.03.tar.gz ok > Scanning cache /root/.cpan/build for sizes > ............................................................---------- > ------ > DONE > > > > Thank you, > > Rafal Roginela > Manager of Information Systems > > AmeriCash Loans, LLC > 880 Lee Street, Suite 302 > Des Plaines, IL 60016 > > Office (847) 827-9740 x109 > Fax (847) 493-8031 > > rroginela@americashloans.net > > -----Original Message----- > From: Jim Brandt via RT [mailto:bug-RT-Extension- > AssetSQL@rt.cpan.org] > Sent: Friday, September 30, 2016 12:49 PM > To: Rafal Roginela <rroginela@AmeriCashLoans.net> > Subject: [rt.cpan.org #118171] Weird error > > <URL: https://rt.cpan.org/Ticket/Display.html?id=118171 > > > On Fri Sep 30 13:34:31 2016, rroginela@AmeriCashLoans.net wrote:

> > Hi, > > > > 1) We are running 4.4.0 and we did apply the patch in the article > > 2) Not sure where that is set and I have not set anything like > > that, just followed the steps from the article here: > > https://metacpan.org/pod/distribution/RT-Extension- > > AssetSQL/lib/RT/Extension/AssetSQL.pm > >

> > Thanks. And version of the extension? > > Disclaimer > > The information contained in this communication from the sender is > confidential. It is intended solely for use by the recipient and > others authorized to receive it. If you are not the recipient, you are > hereby notified that any disclosure, copying, distribution or taking > action in relation of the contents of this information is strictly > prohibited and may be unlawful. > > This email has been scanned for viruses and malware, and may have been > automatically archived by Mimecast Ltd, an innovator in Software as a > Service (SaaS) for business. Providing a safer and more useful place > for your human generated data. Specializing in; Security, archiving > and compliance. To find out more visit the Mimecast website.

Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.