Error with Email Templates

[tshepoth]

Dear All

My Sugar system infor is as follows
Sugar Version: 6.0.1
Sugar Edition: SugarCE
Category: Campaigns
Operating System: Windows 7
PHP Version: PHP 5
Database: MySQL 5.0
Webserver: Apache 2.2.9

I recently installed iZeno SMS module. After installation I could not access list and create email templates. When creating the a new template this si what I get:

Sat May 14 18:11:29 2011 [7628][1][ERROR] Query Failed: SELECT email_templates.id , email_templates.name , email_templates.sms_only , email_templates.description , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, email_templates.date_modified , email_templates.assigned_user_id FROM email_templates LEFT JOIN users jt0 ON
jt0.id= email_templates.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where ((email_templates.sms_only = '0' OR email_templates.sms_only IS NULL)) AND email_templates.deleted=0 ORDER BY email_templates.date_entered DESC LIMIT 0,21: MySQL error 1054: Unknown column 'email_templates.sms_only' in 'field list'

Sat May 14 18:11:45 2011 [7628][1][ERROR] Query Failed: SELECT email_templates.id , email_templates.name , email_templates.sms_only , email_templates.description , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, email_templates.date_modified , email_templates.assigned_user_id FROM email_templates LEFT JOIN users jt0 ON
jt0.id= email_templates.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where ((email_templates.sms_only like '1%')) AND email_templates.deleted=0 ORDER BY email_templates.date_entered DESC LIMIT 0,21: MySQL error 1054: Unknown column 'email_templates.sms_only' in 'field list'
Sat May 14 18:13:38 2011 [7628][1][FATAL] Query Failed: INSERT into email_templates set id='baf5d9ef-208d-1be5-44bc-4dceaa874b2a', date_entered='2011-05-14 16:13:38', date_modified='2011-05-14 16:13:38', modified_user_id='1', created_by='1', published='off', name='Testing email', description=null, subject=null, body=null, body_html=null, deleted='0', assigned_user_id=null, text_only='0', sms_only='0': MySQL error 1054: Unknown column 'sms_only' in 'field list'

Can anyone help me as I dont really know what to do.

Regards,

[Angel]

Sounds like something didn't go right when the SMS module was installed as it is querying a non-default field.

You should contact the iZeno folks directly for quicker assistance.

[tshepoth]

Thanks Angel. I suspected that the sms module might have changed some.

Will contact them and post the solution here!

[tshepoth]

The solution is that you need to run the Quick Repair and Rebuild from Admin > Repair after installation.

[Angel]

Cool. Thanks for sharing the solution.