auto reply fails

[celilo]

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.

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

[sugarchris]

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.

[celilo]

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