Results 1 to 3 of 3

Thread: auto reply fails

  1. #1
    celilo is offline Sugar Community Member
    Join Date
    Mar 2006
    Posts
    14

    Default auto reply fails

    Hi I'm a total newbie to Sugar. Install of latest version (SugarSuite-4.0.1c.zip) seemed to go smoothly, but I am having a problem with the autoreply feature not working.

    I turned on logging and this, I believe, is the pertinent info containing the error.
    Code:
    Fri Mar  3 23:03:02 2006,230 [12797] DEBUG  - looking for a case for test7
    Fri Mar  3 23:03:02 2006,231 [12797] DEBUG  - found auto-reply template id - prefilling and mailing response
    Fri Mar  3 23:03:02 2006,231 [12797] INFO  - Query:UPDATE inbound_email_autoreply SET deleted = 1 WHERE date_created < '2006-03-03 07:03:02'
    Fri Mar  3 23:03:02 2006,231 [12797] INFO  - Query Execution Time:0.000224
    Fri Mar  3 23:03:02 2006,231 [12797] ERROR  - MySQL error 1054: Unknown column 'date_created' in 'where clause'
    Fri Mar  3 23:03:02 2006,232 [12797] INFO  - Query:SELECT count(*) AS c FROM inbound_email_autoreply WHERE deleted = 0 AND autoreplied_to = 'xxx@xxx.net '
    Any help would be appreciated.

    Thanks in advance,
    Kurt

  2. #2
    sugarchris's Avatar
    sugarchris is offline Sugar Community Member
    Join Date
    Sep 2005
    Location
    San Francisco, CA
    Posts
    861

    Default Re: auto reply fails

    Hi Kurt,

    Before doing anything else, try Repairing the Database in Admin->System Repair->Repair->Repair Database.

    Make sure to select "Execute SQL" when you do the repair.

  3. #3
    celilo is offline Sugar Community Member
    Join Date
    Mar 2006
    Posts
    14

    Default Re: auto reply fails

    Well I tried that and recieved the following message appearing to fix a db problem.
    Repair Database:execute
    Print Print Help Help
    /* Table : files */
    /*COLUMNS/*
    /*MISSING IN DATABASE - date_modified - ROW/*
    alter table files add column date_modified datetime
    /*INDEXES/*
    /*MISSING INDEX IN DATABASE - idx_cont_owner_id_and_name -index ROW/*
    ALTER TABLE files ADD INDEX idx_cont_owner_id_and_name (assigned_user_id, name, deleted)

    However, I still get an error, actually now 1 error and 1 warning, as follows:

    Sat Mar 4 15:54:01 2006,993 [15790] INFO - Query Execution Time:0.00034899999999993
    Sat Mar 4 15:54:01 2006,995 [15790] DEBUG - looking for a case for test10
    Sat Mar 4 15:54:01 2006,995 [15790] DEBUG - found auto-reply template id - prefilling and mailing response
    Sat Mar 4 15:54:01 2006,995 [15790] INFO - Query:UPDATE inbound_email_autoreply SET deleted = 1 WHERE date_created < '2006-03-03 23:54:01'
    Sat Mar 4 15:54:01 2006,996 [15790] INFO - Query Execution Time:0.00021899999999997
    Sat Mar 4 15:54:01 2006,996 [15790] ERROR - MySQL error 1054: Unknown column 'date_created' in 'where clause'
    Sat Mar 4 15:54:01 2006,996 [15790] INFO - Query:SELECT count(*) AS c FROM inbound_email_autoreply WHERE deleted = 0 AND autoreplied_to = 'xxx@charter.net '
    Sat Mar 4 15:54:01 2006,997 [15790] INFO - Query Execution Time:0.00022599999999995
    Sat Mar 4 15:54:01 2006,997 [15790] INFO - Query:SELECT value FROM config WHERE name = 'fromname'
    Sat Mar 4 15:54:01 2006,997 [15790] INFO - Query Execution Time:0.000274
    Sat Mar 4 15:54:01 2006,998 [15790] INFO - Query:SELECT value FROM config WHERE name = 'fromaddress'
    Sat Mar 4 15:54:01 2006,998 [15790] INFO - Query Execution Time:0.00016899999999997
    Sat Mar 4 15:54:02 2006,000 [15790] DEBUG - Retrieve EmailTemplate : SELECT email_templates.* FROM email_templates WHERE email_templates.id = 'e3de4efe-b070-ed67-127b-44077c3e2b6b'
    Sat Mar 4 15:54:02 2006,001 [15790] DEBUG - Array
    (
    [0] => SELECT email_templates.* FROM email_templates WHERE email_templates.id = 'e3de4efe-b070-ed67-127b-44077c3e2b6b'
    [1] => 0
    [2] => 1
    [3] => 1
    [4] => Retrieving record by id email_templates:e3de4efe-b070-ed67-127b-44077c3e2b6b found
    )

    Sat Mar 4 15:54:02 2006,001 [15790] DEBUG - Limit Query:SELECT email_templates.* FROM email_templates WHERE email_templates.id = 'e3de4efe-b070-ed67-127b-44077c3e2b6b' Start: 0 count: 1
    Sat Mar 4 15:54:02 2006,001 [15790] INFO - Query:SELECT email_templates.* FROM email_templates WHERE email_templates.id = 'e3de4efe-b070-ed67-127b-44077c3e2b6b' LIMIT 0,1
    Sat Mar 4 15:54:02 2006,002 [15790] INFO - Query Execution Time:0.000349
    Sat Mar 4 15:54:02 2006,004 [15790] DEBUG - get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE 1=1 AND is_group=0 order by user_name asc
    Sat Mar 4 15:54:02 2006,004 [15790] INFO - Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 AND is_group=0 order by user_name asc
    Sat Mar 4 15:54:02 2006,005 [15790] INFO - Query Execution Time:0.000238
    Sat Mar 4 15:54:02 2006,005 [15790] DEBUG - saving and sending auto-reply email
    Sat Mar 4 15:54:02 2006,030 [15790] WARN - Error emailing:Could not instantiate mail function.

    Maybe same issue as http://www.sugarcrm.com/forums/showthread.php?t=9451

Thread Information

Users Browsing this Thread

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

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
  •