Phoca Forum

Code: Select all

1054 - Unknown column 'a.sales' in 'field list' SQL=SELECT a.id, a.title, a.image, a.alias, a.description, a.catid, c.id AS categoryid, c.title AS categorytitle, c.alias AS categoryalias, a.price, a.price_original, t.tax_rate as taxrate, t.calculation_type as taxcalculationtype, t.title as taxtitle, a.date, a.sales, a.featured, a.external_id, AVG(r.rating) AS rating, at.required AS attribute_required FROM crotc_phocacart_products AS a LEFT JOIN crotc_phocacart_categories AS c ON c.id = a.catid LEFT JOIN crotc_phocacart_taxes AS t ON t.id = a.tax_id LEFT JOIN crotc_phocacart_reviews AS r ON a.id = r.product_id AND r.id > 0 LEFT JOIN crotc_phocacart_attributes AS at ON a.id = at.product_id AND at.id > 0 AND at.required = 1 WHERE c.id = 5 AND a.published = 1 AND c.published = 1 AND c.access IN (1,1,5) AND a.access IN (1,1,5) GROUP BY a.id ORDER BY a.date DESC LIMIT 0, 6

Code: Select all

ALTER TABLE `#_phocacart_specifications` ADD `alias_value` VARCHAR(255) NOT NULL DEFAULT '' AFTER `language`;
ALTER TABLE `#_phocacart_products` ADD `sales` INT(11) NOT NULL DEFAULT '0' AFTER `language`;
ALTER TABLE `#_phocacart_products` ADD `serial_number` VARCHAR(255) NOT NULL DEFAULT '' AFTER `sales`;
ALTER TABLE `#_phocacart_products` ADD `registration_key` VARCHAR(255) NOT NULL DEFAULT '' AFTER `serial_number`;
ALTER TABLE `#_phocacart_products` ADD `external_id` VARCHAR(255) NOT NULL DEFAULT '' AFTER `registration_key`;
ALTER TABLE `#_phocacart_products` ADD `external_key` VARCHAR(255) NOT NULL DEFAULT '' AFTER `external_id`;