I can not create grouped product from the admin panel it gives the below error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'position' in
'order clause', query was: SELECT `e`.*, `at_status`.`value` AS
`status`, `links`.`link_id` FROM `catalog_product_entity` AS `e` INNER
JOIN `catalog_product_entity_int` AS `at_status` ON
(`at_status`.`entity_id` = `e`.`entity_id`) AND
(`at_status`.`attribute_id` = '94') AND (`at_status`.`store_id` = 0)
INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id
= e.entity_id AND links.link_type_id = 3 INNER JOIN
`catalog_product_entity` AS `product_entity_table` ON links.product_id =
product_entity_table.entity_id WHERE (((`e`.`required_options` != 1) OR
(`e`.`required_options` IS NULL))) AND (at_status.value IN(1, 2)) AND
(links.product_id = 687) AND (`e`.`entity_id` != '687') ORDER BY
`position` ASC
What caused that error, Thanks in advance.
Edit:
I have used that sql statements to clear the DB from products, customers and categories prior to deploy