Situation
- vanilla Drupal 4.7.2, no variable inside Drupal is changed
- views module cvs version
- upload, views, views_rss, views_theme_wizard and views_ui activated besides the default ones
- Only superuser exists, only one node (page) with one attachment exists.
The view:
---bite here---
$view = new stdClass();
$view->name = 'Test';
$view->description = 'test';
$view->access = array (
0 => '2',
);
$view->view_args_php = '';
$view->page = TRUE;
$view->page_title = 'Test';
$view->page_header = '';
$view->page_header_format = '1';
$view->page_footer = '';
$view->page_footer_format = '1';
$view->page_empty = '';
$view->page_empty_format = '1';
$view->page_type = 'list';
$view->url = 'test';
$view->use_pager = TRUE;
$view->nodes_per_page = '10';
$view->sort = array (
);
$view->argument = array (
);
$view->field = array (
array (
'tablename' => 'node',
'field' => 'title',
'label' => '',
'handler' => 'views_handler_field_nodelink',
),
);
$view->filter = array (
array (
'tablename' => 'file_revisions',
'field' => 'fid',
'operator' => '=',
'options' => '',
'value' => '1',
),
);
$view->exposed_filter = array (
);
$view->requires = array(node, file_revisions);
$views[$view->name] = $view;
---bite here---
When calling the view two errors are shown:
---bite here---
* user warning: Unknown table 'file_revisions' in where clause query: SELECT count(node.nid) FROM node node WHERE (file_revisions.fid) in /var/www/devel07/htdocs/includes/database.mysql.inc on line 120.
* user warning: Unknown table 'file_revisions' in where clause query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed FROM node node WHERE (file_revisions.fid) LIMIT 0, 10 in /var/www/devel07/htdocs/includes/database.mysql.inc on line 120.
---bite here---
In mysql.log i found
---bite here---
502 Query SELECT count(node.nid) FROM node node WHERE (file_revisions.fid)
502 Query SELECT node.nid, node.title AS node_title, node.changed AS node_changed FROM node node WHERE (file_revisions.fid) LIMIT 0, 10
---bite here---
These Queries look very strange to me.
greets
Marc
Comments
Comment #1
merlinofchaos commentedHave you run update.php?
file_revisions is a stock drupal table and should exist. If it does not, your installlation is not correct.
This isn't a Views problem.
Comment #2
dersmie commented> file_revisions is a stock drupal table and should exist.
>If it does not, your installlation is not correct.
The table exists but the sql statement isnt valid because it is not taken care of the table being inserted in the query if one does not define a "File:"-filter-criteria.
For me i solved the problem by adding an ensure_table() to views_handler_file_filter_fid_exist().
greets
Marc