|
Erreur
- user warning: Unknown column 'node_comment_statistics.last_updated' in 'field list'
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid_1,
node.nid AS nid,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format,
node.type AS node_type,
node.title AS node_title,
users.name AS users_name,
users.uid AS users_uid,
node.created AS node_created,
node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
node_counter.totalcount AS node_counter_totalcount,
COALESCE(ncs_users.name, node_comment_statistics.last_comment_name) AS node_comment_statistics_last_comment_name,
ncs_users.name AS ncs_users_name,
node_comment_statistics.last_comment_uid AS node_comment_statistics_last_comment_uid,
GREATEST(node.changed, node_comment_statistics.last_comment_timestamp) AS node_comment_statistics_last_updated,
node.sticky AS node_sticky,
node.comment AS node_comment,
term_data.name AS term_data_name,
term_data.vid AS term_data_vid,
term_data.tid AS term_data_tid,
node_comment_statistics.last_updated AS node_comment_statistics_last_updated_1,
node.sticky AS topic_is_sticky,
forum.tid AS topic_actual_forum
FROM node node
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
INNER JOIN users users ON node.uid = users.uid
INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid
LEFT JOIN users ncs_users ON node_comment_statistics.last_comment_uid = ncs_users.uid AND ncs_users.uid != '0'
LEFT JOIN forum forum ON node.vid = forum.vid
WHERE (node.status <> 0) AND (term_data.vid in ('3'))
GROUP BY nid_1
ORDER BY node_comment_statistics_last_updated DESC, node_comment_statistics_last_updated_1 DESC
) count_alias in /home/knt/webdir/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
- user warning: Unknown column 'node_comment_statistics.last_updated' in 'field list'
query: SELECT DISTINCT(node.nid) AS nid_1,
node.nid AS nid,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format,
node.type AS node_type,
node.title AS node_title,
users.name AS users_name,
users.uid AS users_uid,
node.created AS node_created,
node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
node_counter.totalcount AS node_counter_totalcount,
COALESCE(ncs_users.name, node_comment_statistics.last_comment_name) AS node_comment_statistics_last_comment_name,
ncs_users.name AS ncs_users_name,
node_comment_statistics.last_comment_uid AS node_comment_statistics_last_comment_uid,
GREATEST(node.changed, node_comment_statistics.last_comment_timestamp) AS node_comment_statistics_last_updated,
node.sticky AS node_sticky,
node.comment AS node_comment,
term_data.name AS term_data_name,
term_data.vid AS term_data_vid,
term_data.tid AS term_data_tid,
node_comment_statistics.last_updated AS node_comment_statistics_last_updated_1,
node.sticky AS topic_is_sticky,
forum.tid AS topic_actual_forum
FROM node node
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
INNER JOIN users users ON node.uid = users.uid
INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid
LEFT JOIN users ncs_users ON node_comment_statistics.last_comment_uid = ncs_users.uid AND ncs_users.uid != '0'
LEFT JOIN forum forum ON node.vid = forum.vid
WHERE (node.status <> 0) AND (term_data.vid in ('3'))
GROUP BY nid_1
ORDER BY node_comment_statistics_last_updated DESC, node_comment_statistics_last_updated_1 DESC
LIMIT 0, 20 in /home/knt/webdir/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1090.
|
|
