Error in selecting contact

📦 Install & Upgrade Help
1

Please…Help me…
i have problem during create a cases…at Contants when i try to create>select this error was appear

Notice: Undefined property: Contact::$event_status_name in C:\xampp\htdocs\SuiteCRM\modules\EmailTemplates\EmailTemplate.php on line 565

Notice: Undefined property: Contact::$event_accept_status in C:\xampp\htdocs\SuiteCRM\modules\EmailTemplates\EmailTemplate.php on line 565

Notice: Undefined property: Contact::$event_status_name in C:\xampp\htdocs\SuiteCRM\modules\EmailTemplates\EmailTemplate.php on line 565

Notice: Undefined property: Contact::$event_accept_status in C:\xampp\htdocs\SuiteCRM\modules\EmailTemplates\EmailTemplate.php on line 565

Notice: Undefined property: Contact::$event_status_name in C:\xampp\htdocs\SuiteCRM\modules\EmailTemplates\EmailTemplate.php on line 565

Notice: Undefined property: Contact::$event_accept_status in C:\xampp\htdocs\SuiteCRM\modules\EmailTemplates\EmailTemplate.php on line 565
Database failure. Please refer to sugarcrm.log for details.

2

Hi Nur,

First of all you need to suppress your notices/warnings in your php.ini. There are many posts on the forums and google on how to do this.

Secondly, have you tried navigating to Admin -> Repair and running a Quick Repair & Rebuild? Once this finishes, there may be changes at the bottom of the page. If there are, click ‘Execute’.

It may also be worth checking your suitecrm.log file in your root directory for errors.

Thanks,

Will.

3

this message -> Database tables are synced with vardefs …
Then?How i could do it

4

That means everything is synced and there are no differences.

What are the errors in the log file?

5

09/29/15 03:39:47 [5120][1][FATAL] Error updating table: cases: Query Failed: UPDATE cases
SET name=‘Re: Seeking Advice. ,assigned_user_id=‘1’,type=‘Product’,status=‘Open_Pending Input’,priority=‘P1’,resolution=NULL,work_log=NULL,account_id=‘8bc4e502-ac08-fd23-a1cc-55ed524dcecd’,state=‘Open’,contact_created_by_id=’’
WHERE cases.id = ‘80067e09-3522-7052-5855-55eff2188c5b’ AND deleted=0: MySQL error 1054: Unknown column ‘contact_created_by_id’ in ‘field list’

09/29/15 03:49:24 [5120][1][FATAL] SMTP -> ERROR: Failed to connect to server. Code: 10060 Reply: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

09/29/15 03:49:24 [5120][1][FATAL] SugarPHPMailer encountered an error: The following From address failed
09/29/15 03:49:24 [5120][1][FATAL] Error updating table: cases: Query Failed: UPDATE cases
S
09/29/15 04:08:16 [4824][1][FATAL] IP Address mismatch: SESSION IP: 127.0.0.1 CLIENT IP: ::1
09/29/15 04:15:52 [4824][1][FATAL] IP Address mismatch: SESSION IP: 10.20.116.43 CLIENT IP: 10.20.174.29
09/29/15 07:52:58 [4824][1][FATAL] SMTP -> ERROR: Failed to connect to server. Code: 10060 Reply: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

09/29/15 07:52:58 [4824][1][FATAL] SugarPHPMailer encountered an error: The following From address failed
09/29/15 07:52:59 [4824][1][FATAL] Error updating table: cases: Query Failed: UPDATE cases

09/29/15 09:17:04 [4824][1][FATAL] SMTP -> ERROR: Failed to connect to server. Code: 10060 Reply: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

09/29/15 09:17:04 [4824][1][FATAL] SugarPHPMailer encountered an error: The following From address failed
09/29/15 09:17:04 [4824][1][FATAL] Error updating table: cases: Query Failed: UPDATE cases

09/29/15 09:40:33 [4824][1][FATAL] Error updating table: cases: Query Failed: UPDATE cases
SET name=‘Re: Seeking Advice. FW: Training Confirmation - Advanced Technique in PID Control L3’,date_modified=‘2015-09-29 07:40:33’,modified_user_id=‘1’,created_by=‘1’,description=’’,assigned_user_id=‘1’,type=‘Product’,status=‘Open_Pending Input’,priority=‘P1’,resolution=‘AAA’,work_log=NULL,account_id=‘8bc4e502-ac08-fd23-a1cc-55ed524dcecd’,state=‘Open’,contact_created_by_id=’’
WHERE cases.id = ‘80067e09-3522-7052-5855-55eff2188c5b’ AND deleted=0: MySQL error 1054: Unknown column ‘contact_created_by_id’ in ‘field list’
09/29/15 09:52:32 [4824][1][FATAL] SMTP -> ERROR: Failed to connect to server. Code: 10060 Reply: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

09/29/15 09:52:32 [4824][1][FATAL] SugarPHPMailer encountered an error: The following From address failed:
09/29/15 09:52:32 [4824][1][FATAL] Error updating table: cases: Query Failed: UPDATE cases

09/29/15 09:53:38 [4824][1][FATAL] SMTP -> ERROR: Failed to connect to server. Code: 10060 Reply: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

09/29/15 09:53:38 [4824][1][FATAL] SugarPHPMailer encountered an error: The following From address failed
09/29/15 09:53:38 [4824][1][FATAL] Error updating table: cases: Query Failed: UPDATE cases
S
09/29/15 10:06:29 [4824][1][FATAL] Error updating table: cases: Query Failed: UPDATE cases

09/29/15 10:14:30 [4824][-none-][FATAL] SECURITY: User authentication for Nur failed
09/29/15 10:14:30 [4824][-none-][FATAL] FAILED LOGIN:attempts[1] -
09/29/15 10:14:30 [4824][-none-][FATAL] SECURITY: User authentication for Nur failed
09/29/15 10:14:30 [4824][-none-][FATAL] FAILED LOGIN:attempts[1] -
09/29/15 10:14:38 [4824][-none-][FATAL] SECURITY: User authentication for Nur failed
09/29/15 10:14:38 [4824][-none-][FATAL] FAILED LOGIN:attempts[1] -
09/29/15 10:14:38 [4824][-none-][FATAL] SECURITY: User authentication for Nur failed
09/29/15 10:14:38 [4824][-none-][FATAL] FAILED LOGIN:attempts[1] -
09/29/15 10:14:47 [4824][-none-][FATAL] SECURITY: User authentication for Nur A failed
09/29/15 10:14:47 [4824][-none-][FATAL] FAILED LOGIN:attempts[1] -
09/29/15 10:14:47 [4824][-none-][FATAL] SECURITY: User authentication for Nur A failed
09/29/15 10:14:47 [4824][-none-][FATAL] FAILED LOGIN:attempts[1] -
09/29/15 10:21:06 [4824][1][FATAL] SMTP -> ERROR: Failed to connect to server. Code: 10060 Reply: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

09/29/15 10:21:06 [4824][1][FATAL] SugarPHPMailer encountered an error: The following From address failed
9/29/15 10:21:07 [4824][1][FATAL] Error updating table: cases: Query Failed: UPDATE cases
SET name=’#’,date_modified=‘2015-09-29 08:20:56’,modified_user_id=‘1’,created_by=‘1’,description=’

’,assigned_user_id=‘1’,type=‘Product’,status=‘Open_Pending Input’,priority=‘P1’,resolution=NULL,work_log=NULL,account_id=‘8bc4e502-ac08-fd23-a1cc-55ed524dcecd’,state=‘Open’,contact_created_by_id=’’
WHERE cases.id = ‘80067e09-3522-7052-5855-55eff2188c5b’ AND deleted=0: MySQL error 1054: Unknown column ‘contact_created_by_id’ in ‘field list’
6

Hi Will,

i already fix all of the error by commented out display_errors in php.ini…
And after that,i restart my server…It’s work!!
Thanks a lot , Will…Hope we can discuss another topic next time… B) :cheer: