WARNING: An Error occurred, please refresh the page and try again.User Error256: 1064:syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*' :: SELECT DISTINCT p.products_image, m.manufacturers_name, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id , IF( pd.products_name LIKE '\"soka\"', 10000, IF( pd.products_name LIKE '\"soka\"%', 50, 0 ) + IF( MATCH(pd.products_name) AGAINST('\"soka\"*'),MATCH(pd.products_name) AGAINST('\"soka\"*') * 4, 0) ) + (pd.products_viewed / 6832.4186) as weight FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND p.products_type NOT IN (9,10) AND ( pd.products_name LIKE '%\"soka\"%' OR MATCH(pd.products_name) AGAINST('\"soka\"*' IN BOOLEAN MODE) )) AND p.discontinue = 0 ORDER BY weight DESC, p.products_sort_order, pd.products_name ==> (as called by) /home/upscale/public_html/includes/classes/split_page_results.php on line 78 <== in /home/upscale/public_html/includes/classes/db/mysql/query_factory.php on line 180
Called from:
- trigger_error(string(1497) "1064:syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*' :: SELECT DISTINCT p.products_image, m.manufacturers_name, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id , IF( pd.products_name LIKE '\"soka\"', 10000, IF( pd.products_name LIKE '\"soka\"%', 50, 0 ) + IF( MATCH(pd.products_name) AGAINST('\"soka\"*'),MATCH(pd.products_name) AGAINST('\"soka\"*') * 4, 0) ) + (pd.products_viewed / 6832.4186) as weight FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND p.products_type NOT IN (9,10) AND ( pd.products_name LIKE '%\"soka\"%' OR MATCH(pd.products_name) AGAINST('\"soka\"*' IN BOOLEAN MODE) )) AND p.discontinue = 0 ORDER BY weight DESC, p.products_sort_order, pd.products_name ==> (as called by) /home/upscale/public_html/includes/classes/split_page_results.php on line 78 <=="
, int(256)
)
called in
/home/upscale/public_html/includes/classes/db/mysql/query_factory.php on 180 - show_error()
called in
/home/upscale/public_html/includes/classes/db/mysql/query_factory.php on 152 - set_error(int(1064)
, string(68) "syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'"
, bool(true)
)
called in
/home/upscale/public_html/includes/classes/db/mysql/query_factory.php on 279 - Execute(string(1320) "SELECT DISTINCT p.products_image, m.manufacturers_name, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id , IF( pd.products_name LIKE '\"soka\"', 10000, IF( pd.products_name LIKE '\"soka\"%', 50, 0 ) + IF( MATCH(pd.products_name) AGAINST('\"soka\"*'),MATCH(pd.products_name) AGAINST('\"soka\"*') * 4, 0) ) + (pd.products_viewed / 6832.4186) as weight FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND p.products_type NOT IN (9,10) AND ( pd.products_name LIKE '%\"soka\"%' OR MATCH(pd.products_name) AGAINST('\"soka\"*' IN BOOLEAN MODE) )) AND p.discontinue = 0 ORDER BY weight DESC, p.products_sort_order, pd.products_name"
)
called in
/home/upscale/public_html/includes/classes/split_page_results.php on 78 - __construct(string(1320) "SELECT DISTINCT p.products_image, m.manufacturers_name, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id , IF( pd.products_name LIKE '\"soka\"', 10000, IF( pd.products_name LIKE '\"soka\"%', 50, 0 )
+ IF( MATCH(pd.products_name) AGAINST('\"soka\"*'),MATCH(pd.products_name) AGAINST('\"soka\"*') * 4, 0) )
+ (pd.products_viewed / 6832.4186) as weight FROM (products p
LEFT JOIN manufacturers m
USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c )
LEFT JOIN meta_tags_products_description mtpd
ON mtpd.products_id= p2c.products_id
AND mtpd.language_id = 1 WHERE (p.products_status = 1
AND p.products_id = pd.products_id
AND pd.language_id = 1
AND p.products_id = p2c.products_id
AND p2c.categories_id = c.categories_id
AND p.products_type NOT IN (9,10) AND (
pd.products_name LIKE '%\"soka\"%'
OR MATCH(pd.products_name) AGAINST('\"soka\"*' IN BOOLEAN MODE)
)) AND p.discontinue = 0 ORDER BY weight DESC, p.products_sort_order, pd.products_name"
, string(2) "20"
, string(13) "p.products_id"
, string(4) "page"
)
called in
/home/upscale/public_html/includes/modules/pages/advanced_search_result/header_php.php on 569 - require(string(86) "/home/upscale/public_html/includes/modules/pages/advanced_search_result/header_php.php"
)
called in
/home/upscale/public_html/index.php on 71