support request

**kenan** · 2006-12-07, 01:35 PM

os: Win adv server 2003
sugarcrm ver: 4.2.1a (open source)
Apache ver: 2.0

dear support team,

my contacts page has crashed, i get an error msg as shown beneath when i try to open it. i was trying to edit the list view in the studio, wanted to replace the "office number" with the "mobile" when i view the contact list and when i replaced it with a field from the sugarcrm fields it crashed. i tried to put things back but failed.

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

Is there a way out of this mess... like reseting it to defaults, even if it means i'll have to reenter the info... any help is wellcome.

thnx

**Angel** · 2006-12-07, 06:30 PM

If you look at the database on the MySQL server using some type of admin tool, does the account_name column still exist on the contacts table?

**kenan** · 2006-12-07, 08:55 PM

everything i've been doing so far was from the admin account... no tools of any kind... as soon as i figure out which tools to use i'll post the details...

thnx again... i'm sure there'll be and again and again

**Angel** · 2006-12-07, 09:40 PM

Sorry, I wasn't as clear as I should have been, I meant a database admin tool, like the one from www.webyog.com, which would allow you to directly inspect the MySQL server and its databases outside of the Sugar application.

**sagarladdha** · 2006-12-08, 03:57 AM

Hello kenan,

You can view the database using phpmyadmin tool which is automatically installed with sugarcrm. Just type http://localhost/phpmyadmin in your browser window and you will understand the steps to be followed.

Regards,

Sagar Laddha
India

**kenan** · 2006-12-08, 08:16 AM

well, i've tried to make sense from the phpmyadmin tool but since i have no clue what i am looking at i will post the links to the pics here and you can take a look...

http://i72.photobucket.com/albums/i1...reenprint2.jpg

http://i72.photobucket.com/albums/i1...creenprint.jpg

http://i72.photobucket.com/albums/i1...intscreen1.jpg

**sagarladdha** · 2006-12-08, 10:40 AM

Hello kenan,

When you open the phpmyadmin tool from browser, then in the left subpanel, you see a drop down box named Databases. There you select "sugarcrm". Now you get the entire sugarcrm database with all the tables listed there. Here you click on the contacts table (in the list on left side). Now the structure of the contacts table will be displayed. Check if the account_name column is there in the contacts table.

Regards,

Sagar Laddha
India

**kenan** · 2006-12-08, 12:36 PM

i've done pretty much about everything you said...

http://i72.photobucket.com/albums/i1...rintscreen.jpg

that is a link to a printscreen from phpmyadmin screen and as far as i can see the module contact_account is not there... how do i put it back?

i also get this:

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

every time i try to open my contact page. i gather the sql database is screwed somehow... can i put a fresh one into place or what?

and again... hehehe... thank you for all your help

**kenan** · 2006-12-08, 12:50 PM

latest update on the problem, the page, the whole contact page has crashed... on some PC's (mine included) but on others it works fine, except for the fact that it doesn't display the account field and i can't find that field anywhere to put it back... sucks...