Search Assets by People gives "No assets matching search criteria found."

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

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.robinson@motec.com.au

signature.asc (198 Bytes)

Trying to sift through this SQL query, I’ve reformatted for a bit of clarity:

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’)

I notice in the first JOIN there appears to be an orphaned ‘.id’. Is there something missing there?

AND ( CachedGroupMembers_3.GroupId = .id )

To what should that .id be associated?

Also, how would one go about repairing this?

Kind regards,
TomOn 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

signature.asc (198 Bytes)

Sorry, forgot to mentions I’m using RT4 version 4.4.0On 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

signature.asc (198 Bytes)

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

Sorry, forgot to mentions I’m using RT4 version 4.4.0

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=

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.robinson@motec.com.auOn 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 (198 Bytes)