Ошибка 404 в модуле Video [225093], вспомогательный шаблон Video Page.

Неверный адрес (video-ohota-na-kabana-video-1) или страница удалена. Проверьте SQL выражение для селекта айтема.

Документация по работе модуля Proto

Отладочная информация для модуля 225093 «Video»

JSON API: HashArray подробно в документации по API
TEXT API: TotalItemsUniqsPagesLetterBackwardForwardMinMaxFirstLastPrevNext

Основные параметры
Имена параметров из QUERY_STRING
Значения параметров из QUERY_STRING
Настройки для вычисления урлов
Настройки сортировки
Все переменные %VARS1, которые можно использовать в sql-select, sql-where, data-mask, sql-groupby, sql-having, sql-limit
{ 'offset' : 0, 'row_count' : 100, 'remote_ip' : '3.81.73.233', 'lang' : undef, 'url_hex' : 'd148d75ee650d6ed2d391309ebff3c14', 'urn' : 'ohota-na-kabana-video-1', 'urns' : 'ohota-na-kabana-video-1', 'uri' : '/video/video-pro-kabana/ohota-na-kabana-video-1.html?debug_info_show=225093&debug_info_log=225093', 'referer' : undef, 'method' : 'GET', 'page' : 11566, 'branch' : undef, 'account' : 1981, 'domain' : 'nakabana.ru', 'holder' : 11129, 'member' : 38747, 'user' : 55658985, 'users' : 55658985, 'uri_string' : 'https://nakabana.ru/video/video-pro-kabana/ohota-na-kabana-video-1.html?debug_info_show=225093&debug_info_log=225093', 'uri_path_query' : '/video/video-pro-kabana/ohota-na-kabana-video-1.html?debug_info_show=225093&debug_info_log=225093', 'uri_path' : '/video/video-pro-kabana/ohota-na-kabana-video-1.html', 'query_string' : 'debug_info_show=225093&debug_info_log=225093', 'request_uri' : '/video/video-pro-kabana/ohota-na-kabana-video-1.html?debug_info_show=225093&debug_info_log=225093', 'http_referer' : undef, 'http_host' : 'nakabana.ru', 'http_scheme' : 'https://', 'browser_string' : undef, 'browser_version' : '2.0', 'engine_string' : undef, 'engine_version' : undef, 'os_string' : undef, 'device_string' : undef, 'robot_string' : 'CCBot', 'delayed' : undef, 'final_render' : undef, 'breadcrumbs' : sub { "DUMMY" }, 'sitesearch' : sub { "DUMMY" }, 'module_parent' : 225084, 'module' : 225093, 'status' : undef, 'Function' : 'folder', 'folder_uid_ids' : sub { "DUMMY" }, 'folder_hld_holders' : sub { "DUMMY" }, 'folder_mbr_members' : sub { "DUMMY" }, 'folder_hld_holder' : 11129, 'folder_chr_name' : 'Охота на кабана', 'folder_enm_spec' : 'NO', 'folder_enm_active' : 'YES', 'folder_txt_text' : '', 'folder_uid_id' : 38747, 'folder_ind_index' : 1, 'folder_chr_link' : 'video-pro-kabana', 'folder_cnt_account' : 1981, 'folder_smp_create' : '2016-11-04 22:40:13', 'folder_ref_parent' : 0, 'folder_mbr_member' : 0, 'folder_smp_update' : '2016-11-27 20:52:05', 'plain-folder_txt_abstract' : sub { "DUMMY" }, 'xml-folder_txt_abstract' : sub { "DUMMY" }, 'utf8-folder_txt_abstract' : sub { "DUMMY" }, 'xml_utf8-folder_txt_abstract' : sub { "DUMMY" }, 'plain_utf8-folder_txt_abstract' : sub { "DUMMY" }, 'escape-folder_txt_abstract' : sub { "DUMMY" }, 'escape_utf8-folder_txt_abstract' : sub { "DUMMY" }, 'encode_base64-folder_txt_abstract' : sub { "DUMMY" }, 'plain-folder_txt_descr' : sub { "DUMMY" }, 'xml-folder_txt_descr' : sub { "DUMMY" }, 'utf8-folder_txt_descr' : sub { "DUMMY" }, 'xml_utf8-folder_txt_descr' : sub { "DUMMY" }, 'plain_utf8-folder_txt_descr' : sub { "DUMMY" }, 'escape-folder_txt_descr' : sub { "DUMMY" }, 'escape_utf8-folder_txt_descr' : sub { "DUMMY" }, 'encode_base64-folder_txt_descr' : sub { "DUMMY" }, 'plain-folder_chr_name' : sub { "DUMMY" }, 'xml-folder_chr_name' : sub { "DUMMY" }, 'utf8-folder_chr_name' : sub { "DUMMY" }, 'xml_utf8-folder_chr_name' : sub { "DUMMY" }, 'plain_utf8-folder_chr_name' : sub { "DUMMY" }, 'escape-folder_chr_name' : sub { "DUMMY" }, 'escape_utf8-folder_chr_name' : sub { "DUMMY" }, 'encode_base64-folder_chr_name' : sub { "DUMMY" }, 'plain-folder_set_category' : sub { "DUMMY" }, 'xml-folder_set_category' : sub { "DUMMY" }, 'utf8-folder_set_category' : sub { "DUMMY" }, 'xml_utf8-folder_set_category' : sub { "DUMMY" }, 'plain_utf8-folder_set_category' : sub { "DUMMY" }, 'escape-folder_set_category' : sub { "DUMMY" }, 'escape_utf8-folder_set_category' : sub { "DUMMY" }, 'encode_base64-folder_set_category' : sub { "DUMMY" }, 'plain-folder_chr_title' : sub { "DUMMY" }, 'xml-folder_chr_title' : sub { "DUMMY" }, 'utf8-folder_chr_title' : sub { "DUMMY" }, 'xml_utf8-folder_chr_title' : sub { "DUMMY" }, 'plain_utf8-folder_chr_title' : sub { "DUMMY" }, 'escape-folder_chr_title' : sub { "DUMMY" }, 'escape_utf8-folder_chr_title' : sub { "DUMMY" }, 'encode_base64-folder_chr_title' : sub { "DUMMY" }, 'plain-folder_txt_text' : sub { "DUMMY" }, 'xml-folder_txt_text' : sub { "DUMMY" }, 'utf8-folder_txt_text' : sub { "DUMMY" }, 'xml_utf8-folder_txt_text' : sub { "DUMMY" }, 'plain_utf8-folder_txt_text' : sub { "DUMMY" }, 'escape-folder_txt_text' : sub { "DUMMY" }, 'escape_utf8-folder_txt_text' : sub { "DUMMY" }, 'encode_base64-folder_txt_text' : sub { "DUMMY" }, 'plain-folder_chr_link' : sub { "DUMMY" }, 'xml-folder_chr_link' : sub { "DUMMY" }, 'utf8-folder_chr_link' : sub { "DUMMY" }, 'xml_utf8-folder_chr_link' : sub { "DUMMY" }, 'plain_utf8-folder_chr_link' : sub { "DUMMY" }, 'escape-folder_chr_link' : sub { "DUMMY" }, 'escape_utf8-folder_chr_link' : sub { "DUMMY" }, 'encode_base64-folder_chr_link' : sub { "DUMMY" }, 'plain-folder_txt_keywords' : sub { "DUMMY" }, 'xml-folder_txt_keywords' : sub { "DUMMY" }, 'utf8-folder_txt_keywords' : sub { "DUMMY" }, 'xml_utf8-folder_txt_keywords' : sub { "DUMMY" }, 'plain_utf8-folder_txt_keywords' : sub { "DUMMY" }, 'escape-folder_txt_keywords' : sub { "DUMMY" }, 'escape_utf8-folder_txt_keywords' : sub { "DUMMY" }, 'encode_base64-folder_txt_keywords' : sub { "DUMMY" }, 'bool-folder_enm_spec' : sub { "DUMMY" }, 'bool-folder_enm_active' : sub { "DUMMY" }, 'unix-folder_dat_date' : sub { "DUMMY" }, 'date-folder_dat_date' : sub { "DUMMY" }, 'ddmmyy-folder_dat_date' : sub { "DUMMY" }, 'ddmm-folder_dat_date' : sub { "DUMMY" }, 'mmdd-folder_dat_date' : sub { "DUMMY" }, 'time-folder_dat_date' : sub { "DUMMY" }, 'unix-folder_smp_create' : sub { "DUMMY" }, 'date-folder_smp_create' : sub { "DUMMY" }, 'ddmmyy-folder_smp_create' : sub { "DUMMY" }, 'ddmm-folder_smp_create' : sub { "DUMMY" }, 'mmdd-folder_smp_create' : sub { "DUMMY" }, 'time-folder_smp_create' : sub { "DUMMY" }, 'unix-folder_smp_update' : sub { "DUMMY" }, 'date-folder_smp_update' : sub { "DUMMY" }, 'ddmmyy-folder_smp_update' : sub { "DUMMY" }, 'ddmm-folder_smp_update' : sub { "DUMMY" }, 'mmdd-folder_smp_update' : sub { "DUMMY" }, 'time-folder_smp_update' : sub { "DUMMY" }, 'folder_chr_name_alt' : 'Охота на кабана', 'Folder_Href' : sub { "DUMMY" }, 'mime' : 'html', 'debug_info_log' : 225093, 'debug_info_show' : 225093, 'p' : 'video', 'folder' : 'video-pro-kabana', 'video' : 'ohota-na-kabana-video-1' }
Все алиасы (alias) и их выражения (select_expr) найденные в селекте
{ "video_uid_id" : "video_uid_id", "video_cnt_account" : "video_cnt_account", "video_hld_holder" : "video_hld_holder", "video_mbr_member" : "video_mbr_member", "video_chr_link" : "video_chr_link", "video_chr_name" : "video_chr_name", "video_dat_date" : "video_dat_date", "video_chr_href" : "video_chr_href", "video_chr_size" : "video_chr_size", "video_img_image1" : "video_img_image1", "video_wth_image1" : "video_wth_image1", "video_hgt_image1" : "video_hgt_image1", "video_int_width" : "video_int_width", "video_int_height" : "video_int_height", "video_txt_text" : "video_txt_text", "video_enm_active" : "video_enm_active", "video_txt_descr" : "video_txt_descr", "video_txt_keywords" : "video_txt_keywords", "video_chr_title" : "video_chr_title", "video_ind_index" : "video_ind_index", "video_smp_create" : "video_smp_create", "video_smp_update" : "video_smp_update", "Date" : "DATE_FORMAT(video_dat_date,'%Y-%m-%d')", "Time" : "DATE_FORMAT(video_dat_date,'%H:%i')", "Day" : "DATE_FORMAT(video_dat_date,'%d')", "Mon" : "DATE_FORMAT(video_dat_date,'%m')", "Year" : "DATE_FORMAT(video_dat_date,'%Y')" }
Алгоритм вычислеия УРЛов

Модуль привязан к родительской подшивке (module_tie = 1), УРЛ наследуется, ничего вычислять не надо. Цепочку модулей (ф-ия SeekModule) не ищем.

Параметры из QUERY_STRING для пагинации
{}

Айтем ищем по его URN (video_chr_link=ohota-na-kabana-video-1).

Запрос для выборки одного айтема
SELECT video_uid_id, video_cnt_account, video_hld_holder, video_mbr_member, video_chr_link, video_chr_name, video_dat_date, video_chr_href, video_chr_size, video_img_image1, video_wth_image1, video_hgt_image1, video_int_width, video_int_height, video_txt_text, video_enm_active, video_txt_descr, video_txt_keywords, video_chr_title, video_ind_index, video_smp_create, video_smp_update, DATE_FORMAT(video_dat_date,'%Y-%m-%d') AS Date, DATE_FORMAT(video_dat_date,'%H:%i') AS Time, DATE_FORMAT(video_dat_date,'%d') AS Day, DATE_FORMAT(video_dat_date,'%m') AS Mon, DATE_FORMAT(video_dat_date,'%Y') AS Year FROM account_video a WHERE a.video_cnt_account=1981 AND a.video_hld_holder IN(11129) AND a.video_mbr_member IN(38747) AND video_chr_link LIKE ? ORDER BY video_uid_id LIMIT 1 (где знак '?' заменяется на значение 'ohota-na-kabana-video-1')

Запрос вернул ноль строк. Не нашли айтем по его URN. Другими словами это ошибка 404.



Краткая справка

Модуль выполняет два варианта запросов к БД:

Плейсхолдеры, которые можно использовать в шаблоне
{ "Account" : "1981", "Holder" : "11129", "Member" : 38747, "Function" : "video", "UserID" : 55658985, "Users" : "Функция", "Letter" : "Функция", "Pages" : "Функция", "Backward" : "Функция", "Forward" : "Функция", "PagePos" : "Функция", "PageQuantity" : "Функция", "Pos" : "Функция", "Min" : "Функция", "Max" : "Функция", "Last" : "Функция", "First" : "Функция", "Prev" : "Функция", "Next" : "Функция", "Total" : "Функция", "Items" : "Функция", "Uniqs" : "Функция", "Hash" : "Функция", "Array" : "Функция", "Listing" : "Функция", "Union" : "/video/video-pro-kabana/union.html", "Data_uid_id" : "video_uid_id", "Data_hld_holder" : "video_hld_holder", "Data_mbr_member" : "video_mbr_member", "Data_chr_link" : "video_chr_link", "Data_ref_link" : null, "Data_lng_language" : null, "Data_chr_name" : "video_chr_name", "Data_chr_title" : "video_chr_title", "Data_txt_descr" : "video_txt_descr", "Data_txt_keywords" : "video_txt_keywords", "QA" : "video", "QA_Page" : "p", "QA_ItemQuantity" : "quantvideo", "QA_FirstItem" : "firstvideo", "QA_Sort" : "sortvideo", "QA_Desc" : "descvideo", "Return" : null, "ItemQuantity" : "100", "FirstItem" : "0", "QSPage" : "video", "BaseHref" : null, "main-Module" : "225093", "page-Module" : "Функция", "parent-Module" : 225084, "SQL" : "SELECT\n\tvideo_uid_id,\n\tvideo_cnt_account,\n\tvideo_hld_holder,\n\tvideo_mbr_member,\n\tvideo_chr_link,\n\tvideo_chr_name,\n\tvideo_dat_date,\n\tvideo_chr_href,\n\tvideo_chr_size,\n\tvideo_img_image1,\n\tvideo_wth_image1,\n\tvideo_hgt_image1,\n\tvideo_int_width,\n\tvideo_int_height,\n\tvideo_txt_text,\n\tvideo_enm_active,\n\tvideo_txt_descr,\n\tvideo_txt_keywords,\n\tvideo_chr_title,\n\tvideo_ind_index,\n\tvideo_smp_create,\n\tvideo_smp_update,\n\tDATE_FORMAT(video_dat_date,'%Y-%m-%d') AS Date,\n\tDATE_FORMAT(video_dat_date,'%H:%i') AS Time,\n\tDATE_FORMAT(video_dat_date,'%d') AS Day,\n\tDATE_FORMAT(video_dat_date,'%m') AS Mon,\n\tDATE_FORMAT(video_dat_date,'%Y') AS Year\nFROM account_video a\n\tWHERE a.video_cnt_account=1981\nAND a.video_hld_holder IN(11129)\nAND a.video_mbr_member IN(38747)\n\t AND video_chr_link LIKE ? \n\t\n\t\n\tORDER BY video_uid_id \n\tLIMIT 1 /*URN item*/", "Timing" : "Функция", "AuthLogin" : "Функция", "CONF_QsSelect" : "1", "CONF_ShowEmpty" : "1", "CONF_ColumnCount" : 0, "CONF_ColumnFormat" : "1", "CONF_SeekModule" : "0", "CONF_ItemQuantity" : "100", "CONF_SqlWhereQsMatch" : "", "CONF_SqlGroupby" : "", "CONF_SqlHaving" : "", "CONF_QsId" : "video", "CONF_SqlLimit" : "LIMIT 100 OFFSET 0", "CONF_SqlFrom" : "FROM account_video a", "CONF_CustomParent" : "", "CONF_SqlWhere" : "WHERE a.video_cnt_account=1981\nAND a.video_hld_holder IN(11129)\nAND a.video_mbr_member IN(38747)", "CONF_SqlSelect" : "SELECT\n\tvideo_uid_id,\n\tvideo_cnt_account,\n\tvideo_hld_holder,\n\tvideo_mbr_member,\n\tvideo_chr_link,\n\tvideo_chr_name,\n\tvideo_dat_date,\n\tvideo_chr_href,\n\tvideo_chr_size,\n\tvideo_img_image1,\n\tvideo_wth_image1,\n\tvideo_hgt_image1,\n\tvideo_int_width,\n\tvideo_int_height,\n\tvideo_txt_text,\n\tvideo_enm_active,\n\tvideo_txt_descr,\n\tvideo_txt_keywords,\n\tvideo_chr_title,\n\tvideo_ind_index,\n\tvideo_smp_create,\n\tvideo_smp_update,\n\tDATE_FORMAT(video_dat_date,'%Y-%m-%d') AS Date,\n\tDATE_FORMAT(video_dat_date,'%H:%i') AS Time,\n\tDATE_FORMAT(video_dat_date,'%d') AS Day,\n\tDATE_FORMAT(video_dat_date,'%m') AS Mon,\n\tDATE_FORMAT(video_dat_date,'%Y') AS Year", "CONF_FunctionTable" : "account_video", "CONF_ShortText" : 100, "Video_Href" : "Функция", "([A-Z][a-z]+)Update" : "Функция", "([a-z]+_[a-z]+)Update" : "Функция" }

ВАРИАНТ 1. Показываем страницу айтема. Параметр URN (имя video в QUERY_STRING) определён (значение равно ohota-na-kabana-video-1). Соотвтественно айтем выбран.

Выбираем модуль из списка доступных шаблонов ('Video Page', 'Video') с ролью module_role=CONTAINER:

Условие выполнено (MATCH) для шаблона: «Video Page»

SELECT 'ohota-na-kabana-video-1' is not null

Нашли шаблон (Page CONTAINER) для страницы айтема — 225095 «Video Page».

Фото с охоты