I am getting this error on my mail regarding a CustomRoles table not
existing:
[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.
+(/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm: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.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x9a9d070),
“SELECT main.* FROM CustomRoles main WHERE (main.Disabled = '”…) called
at
+/usr/local/share/perl/5.14.2/DBIx/SearchBuilder.pm line 239
DBIx::SearchBuilder::_DoSearch(RT::CustomRoles=HASH(0xb1d5ee8))
called a
+t /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 982
RT::SearchBuilder::_DoSearch(RT::CustomRoles=HASH(0xb1d5ee8)) called
at
+/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
/opt/rt4/sbi
+n/…/lib/RT.pm line 202
RT::Init() called at /opt/rt4/sbin/rt-email-dashboards line 93
(/usr/local/share/perl/5.14.2/Carp.pm:169)
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
–search-a
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
–search-
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