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

Martin Wheldon martin.wheldon at greenhills-it.co.uk
Thu Nov 3 06:30:22 EDT 2016


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



More information about the rt-users mailing list