[rt-users] Assets not linking to privileged users after upgrade to 4.4.0

John Andersen john at yvig.com
Wed Feb 17 21:16:29 EST 2016


I don't know if I missed a step on the upgrade or what (I did to run
etc/upgrade/upgrade-assets).  My assets are working correctly except for
this:

Any asset linked to a privileged user will not show up as an Assigned Asset
on their user page.   As long as they are a non-privileged user, it seems
to work fine (tested with Held By and Ownder),

I'm sure this search error I get in the log is pointing me to the culprit
but not sure what to do in order to fix the issue or how I might have
caused it.

--

Feb 17 18:10:59 rt RT: [19769] Use of uninitialized value
$args{"GroupsAlias"} in hash element at
/opt/rt4/sbin/../lib/RT/SearchBuilder/Role/Roles.pm line 153.

Feb 17 18:10:59 rt RT: [19769] Use of uninitialized value $args{"ALIAS1"}
in concatenation (.) or string at
/usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm line 1086.

Feb 17 18:10:59 rt RT: [19769] Use of uninitialized value in string eq at
/usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm line 1282.

Feb 17 18:10:59 rt RT: [19769] DBD::Pg::st execute failed: ERROR:  syntax
error at or near "."#012LINE 1: ...bled = '0' ) AND (
CachedGroupMembers_3.GroupId = .id ) JOIN...#012
                                  ^ at
/usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm line 586.

Feb 17 18:10:59 rt RT: [19769] RT::Handle=HASH(0x7f6ca0066e60) 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 CachedGroupMembers
CachedGroupMembers_4  ON ( CachedGroupMembers_4.Disabled = '0' ) AND (
CachedGroupMembers_4.GroupId = .id ) JOIN Groups Groups_1  ON (
LOWER(Groups_1.Domain) = 'rt::asset-role' ) 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 = '151821' )  OR  (
CachedGroupMembers_3.MemberId = '3863' )  OR  (
CachedGroupMembers_4.MemberId = '26' ) ) AND (LOWER(main.Status) !=
'deleted') ' at /usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm
line
599.#012#011DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7f6ca0066e60),
"SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGr"...) called
at /usr/local/share/perl/5.20.2/DBIx/SearchBuilder.pm line
295#012#011DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0x7f6cb4236bb0),
1) called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line
993#012#011RT::SearchBuilder::_DoCount(RT::Assets=HASH(0x7f6cb4236bb0), 1)
called at /opt/rt4/sbin/../lib/RT/Assets.pm line
293#012#011RT::Assets::_DoCount(RT::Assets=HASH(0x7f6cb4236bb0), 1) called
at /usr/local/share/perl/5.20.2/DBIx/SearchBuilder.pm line
1525#012#011DBIx::SearchBuilder::CountAll(RT::Assets=HASH(0x7f6cb4236bb0))
called at /opt/rt4/share/html/Elements/CollectionList line
54#012#011HTML::Mason::Commands::__ANON__("Collection",
RT::Assets=HASH(0x7f6cb4236bb0), "OrderBy", "id", "Order", "ASC", "Format",
"\x{a}    '<b><a href=\"__WebHomePath__/Asset/Display.html?id=__id_"...,
"AllowSorting", ...) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6ca0448688),
"Collection", RT::Assets=HASH(0x7f6cb4236bb0), "OrderBy", "id", "Order",
"ASC", "Format", "\x{a}    '<b><a
href=\"__WebHomePath__/Asset/Display.html?id=__id_"..., ...) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1302#012#011eval
{...} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, "Collection",
RT::Assets=HASH(0x7f6cb4236bb0), "OrderBy", "id", "Order", "ASC", "Format",
...) called at /opt/rt4/share/html/User/Elements/AssetList line
66#012#011HTML::Mason::Commands::__ANON__() called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1380#012#011eval
{...} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1380#012#011HTML::Mason::Request::content(RT::Interface::Web::Request=HASH(0x7f6ca04799d0))
called at /opt/rt4/share/html/Widgets/TitleBox line
56#012#011HTML::Mason::Commands::__ANON__("title", "Assigned Assets",
"class", "user asset-list") called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6ca0439fb0),
"title", "Assigned Assets", "class", "user asset-list") called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1302#012#011eval
{...} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, undef, "title",
"Assigned Assets", "class", "user asset-list") called at
/opt/rt4/share/html/User/Elements/AssetList line
73#012#011HTML::Mason::Commands::__ANON__("User",
RT::User=HASH(0x7f6ca04e4818), "Roles", ARRAY(0x7f6cb8d0cb70), "Title",
"Assigned Assets") called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6cb4236e50),
"User", RT::User=HASH(0x7f6ca04e4818), "Roles", ARRAY(0x7f6cb8d0cb70),
"Title", "Assigned Assets") called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1302#012#011eval
{...} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, "User",
RT::User=HASH(0x7f6ca04e4818), "Roles", ARRAY(0x7f6cb8d0cb70), "Title",
"Assigned Assets") called at
/opt/rt4/share/html/User/Elements/Portlets/UserAssets line
49#012#011HTML::Mason::Commands::__ANON__("User",
RT::User=HASH(0x7f6ca04e4818)) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6cb8d105b8),
"User", RT::User=HASH(0x7f6ca04e4818)) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 1302#012#011eval
{...} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, "User",
RT::User=HASH(0x7f6ca04e4818)) called at
/opt/rt4/share/html/User/Summary.html line
94#012#011HTML::Mason::Commands::__ANON__("UserAssets") called at
/opt/rt4/share/html/User/Summary.html line
57#012#011HTML::Mason::Commands::__ANON__("id", 26) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6ca03b21c8),
"id", 26) called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1302#012#011eval {...} called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, undef, "id", 26)
called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line
696#012#011RT::Interface::Web::ShowRequestedPage(HASH(0x7f6cb031b0e8))
called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line
375#012#011RT::Interface::Web::HandleRequest(HASH(0x7f6cb031b0e8)) called
at /opt/rt4/share/html/autohandler line
53#012#011HTML::Mason::Commands::__ANON__("id", 26) called at
/usr/local/share/perl/5.20.2/HTML/Mason/Component.pm line
135#012#011HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f6ca0142530),
"id", 26) called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1300#012#011eval {...} called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
1292#012#011HTML::Mason::Request::comp(undef, undef, undef, "id", 26)
called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
481#012#011eval {...} called at
/usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line 481#012#011eval
{...} called at /usr/local/share/perl/5.20.2/HTML/Mason/Request.pm line
433#012#011HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0x7f6ca04799d0))
called at /usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler.pm line
96#012#011eval {...} called at
/usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler.pm line
96#012#011HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0x7f6ca04799d0))
called at /usr/local/share/perl/5.20.2/HTML/Mason/Interp.pm line
342#012#011HTML::Mason::Interp::exec(undef, undef, "id", 26) called at
/usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler.pm line 59#012#011eval
{...} called at /usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler.pm line
59#012#011HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x7f6cfe138d60),
HASH(0x7f6cb8c41c60), HASH(0x7f6ca04f4500)) called at
/usr/local/share/perl/5.20.2/HTML/Mason/PSGIHandler/Streamy.pm line
52#012#011HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0x7f6cb8cbb4c0))
called at /usr/local/share/perl/5.20.2/Plack/Util.pm line
339#012#011Plack::Util::__ANON__(CODE(0x7f6ca04c3ec0)) called at
/usr/local/share/perl/5.20.2/Plack/Handler/Apache2.pm line
89#012#011Plack::Handler::Apache2::call_app("Plack::Handler::Apache2",
Apache2::RequestRec=SCALAR(0x7f6ca04cd218), CODE(0x7f6cfe2b5ce0)) called at
/usr/local/share/perl/5.20.2/Plack/Handler/Apache2.pm line
126#012#011Plack::Handler::Apache2::handler(Apache2::RequestRec=SCALAR(0x7f6ca04cd218))
called at -e line 0#012#011eval {...} called at -e line 0
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160217/bfdd8488/attachment.htm>


More information about the rt-users mailing list