My mass email tests all work, and when I sent a campaign into the queue it goes in fine. I have schedulers scheduled hourly and I have a Cron job scheduled on the Solaris box as well.

But when I go to Mass Email Queue Management, nothing will work and this is the error on the page.


Error retrieving EmailMan list: Query Failed:SELECT emailman.* , campaigns.name as campaign_name, email_marketing.name as message_name, (CASE related_type WHEN 'Contacts' THEN CONCAT(CONCAT(contacts.first_name, ' ' ), contacts.last_name) WHEN 'Leads' THEN CONCAT(CONCAT(leads.first_name, ' ' ), leads.last_name) WHEN 'Users' THEN CONCAT(CONCAT(users.first_name, ' ' ), users.last_name) WHEN 'Prospects' THEN CONCAT(CONCAT(prospects.first_name, ' ' ), prospects.last_name) END) recipient_name, (CASE related_type WHEN 'Contacts' THEN contacts.email1 WHEN 'Leads' THEN leads.email1 WHEN 'Users' THEN users.email1 WHEN 'Prospects' THEN prospects.email1 END) recipient_email FROM emailman LEFT JOIN users ON users.id = emailman.related_id and emailman.related_type ='Users' LEFT JOIN contacts ON contacts.id = emailman.related_id and emailman.related_type ='Contacts' LEFT JOIN leads ON leads.id = emailman.related_id and emailman.related_type ='Leads' LEFT JOIN prospects ON prospects.id = emailman.related_id and emailman.related_type ='Prospects' LEFT JOIN prospect_lists ON prospect_lists.id = emailman.list_id LEFT JOIN campaigns ON campaigns.id = emailman.campaign_id LEFT JOIN email_marketing ON email_marketing.id = emailman.marketing_id where emailman.deleted=0 ORDER BY to_email asc LIMIT 0,20::MySQL error 1054: Unknown column 'to_email' in 'order clause'