CiviCase activity trouble with 4.5.2 upgrade

[reload]

Hello CiviCRMers,

I proceeded with an upgrade, no errors (that I noticed) everything looked good.
except: The civicase screen has no activities or timelines, and the custom case report form
that is described in xml to be added at the case opening is not there.

I made 2 errors before install,
1) forgot mbstring() in php build
2)forgot to put the custom xml file in the CRM/Case/xml folder
These were done after upgrade. Are these mistakes fatal?

Another clue on this issue is the (admin -> case -> types) links is not formed correct, goes to /a/#/caseType
With no case types, Yet the Open Case Screen has the only case type we use in the dropdown.
If I maually go here: civicrm/admin/options/case_type?group=case_type&reset=1 it directs me to /a/#/caseType
The rest of the data looks good all custom data etc.

I hope there is a fix for this install rather than start over, seems real close.

Thanks!

[totten]

Can you insect the contents of the SQL table " civicrm_case_type"? There should be a row for each case type, and the "definition" for each should be either NULL or the proper XML (NULL means "load from file" like we've traditionally done.). If the order of operations in loading the XML files and clicking through admin were weird, it's possible that the definition could have gotten messed up.

[reload]

Hi Totten,

 The case type IS in the table, with a blob as the xml. If I revert to null is there
something else needs to be done to re-read the xml?
Thanks for your quick response.

[reload]

Hi Totten,

 Your suggestions worked like a charm! Maybe needed a logout.
The Activities are there and the case type link works.
I think your mom would be proud of how smart you are 

Thanks,
reload

[totten]

Glad it worked out.

[pmoz]

I believe that I am in a similar situation with an old case type.  See: http://forum.civicrm.org/index.php/topic,34874.msg148335.html#msg148335

Reload, what did you do to resolve this?  Did you just change the definition field from blob to null?

[reload]

Hello pmoz,

 Yes just empty that flush cache and then civi read the info from the xml file
That malformed link seems like a good indicator of this.