I got the following error when I try to create a view based on block as the content type:
SQLSTATE[42S02]: Base table or view not found: 1146 Table '{database}.blocks' doesn't exist
See below for the export dump.
Could anyone provide some pointers?
Thank you in advance.
/***** export dump *****/
$view = new view();
$view->name = 'block_tags';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'blocks';
$view->human_name = 'Block Tags';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'Block Tags';
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'some';
$handler->display->display_options['pager']['options']['items_per_page'] = '10';
$handler->display->display_options['style_plugin'] = 'table';
/* Field: Block: Module */
$handler->display->display_options['fields']['module']['id'] = 'module';
$handler->display->display_options['fields']['module']['table'] = 'blocks';
$handler->display->display_options['fields']['module']['field'] = 'module';
/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Block: Delta */
$handler->display->display_options['fields']['delta']['id'] = 'delta';
$handler->display->display_options['fields']['delta']['table'] = 'blocks';
$handler->display->display_options['fields']['delta']['field'] = 'delta';
/* Field: Block: Module */
$handler->display->display_options['fields']['module_1']['id'] = 'module_1';
$handler->display->display_options['fields']['module_1']['table'] = 'blocks';
$handler->display->display_options['fields']['module_1']['field'] = 'module';
/* Field: Block: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'blocks';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['path'] = 'block-tags';
Comments
Comment #1
amaisano commentedHaving the same problem. My database has a "block" table, but not a "blocks" plural table. Is it just a typo in the module code??
Comment #2
amaisano commentedabrlam - found out it is indeed a typo problem. The latest dev at this time fixes it:
https://drupal.org/node/1976802