Invalid query:
CREATE TEMPORARY TABLE TMP_TREEITEMS_76b665b3c3c0907829eb0c8c13918cbb ENGINE=MEMORY SELECT __t.id, __t.parent_id
, CASE WHEN t.left_key IS NULL THEN t.ord + _t.ord + 1 ELSE t.ord END AS ord
, __t.acl_object_id, __t.entity_type_id, __t.root_id, t.linked_item_id
, CASE WHEN t.left_key IS NULL THEN _t.left_key ELSE t.left_key END AS left_key
, CASE WHEN t.left_key IS NULL THEN _t.left_key ELSE t.right_key END AS right_key
, CASE WHEN t.left_key IS NULL THEN _t.level + 1 ELSE t.level END AS level
, CASE WHEN __t.id <> t.id THEN t.root_id ELSE NULL END AS master_root_id
, CASE WHEN __t.id <> t.id THEN t.parent_id ELSE NULL END AS master_id
, CASE WHEN __t.id <> t.id THEN t.id ELSE NULL END AS slave_id FROM T_TREE AS _ti
JOIN T_TREE AS t ON t.root_id = _ti.root_id AND t.left_key BETWEEN _ti.left_key AND _ti.right_key AND t.level >= _ti.level + 1 LEFT JOIN T_TREE AS _t ON _t.id = t.parent_id AND _t.root_id = t.root_id
JOIN T_TREE AS __t ON __t.id = CASE WHEN t.entity_type_id = 0 THEN t.linked_item_id ELSE t.id END AND __t.entity_type_id NOT IN (1) JOIN T_CONTENT AS con ON con.id = __t.id LEFT JOIN T_MV_DATA AS visibility_inheritance_cache ON visibility_inheritance_cache.mv_registry_id = 300114 AND visibility_inheritance_cache.tree_id = CASE WHEN __t.parent_id IS NULL THEN __t.id ELSE __t.parent_id END AND visibility_inheritance_cache.data = '1' WHERE (((_ti.id IN (2133)) AND ( NOT EXISTS (SELECT r.id FROM TMP_RESTRICTED_ITEMS_2 AS r WHERE r.root_id = t.root_id AND (r.id = t.id OR t.left_key BETWEEN r.left_key AND r.right_key AND t.level > r.level) OR r.root_id = _t.root_id AND (r.id = _t.id OR _t.left_key BETWEEN r.left_key AND r.right_key AND _t.level > r.level) OR r.root_id = __t.root_id AND (r.id = __t.id OR __t.left_key BETWEEN r.left_key AND r.right_key AND __t.level > r.level)))) AND ( visibility_inheritance_cache.tree_id IS NOT NULL)) AND (con.is_active = 1 AND
(con.show_after IS NULL OR FROM_UNIXTIME(1716034900) >= con.show_after) AND
(con.show_before IS NULL OR FROM_UNIXTIME(1716034900) < con.show_before)) UNION SELECT __t.id, __t.parent_id
, CASE WHEN t.left_key IS NULL THEN t.ord + _t.ord + 1 ELSE t.ord END AS ord
, __t.acl_object_id, __t.entity_type_id, __t.root_id, t.linked_item_id
, CASE WHEN t.left_key IS NULL THEN _t.left_key ELSE t.left_key END AS left_key
, CASE WHEN t.left_key IS NULL THEN _t.left_key ELSE t.right_key END AS right_key
, CASE WHEN t.left_key IS NULL THEN _t.level + 1 ELSE t.level END AS level
, CASE WHEN __t.id <> t.id THEN t.root_id ELSE NULL END AS master_root_id
, CASE WHEN __t.id <> t.id THEN t.parent_id ELSE NULL END AS master_id
, CASE WHEN __t.id <> t.id THEN t.id ELSE NULL END AS slave_id FROM T_TREE AS _ti
JOIN T_TREE AS t ON t.root_id = _ti.root_id AND t.parent_id = _ti.id AND t.left_key IS NULL LEFT JOIN T_TREE AS _t ON _t.id = t.parent_id AND _t.root_id = t.root_id
JOIN T_TREE AS __t ON __t.id = CASE WHEN t.entity_type_id = 0 THEN t.linked_item_id ELSE t.id END AND __t.entity_type_id NOT IN (1) JOIN T_CONTENT AS con ON con.id = __t.id LEFT JOIN T_MV_DATA AS visibility_inheritance_cache ON visibility_inheritance_cache.mv_registry_id = 300114 AND visibility_inheritance_cache.tree_id = CASE WHEN __t.parent_id IS NULL THEN __t.id ELSE __t.parent_id END AND visibility_inheritance_cache.data = '1' WHERE (((_ti.id IN (2133) AND _ti.left_key IS NULL) AND ( NOT EXISTS (SELECT r.id FROM TMP_RESTRICTED_ITEMS_2_COPY_1 AS r WHERE r.root_id = t.root_id AND (r.id = t.id OR t.left_key BETWEEN r.left_key AND r.right_key AND t.level > r.level) OR r.root_id = _t.root_id AND (r.id = _t.id OR _t.left_key BETWEEN r.left_key AND r.right_key AND _t.level > r.level) OR r.root_id = __t.root_id AND (r.id = __t.id OR __t.left_key BETWEEN r.left_key AND r.right_key AND __t.level > r.level)))) AND ( visibility_inheritance_cache.tree_id IS NOT NULL)) AND (con.is_active = 1 AND
(con.show_after IS NULL OR FROM_UNIXTIME(1716034900) >= con.show_after) AND
(con.show_before IS NULL OR FROM_UNIXTIME(1716034900) < con.show_before)) UNION SELECT __t.id, __t.parent_id
, CASE WHEN t.left_key IS NULL THEN t.ord + _t.ord + 1 ELSE t.ord END AS ord
, __t.acl_object_id, __t.entity_type_id, __t.root_id, t.linked_item_id
, CASE WHEN t.left_key IS NULL THEN _t.left_key ELSE t.left_key END AS left_key
, CASE WHEN t.left_key IS NULL THEN _t.left_key ELSE t.right_key END AS right_key
, CASE WHEN t.left_key IS NULL THEN _t.level + 1 ELSE t.level END AS level
, CASE WHEN __t.id <> t.id THEN t.root_id ELSE NULL END AS master_root_id
, CASE WHEN __t.id <> t.id THEN t.parent_id ELSE NULL END AS master_id
, CASE WHEN __t.id <> t.id THEN t.id ELSE NULL END AS slave_id FROM T_TREE AS __ti
JOIN T_TREE AS _ti ON _ti.root_id = __ti.root_id AND _ti.left_key BETWEEN __ti.left_key AND __ti.right_key AND _ti.level >= __ti.level + 0
JOIN T_TREE AS t ON t.root_id = _ti.root_id AND t.parent_id = _ti.id AND t.left_key IS NULL LEFT JOIN T_TREE AS _t ON _t.id = t.parent_id AND _t.root_id = t.root_id
JOIN T_TREE AS __t ON __t.id = CASE WHEN t.entity_type_id = 0 THEN t.linked_item_id ELSE t.id END AND __t.entity_type_id NOT IN (1) JOIN T_CONTENT AS con ON con.id = __t.id LEFT JOIN T_MV_DATA AS visibility_inheritance_cache ON visibility_inheritance_cache.mv_registry_id = 300114 AND visibility_inheritance_cache.tree_id = CASE WHEN __t.parent_id IS NULL THEN __t.id ELSE __t.parent_id END AND visibility_inheritance_cache.data = '1' WHERE (((__ti.id IN (2133)) AND ( NOT EXISTS (SELECT r.id FROM TMP_RESTRICTED_ITEMS_2_COPY_2 AS r WHERE r.root_id = t.root_id AND (r.id = t.id OR t.left_key BETWEEN r.left_key AND r.right_key AND t.level > r.level) OR r.root_id = _t.root_id AND (r.id = _t.id OR _t.left_key BETWEEN r.left_key AND r.right_key AND _t.level > r.level) OR r.root_id = __t.root_id AND (r.id = __t.id OR __t.left_key BETWEEN r.left_key AND r.right_key AND __t.level > r.level)))) AND ( visibility_inheritance_cache.tree_id IS NOT NULL)) AND (con.is_active = 1 AND
(con.show_after IS NULL OR FROM_UNIXTIME(1716034900) >= con.show_after) AND
(con.show_before IS NULL OR FROM_UNIXTIME(1716034900) < con.show_before))
The table '/tmp/#sqlf19fc_2e67_3f' is full
at MySQLiDatabase->executeQueryStr("CREATE TEMPORARY TABLE TMP_TREEITEMS_76b665b3c3c0907829eb0c8c139...") [/var/www/metportal/data/www/metportal.com.ua/engine/classes/db/AbstractDatabase.php:116])
at AbstractDatabase->selectAsTemporaryTableImpl("CREATE TEMPORARY TABLE TMP_TREEITEMS_76b665b3c3c0907829eb0c8c139...", "TMP_TREEITEMS_76b665b3c3c0907829eb0c8c13918cbb", False) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/db/AbstractDatabase.php:35])
at AbstractDatabase->selectAsTemporaryTableStr("SELECT __t.id, __t.parent_id
, CASE WHEN t.left_key IS NULL ...", "TMP_TREEITEMS_76b665b3c3c0907829eb0c8c13918cbb", False) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/db/AbstractDatabase.php:26])
at AbstractDatabase->selectAsTemporaryTable(Object(MySQLQuery), "TMP_TREEITEMS_76b665b3c3c0907829eb0c8c13918cbb") [/var/www/metportal/data/www/metportal.com.ua/engine/classes/bl/content/DatabaseTree.php:985])
at DatabaseTree->enumChildren("2133", 1, 0, "TMP_TREEITEMS_76b665b3c3c0907829eb0c8c13918cbb", "!1", Object(CompositeQueryFilter)) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/bl/content/TreeItemProvider.php:984])
at TreeItemProvider->listTreeItems("2133", "ru", 1, 0, 118100, "50", Object(CompositeQueryFilter), "!1", Null, 1, Object(CompositeQueryFilter)) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/modules/content/ArticleList.php:131])
at ArticleList->fetchTemplateDataImpl(Object(ModuleContext)) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/modules/Module.php:578])
at Module->fetchTemplateData(Object(ModuleContext)) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/modules/Module.php:560])
at Module->bindDisplayContext(Object(ModuleContext), 1) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/modules/Module.php:550])
at Module->display(Object(ModuleContext), 1) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/modules/Module.php:432])
at Module->displayCache(Object(ModuleContext), 2) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/Frame.php:93])
at Frame->displayAll(2) [/var/www/metportal/data/www/metportal.com.ua/engine/classes/View.php:559])
at View->display("main_content") [/var/www/metportal/data/www/metportal.com.ua/site/templates/default/index.php:58])
at include_once("/var/www/metportal/data/www/metportal.com.ua/site/templates/defa...") [/var/www/metportal/data/www/metportal.com.ua/engine/inc/main.inc.php:65])
at include_once("/var/www/metportal/data/www/metportal.com.ua/engine/inc/main.inc...") [/var/www/metportal/data/www/metportal.com.ua/index.php:225])
|