All defined views have disappeared. What do I do?

ryanhunt - November 5, 2009 - 23:53

Monday morning I woke up to my site being down. (intranet, cant show)

I performed voodoo for 2 days and finally got it back up. (literally voodoo, same code, same db. just multiple restarts of the server etc....)

Actually there was one change, the menu_router table was empty for some reason. It was so empty I could not even issue a rebuild menu command. I restored from backup. cleared cache, rebuilt the menu.

When the site came back on line. All of the views I had defined come up with a blank page. Not even the drupal_not_found page.

I think I have isolated something, I am just not sure what.

In the view.inc in the execute_display function I get a display ID passed in an args...,

But this line:

$output = $this->display_handler->execute();

returns nothing as the output.

I have added this line:

watchdog(__FUNCTION__, "Output:$display_id".print_r($output, true), NULL,WATCHDOG_DEBUG);

Which give me a line like the following:

Message Output:blockArray ( [content] => [subject] => )

So as far as I can tell it is getting what it needs up to this point, but the $output is coming back empty.

I tried understanding the code further, but began to think it was pointless, as I have not changed any of the code, either for core, the modules, or custom code.

The only thing I can think of is that it is a DB issue, but the tables all appear ok. The views seem to be stored as BLOBs, so I can't see what is in them to know if they are all right.

Does anyone have any advice on how to debug or better yet fix this problem?

I am drawing a blank on this

ryanhunt - November 6, 2009 - 02:03

I am drawing a blank on this one.

If someone knows how to look at the data held in the blobs in the views table that might be helpful.

By updating the views module,

ryanhunt - November 6, 2009 - 18:44

By updating the views module, and Drupal core to the latest code, then disabling and reenabling all view related modules, I was able to get the page up that allows exporting views to a module.

The views still do not work though...

I can see them in the export list, and can export them.. but when i try to access them it doesn't work..

Could this be a problem with Views UI?

_

WorldFallz - November 6, 2009 - 19:50

What happens when you create a brand new view?

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.

I couldn't even access the

ryanhunt - November 9, 2009 - 14:59

I couldn't even access the create new view page to create a new view.

I was able to find a work around, I anyone else comes across this problem. After an agonizing week, I finally discovered that if I turn off syslog, Views came back to life.

Not sure if it a problem with syslog, or a problem with views, but these two modules did not like being turn on and running together.

Anyone have thoughts on if I should file a bug for either of those?

Both?

 
 

Drupal is a registered trademark of Dries Buytaert.