Ragazzi ho una rogna che non riesco a risolvere
ho fatto una vista usando lo stile campi
ho aggiunto una serie di voci da visualizzare ma quando inserisco Taxonomy: Term image non mi fa comparire nulla e ho anche capito il perchè.
Nella select prende il tid invece che il campo path e quindi quando lo va a richiamare risulta vuoto
vi incollo la prima parte del select con l'errore
SELECT DISTINCT(node.nid) AS nid,
node.title AS node_title,
node.language AS node_language,
node_data_field_external_link.field_external_link_url AS node_data_field_external_link_field_external_link_url,
node_data_field_external_link.field_external_link_title AS node_data_field_external_link_field_external_link_title,
node_data_field_external_link.field_external_link_attributes AS node_data_field_external_link_field_external_link_attributes,
node.type AS node_type,
node.vid AS node_vid,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format,
users.name AS users_name,
users.uid AS users_uid,
term_data_node__term_image.tid AS term_data_node__term_image_tid,
node_counter.daycount AS node_counter_daycount,
DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m%%d%H') AS node_created_hour
FROM net1_node node
In grassetto vi ho messo l'errore, qualla riga dovrebbe essere
term_data_node__term_image.path AS term_data_node__term_image_path
Se lo inserisco senza nessuna relazione stessa identica cosa
SELECT DISTINCT(node.nid) AS nid,
node.title AS node_title,
node.language AS node_language,
node_data_field_external_link.field_external_link_url AS node_data_field_external_link_field_external_link_url,
node_data_field_external_link.field_external_link_title AS node_data_field_external_link_field_external_link_title,
node_data_field_external_link.field_external_link_attributes AS node_data_field_external_link_field_external_link_attributes,
node.type AS node_type,
node.vid AS node_vid,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format,
users.name AS users_name,
users.uid AS users_uid,
term_image.tid AS term_image_tid,
node_counter.daycount AS node_counter_daycount,
DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200 SECOND), '%Y%m%%d%H') AS node_created_hour
FROM net1_node node
avete idea se è un problema di vista o del modulo taxonomy_image
e se possibile come risolverlo
Grazie anzora
