accounts list view empty?!

[napx]

Hi I have a problem that seems to have just manifested itself. If I look at accounts list view, it's completely empty, even though there are hundreds of entries. If I query one of those entries directly, or click on the account name listed under a contact in the contacts module, I can get to it. But these accounts (not deleted or anything like that) don't show up in the list for some reason. And because of this, cases affiliated with these accounts don't show up in the corresponding cases list either. HELP! I'm really lost here...

[napx]

Also, if I create a new account from the accounts screen that NEW account doesn't show up in the list either. ?!?

[napx]

I rebuilt relationships and it didn't help. Then I logged out and back in as the same user and my accounts are back. wtf? However, I'm still missing a mess of sessions in the sessions list view. Bad relationships somehow?

Perhaps it's related to a problem I had earlier this morning. I was getting this error:

Error retrieving Case list: Query Failed:SELECT cases.*, accounts.name as account_name1, accounts.assigned_user_id account_name1_owner, users.user_name as assigned_user_name , cases_cstm.* FROM cases LEFT JOIN users ON cases.assigned_user_id=users.id LEFT JOIN accounts ON cases.account_id=accounts.id LEFT JOIN cases_cstm ON cases.id = cases_cstm.id_c where cases.deleted=0 AND accounts.deleted=0 ORDER BY cases.assigned_user_name asc LIMIT 0,20::MySQL error 1054: Unknown column 'cases.assigned_user_name' in 'order clause'

On cases list view screen. I read through the forums and found someone who suggested commenting out the ListView->setQuery() line in ListView.php so I did that. Then my sessions (at least, some of them) showed up again. Something is obviously still broken. Anyone?

[napx]

Please disregard, I guess the rebuild fixed the accounts list problem and the cases problem seems to be showing only the first 20 cases, indicating that the paginator is broken. This is no doubt due to my mucking with $Layout->setQuery. I've still got a problem with an invalid sort order for cases being generated by the system, but I've posted that problem elsewhere. Maybe this thread will help someone else.