View-field 'Translate link' generates Error - not ported yet to D7 [#1112352]

If you add the field 'Content translation: Translate link (Translate link)' to a view, to following error appears:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sid0330.node_revisions' doesn't exist

This is because the table 'field_revisions' is renamed to 'field_revision', which is not done yet in views_handler_field_node_link_translate.inc.

Comment	File	Size	Author
#2	1112352-field-translate.patch	1.46 KB	dawehner

Comments

Comment #1

johnv

Dutch

commented 31 March 2011 at 18:59

Title:

View-field 'Translate link' generates error "Base table or view not found"

» View-field 'Translate link' generates Error - not ported yet to D7

I thought a patch was very simple, but the field format has moved, too, to the Field_revision_* tables, and the query remains empty, becaus field 'node_revision.format AS node_revision_format' does not exist..

-    $this->additional_fields['format'] = array('table' => 'node_revisions', 'field' => 'format');
+    $this->additional_fields['format'] = array('table' => 'node_revision', 'field' => 'format');

It is still to be ported to D7.

Comment #2

dawehner

German

commented 9 April 2011 at 18:42

Status:

Active

» Needs review

Status	File	Size
new	1112352-field-translate.patch	1.46 KB

Here is a port of it.

Comment #3

dawehner

German

commented 9 April 2011 at 21:37

Status:

Needs review

» Fixed

Okay commited to 7.x-3.x

Comment #4

23 April 2011 at 21:41

Status:

Fixed

» Closed (fixed)

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

Comment #5

Jerome F commented 6 June 2011 at 16:47

Status:

Closed (fixed)

» Active

Is this really fixed? (running Drupal core 7.2 / views and Internationalization last git)

When I add the field 'Content translation: Translate link I receive this debug message:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_revision.format' in 'field list'

in views_plugin_query_default->execute() (line 1377 of /Users/jerome/Sites/acquia-drupal/sites/all/modules/views/plugins/views_plugin_query_default.inc).