[PrestaShopDatabaseException] Unknown column 'ag.position' in 'order clause' SELECT

[sergio1440069]

Buenas tardes!

uso prestashop 1.5.6. y desde hoy me sale este mensaje al intentar ir a cualquier seccion de la tienda:

 

[PrestaShopDatabaseException]

Unknown column 'ag.position' in 'order clause'

 

                    SELECT COUNT(DISTINCT p.id_product) nbr, lpa.id_attribute_group,

                    a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,

                    liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title, psi.price_min, psi.price_max

 

                    FROM mv9hssocwxlayered_product_attribute lpa

                    INNER JOIN mv9hssocwxattribute a

                    ON a.id_attribute = lpa.id_attribute

                    INNER JOIN mv9hssocwxattribute_lang al

                    ON al.id_attribute = a.id_attribute

                    AND al.id_lang = 3

                    INNER JOIN mv9hssocwxproduct as p

                    ON p.id_product = lpa.id_product

                    INNER JOIN mv9hssocwxattribute_group ag

                    ON ag.id_attribute_group = lpa.id_attribute_group

                    INNER JOIN mv9hssocwxattribute_group_lang agl

                    ON agl.id_attribute_group = lpa.id_attribute_group

                    AND agl.id_lang = 3

                    LEFT JOIN mv9hssocwxlayered_indexable_attribute_group_lang_value liagl

                    ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 3)

                    LEFT JOIN mv9hssocwxlayered_indexable_attribute_lang_value lial

                    ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 3) INNER JOIN mv9hssocwxproduct_shop product_shop

        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)

 

            INNER JOIN `mv9hssocwxlayered_price_index` psi

            ON (psi.id_product = p.id_product AND psi.id_currency = 2)

WHERE a.id_attribute_group = 1 AND lpa.`id_shop` = 1 AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog")

                    AND p.id_product IN (

                        SELECT id_product

                        FROM mv9hssocwxcategory_product cp

                        INNER JOIN mv9hssocwxcategory c ON (c.id_category = cp.id_category AND

                        c.nleft >= 139

                        AND c.nright <= 140

                        AND c.active = 1)

                    )

 

                    GROUP BY lpa.id_attribute

                    ORDER BY ag.`position` ASC, a.`position` ASC

at line 613 in file classes/db/Db.php

 

607.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

608.         }

609.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

610.         {

611.             if ($sql)

612.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

613.             throw new PrestaShopDatabaseException($this->getMsgError());

614.         }

615.     }

616.

617.     /**

• DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 2693 - modules/blocklayered/blocklayered.php] - [1 Arguments]
• BlockLayered->getFilterBlock - [line 1140 - modules/blocklayered/blocklayered.php] - [1 Arguments]
• BlockLayered->hookHeader - [line 459 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 426 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initContent - [line 100 - controllers/front/CategoryController.php] - [0 Argument]
• CategoryControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

[sergio1440069]

x favor ayuda!! tengola web paradaa ya que no se puede comprar nada!!!

[tuk66]

Su mesa attribute_group no tiene ninguna "position" de campo (y, probablemente, 'group_type' también). Usted tal vez una actualización desde v1.4 y la base de datos no ha cambiado correctamente. No puede haber más problemas en su base de datos.

Puede actualizar esta tabla con la mano pero te sugiero que comprobar todas las tablas con cuidado también.

 

====================

 

Your attribute_group table has no 'position' field (and probably 'group_type' as well). You perhaps upgraded from v1.4 and database hasn't changed properly. There can be more problems in your database.

 

You can update this table by hand but I suggest to check all tables carefully as well.