|
Erreur
- warning: mysqli_query(): (HY000/1296): Got error 192 'Table encrypted but decryption failed. This could be because correct encryption management plugin is not loaded, used encryption key is not available or encryption method does not match.' from InnoDB in /home/lehooper/www/includes/database.mysqli.inc on line 114.
- user warning: Got error 192 'Table encrypted but decryption failed. This could be because correct encryption management plugin is not loaded, used encryption key is not available or encryption method does not match.' from InnoDB
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
node_node_comments__term_data.name AS node_node_comments__term_data_name,
node_node_comments__term_data.vid AS node_node_comments__term_data_vid,
node_node_comments__term_data.tid AS node_node_comments__term_data_tid,
node_node_comments.title AS node_node_comments_title,
node_node_comments.nid AS node_node_comments_nid,
node.type AS node_type,
node.title AS node_title,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format,
node.created AS node_created,
GREATEST(node_node_comments.changed, node_node_comments__node_comment_statistics.last_comment_timestamp) AS node_node_comments__node_comment_statistics_last_updated,
node_node_comments.type AS node_node_comments_type,
node_node_comments__node_comment_statistics.comment_count AS node_node_comments__node_comment_statistics_comment_count,
node.sticky AS topic_is_sticky,
forum.tid AS topic_actual_forum
FROM node node
LEFT JOIN node_comments node_comments ON node.nid = node_comments.cid
INNER JOIN node node_node_comments ON COALESCE(node_comments.nid, node.nid) = node_node_comments.nid
LEFT JOIN term_node node_node_comments__term_node ON node_node_comments.vid = node_node_comments__term_node.vid
LEFT JOIN term_node node_node_comments_node_node_comments__term_node ON node_node_comments.vid = node_node_comments_node_node_comments__term_node.vid
LEFT JOIN term_data node_node_comments__term_data ON node_node_comments__term_node.tid = node_node_comments__term_data.tid
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
INNER JOIN node_comment_statistics node_node_comments__node_comment_statistics ON node_node_comments.nid = node_node_comments__node_comment_statistics.nid
LEFT JOIN forum forum ON node.vid = forum.vid
WHERE (node.status = 1) AND (node_node_comments__term_data.vid in ('4')) AND (node_node_comments.vid IN (
SELECT tn.vid FROM term_node tn
LEFT JOIN term_hierarchy th ON th.tid = tn.tid
LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid
LEFT JOIN term_hierarchy th2 ON th1.parent = th2.tid
WHERE tn.tid IN (70, 74, 88, 437, 94, 429, 384, 438, 76, 90, 91, 413, 71, 77, 78, 425, 79, 107, 101, 102, 103, 104, 105, 106, 426, 108, 393, 394, 72, 95, 80, 81, 82, 86, 110, 521, 83, 407)
OR th1.tid IN (70, 74, 88, 437, 94, 429, 384, 438, 76, 90, 91, 413, 71, 77, 78, 425, 79, 107, 101, 102, 103, 104, 105, 106, 426, 108, 393, 394, 72, 95, 80, 81, 82, 86, 110, 521, 83, 407)
OR th2.tid IN (70, 74, 88, 437, 94, 429, 384, 438, 76, 90, 91, 413, 71, 77, 78, 425, 79, 107, 101, 102, 103, 104, 105, 106, 426, 108, 393, 394, 72, 95, 80, 81, 82, 86, 110, 521, 83, 407)
)) AND (node_node_comments.status = 1) AND (users.uid = 883 )
GROUP BY nid
ORDER BY node_created DESC
) count_alias in /home/lehooper/www/sites/all/modules/views/includes/view.inc on line 805.
- warning: mysqli_query(): (HY000/1030): Got error 1877 "Unknown error 1877" from storage engine InnoDB in /home/lehooper/www/includes/database.mysqli.inc on line 114.
- user warning: Got error 1877 "Unknown error 1877" from storage engine InnoDB
query: SELECT DISTINCT(node.nid) AS nid,
node_node_comments__term_data.name AS node_node_comments__term_data_name,
node_node_comments__term_data.vid AS node_node_comments__term_data_vid,
node_node_comments__term_data.tid AS node_node_comments__term_data_tid,
node_node_comments.title AS node_node_comments_title,
node_node_comments.nid AS node_node_comments_nid,
node.type AS node_type,
node.title AS node_title,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format,
node.created AS node_created,
GREATEST(node_node_comments.changed, node_node_comments__node_comment_statistics.last_comment_timestamp) AS node_node_comments__node_comment_statistics_last_updated,
node_node_comments.type AS node_node_comments_type,
node_node_comments__node_comment_statistics.comment_count AS node_node_comments__node_comment_statistics_comment_count,
node.sticky AS topic_is_sticky,
forum.tid AS topic_actual_forum
FROM node node
LEFT JOIN node_comments node_comments ON node.nid = node_comments.cid
INNER JOIN node node_node_comments ON COALESCE(node_comments.nid, node.nid) = node_node_comments.nid
LEFT JOIN term_node node_node_comments__term_node ON node_node_comments.vid = node_node_comments__term_node.vid
LEFT JOIN term_node node_node_comments_node_node_comments__term_node ON node_node_comments.vid = node_node_comments_node_node_comments__term_node.vid
LEFT JOIN term_data node_node_comments__term_data ON node_node_comments__term_node.tid = node_node_comments__term_data.tid
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
INNER JOIN node_comment_statistics node_node_comments__node_comment_statistics ON node_node_comments.nid = node_node_comments__node_comment_statistics.nid
LEFT JOIN forum forum ON node.vid = forum.vid
WHERE (node.status = 1) AND (node_node_comments__term_data.vid in ('4')) AND (node_node_comments.vid IN (
SELECT tn.vid FROM term_node tn
LEFT JOIN term_hierarchy th ON th.tid = tn.tid
LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid
LEFT JOIN term_hierarchy th2 ON th1.parent = th2.tid
WHERE tn.tid IN (70, 74, 88, 437, 94, 429, 384, 438, 76, 90, 91, 413, 71, 77, 78, 425, 79, 107, 101, 102, 103, 104, 105, 106, 426, 108, 393, 394, 72, 95, 80, 81, 82, 86, 110, 521, 83, 407)
OR th1.tid IN (70, 74, 88, 437, 94, 429, 384, 438, 76, 90, 91, 413, 71, 77, 78, 425, 79, 107, 101, 102, 103, 104, 105, 106, 426, 108, 393, 394, 72, 95, 80, 81, 82, 86, 110, 521, 83, 407)
OR th2.tid IN (70, 74, 88, 437, 94, 429, 384, 438, 76, 90, 91, 413, 71, 77, 78, 425, 79, 107, 101, 102, 103, 104, 105, 106, 426, 108, 393, 394, 72, 95, 80, 81, 82, 86, 110, 521, 83, 407)
)) AND (node_node_comments.status = 1) AND (users.uid = 883 )
GROUP BY nid
ORDER BY node_created DESC
LIMIT 0, 15 in /home/lehooper/www/sites/all/modules/views/includes/view.inc on line 810.
|
|
