Database Help Please

[rtynal]

Allright here is what happened somehow when I was in the account listview editing the layout of the fieldsusing the admin within SugarCRM the column accounts.assigned_use_name got deleted. This is the column that has the heading of user and shows what user is in charge of a account. So however that happened whenever I went to the accounts tab in SugarCRM I was getting a mysql error telling me that the column accounts.assigned_user_name cannot be found. I proceded to go into the database and add the field assigned_user_name into the accounts table. Now when I goto the accounts tab it shows the table of accounts without the error. The issue is that it does not show the user associated with the account in the listview it just shows null. Even if I assign a user to a account in the listview view it will not show the user it still will only say null. How do I repair this?

[kbrill]

assigned_user_name is not a field from the mysql database it is a linked field from the users table. Sugar takes assigned_user_id and looks up the name of that user and populates assigned_user_name with that. If you are getting the error messages that you talk about then something is REALLY wrong with your code. You should never see 'column accounts.assigned_user_name cannot be found' from your mysql engine as it's not listed in any query.