Urgent: All Views Results Disappeared

There are far too many missing details to be able to help effectively.

If you modified the field_data_body table by hand using queries then you appear to have broken something in the data.

Do you have a backup you can restore to?

I used SQL update query to update the field_data_body table in phprdmin. All nodes seem to display well after update. The only problem is Views. There is no display in Preview either. I don't think the problem is in view itself, because I didn't make any changes to views setting or anything.

All modules and drupal 7 core are up to date. No other actions taken except the SQL Update. Not sure why any changes in the field_data_body table could possibly affect the view display.

Does Views look or store any data in field_data_body table?

I've requested my host to restore the data from last night, but not sure how long it takes. My site is kind of broken...

My site is back working. Here are a few things I went through:

1. I checked al my tables in Phpmyadmin, all OK;
2. I created a simple view just showing Title for one type. No result display in Preview or on page. I enabled the SQL display, and then copied the SQL to PHPmyadmin, the result displaying fine there.

The above indicates my database and view configurations are all good.

In order to debug view, I installed Devel module and enabled debug for view. Believe it or not, ALL MY VIEWs are back working fine!!!!!!!

I am closing this issue now, hoping this experience can provide some consideration to developers and experts.

Thanks

Glad to hear the site is working again now.

Automatically closed - issue fixed for 2 weeks with no activity.