https://www.ulterium.co.uk | © Ulterium Ltd 2024
Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1064 syntax error, unexpected '-', expecting FTS_TERM or FTS_NUMB or '*' (SQL: select SQL_CALC_FOUND_ROWS products.id as 'id', `name`, `mpn`, `model`, `sku`, `meta`, `unit_type`, `tax_id`, `options`, `supplier_id`, `manufacturer_id`, `track_stock`, `pricing_display_type`, `price`, `price_sale`, (select sum(`product_stock`.`quantity`) from `product_stock` where `products`.`id` = `product_stock`.`product_id` and `status` = AVAILABLE) as `stock_sum_quantity` from `products` where (MATCH(`products`.`name`, `products`.`description`, `description_extra`, `products`.`barcode`, `products`.`sku`, `products`.`model`, `products`.`mpn`, `products`.`keywords`) AGAINST (*-BFL-S* IN BOOLEAN MODE)) and `status` = ACTIVE order by MATCH(`products`.`name`, `products`.`description`, `description_extra`, `products`.`barcode`, `products`.`sku`, `products`.`model`, `products`.`mpn`, `products`.`keywords`) AGAINST (BFLS IN BOOLEAN MODE) * 2 DESC, MATCH(`products`.`name`, `products`.`description`, `description_extra`, `products`.`barcode`, `products`.`sku`, `products`.`model`, `products`.`mpn`, `products`.`keywords`) AGAINST (BFLS* IN BOOLEAN MODE) * 1 DESC limit 20) at Illuminate.Database.Connection.runQueryCallback(Connection.php:712) at Illuminate.Database.Connection.run(Connection.php:672) at Illuminate.Database.Connection.select(Connection.php:359) at Illuminate.Database.Query.Builder.runSelect(Builder.php:2413) at Illuminate.Database.Query.Builder.Illuminate.Database.Query.{closure}(Builder.php:2402) at Illuminate.Database.Query.Builder.onceWithColumns(Builder.php:2936) at Illuminate.Database.Query.Builder.get(Builder.php:2401) at Illuminate.Database.Eloquent.Builder.getModels(Builder.php:625) at Illuminate.Database.Eloquent.Builder.get(Builder.php:609) at App.Model.Product.Search(Product.php:949) at App.Public_Theme.actionRenderSalesSearch(public_theme.php:1253) at Entity.Router.Action(router.php:357) at Entity.Router.Detect(router.php:248) at (main)(index.php:11) Caused by: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 syntax error, unexpected '-', expecting FTS_TERM or FTS_NUMB or '*' at PDOStatement.execute(Connection.php:373) at Illuminate.Database.Connection.Illuminate.Database.{closure}(Connection.php:373) at Illuminate.Database.Connection.runQueryCallback(Connection.php:705) at Illuminate.Database.Connection.run(Connection.php:672) at Illuminate.Database.Connection.select(Connection.php:359) at Illuminate.Database.Query.Builder.runSelect(Builder.php:2413) at Illuminate.Database.Query.Builder.Illuminate.Database.Query.{closure}(Builder.php:2402) at Illuminate.Database.Query.Builder.onceWithColumns(Builder.php:2936) at Illuminate.Database.Query.Builder.get(Builder.php:2401) at Illuminate.Database.Eloquent.Builder.getModels(Builder.php:625) at Illuminate.Database.Eloquent.Builder.get(Builder.php:609) at App.Model.Product.Search(Product.php:949) at App.Public_Theme.actionRenderSalesSearch(public_theme.php:1253) at Entity.Router.Action(router.php:357) at Entity.Router.Detect(router.php:248) at (main)(index.php:11)