kungmats Posted April 12, 2021 Share Posted April 12, 2021 Hi I get this error after upgrade. U happends when I try to enter manufacorer page Oops... looks like an unexpected error occurred An exception occurred while executing 'SELECT m.`id_manufacturer`, m.`name`, m.`active`, COUNT(p.`id_product`) AS `products_count`, (SELECT COUNT(a.`id_manufacturer`) AS `addresses_count` FROM address a WHERE (m.`id_manufacturer` = a.`id_manufacturer`) AND (a.`deleted` = 0) GROUP BY a.`id_manufacturer`) AS addresses_count FROM manufacturer m INNER JOIN manufacturer_shop ms ON ms.`id_manufacturer` = m.`id_manufacturer` LEFT JOIN product p ON m.`id_manufacturer` = p.`id_manufacturer` WHERE ms.`id_shop` IN (?) GROUP BY m.`id_manufacturer` ORDER BY position asc LIMIT 50' with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'position' in 'order clause' [Doctrine\DBAL\Exception\InvalidFieldNameException 0] Link to comment Share on other sites More sharing options...
musicmaster Posted April 15, 2021 Share Posted April 15, 2021 Try to find out where this query comes from. I cannot find it in the base installation. So it may be in some module/override. And none of the involved tables contains a "position" field. Link to comment Share on other sites More sharing options...
kungmats Posted April 16, 2021 Author Share Posted April 16, 2021 Hi This is more or less a standard installation with standard theme with almost none extra module After upgrading to 1.7.7.3 it seems to work. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now