Print Page - DB error in product.php

Title: DB error in product.php
Post by: jetman on December 28, 2016, 01:38:03 AM

php 7.0.13
10.1.14-MariaDB
driver: amysqli
litespeed

Clicking on a product with an option in the cart, the resulting product page returns with this error:

2016-12-27 21:32:02 - database error: AbanteCart core v.1.2.9 SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':70968c2523c4ae41441b8df13a2c9231)
AND customer_group_id = '1'
AND' at line 3
Error No: 1064
SQL: SELECT product_id, price
FROM product_specials
WHERE product_id IN (1975:70968c2523c4ae41441b8df13a2c9231)
AND customer_group_id = '1'
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>/home/***/public_html/core/database/amysqli.php</b> on line <b>108</b>

I am unable reproduce the error on the demo store and I replaced the core/storefront with a fresh copy but I am still getting this error. I like to know why abantecart is not removing ":70968c2523c4ae41441b8df13a2c9231"

Any ideas?

Jason

Title: Re: DB error in product.php
Post by: abolabo on December 28, 2016, 09:14:11 AM

try to replace your file public_html/storefront/model/catalog/product.php with attached and let us know

Title: Re: DB error in product.php
Post by: jetman on December 28, 2016, 01:00:26 PM

Thank you. It works perfectly :)

AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: jetman on December 28, 2016, 01:38:03 AM