Results 1 to 1 of 1

Thread: Cannot save email settings - 6.0.2 - Unknown column 'mail_smtptype' in 'field list'

  1. #1
    matty102 is offline Sugar Community Member
    Join Date
    Oct 2007
    Posts
    16

    Arrow Cannot save email settings - 6.0.2 - Unknown column 'mail_smtptype' in 'field list'

    Hi,

    I recently upgraded to 6.0.2 and at the end of the silent upgrade I had the following message;

    Query Failed:ALTER TABLE email_addr_bean_rel modify column bean_module varcha
    r(25) NULL ::MySQL error 1194: Table 'email_addr_bean_rel' is marked as crashed
    and should be repaired

    If I try and save the email settings now I get the following message;

    Query Failed:UPDATE outbound_email SET id = 'e95c8e14-3773-d11d-6752-47fb7c86c846', name = 'system', type = 'system', user_id = '1', mail_sendtype = 'SMTP', mail_smtptype = 'other', mail_smtpserver = '223.223.223.107', mail_smtpport = '25', mail_smtpuser = 'cts-retailadministrator', mail_smtppass = 'UxO8lBay+ls=', mail_smtpauth_req = 1, mail_smtpssl = 0 WHERE id = 'e95c8e14-3773-d11d-6752-47fb7c86c846'::MySQL error 1054: Unknown column 'mail_smtptype' in 'field list'

    I also cannot add email addresses to leads - if I click on the + nothing happens.

    I've done a repair on the table but I'm no expert and a bit lost now so would really appreciate any help?

    Many Thanks
    Matt
    Last edited by matty102; 2010-10-13 at 05:49 PM. Reason: Additional information

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 2010-04-13, 11:10 AM
  2. Replies: 3
    Last Post: 2006-01-12, 11:41 AM
  3. Replies: 11
    Last Post: 2005-12-28, 09:32 PM
  4. Replies: 1
    Last Post: 2005-11-30, 03:15 AM
  5. Replies: 1
    Last Post: 2005-07-15, 04:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •