THELIA Forum

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'VIRTUAL' in 'field list'

PropelException: Unable to execute COUNT statement [SELECT COUNT(*) FROM (SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VIRTUAL, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.BRAND_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY, ROUND(CASE WHEN `pse`.PROMO=1 THEN `price`.PROMO_PRICE ELSE `price`.PRICE END, 2) AS real_price, `price`.PRICE AS price, `price`.PROMO_PRICE AS promo_price, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, `requested_locale_i18n`.`TITLE` AS i18n_TITLE, `requested_locale_i18n`.`CHAPO` AS i18n_CHAPO, `requested_locale_i18n`.`DESCRIPTION` AS i18n_DESCRIPTION, `requested_locale_i18n`.`POSTSCRIPTUM` AS i18n_POSTSCRIPTUM, `requested_locale_i18n`.`META_TITLE` AS i18n_META_TITLE, `requested_locale_i18n`.`META_DESCRIPTION` AS i18n_META_DESCRIPTION, `requested_locale_i18n`.`META_KEYWORDS` AS i18n_META_KEYWORDS, `SalePriceDisplay`.DISPLAY_INITIAL_PRICE AS display_initial_price, `pse`.ID AS pse_id, `pse`.NEWNESS AS is_new, `pse`.PROMO AS is_promo, `pse`.QUANTITY AS quantity, `pse`.WEIGHT AS weight, `pse`.EAN_CODE AS ean_code, COUNT(`pse_count`.ID) AS pse_count FROM `product` INNER JOIN `product_sale_elements` `pse` ON (product.ID=pse.PRODUCT_ID AND `pse`.IS_DEFAULT=1) INNER JOIN `product_sale_elements` `pse_count` ON (product.ID=pse_count.PRODUCT_ID) LEFT JOIN `product_price` `price` ON (pse.ID=price.PRODUCT_SALE_ELEMENTS_ID AND `price`.`currency_id` = :p1) LEFT JOIN `product_i18n` `requested_locale_i18n` ON (product.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = :p2) LEFT JOIN `sale_product` `SaleProductPriceDisplay` ON (product.ID=SaleProductPriceDisplay.PRODUCT_ID) LEFT JOIN `sale` `SalePriceDisplay` ON (SaleProductPriceDisplay.SALE_ID=SalePriceDisplay.ID AND `SalePriceDisplay`.`active` = 1) GROUP BY product.ID) propelmatch4cnt]

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'module_image.VISIBLE' in 'field list'

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'thelia.meta_data' doesn't exist

2/2 PropelException: Unable to execute INSERT statement [INSERT INTO `module_i18n` (`ID`, `TITLE`) VALUES (:p0, :p1)]
1/2 PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '39-en_US' for key 'PRIMARY'

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_product.ID' in 'field list'