Hi Martin, Thanks. Looks like I need to do the upgrade. Wasn't planning on that!
Kind regards,
Tom
Tom Robinson
IT Manager/System Administrator
MoTeC Pty Ltd
121 Merrindale Drive
Croydon South
3136 Victoria
Australia
T: +61 3 9761 5050
F: +61 3 9761 5051
E: tom.robin...@motec.com.au
On 03/11/16 21:30, Martin Wheldon wrote:
> Hi Tom,
>
> Just tried this on my RT 4.4.1 install and it works fine, this is probably
> this bug?
>
> From the release notes of RT 4.4.1
> * Fix searching for people associated with Assets (I#31546)
>
> Best Regards
>
> Martin
>
> On 2016-11-03 00:01, Tom Robinson wrote:
>> Sorry, forgot to mentions I'm using RT4 version 4.4.0
>>
>>
>> On 03/11/16 10:37, Tom Robinson wrote:
>>> Hi,
>>>
>>> I'm trying to search my Assets database by People (Owner, Contact or Held
>>> By) but always get "No
>>> assets matching search criteria found.".
>>>
>>> I think there may be an issue with the created query as I'm seeing an error
>>> in the logs. Anyone know
>>> what is causing this?
>>>
>>> Kind regards,
>>> Tom
>>>
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
>>> $args{"GroupsAlias"} in hash
>>> element at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
>>> (/usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm:153)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value
>>> $args{"GroupsAlias"} in hash element
>>> at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
>>> $args{"ALIAS1"} in
>>> concatenation (.) or string at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1086)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value
>>> $args{"ALIAS1"} in concatenation (.)
>>> or string at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value in
>>> string eq at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1282)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value in string eq
>>> at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: DBD::mysql::st execute failed:
>>> You have an error in
>>> your SQL syntax; check the manual that corresponds to your MySQL server
>>> version for the right syntax
>>> to use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain =
>>> 'RT::Asset-Role' ) AND ( Groups_1' at
>>> line 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: You have
>>> an error in your SQL
>>> syntax; check the manual that corresponds to your MySQL server version for
>>> the right syntax to use
>>> near ') JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND
>>> ( Groups_1' at line 1 at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: RT::Handle=HASH(0x8a09ae8)
>>> couldn't execute the query
>>> 'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers
>>> CachedGroupMembers_3 ON (
>>> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId =
>>> .id ) JOIN Groups
>>> Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name =
>>> 'Owner' ) AND (
>>> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2
>>> ON (
>>> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId =
>>> Groups_1.id ) WHERE ( (
>>> CachedGroupMembers_2.MemberId = '22' ) OR ( CachedGroupMembers_3.MemberId
>>> = '0' ) ) AND
>>> (main.Catalog = '4') AND (main.Status != 'deleted') ' at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
>>>
>>> DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
>>> "SELECT COUNT(DISTINCT
>>> main.id) FROM Assets main JOIN CachedGr"...) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm
>>> line 295
>>> DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/SearchBuilder.pm line 993
>>> RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/Assets.pm line 293
>>> RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1471
>>> DBIx::SearchBuilder::Count(RT::Assets=HASH(0xa8943c0)) called at
>>> /var/www/rt4/Asset/Search/index.html line 57
>>> HTML::Mason::Commands::__ANON__("!CF.{Asset Number}", "",
>>> "CF.{OS}", "", "CF.{Express
>>> Service Code}", "", "Status", "", "CF.{Asset Number}", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Component.pm line 135
>>>
>>> HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0xa667330),
>>> "!CF.{Asset
>>> Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", "Status", "",
>>> ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line 1302
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 1292
>>> HTML::Mason::Request::comp(undef, undef, undef, "!CF.{Asset
>>> Number}", "", "CF.{OS}", "",
>>> "CF.{Express Service Code}", "", ...) called at
>>> /usr/local/rt4/lib/RT/Interface/Web.pm line 696
>>> RT::Interface::Web::ShowRequestedPage(HASH(0xa88feb8)) called at
>>> /usr/local/rt4/lib/RT/Interface/Web.pm line 375
>>> RT::Interface::Web::HandleRequest(HASH(0xa88feb8)) called at
>>> /var/www/rt4/autohandler
>>> line 53
>>> HTML::Mason::Commands::__ANON__("!CF.{Asset Number}", "",
>>> "CF.{OS}", "", "CF.{Express
>>> Service Code}", "", "Status", "", "CF.{Type}", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Component.pm line 135
>>>
>>> HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x8a46060),
>>> "!CF.{Asset
>>> Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", "Status", "",
>>> ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line 1297
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 1292
>>> HTML::Mason::Request::comp(undef, undef, undef, "!CF.{Asset
>>> Number}", "", "CF.{OS}", "",
>>> "CF.{Express Service Code}", "", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line
>>> 481
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 481
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 433
>>>
>>> HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0xa609e38))
>>> called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
>>> eval {...} called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
>>>
>>> HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0xa609e38))
>>> called at
>>> /usr/local/share/perl5/HTML/Mason/Interp.pm line 342
>>> HTML::Mason::Interp::exec(undef, undef, "!CF.{Asset Number}", "",
>>> "CF.{OS}", "",
>>> "CF.{Express Service Code}", "", "Status", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
>>> eval {...} called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
>>>
>>> HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x87e5298),
>>> HASH(0xa88d0e0), HASH(0xa715e30)) called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm
>>> line 52
>>> HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0xa8941f8)) called
>>> at
>>> /usr/local/share/perl5/Plack/Util.pm line 339
>>> Plack::Util::__ANON__(CODE(0xa51a8e8)) called at
>>> /usr/local/share/perl5/Plack/Handler/FCGI.pm line 145
>>> Plack::Handler::FCGI::run(Plack::Handler::FCGI=HASH(0x8992168),
>>> CODE(0x8951758)) called at
>>> /usr/local/share/perl5/Plack/Loader.pm line 84
>>> Plack::Loader::run(Plack::Loader=HASH(0x8951668),
>>> Plack::Handler::FCGI=HASH(0x8992168))
>>> called at /usr/local/share/perl5/Plack/Runner.pm line 277
>>> Plack::Runner::run(RT::PlackRunner=HASH(0x87c6850)) called at
>>> /usr/local/rt4/lib/RT/PlackRunner.pm line 141
>>> eval {...} called at /usr/local/rt4/lib/RT/PlackRunner.pm line 141
>>> RT::PlackRunner::run(RT::PlackRunner=HASH(0x87c6850)) called at
>>> /usr/local/rt4/sbin/rt-server.fcgi line 162
>>> (/usr/local/share/perl5/Carp.pm:169)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] RT::Handle=HASH(0x8a09ae8) couldn't
>>> execute the query 'SELECT
>>> COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers
>>> CachedGroupMembers_3 ON (
>>> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId =
>>> .id ) JOIN Groups
>>> Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name =
>>> 'Owner' ) AND (
>>> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2
>>> ON (
>>> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId =
>>> Groups_1.id ) WHERE ( (
>>> CachedGroupMembers_2.MemberId = '22' ) OR ( CachedGroupMembers_3.MemberId
>>> = '0' ) ) AND
>>> (main.Catalog = '4') AND (main.Status != 'deleted') ' at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line
>>> 599.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
>>> "SELECT
>>> COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGr"...) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm line
>>> 295#012#011DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called
>>> at
>>> /usr/local/rt4/lib/RT/SearchBuilder.pm line
>>> 993#012#011RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/Assets.pm line
>>> 293#012#011RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0))
>>> called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line
>>> 1471#012#011DBIx::SearchBuilder::Count(RT::Assets=HASH(0xa8943c0)) called at
>>> /var/www/rt4/Asset/Search/index.html line
>>> 57#012#011HTML::Mason::Commands::__ANON__("!CF.{Asset
>>> Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", "Status", "",
>>> "CF.{Asset Number}",
>>> ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line
>>> 135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0xa667330),
>>> "!CF.{Asset Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "",
>>> "Status", "", ...) called
>>> at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302#012#011eval {...}
>>> called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line
>>> 1292#012#011HTML::Mason::Request::comp(undef,
>>> undef, undef, "!C
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
>>> $num in numeric lt (<) at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 79.
>>> (/usr/local/share/perl5/Locale/Maketext.pm:79)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value $num in
>>> numeric lt (<) at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 79.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
>>> $num in numeric gt (>) at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 79.
>>> (/usr/local/share/perl5/Locale/Maketext.pm:79)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value $num in
>>> numeric gt (>) at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 79.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
>>> $num in int at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 79.
>>> (/usr/local/share/perl5/Locale/Maketext.pm:79)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value $num in int at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 79.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
>>> $num in numeric eq (==) at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 79.
>>> (/usr/local/share/perl5/Locale/Maketext.pm:79)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value $num in
>>> numeric eq (==) at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 79.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
>>> $num in numeric eq (==) at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 64.
>>> (/usr/local/share/perl5/Locale/Maketext.pm:64)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value $num in
>>> numeric eq (==) at
>>> /usr/local/share/perl5/Locale/Maketext.pm line 64.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: DBD::mysql::st execute failed:
>>> You have an error in
>>> your SQL syntax; check the manual that corresponds to your MySQL server
>>> version for the right syntax
>>> to use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain =
>>> 'RT::Asset-Role' ) AND ( Groups_1' at
>>> line 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: You have
>>> an error in your SQL
>>> syntax; check the manual that corresponds to your MySQL server version for
>>> the right syntax to use
>>> near ') JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND
>>> ( Groups_1' at line 1 at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: RT::Handle=HASH(0x8a09ae8)
>>> couldn't execute the query
>>> 'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers
>>> CachedGroupMembers_3 ON (
>>> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId =
>>> .id ) JOIN Groups
>>> Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name =
>>> 'Owner' ) AND (
>>> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2
>>> ON (
>>> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId =
>>> Groups_1.id ) WHERE ( (
>>> CachedGroupMembers_2.MemberId = '22' ) OR ( CachedGroupMembers_3.MemberId
>>> = '0' ) ) AND
>>> (main.Catalog = '4') AND (main.Status != 'deleted' OR main.Status !=
>>> 'deleted') ' at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
>>>
>>> DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
>>> "SELECT COUNT(DISTINCT
>>> main.id) FROM Assets main JOIN CachedGr"...) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm
>>> line 295
>>> DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0), 1) called
>>> at
>>> /usr/local/rt4/lib/RT/SearchBuilder.pm line 993
>>> RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0), 1) called at
>>> /usr/local/rt4/lib/RT/Assets.pm line 293
>>> RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0), 1) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1525
>>> DBIx::SearchBuilder::CountAll(RT::Assets=HASH(0xa8943c0)) called at
>>> /var/www/rt4/Elements/CollectionList line 54
>>> HTML::Mason::Commands::__ANON__("Rows", 50, "Catalog", 4, "Format",
>>> "\x{a} '<a
>>> href=\"__WebHomePath__/Asset/Display.html?id=__id__\">"..., "Order", "ASC",
>>> "PassArguments", ...)
>>> called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135
>>>
>>> HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x9087630),
>>> "Rows", 50,
>>> "Catalog", 4, "Format", "\x{a} '<a
>>> href=\"__WebHomePath__/Asset/Display.html?id=__id__\">"...,
>>> "Order", "ASC", ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 1302
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 1292
>>> HTML::Mason::Request::comp(undef, undef, "Rows", 50, "Catalog", 4,
>>> "Format", "\x{a} '<a
>>> href=\"__WebHomePath__/Asset/Display.html?id=__id__\">"..., "Order", ...)
>>> called at
>>> /var/www/rt4/Asset/Search/index.html line 66
>>> HTML::Mason::Commands::__ANON__("!CF.{Asset Number}", "",
>>> "CF.{OS}", "", "CF.{Express
>>> Service Code}", "", "Status", "", "CF.{Asset Number}", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Component.pm line 135
>>>
>>> HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0xa667330),
>>> "!CF.{Asset
>>> Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", "Status", "",
>>> ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line 1302
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 1292
>>> HTML::Mason::Request::comp(undef, undef, undef, "!CF.{Asset
>>> Number}", "", "CF.{OS}", "",
>>> "CF.{Express Service Code}", "", ...) called at
>>> /usr/local/rt4/lib/RT/Interface/Web.pm line 696
>>> RT::Interface::Web::ShowRequestedPage(HASH(0xa88feb8)) called at
>>> /usr/local/rt4/lib/RT/Interface/Web.pm line 375
>>> RT::Interface::Web::HandleRequest(HASH(0xa88feb8)) called at
>>> /var/www/rt4/autohandler
>>> line 53
>>> HTML::Mason::Commands::__ANON__("!CF.{Asset Number}", "",
>>> "CF.{OS}", "", "CF.{Express
>>> Service Code}", "", "Status", "", "CF.{Type}", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Component.pm line 135
>>>
>>> HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x8a46060),
>>> "!CF.{Asset
>>> Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", "Status", "",
>>> ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line 1297
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 1292
>>> HTML::Mason::Request::comp(undef, undef, undef, "!CF.{Asset
>>> Number}", "", "CF.{OS}", "",
>>> "CF.{Express Service Code}", "", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line
>>> 481
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 481
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 433
>>>
>>> HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0xa609e38))
>>> called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
>>> eval {...} called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
>>>
>>> HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0xa609e38))
>>> called at
>>> /usr/local/share/perl5/HTML/Mason/Interp.pm line 342
>>> HTML::Mason::Interp::exec(undef, undef, "!CF.{Asset Number}", "",
>>> "CF.{OS}", "",
>>> "CF.{Express Service Code}", "", "Status", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
>>> eval {...} called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
>>>
>>> HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x87e5298),
>>> HASH(0xa88d0e0), HASH(0xa715e30)) called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm
>>> line 52
>>> HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0xa8941f8)) called
>>> at
>>> /usr/local/share/perl5/Plack/Util.pm line 339
>>> Plack::Util::__ANON__(CODE(0xa51a8e8)) called at
>>> /usr/local/share/perl5/Plack/Handler/FCGI.pm line 145
>>> Plack::Handler::FCGI::run(Plack::Handler::FCGI=HASH(0x8992168),
>>> CODE(0x8951758)) called at
>>> /usr/local/share/perl5/Plack/Loader.pm line 84
>>> Plack::Loader::run(Plack::Loader=HASH(0x8951668),
>>> Plack::Handler::FCGI=HASH(0x8992168))
>>> called at /usr/local/share/perl5/Plack/Runner.pm line 277
>>> Plack::Runner::run(RT::PlackRunner=HASH(0x87c6850)) called at
>>> /usr/local/rt4/lib/RT/PlackRunner.pm line 141
>>> eval {...} called at /usr/local/rt4/lib/RT/PlackRunner.pm line 141
>>> RT::PlackRunner::run(RT::PlackRunner=HASH(0x87c6850)) called at
>>> /usr/local/rt4/sbin/rt-server.fcgi line 162
>>> (/usr/local/share/perl5/Carp.pm:169)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] RT::Handle=HASH(0x8a09ae8) couldn't
>>> execute the query 'SELECT
>>> COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers
>>> CachedGroupMembers_3 ON (
>>> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId =
>>> .id ) JOIN Groups
>>> Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name =
>>> 'Owner' ) AND (
>>> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2
>>> ON (
>>> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId =
>>> Groups_1.id ) WHERE ( (
>>> CachedGroupMembers_2.MemberId = '22' ) OR ( CachedGroupMembers_3.MemberId
>>> = '0' ) ) AND
>>> (main.Catalog = '4') AND (main.Status != 'deleted' OR main.Status !=
>>> 'deleted') ' at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line
>>> 599.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
>>> "SELECT
>>> COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGr"...) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm line
>>> 295#012#011DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0), 1)
>>> called at
>>> /usr/local/rt4/lib/RT/SearchBuilder.pm line
>>> 993#012#011RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0), 1)
>>> called at
>>> /usr/local/rt4/lib/RT/Assets.pm line
>>> 293#012#011RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0), 1)
>>> called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line
>>> 1525#012#011DBIx::SearchBuilder::CountAll(RT::Assets=HASH(0xa8943c0))
>>> called at
>>> /var/www/rt4/Elements/CollectionList line
>>> 54#012#011HTML::Mason::Commands::__ANON__("Rows", 50,
>>> "Catalog", 4, "Format", "\x{a} '<a
>>> href=\"__WebHomePath__/Asset/Display.html?id=__id__\">"...,
>>> "Order", "ASC", "PassArguments", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Component.pm line
>>> 135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x9087630),
>>> "Rows",
>>> 50, "Catalog", 4, "Format", "\x{a} '<a
>>> href=\"__WebHomePath__/Asset/Display.html?id=__id__\">"..., "Order", "ASC",
>>> ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line 1302#012#011eval {...}
>>> called at /
>>> Nov 3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: You have
>>> an error in your SQL
>>> syntax; check the manual that corresponds to your MySQL server version for
>>> the right syntax to use
>>> near ') JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND
>>> ( Groups_1' at line 1 at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: DBD::mysql::st execute failed:
>>> You have an error in
>>> your SQL syntax; check the manual that corresponds to your MySQL server
>>> version for the right syntax
>>> to use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain =
>>> 'RT::Asset-Role' ) AND ( Groups_1' at
>>> line 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
>>>
>>> ==> messages <==
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: RT::Handle=HASH(0x8a09ae8)
>>> couldn't execute the query
>>> 'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers
>>> CachedGroupMembers_3 ON (
>>> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId =
>>> .id ) JOIN Groups
>>> Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name =
>>> 'Owner' ) AND (
>>> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2
>>> ON (
>>> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId =
>>> Groups_1.id ) WHERE ( (
>>> CachedGroupMembers_2.MemberId = '22' ) OR ( CachedGroupMembers_3.MemberId
>>> = '0' ) ) AND
>>> (main.Catalog = '4') AND (main.Status != 'deleted' OR main.Status !=
>>> 'deleted' OR main.Status !=
>>> 'deleted') ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line
>>> 599.
>>>
>>> DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
>>> "SELECT COUNT(DISTINCT
>>> main.id) FROM Assets main JOIN CachedGr"...) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm
>>> line 295
>>> DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/SearchBuilder.pm line 993
>>> RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/Assets.pm line 293
>>> RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1471
>>> DBIx::SearchBuilder::Count(RT::Assets=HASH(0xa8943c0)) called at
>>> /var/www/rt4/Asset/Search/index.html line 71
>>> HTML::Mason::Commands::__ANON__("!CF.{Asset Number}", "",
>>> "CF.{OS}", "", "CF.{Express
>>> Service Code}", "", "Status", "", "CF.{Asset Number}", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Component.pm line 135
>>>
>>> HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0xa667330),
>>> "!CF.{Asset
>>> Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", "Status", "",
>>> ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line 1302
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 1292
>>> HTML::Mason::Request::comp(undef, undef, undef, "!CF.{Asset
>>> Number}", "", "CF.{OS}", "",
>>> "CF.{Express Service Code}", "", ...) called at
>>> /usr/local/rt4/lib/RT/Interface/Web.pm line 696
>>> RT::Interface::Web::ShowRequestedPage(HASH(0xa88feb8)) called at
>>> /usr/local/rt4/lib/RT/Interface/Web.pm line 375
>>> RT::Interface::Web::HandleRequest(HASH(0xa88feb8)) called at
>>> /var/www/rt4/autohandler
>>> line 53
>>> HTML::Mason::Commands::__ANON__("!CF.{Asset Number}", "",
>>> "CF.{OS}", "", "CF.{Express
>>> Service Code}", "", "Status", "", "CF.{Type}", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Component.pm line 135
>>>
>>> HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x8a46060),
>>> "!CF.{Asset
>>> Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", "Status", "",
>>> ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line 1297
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 1292
>>> HTML::Mason::Request::comp(undef, undef, undef, "!CF.{Asset
>>> Number}", "", "CF.{OS}", "",
>>> "CF.{Express Service Code}", "", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line
>>> 481
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 481
>>> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
>>> line 433
>>>
>>> HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0xa609e38))
>>> called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
>>> eval {...} called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
>>>
>>> HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0xa609e38))
>>> called at
>>> /usr/local/share/perl5/HTML/Mason/Interp.pm line 342
>>> HTML::Mason::Interp::exec(undef, undef, "!CF.{Asset Number}", "",
>>> "CF.{OS}", "",
>>> "CF.{Express Service Code}", "", "Status", ...) called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
>>> eval {...} called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
>>>
>>> HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x87e5298),
>>> HASH(0xa88d0e0), HASH(0xa715e30)) called at
>>> /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm
>>> line 52
>>> HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0xa8941f8)) called
>>> at
>>> /usr/local/share/perl5/Plack/Util.pm line 339
>>> Plack::Util::__ANON__(CODE(0xa51a8e8)) called at
>>> /usr/local/share/perl5/Plack/Handler/FCGI.pm line 145
>>> Plack::Handler::FCGI::run(Plack::Handler::FCGI=HASH(0x8992168),
>>> CODE(0x8951758)) called at
>>> /usr/local/share/perl5/Plack/Loader.pm line 84
>>> Plack::Loader::run(Plack::Loader=HASH(0x8951668),
>>> Plack::Handler::FCGI=HASH(0x8992168))
>>> called at /usr/local/share/perl5/Plack/Runner.pm line 277
>>> Plack::Runner::run(RT::PlackRunner=HASH(0x87c6850)) called at
>>> /usr/local/rt4/lib/RT/PlackRunner.pm line 141
>>> eval {...} called at /usr/local/rt4/lib/RT/PlackRunner.pm line 141
>>> RT::PlackRunner::run(RT::PlackRunner=HASH(0x87c6850)) called at
>>> /usr/local/rt4/sbin/rt-server.fcgi line 162
>>> (/usr/local/share/perl5/Carp.pm:169)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] RT::Handle=HASH(0x8a09ae8) couldn't
>>> execute the query 'SELECT
>>> COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers
>>> CachedGroupMembers_3 ON (
>>> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId =
>>> .id ) JOIN Groups
>>> Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name =
>>> 'Owner' ) AND (
>>> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2
>>> ON (
>>> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId =
>>> Groups_1.id ) WHERE ( (
>>> CachedGroupMembers_2.MemberId = '22' ) OR ( CachedGroupMembers_3.MemberId
>>> = '0' ) ) AND
>>> (main.Catalog = '4') AND (main.Status != 'deleted' OR main.Status !=
>>> 'deleted' OR main.Status !=
>>> 'deleted') ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line
>>> 599.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
>>> "SELECT
>>> COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGr"...) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm line
>>> 295#012#011DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called
>>> at
>>> /usr/local/rt4/lib/RT/SearchBuilder.pm line
>>> 993#012#011RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/Assets.pm line
>>> 293#012#011RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0))
>>> called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line
>>> 1471#012#011DBIx::SearchBuilder::Count(RT::Assets=HASH(0xa8943c0)) called at
>>> /var/www/rt4/Asset/Search/index.html line
>>> 71#012#011HTML::Mason::Commands::__ANON__("!CF.{Asset
>>> Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", "Status", "",
>>> "CF.{Asset Number}",
>>> ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line
>>> 135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0xa667330),
>>> "!CF.{Asset Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "",
>>> "Status", "", ...) called
>>> at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302#012#011eval {...}
>>> called at
>>> /usr/local/share/perl5/HTML/Mason/Request.pm line 1292#012
>>>
>>> ==> httpd/rt4.motec.com.au-ssl_access_log <==
>>> 192.168.0.74 - - [03/Nov/2016:10:36:26 +1100] "GET
>>>
> /Asset/Search/index.html?Catalog=4&Status=&Name=&%21Name=&Description=&%21Description=&Role.Owner=tom.robinson%40motec.com.au&%21Role.Owner=&Role.HeldBy=&%21Role.HeldBy=&Role.Contact=&%21Role.Contact=&SearchAssets=Search&CF.%7BAsset+Number%7D=&%21CF.%7BAsset+Number%7D=&CF.%7BType%7D=&%21CF.%7BType%7D=&CF.%7BService+Tag%7D=&%21CF.%7BService+Tag%7D=&CF.%7BExpress+Service+Code%7D=&%21CF.%7BExpress+Service+Code%7D=&CF.%7BSerial+Number%7D=&%21CF.%7BSerial+Number%7D=&CF.%7BManufacturer%7D=&%21CF.%7BManufacturer%7D=&CF.%7BModel+Type%7D=&%21CF.%7BModel+Type%7D=&CF.%7BModel+Number%7D=&%21CF.%7BModel+Number%7D=&CF.%7BPart+Number%7D=&%21CF.%7BPart+Number%7D=&CF.%7BShip+Date%7D=&%21CF.%7BShip+Date%7D=&CF.%7BWarranty+End%7D=&%21CF.%7BWarranty+End%7D=&CF.%7BLocation%7D=&%21CF.%7BLocation%7D=&CF.%7BSoftware%7D=&%21CF.%7BSoftware%7D=&CF.%7BOS%7D=&%21CF.%7BOS%7D=&CF.%7BMAC+Address%7D=&%21CF.%7BMAC+Address%7D=&CF.%7BMAC+Address+Wifi%7D=&%21CF.%7BMAC+Address+Wifi%7D=&CF.%7BNotes%7D=&%21CF.%7BNotes%7D=&
>
> CF.%7BAttachments%7D=&%21CF.%7BAttachments%7D=
>>> HTTP/1.1" 200 52378
>>>
>>>
>>>
>>>
>>>
>>> ---------
>>> RT 4.4 and RTIR training sessions, and a new workshop day!
>>> https://bestpractical.com/training
>>> * Los Angeles - Q1 2017
>>>
>>
>>
>> ---------
>> RT 4.4 and RTIR training sessions, and a new workshop day!
>> https://bestpractical.com/training
>> * Los Angeles - Q1 2017
> ---------
> RT 4.4 and RTIR training sessions, and a new workshop day!
> https://bestpractical.com/training
> * Los Angeles - Q1 2017
signature.asc
Description: OpenPGP digital signature
--------- RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Los Angeles - January 9-11 2017
