[rt-users] Error in rt-email-dashboards

fleon fleon at seguroscatatumbo.com
Thu Feb 11 12:59:17 EST 2016

I am getting this error on my mail regarding a CustomRoles table not

[26783] [Thu Feb 11 15:30:02 2016] [warning]: DBD::mysql::st execute failed:
+Table 'rt4.CustomRoles' doesn't exist at
+/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 586.
[26783] [Thu Feb 11 15:30:02 2016] [warning]: RT::Handle=HASH(0x9a9d070)
+couldn't execute the query 'SELECT main.* FROM CustomRoles main  WHERE
+(main.Disabled = '0') ' at
+/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 599.
"SELECT main.* FROM CustomRoles main  WHERE (main.Disabled = '"...) called
+/usr/local/share/perl/5.14.2/DBIx/SearchBuilder.pm line 239
called a
+t /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 982
        RT::SearchBuilder::_DoSearch(RT::CustomRoles=HASH(0xb1d5ee8)) called
+/usr/local/share/perl/5.14.2/DBIx/SearchBuilder.pm line 507
        DBIx::SearchBuilder::Next(RT::CustomRoles=HASH(0xb1d5ee8)) called at
/opt/rt4/sbin/../lib/RT/CustomRoles.pm line 104
        RT::CustomRoles::RegisterRoles("RT::CustomRoles") called at
+n/../lib/RT.pm line 202
        RT::Init() called at /opt/rt4/sbin/rt-email-dashboards line 93

Here are my cron entries:
# Recordatorios RT
#40 8     * * *   root    /opt/rt4/bin/rt-crontool --search
RT::Search::ActiveTicketsInQueue  --search-arg apoyo  --condition
RT::Condition::Overdue --action RT
::Action::SetPriority --action-arg 99 --verbose
#0 8 * * * root /opt/rt4/bin/rt-crontool --search RT::Search::FromSQL
rg "Queue = 'apoyo' AND Owner != 'Nobody' AND (  Status = 'open' OR Status =
'new' ) AND Created < '1 day ago'" --action RT::Action::Notify --action-arg
Owner,AlwaysNotifyActor --template 'Recordatorio' --transaction first
#0 14 * * * root /opt/rt4/bin/rt-crontool --search RT::Search::FromSQL
arg "Queue = 'apoyo' AND Owner != 'Nobody' AND (  Status = 'open' OR Status
= 'new' ) AND Created < '1 day ago'" --action RT::Action::Notify
--action-arg Owner,
AlwaysNotifyActor --template 'Recordatorio' --transaction first

I really don't see anything in the upgrade file regarding this, only some
example with custom roles referencing the CustomRole table (notice it's
CustomRole and not CustomRoles). Is this a bug? I am quite sure i am not
referencing any table regarding custom roles.

View this message in context: http://requesttracker.8502.n7.nabble.com/Error-in-rt-email-dashboards-tp61358.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

More information about the rt-users mailing list