When I use Views in a table view and make the link Sortable, Multiples of the same link shows up, it seem that the number of times that I have edited the content is the number of times it shows up when it set to be able to sort in the table view any clues on that.

Comments

quicksketch’s picture

quicksketch
he/him
commented
Category: bug » support

This is because every time you edit the node, you create a new revision. You should either turn off revisions for that node type (at admin/content/types) or more preferably, add a filter that only includes the latest revision.

tsavino’s picture

tsavino commented
Category: support » bug

Found the filter Node: Distinct set that and the dups where gone but got this message error:

    * user warning: Unknown column 'node_data_field_vsad_link_field_vsad_link_url' in 'order clause' query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, node_data_field_project_primary_link.field_project_primary_link_url AS node_data_field_project_primary_link_field_project_primary_link_url, node_data_field_project_primary_link.field_project_primary_link_title AS node_data_field_project_primary_link_field_project_primary_link_title, node_data_field_project_primary_link.field_project_primary_link_attributes AS node_data_field_project_primary_link_field_project_primary_link_attributes, node_data_field_project_backup_link.field_project_backup_link_url AS node_data_field_project_backup_link_field_project_backup_link_url, node_data_field_project_backup_link.field_project_backup_link_title AS node_data_field_project_backup_link_field_project_backup_link_title, node_data_field_project_backup_link.field_project_backup_link_attributes AS node_data_field_project_backup_link_field_project_backup_link_attributes, node_data_field_project_lead_link.field_project_lead_link_url AS node_data_field_project_lead_link_field_project_lead_link_url, node_data_field_project_lead_link.field_project_lead_link_title AS node_data_field_project_lead_link_field_project_lead_link_title, node_data_field_project_lead_link.field_project_lead_link_attributes AS node_data_field_project_lead_link_field_project_lead_link_attributes FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_vsad_link node_data_field_vsad_link ON node.vid = node_data_field_vsad_link.vid LEFT JOIN content_field_project_primary_link node_data_field_project_primary_link ON node.vid = node_data_field_project_primary_link.vid LEFT JOIN content_field_project_backup_link node_data_field_project_backup_link ON node.vid = node_data_field_project_backup_link.vid LEFT JOIN content_field_project_lead_link node_data_field_project_lead_link ON node.vid = node_data_field_project_lead_link.vid WHERE (term_node.tid = '52') GROUP BY node.nid ORDER BY node_data_field_vsad_link_field_vsad_link_url ASC LIMIT 0, 50 in /apps/opt/drupal/includes/database.mysql.inc on line 172.
    * user warning: Unknown column 'node_data_field_vsad_link_field_vsad_link_url' in 'order clause' query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, node_data_field_project_primary_link.field_project_primary_link_url AS node_data_field_project_primary_link_field_project_primary_link_url, node_data_field_project_primary_link.field_project_primary_link_title AS node_data_field_project_primary_link_field_project_primary_link_title, node_data_field_project_primary_link.field_project_primary_link_attributes AS node_data_field_project_primary_link_field_project_primary_link_attributes, node_data_field_project_backup_link.field_project_backup_link_url AS node_data_field_project_backup_link_field_project_backup_link_url, node_data_field_project_backup_link.field_project_backup_link_title AS node_data_field_project_backup_link_field_project_backup_link_title, node_data_field_project_backup_link.field_project_backup_link_attributes AS node_data_field_project_backup_link_field_project_backup_link_attributes, node_data_field_project_lead_link.field_project_lead_link_url AS node_data_field_project_lead_link_field_project_lead_link_url, node_data_field_project_lead_link.field_project_lead_link_title AS node_data_field_project_lead_link_field_project_lead_link_title, node_data_field_project_lead_link.field_project_lead_link_attributes AS node_data_field_project_lead_link_field_project_lead_link_attributes FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_vsad_link node_data_field_vsad_link ON node.vid = node_data_field_vsad_link.vid LEFT JOIN content_field_project_primary_link node_data_field_project_primary_link ON node.vid = node_data_field_project_primary_link.vid LEFT JOIN content_field_project_backup_link node_data_field_project_backup_link ON node.vid = node_data_field_project_backup_link.vid LEFT JOIN content_field_project_lead_link node_data_field_project_lead_link ON node.vid = node_data_field_project_lead_link.vid WHERE (term_node.tid = '51') GROUP BY node.nid ORDER BY node_data_field_vsad_link_field_vsad_link_url ASC LIMIT 0, 50 in /apps/opt/drupal/includes/database.mysql.inc on line 172.
tsavino’s picture

tsavino commented
Version: 5.x-2.3.1 » 5.x-2.5

Still getting the same error as above and still getting dups only when I turn on sort for the link columns....

dqd’s picture

dqd
Location London | N.Y.C | Paris | Hamburg | Berlin
commented
Status: Active » Closed (won't fix)

Issue date expired ...

For any feature request please take a look on the link module versions for Drupal 6 and Drupal 7 with much more features and better server and web standart support since Drupal 5 is not supported no more officially.

The stop for Drupal 5 support: Since we have to catch up to get ready for the final Drupal 7 release and have to deal with many feature requests for the Drupal 6 and Drupal 7 version of the link field module, we sadly have to annouce the stop of Drupal 5 support. The files will stay for any individual use or customization, but any support in the issue queue and in the forums has expired from now on.

Sorry and thanks for understanding.