file:[/home/vartecbg/public_html/common/dblayer.php]
line:[41]
function:[fatal]
args:[Show/Hide
(0)->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 '-6, 6' at line 3 - SELECT product.*, (SELECT DATE_FORMAT(date, '%d.%m.%Y') FROM promotion) AS promotionDate, CASE (SELECT `date` >= DAY(NOW()) FROM promotion ) WHEN true THEN promoPrice ELSE null END AS promotionPrice FROM product_cat
INNER JOIN product ON product_cat.id = categoryid
WHERE (product.active = 1 AND product_cat.active = 1 AND product_cat.id in (25)) ORDER BY product.weight LIMIT -6, 6
(1)->
]
file:[/home/vartecbg/public_html/common/client_category.php]
line:[224]
function:[ExecQuery]
class:[DBLayer]
object:[]
type:[->]
args:[Show/Hide
(0)->SELECT product.*, (SELECT DATE_FORMAT(date, '%d.%m.%Y') FROM promotion) AS promotionDate, CASE (SELECT `date` >= DAY(NOW()) FROM promotion ) WHEN true THEN promoPrice ELSE null END AS promotionPrice FROM product_cat
INNER JOIN product ON product_cat.id = categoryid
WHERE (product.active = 1 AND product_cat.active = 1 AND product_cat.id in (25)) ORDER BY product.weight LIMIT -6, 6
]
file:[/home/vartecbg/public_html/common/client_category.php]
line:[174]
function:[calcPage]
class:[Category]
object:[]
type:[->]
args:[Show/Hide
(0)->-6
(1)->6
(2)->0
]
file:[/home/vartecbg/public_html/index.php]
line:[219]
function:[ShowAll]
class:[Category]
object:[]
type:[->]
args:[Show/Hide
(0)->5
]
file:[/home/vartecbg/public_html/common/controlerex.php]
line:[292]
function:[products]
class:[Index]
object:[]
type:[->]
args:[Show/Hide
]
file:[/home/vartecbg/public_html/common/controlerex.php]
line:[150]
function:[ExecParametter]
class:[Controler]
object:[]
type:[->]
args:[Show/Hide
]
file:[/home/vartecbg/public_html/index.php]
line:[112]
function:[Controler]
class:[Controler]
object:[]
type:[->]
args:[Show/Hide
(0)->
]
file:[/home/vartecbg/public_html/index.php]
line:[525]
function:[Index]
class:[Index]
object:[]
type:[->]
args:[Show/Hide
]