Re: [rt-users] Search Assets by People gives "No assets matching search criteria found."

Martin Wheldon Thu, 03 Nov 2016 03:32:25 -0700

Hi Tom,

Just tried this on my RT 4.4.1 install and it works fine, this isprobably 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 orHeld 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 anerror 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 uninitializedvalue $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 uninitializedvalue $args{"ALIAS1"} inconcatenation (.) 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 line1086.
==> httpd/error_log <==
[2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitializedvalue 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 instring 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 executefailed: You have an error inyour SQL syntax; check the manual that corresponds to your MySQLserver version for the right syntaxto use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain ='RT::Asset-Role' ) AND ( Groups_1' atline 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line586.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)

==> messages <==
Nov 3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: Youhave an error in your SQLsyntax; check the manual that corresponds to your MySQL server versionfor the right syntax to usenear ') 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 JOINCachedGroupMembers CachedGroupMembers_3 ON (CachedGroupMembers_3.Disabled = '0' ) AND (CachedGroupMembers_3.GroupId = .id ) JOIN GroupsGroups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND (Groups_1.Name = 'Owner' ) AND (Groups_1.Instance = main.id ) JOIN CachedGroupMembersCachedGroupMembers_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(DISTINCTmain.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)) calledat
/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)) calledat
/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.{AssetNumber}", "", "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 1292HTML::Mason::Request::comp(undef, undef, undef, "!CF.{AssetNumber}", "", "CF.{OS}", "","CF.{Express Service Code}", "", ...) called at/usr/local/rt4/lib/RT/Interface/Web.pm line 696RT::Interface::Web::ShowRequestedPage(HASH(0xa88feb8)) calledat
/usr/local/rt4/lib/RT/Interface/Web.pm line 375
RT::Interface::Web::HandleRequest(HASH(0xa88feb8)) called at/var/www/rt4/autohandler line 53HTML::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.{AssetNumber}", "", "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 1292HTML::Mason::Request::comp(undef, undef, undef, "!CF.{AssetNumber}", "", "CF.{OS}", "","CF.{Express Service Code}", "", ...) called at/usr/local/share/perl5/HTML/Mason/Request.pm line 481eval {...} called at/usr/local/share/perl5/HTML/Mason/Request.pm line 481eval {...} called at/usr/local/share/perl5/HTML/Mason/Request.pm line 433HTML::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 96HTML::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 59HTML::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 line141RT::PlackRunner::run(RT::PlackRunner=HASH(0x87c6850)) calledat/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'texecute the query 'SELECTCOUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembersCachedGroupMembers_3 ON (CachedGroupMembers_3.Disabled = '0' ) AND (CachedGroupMembers_3.GroupId = .id ) JOIN GroupsGroups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND (Groups_1.Name = 'Owner' ) AND (Groups_1.Instance = main.id ) JOIN CachedGroupMembersCachedGroupMembers_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 line293#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 line57#012#011HTML::Mason::Commands::__ANON__("!CF.{AssetNumber}", "", "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", "", ...) calledat /usr/local/share/perl5/HTML/Mason/Request.pm line 1302#012#011eval{...} called at/usr/local/share/perl5/HTML/Mason/Request.pm line1292#012#011HTML::Mason::Request::comp(undef,
undef, undef, "!C

==> httpd/error_log <==
[2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitializedvalue $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 innumeric 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 uninitializedvalue $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 innumeric 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 uninitializedvalue $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 inint at
/usr/local/share/perl5/Locale/Maketext.pm line 79.

==> httpd/error_log <==
[2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitializedvalue $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 innumeric 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 uninitializedvalue $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 innumeric 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 executefailed: You have an error inyour SQL syntax; check the manual that corresponds to your MySQLserver version for the right syntaxto use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain ='RT::Asset-Role' ) AND ( Groups_1' atline 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line586.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)

==> messages <==
Nov 3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: Youhave an error in your SQLsyntax; check the manual that corresponds to your MySQL server versionfor the right syntax to usenear ') 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 JOINCachedGroupMembers CachedGroupMembers_3 ON (CachedGroupMembers_3.Disabled = '0' ) AND (CachedGroupMembers_3.GroupId = .id ) JOIN GroupsGroups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND (Groups_1.Name = 'Owner' ) AND (Groups_1.Instance = main.id ) JOIN CachedGroupMembersCachedGroupMembers_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(DISTINCTmain.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} '<ahref=\"__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} '<ahref=\"__WebHomePath__/Asset/Display.html?id=__id__\">"...,"Order", "ASC", ...) called at/usr/local/share/perl5/HTML/Mason/Request.pm line 1302eval {...} called at/usr/local/share/perl5/HTML/Mason/Request.pm line 1292HTML::Mason::Request::comp(undef, undef, "Rows", 50,"Catalog", 4, "Format", "\x{a} '<ahref=\"__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.{AssetNumber}", "", "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 1292HTML::Mason::Request::comp(undef, undef, undef, "!CF.{AssetNumber}", "", "CF.{OS}", "","CF.{Express Service Code}", "", ...) called at/usr/local/rt4/lib/RT/Interface/Web.pm line 696RT::Interface::Web::ShowRequestedPage(HASH(0xa88feb8)) calledat
/usr/local/rt4/lib/RT/Interface/Web.pm line 375
RT::Interface::Web::HandleRequest(HASH(0xa88feb8)) called at/var/www/rt4/autohandler line 53HTML::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.{AssetNumber}", "", "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 1292HTML::Mason::Request::comp(undef, undef, undef, "!CF.{AssetNumber}", "", "CF.{OS}", "","CF.{Express Service Code}", "", ...) called at/usr/local/share/perl5/HTML/Mason/Request.pm line 481eval {...} called at/usr/local/share/perl5/HTML/Mason/Request.pm line 481eval {...} called at/usr/local/share/perl5/HTML/Mason/Request.pm line 433HTML::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 96HTML::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 59HTML::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 line141RT::PlackRunner::run(RT::PlackRunner=HASH(0x87c6850)) calledat/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'texecute the query 'SELECTCOUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembersCachedGroupMembers_3 ON (CachedGroupMembers_3.Disabled = '0' ) AND (CachedGroupMembers_3.GroupId = .id ) JOIN GroupsGroups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND (Groups_1.Name = 'Owner' ) AND (Groups_1.Instance = main.id ) JOIN CachedGroupMembersCachedGroupMembers_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 line293#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 line54#012#011HTML::Mason::Commands::__ANON__("Rows", 50,"Catalog", 4, "Format", "\x{a} '<ahref=\"__WebHomePath__/Asset/Display.html?id=__id__\">"...,"Order", "ASC", "PassArguments", ...) called at/usr/local/share/perl5/HTML/Mason/Component.pm line135#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: Youhave an error in your SQLsyntax; check the manual that corresponds to your MySQL server versionfor the right syntax to usenear ') 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 executefailed: You have an error inyour SQL syntax; check the manual that corresponds to your MySQLserver version for the right syntaxto use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain ='RT::Asset-Role' ) AND ( Groups_1' atline 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line586.
(/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 JOINCachedGroupMembers CachedGroupMembers_3 ON (CachedGroupMembers_3.Disabled = '0' ) AND (CachedGroupMembers_3.GroupId = .id ) JOIN GroupsGroups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND (Groups_1.Name = 'Owner' ) AND (Groups_1.Instance = main.id ) JOIN CachedGroupMembersCachedGroupMembers_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.pmline 599.DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),"SELECT COUNT(DISTINCTmain.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)) calledat
/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)) calledat
/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.{AssetNumber}", "", "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 1292HTML::Mason::Request::comp(undef, undef, undef, "!CF.{AssetNumber}", "", "CF.{OS}", "","CF.{Express Service Code}", "", ...) called at/usr/local/rt4/lib/RT/Interface/Web.pm line 696RT::Interface::Web::ShowRequestedPage(HASH(0xa88feb8)) calledat
/usr/local/rt4/lib/RT/Interface/Web.pm line 375
RT::Interface::Web::HandleRequest(HASH(0xa88feb8)) called at/var/www/rt4/autohandler line 53HTML::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.{AssetNumber}", "", "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 1292HTML::Mason::Request::comp(undef, undef, undef, "!CF.{AssetNumber}", "", "CF.{OS}", "","CF.{Express Service Code}", "", ...) called at/usr/local/share/perl5/HTML/Mason/Request.pm line 481eval {...} called at/usr/local/share/perl5/HTML/Mason/Request.pm line 481eval {...} called at/usr/local/share/perl5/HTML/Mason/Request.pm line 433HTML::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 96HTML::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 59HTML::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 line141RT::PlackRunner::run(RT::PlackRunner=HASH(0x87c6850)) calledat/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'texecute the query 'SELECTCOUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembersCachedGroupMembers_3 ON (CachedGroupMembers_3.Disabled = '0' ) AND (CachedGroupMembers_3.GroupId = .id ) JOIN GroupsGroups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND (Groups_1.Name = 'Owner' ) AND (Groups_1.Instance = main.id ) JOIN CachedGroupMembersCachedGroupMembers_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.pmline599.#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 line293#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 line71#012#011HTML::Mason::Commands::__ANON__("!CF.{AssetNumber}", "", "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", "", ...) calledat /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

Re: [rt-users] Search Assets by People gives "No assets matching search criteria found."

Reply via email to