Message

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 'ORDER BY `category` ASC' at line 5 (1064)

SELECT * FROM `cscart_category_descriptions` LEFT JOIN `cscart_categories` on `cscart_category_descriptions`.`category_id`= `cscart_categories`.`category_id` WHERE `cscart_category_descriptions`.`category` LIKE 'patiserie' AND `cscart_categories`.`parent_id`= ORDER BY `category` ASC

Error at

app/Tygh/Database.php, line: 646

Backtrace

File:app/Tygh/Database.php
Line:331
Function:_error
File:app/Tygh/Database.php
Line:156
Function:query
File:app/functions/fn.database.php
Line:54
Function:getRow
File:app/addons/my_changes/func.php
Line:122
Function:db_get_row
File:app/functions/fn.control.php
Line:94
Function:fn_my_changes_get_route
File:app/functions/fn.control.php
Line:705
Function:fn_set_hook
File:app/functions/fn.init.php
Line:918
Function:fn_get_route
File:init.php
Line:128
Function:fn_init
File:index.php
Line:24
Function:require