Oops — something went wrong. We’re experiencing a temporary technical issue. Please try again in a few minutes.
Ошибка при запросе к БД!
SQL: SELECT `prints_set`.`id`, `prints_set`.`url`, `prints_set`.`name_full`, COUNT(`vector_id`) c, MIN(`price`) price, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1), (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1)) as preview, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, 1, 0) as vector FROM `prints_set` LEFT JOIN `prints_set_vector` ON `prints_set`.`id` = `prints_set_vector`.`set_id` LEFT JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set`.id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(56,31929,824,1095,1319,1324,1542,3704,4819,4820,28832,30086)) AND id NOT IN(31578) AND EXISTS(SELECT 1 FROM `prints_set_vector` psv2 INNER JOIN `prints_vector` pv2 ON pv2.`id` = psv2.`vector_id` WHERE psv2.`set_id` = `prints_set`.`id` AND psv2.`vector_id` IN(56,31929,824,1095,1319,1324,1542,3704,4819,4820,28832,30086) AND pv2.`bundle` = 0) GROUP BY `prints_set`.`id` ORDER BY IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, 0, 1), `prints_set`.`name_full` LIMIT 3
Ошибка: Column 'id' in IN/ALL/ANY subquery is ambiguous
Ошибка в '/var/www/html/nox-system/db/noxDbQuery.class.php' в строке 151:
<?php
146 return true;
147 } else
148 {
149 if (noxConfig::isDebug() && !isset($GLOBALS['cron']))
150 {
>>151 throw new noxException('Ошибка при запросе к БД!<br /><br />SQL: ' . htmlspecialchars($sql) . '<br /><br />Ошибка: ' . $this->db->error());
152 }
153 return false;
154 }
155 }
156
?>
Стек вызова
#0 /var/www/html/nox-modules/prints/lib/models/printsSet.model.php(326): noxDbQuery->exec('SELECT `prints_...')
#1 /var/www/html/nox-modules/prints/lib/models/printsSet.model.php(252): printsSetModel->getSetsForVectors(Array, 3, '31578')
#2 /var/www/html/nox-modules/prints/lib/actions/frontend/printsBlueprintsPrint.action.php(129): printsSetModel->getRelatedSetsForBlueprintLinkedFirst(Array, 31578)
#3 /var/www/html/nox-system/action/noxThemeAction.class.php(221): printsBlueprintsPrintAction->execute()
#4 /var/www/html/nox-system/application/noxApplication.class.php(303): noxThemeAction->run()
#5 /var/www/html/nox-system/application/noxApplication.class.php(364): noxApplication->runAction()
#6 /var/www/html/nox-config/application.class.php(17): noxApplication->run()
#7 /var/www/html/nox-system/noxSystem.class.php(371): application->run()
#8 /var/www/html/index.php(11): noxSystem::run()
#9 {main}noxSystem
Full URL: https://v2.getoutlines.com/blueprints/582/1968-buick-lesabre-4-door-sedan-blueprints
Base URL:
Request URL: /blueprints/582/1968-buick-lesabre-4-door-sedan-blueprints
Request Path: /blueprints/582/1968-buick-lesabre-4-door-sedan-blueprints
Module URL:
Action URL: /blueprints/582/1968-buick-lesabre-4-door-sedan-blueprints
Params: Array
(
[get_preset] => Array
(
[id] => 0
[page] => 1
[search] =>
[section] => administrator
[status] => 0
[order] => 0
[period] => 0
[author] => 0
[contact] => 0
[category_id] => 0
[filter category_id] => 0
[make_id] => 0
[filter make_id] => 0
[filter set_id] => 0
[report_id] => 0
[update_count] => 0
[prm1] => 0
[prm2] => 0
[prm3] => 0
[days] => 0
[want_pay] => 0
)
[get] => Array
(
[id] => 0
[page] => 1
[search] =>
[section] => administrator
[status] => 0
[order] => 0
[period] => 0
[author] => 0
[contact] => 0
[category_id] => 0
[filter] => Array
(
[category_id] => 0
[make_id] => 0
[set_id] => 0
)
[make_id] => 0
[report_id] => 0
[update_count] => 0
[prm1] => 0
[prm2] => 0
[prm3] => 0
[days] => 0
[want_pay] => 0
)
[post] => Array
(
)
[requestMethod] => GET
[ajax] =>
[backend] =>
[frontend] => 1
[printId] => 582
[printUrl] => 1968-buick-lesabre-4-door-sedan
)
Module Folder: /var/www/html/nox-modules/prints