After upgrading from version 4.4.1 to 4.4.2 does not work rt-crontool when I use the following command to send me a notification email:
/opt/rt4/bin/rt-crontool --search RT::Search::FromSQL --search-arg ‘Type = “ticket” and (Status = “open” or Status = “new”) and (CustomFieldValue = “Recomendacion_Aplicación_75_dias”)’ --condition RT::Condition::Overdue --condition-arg 1d --action RT::Action::NotifyGroup --action-arg user@gmail.con --transaction first --template ‘Reminder before due ticket’ --verbose --log debug
The error is:
[26016] [Wed Aug 30 00:25:47 2017] [debug]: Using internal Perl HTML -> text conversion (/opt/rt4/bin/…/lib/RT/Interface/Email.pm:1475)
[26016] [Wed Aug 30 00:25:47 2017] [error]: Couldn’t parse query: No field specified at /opt/rt4/bin/…/lib/RT/Tickets.pm line 1271, line 522. (/opt/rt4/bin/…/lib/RT/Tickets.pm:3209)
Trace begun at /opt/rt4/bin/…/lib/RT.pm line 309
Log::Dispatch::ANON(‘Log::Dispatch=HASH(0x4321938)’, ‘Couldn’t parse query: No field specified at /opt/rt4/bin/…/lib/RT/Tickets.pm line 1271, line 522.^J’) called at /opt/rt4/bin/…/lib/RT/Tickets.pm line 3209
RT:
:FromSQL(‘RT::Tickets=HASH(0x7290258)’, ‘Type = “ticket” and (Status = “open” or Status = “new”) and (CustomFieldValue = “Recomendacion_AplicaciM-CM-3n_75_dias”)’) called at /opt/rt4/bin/…/lib/RT/Search/FromSQL.pm line 94
RT::Search::FromSQL::Prepare(‘RT::Search::FromSQL=HASH(0x729e3c8)’) called at /opt/rt4/bin/rt-crontool line 153
See a especific error:
“No field specified” I was ussing “CustomFieldValue”
Some help please.