Hi,
I added a couple of fields in the product.tpl view and controller and then added a couple of storefront language changes to match.
After uploading the files to a test web server, they work fine on the product page, but the home page for the store now throws an error that refers to the error logs.
Rolling the files back to the base files produces the same error. Clearing the cache and turning it off makes no change. I was just wondering if there is a security integrity problem or if I need to dig deeper into database references within the .tpl files. In short, is there a best practice process for moving .tpl files into a new installation?
The db error is below:
database error: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND customer_group_id = '8'
AND ((date_start = '0000-00-00' OR d' at line 3<br />Error No: 1064<br />SELECT product_id, price
FROM ac_product_specials
WHERE product_id IN ()
AND customer_group_id = '8'
AND ((date_start = '0000-00-00' OR date_start < NOW())
AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY product_id ASC, priority ASC, price ASC in <b>/var/www/market/core/database/mysql.php</b> on line <b>86</b>