drupal v6.14, after installing required dependency modules, everything works (AFAIK) except the manage button. when I press it, I get the following error:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: missing FROM-clause entry for table "node_data_field_testimonial_link" at character 160 in /usr/local/www/cgi-bin/drupal-6.14/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT node.nid AS nid, node.title AS node_title, node.uid AS node_uid, node.type AS node_type, node_revisions.format AS node_revisions_format, node_data_field_testimonial_link.field_testimonial_link_url AS unknown FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.type in ('testimonial')) ORDER BY unknown ASC LIMIT 25 OFFSET 0 in /usr/local/www/cgi-bin/drupal-6.14/sites/all/modules/views/includes/view.inc on line 755.

Comments

gizmolab’s picture

gizmolab CreditAttribution: gizmolab commented

i fixed this by removing the default sort criteria in the admin >>> views configuration page. perhaps you could remove this default in the installer

tarzadon’s picture

tarzadon CreditAttribution: tarzadon commented

Thanks @gizmolab.

I was getting the error:
user warning: Unknown column 'field_testimonial_link_url' in 'field list' query: SELECT node.nid AS nid, node.title AS node_title, node.uid AS node_uid, node.type AS node_type, node_revisions.format AS node_revisions_format, field_testimonial_link_url AS unknown FROM drup_node node LEFT JOIN drup_node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.status = 1) AND (node.type in ('testimonial')) ORDER BY unknown ASC LIMIT 0, 25 in /var/www/public_html/sites/all/modules/views/includes/view.inc on line 810.

I had to remove a bunch of "Broken/missing handler" in the Views.

I went into Content Types, manually added the field_testimonial_link_url, then added that field back into the Views.