Accounts disappeared in List view

[mzenns]

I added a field to the Accounts module using Studio, then added it to all layouts except the list view. Now when I go to the Accounts module, none of the accounts show up in the list view. What did I do wrong, and where do I look to fix this?

Sugar CE 5.01
MySQL 5
PHP 5
Ubuntu 8.04 Server

[andopes]

Hi mzenns

Probably it is due a query error in MySQL.
Edit the file include/ListView/ListViewData.php and add this line:

 echo "<LI>$main_query"; 
  

Just after the line:

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
  

Let me know the query in the ListView of Accounts.

Cheers

[mzenns]

Editing the ListView.php file didn't change the result. Here is the error I get now, and still no list.

SELECT accounts.id ,accounts_cstm.lbl_tech_name_c,accounts_cstm.tech_ phone_c,accounts_cstm.ip_blocks_c,accounts_cstm.pr oj_install_c,accounts_cstm.act_install_c,accounts_ cstm.multi_site_c,accounts_cstm.accountnumber_c, accounts.name , accounts.billing_address_city , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, accounts.assigned_user_id FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON jt0.id= accounts.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 where accounts.deleted=0 ORDER BY accounts.name ASC

[andopes]

Hi mzenns

Run this query into phpMyAdmin inside the same database used by SugarCRM.
Certainly it will return an error. This error can guide you to the fix.

Cheers

[mzenns]

Thanks! For some reason, the field was created in the Sugar gui, but not in the database. I deleted the field in the Sugar gui, then re-added it and everything's fine now.

I'm very glad there's folks willing to help, as I'm just getting back into database and programming, and have never worked with MySQL and PHP before.