I was trying to fix problem with SugarPHP mailer after upgrading from SugarCRM 5 to 6 that accidentally lead me to fatal mistake that I delete value in mysql Database for outbound_email that apparently make me unable to log in back to sugarcrm
the error message in log is
Thu Aug 12 21:03:23 2010 [21046][-none-][FATAL] MySQL error 1054: Unknown column 'mail_smtptype' in 'field list'
The the error message in browser
Query Failed:INSERT INTO outbound_email (id, name, type, user_id, mail_sendtype, mail_smtptype, mail_smtpserver, mail_smtpport, mail_smtpuser, mail_smtppass, mail_smtpauth_req, mail_smtpssl) VALUES ('b0d8e33d-6200-3826-c1d1-4c64c92dfb0a', 'system', 'system', '1', 'SMTP', 'other', '', '25', '', '', 1, 0)::MySQL error 1054: Unknown column 'mail_smtptype' in 'field list'
Can anyone help me how to fix this problem? I was checking all sources to find a way to delete or stop last active session


LinkBack URL
About LinkBacks



Reply With Quote

Bookmarks