Hi,
Since two days ago, I'm getting this error for one of the cronjobs of a2billing, and it's causing more than 2500 emails (failures) to be stroed in our mailserver, the error in the failed emails is:
SQL QUERY: SELECT count(*) FROM cc_phonenumber , cc_phonebook , cc_campaign_phonebook, cc_campaign WHERE cc_phonenumber.id_phonebook = cc_phonebook.id AND cc_campaign_phonebook.id_phonebook = cc_phonebook.id AND cc_campaign_phonebook.id_campaign = cc_campaign.id AND cc_campaign.status = 1 AND cc_campaign.startingdate <= CURRENT_TIMESTAMP AND cc_campaign.expirationdate > CURRENT_TIMESTAMP AND cc_campaign.monday = 1 AND cc_campaign.daily_start_time <= CURRENT_TIME AND cc_campaign.daily_stop_time > CURRENT_TIME AND cc_phonenumber.status = 1
Array
(
[0] => Array
(
[0] => 0
[count(*)] => 0
)
)
[No phonenumbers to call now]
I tried to run this cronjob manually, and got the same thing. The only change we have done in the whole server is the hostname, if it's related at all... (strange...
)
Any help highly appreciated...
Ali.