Cases: SQL Error When Viewing a Case

[leemoney24]

I've had no problems like this until recently. I was away for a week, and when I got back i noticed this.

When i access a case from anywhere other than an individuals/contacts list...i get this error:

Error retrieving Case list: Query Failed:SELECT cases.*, accounts.name as account_name, accounts.name as account_name1, accounts.assigned_user_id account_name1_owner, users.user_name as assigned_user_name FROM cases LEFT JOIN users ON cases.assigned_user_id=users.id LEFT JOIN accounts ON cases.account_id=accounts.id where cases.status in ('New','Assigned','Pending Input') and cases.assigned_user_id in ('1','1ae5a251-139a-e05c-edb1-43df724fdf7e') AND cases.deleted=0 AND accounts.deleted=0 ORDER BY account_name ASC LIMIT 12,1::MySQL error 1052: Column 'account_name' in order clause is ambiguous

I can access the case information fine from a contacts case list. If i try to access the case from any other means, (i.e. dashboard, all cases list, etc)...i get this same error for all cases.

Any help would be appreciated. Today i installed the patch from Version 4.5.1c to Version 4.5.1d...to see if that would fix my problem...wishful thinking.

[leemoney24]

FIXED!!!!!

I uploaded all the source files for the /modules/Cases and it fixed the problem. Must have had a corrupt/missing/rouge file out there .

I figured i'd post the fix in case this might help someone else later in life.

[andydreisch]

Hi leemoney24, thanks for the update.

I've also heard that Rebuild Relationships (via Admin) could help in this situation.

Hopefully this can help in the future.

Andy