Contact edit function display error and save error

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

We are using Version 7.1.0.

We are still in the process of setting up and importing accounts. The contact import wen wwell after the initial account import. We have done the first test import with 500 accounts.

When choosing to click on the highlited contact name in account window a pop up window accours, but with errors and strange format. I am using Chrome browser, but also checked wwith Firefox and explorer, all failing. Attached find the Chrome screenshot. Well, just tried that, but can not add file, it will not collect the image I choose !?

Any way, if I select the “edit” button on the right side of contact module in the acount window, the correct edit window displays, but if I try to make any changes and click save I get this meassage: Database failure. Please refer to sugarcrm.log for details.

It is vital that that contact editing works.

Please help us out here. I am surprised to find such error to a vital function.

#2

Hi Egil,

Nothing attached… and did you look in sugarcrm.log? What was there?

Cheers

Bruce

#3

Hello again. Yesterday the attach file function did not work, but noe it does, so here is the screenshot.
in regardst to sugrarcrm.log I have to wait for my tech guy to help me later today, but the error message happens only when trying to save any aditing in the contact window.

#4

Her the logfile:
Databaselog:
Thu Apr 10 10:24:29 2014 [15691][1][FATAL] Error updating table: contacts: Query Failed: UPDATE contacts
SET date_modified=‘2014-04-10 08:24:29’,modified_user_id=‘1’,created_by=‘1’,description=NULL,assigned_user_id=‘1’,salutation=NULL,first_name=‘testkontakt’,last_name=‘test’,title=‘tittelen’,department=NULL,do_not_call=0,phone_home=NULL,phone_mobile=NULL,phone_work=‘61184140’,phone_other=NULL,phone_fax=NULL,primary_address_street=‘Studievegen 16’,primary_address_city=‘Gjøvik’,primary_address_state=NULL,primary_address_postalcode=‘2815’,primary_address_country=NULL,alt_address_street=NULL,alt_address_city=NULL,alt_address_state=NULL,alt_address_postalcode=NULL,alt_address_country=NULL,assistant=NULL,assistant_phone=NULL,lead_source=NULL,reports_to_id=’’,birthdate=NULL,campaign_id=’’,=NULL,joomla_account_id=NULL,portal_account_disabled=0,portal_user_type=‘Single’
WHERE contacts.id = ‘4e61cd9f-bc1f-1fee-19ba-53457648a997’ AND deleted=0: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘=NULL,joomla_account_id=NULL,portal_account_disabled=0,portal_user_type=‘Single’’ at line 2
Second error:
Thu Apr 10 00:31:46 2014 [31032][45ef7f72-f4d8-e84c-0ee7-533de47e4ccf][FATAL] Error running count query for Contact List: Query Failed: ( SELECT count(*) c FROM fp_events INNER JOIN fp_events_contacts_c ON fp_events.id=fp_events_contacts_c.fp_events_contactsfp_events_ida AND fp_events_contacts_c.fp_events_contactscontacts_idb=‘6d0adc22-5b8f-59a2-a2ae-53456299f137’ AND fp_events_contacts_c.deleted=0

where fp_events.deleted=0 ): MySQL error 1146: Table ‘suitecrmdb.fp_events_contacts_c’ doesn’t exist
Thu Apr 10 10:23:28 2014 [9563][1][FATAL] Error running count query for Contact List: Query Failed: ( SELECT count(*) c FROM fp_events INNER JOIN fp_events_contacts_c ON fp_events.id=fp_events_contacts_c.fp_events_contactsfp_events_ida AND fp_events_contacts_c.fp_events_contactscontacts_idb=‘4e61cd9f-bc1f-1fee-19ba-53457648a997’ AND fp_events_contacts_c.deleted=0

where fp_events.deleted=0 ): MySQL error 1146: Table ‘suitecrmdb.fp_events_contacts_c’ doesn’t exist

#5

Hi Egil,

For the first error, the solution described here will probably fix it.

I would also do what the bottom of the dialog in your screen shot suggests. Turn off UI ajax for the Contacts module. (System Settings -> Configure AJAX User Interface)

As for the second error, someone else will have to pick it up. I do not have the table fp_events_contacts_c in my database and do not know what creates it.

Cheers

Bruce