The "node_revision" table is sometimes erroneously referred to as "node_revisions" [#1128668]

I ran into this error when adding Webform fields to a View

https://skitch.com/jesse.beach/r4prb/webform-results-content-my-site

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'gardens.node_revisions' doesn't exist

In my Drupal installation, I have a node_revision table, but not node_revisions table. "Gardens" is the name of my database.

Looking through the sourcecode for Views, it seems like numerous references to the node_revisions table exist. These should be replaced with node_revision as far as I understand the problem.

Comments

Comment #1

merlinofchaos CreditAttribution: merlinofchaos commented 15 April 2011 at 18:24

Status:

Active

» Fixed

Most of the references to node_revisions remaining in Views are harmless (one was not) and probably not the cause.

webform also has some references to node_revisions that seem equally likely to be the issue:

[merlin@furor views]$ grep -R node_revisions ../webform/
../webform/views/webform_handler_field_node_link_results.inc:    $this->additional_fields['format'] = array('table' => 'node_revisions', 'field' => 'format');
../webform/views/webform_handler_field_node_link_edit.inc:    $this->additional_fields['format'] = array('table' => 'node_revisions', 'field' => 'format');
../webform/views/webform.views.inc:      'skip base' => array('node', 'node_revisions'),
../webform/views/webform.views.inc:      'skip base' => array('users', 'node', 'node_revisions'),