mysql error and no contacts shown

[jacquesl]

Hi,
I experience the following error:
Error retrieving Account list: Query Failed: SELECT contacts.id ,contacts_cstm.typeofcontact_c,contacts_cstm.types ofsport_c,contacts_cstm.emailfollowup_c,contacts_c stm.donotemail_c,contacts_cstm.skype_c, contacts.first_name , contacts.last_name , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) as name, contacts.primary_address_city , contacts.primary_address_state , contacts.phone_work , contacts.assigned_user_id , 'contacts' panel_name FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c INNER JOIN accounts_contacts ON (contacts.id=accounts_contacts.contact_id AND accounts_contacts.account_id= 'f0409da7-4c33-d837-faa7-4943de847cad') where ( accounts_contacts.deleted=0 AND contacts.deleted=0) AND contacts.deleted=0 ORDER BY contacts.last_name,contacts.first_name asc LIMIT 0,11::MySQL error 1054: Unknown column 'contacts_cstm.skype_c' in 'field list'

And if I try to search for contacts I most often do not get any result.

What can I do? I use sugar Pro 5.1 b

Andreas

[andreasbalzer2]

ping (want to get notified by answers)

[eggsurplus]

Try doing a repair/rebuild on the Contacts module. It looks like the database needs to be updated so that skype_c is added to the contacts_cstm table. Another option is to manually add that column to the database. Perhaps the database user that Sugar uses doesn't have rights to add columns to your database?

[andreasbalzer2]

Hi,
I did it but I still don't get any contacts displayed.

Any idea?

Andreas

[eggsurplus]

Do you get that same error as above? Or do you get a different error now? Do these columns exist in the contacts_cstm table?

contacts_cstm.typeofcontact_c,contacts_cstm.types ofsport_c,contacts_cstm.emailfollowup_c,contacts_c stm.donotemail_c,

[andreasbalzer2]

Hi,
well we both have the server. Actually I was told that the error appeared but I have never saw it nor does it display in a newly created error log. I looked into the database and we have all of the columns you mentioned in your last post. Any idea?

[eggsurplus]

You can turn on full logging by going to your config.php and setting the log level to debug. This will get you more information in sugarcrm.log to determine what's going on.