[SOLVED] UKSB Google Merchant Errors

Code: Select all

Error: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error No: 1140
SELECT ps.date_end AS end, COUNT(ps.product_special_id) AS total FROM product_special ps WHERE ps.product_id = '50' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))

Code: Select all

Fatal error: Cannot redeclare ModelCatalogProduct::getSpecialEndDate() in /var/www/vhosts/website.com/httpdocs/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 580

Code: Select all

uksb_google_merchant.xml 

Code: Select all

Error: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error No: 1140
SELECT ps.date_end AS end, COUNT(ps.product_special_id) AS total FROM product_special ps WHERE ps.product_id = '50' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))