Contact List Broken

[Tirin]

Hello. I added some custom fields to the contacts area and was trying to get them to show up in the contact list page. I was using the columns to add in some new areas for fields and did something stupid. I deleted the name column on accident. I've re-added it, but I can't get the full names to display, even though I believe I moved the proper tag back into that spot. Also, whenever I go to the contacts list page, I receive this error instead of the list:

Error retrieving Contact list: Query Failed:SELECT accounts.name as account_name, accounts.id as account_id, users.user_name as assigned_user_name , contacts_cstm.* ,contacts.assigned_user_id, contacts.id, contacts.first_name, contacts.last_name, contacts.phone_work, contacts.title, contacts.email1, contacts.email2 FROM contacts LEFT JOIN users ON contacts.assigned_user_id=users.id LEFT JOIN accounts_contacts ON contacts.id=accounts_contacts.contact_id LEFT JOIN accounts ON accounts_contacts.account_id=accounts.id LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c where ( accounts_contacts.deleted IS NULL OR accounts_contacts.deleted=0 ) AND ( accounts.deleted IS NULL OR accounts.deleted=0 ) AND contacts.deleted=0 ORDER BY contacts.full_name asc LIMIT 0,20::MySQL error 1054: Unknown column 'contacts.full_name' in 'order clause'

I have a feeling the two are related problems, but I'm unfortunately not savvy enough to figure out what's happening exactly.

I'm working with Sugar Suite v. 3.0.1b on Windows XP. If I'm posting in the wrong area, please let me know. Apologies if this is a common error, I didn't see any a solution to it in the Wiki, but I'm also not sure what to look for.

[sacramentojoe]

error is stated at the end.

Unknown column 'contacts.full_name' in 'order clause'

Basically stating that your contacts table doesn't have a full_name field.

If you added this field, try contact_cstm.full_name_c

[Tirin]

Thanks for the response. I'm still a little confused. I have a sugar field called {CONTACT.FULL_NAME}, however when I apply this to the appropriate area, nothing shows up after I save the layout. Even if I do a search for a person, it will retrieve the data based on what I searched for, but the field that should have their name is still blank.

I keep getting the same error, too. Is there a way to get this back up?

[Tirin]

Ok, we went through and pretty much rolled back and added the field to the system and it seems to be working. Thanks for the help.