CiviCRM Community Forums (archive)

Thanks Pete.

That too is interesting.  Here's what I get when I paste your link in.  When I hit enter after pasting, the address changes to civicrm/a/#/caseType and I see this table.

My profile version actually refers to a different company.

This site is on 4.5.3.  I definitely should have been clearer about that.

sounds like there needs to be some work done on Views for 4.5 - you could probably add a JIRA ticket - preferably with a patch if you can - esp if it is as trivial as it might be. We probably won't be pushing our clients up to 4.5 till the new year as there is just too much risk of things like this hitting us across 50+ sites which is why we put a fair bit of effort in to the LTS.

Scratch that, can't get to site at all now.

All pages give DB Error: no such field.

Update:
After some gagging, we're back up.

Update:
Still gagging with "No such field"

Truncating all cache tables fixed it.

Made the change with no luck. v4.6.2

I truncated the cache tables manually too, to be sure, after updating the file:
truncate cache_form; truncate cache_field; truncate cache_filter; truncate cache_image; truncate cache_menu; truncate cache_page; truncate cache_path;  truncate cache_rules; truncate cache_update; truncate cache_views;

I've noticed in the case dashlet, the case type isn't shown in open cases... nor on the job dashboard when showing job count by status.. yet the count is correct.

The case_type_id appears to be valid and linked in the database.. so it would appear until I perform further investigation the code needs updating in a few places.