Unknown column 'ago.id_object' in 'on clause'
SELECT *
FROM `ps_attribute` a
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_object_owner` ao on (ao.entity='attribute' AND ago.id_object=ag.id_attribute)
WHERE a.`id_attribute_group` = 2
AND IFNULL(ao.id_owner,0) in (0,0)
ORDER BY `position` ASC
at line 769 in file classes/db/Db.php
764. if ($webservice_call && $errno) {
765. $dbg = debug_backtrace();
766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768. if ($sql) {
769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770. }
771.
772. throw new PrestaShopDatabaseException($this->getMsgError());
773. }
774. }
380. $this->result = $this->_query($sql);
381. }
382. }
383.
384. if (_PS_DEBUG_SQL_) {
385. $this->displayError($sql);
386. }
387.
388. return $this->result;
389. }
390.
Argument [0] SELECT * FROM `ps_attribute` a INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_object_owner` ao on (ao.entity='attribute' AND ago.id_object=ag.id_attribute) WHERE a.`id_attribute_group` = 2 AND IFNULL(ao.id_owner,0) in (0,0) ORDER BY `position` ASC
608. }
609.
610. return $this->execute($sql, $use_cache);
611. }
612.
613. $this->result = $this->query($sql);
614.
615. if (!$this->result) {
616. $result = false;
617. } else {
618. if (!$array) {
Argument [0] SELECT * FROM `ps_attribute` a INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_object_owner` ao on (ao.entity='attribute' AND ago.id_object=ag.id_attribute) WHERE a.`id_attribute_group` = 2 AND IFNULL(ao.id_owner,0) in (0,0) ORDER BY `position` ASC
25. WHERE a.`id_attribute_group` = '.(int)$id_attribute_group.'
26. '. $additional_where.'
27. ORDER BY `position` ASC
28. ';
29.
30. return Db::getInstance()->executeS($sql);
31. }
32. /*
33. * module: agilemultipleseller
34. * date: 2020-04-06 14:56:37
35. * version: 3.7.4.0
Argument [0] SELECT * FROM `ps_attribute` a INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_object_owner` ao on (ao.entity='attribute' AND ago.id_object=ag.id_attribute) WHERE a.`id_attribute_group` = 2 AND IFNULL(ao.id_owner,0) in (0,0) ORDER BY `position` ASC
324. foreach ($attributesGroup as $attributeGroup) {
325. if ($filter['id_value'] == $attributeGroup['id_attribute_group']
326. && isset($facetAndFiltersLabels[$attributeGroup['public_name']])
327. ) {
328. $attributeLabels = $facetAndFiltersLabels[$attributeGroup['public_name']];
329. $attributes = AttributeGroup::getAttributes($idLang, $attributeGroup['id_attribute_group']);
330. foreach ($attributes as $attribute) {
331. if (in_array($attribute['name'], $attributeLabels)) {
332. $searchFilters['id_attribute_group'][$attributeGroup['id_attribute_group']][] = $attribute['id_attribute'];
333. }
334. }
Argument [0] 1 Argument [1] 2
110. ProductSearchContext $context,
111. ProductSearchQuery $query
112. ) {
113. $result = new ProductSearchResult();
114. // extract the filter array from the Search query
115. $facetedSearchFilters = $this->filtersConverter->createFacetedSearchFiltersFromQuery($query);
116.
117. $context = $this->module->getContext();
118. $facetedSearch = new Search($context);
119. // init the search with the initial population associated with the current filters
120. $facetedSearch->initSearch($facetedSearchFilters);
Argument [0] PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery Object ( [query_type:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [id_category:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => 2 [id_manufacturer:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [id_supplier:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [search_string:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [search_tag:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [encodedFacets:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => Farbe-Camel [resultsPerPage:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => 20 [page:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => 1 [sortOrder:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => PrestaShop\PrestaShop\Core\Product\Search\SortOrder Object ( [entity:PrestaShop\PrestaShop\Core\Product\Search\SortOrder:private] => product [field:PrestaShop\PrestaShop\Core\Product\Search\SortOrder:private] => position [direction:PrestaShop\PrestaShop\Core\Product\Search\SortOrder:private] => asc [label:PrestaShop\PrestaShop\Core\Product\Search\SortOrder:private] => ) )
307. // We're ready to run the actual query!
308.
309. $result = $provider->runQuery(
310. $context,
311. $query
312. );
313.
314. // sort order is useful for template,
315. // add it if undefined - it should be the same one
316. // as for the query anyway
317. if (!$result->getCurrentSortOrder()) {
Argument [0] PrestaShop\PrestaShop\Core\Product\Search\ProductSearchContext Object ( [id_shop:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchContext:private] => 1 [id_lang:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchContext:private] => 1 [id_currency:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchContext:private] => 1 [id_customer:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchContext:private] => ) Argument [1] PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery Object ( [query_type:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [id_category:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => 2 [id_manufacturer:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [id_supplier:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [search_string:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [search_tag:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => [encodedFacets:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => Farbe-Camel [resultsPerPage:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => 20 [page:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => 1 [sortOrder:PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery:private] => PrestaShop\PrestaShop\Core\Product\Search\SortOrder Object ( [entity:PrestaShop\PrestaShop\Core\Product\Search\SortOrder:private] => product [field:PrestaShop\PrestaShop\Core\Product\Search\SortOrder:private] => position [direction:PrestaShop\PrestaShop\Core\Product\Search\SortOrder:private] => asc [label:PrestaShop\PrestaShop\Core\Product\Search\SortOrder:private] => ) )
540. header('Content-Type: application/json');
541. $this->ajaxRender(json_encode($this->getAjaxProductSearchVariables()));
542.
543. return;
544. } else {
545. $variables = $this->getProductSearchVariables();
546. $this->context->smarty->assign(array(
547. 'listing' => $variables,
548. ));
549. $this->setTemplate($template, $params, $locale);
550. }
134. 'catalog/listing/category',
135. [
136. 'entity' => 'category',
137. 'id' => $this->category->id,
138. ]
139. );
140. }
141. }
142.
143. /**
144. * overrides layout if category is not visible.
Argument [0] catalog/listing/category Argument [1] Array ( [entity] => category [id] => 2 )
276. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
277. $this->initHeader();
278. }
279.
280. if ($this->viewAccess()) {
281. $this->initContent();
282. } else {
283. $this->errors[] = $this->trans('Access denied.', array(), 'Admin.Notifications.Error');
284. }
285.
286. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
504. if (isset($params_hook_action_dispatcher)) {
505. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
506. }
507.
508. // Running controller
509. $controller->run();
510.
511. // Execute hook dispatcher after
512. if (isset($params_hook_action_dispatcher)) {
513. Hook::exec('actionDispatcherAfter', $params_hook_action_dispatcher);
514. }
36. define('_IS_GOOGLE_', true);
37. } else {
38. define('_IS_GOOGLE_', false);
39. }*/
40.
41. Dispatcher::getInstance()->dispatch();