Comment 5 for bug 1626462

Hi Andy

For the client that didn't have the content reinstated - can you look at their database for a page that is not displaying correctly and run this command:

SELECT bi.blocktype FROM block_instance bi WHERE view = [id of page];

This should show you which blocks should be appearing on the page

Then run:

SELECT bi.blocktype FROM block_instance bi JOIN view v ON v.id = bi.view JOIN view_rows_columns vrc ON vrc.view = v.id WHERE v.id = [id of page];

This will show you the same list if the info in view_rows_columns exists.

If the first command is not empty but the second one is then there is still something amiss with the fix. If the first command is empty it means the page itself is actually empty (no blocks associated with the page).

Cheers

Robert