Entity Error

https://www.ulterium.co.uk | © Ulterium Ltd 2024

Exception

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 (*-M16* 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 (M16 IN BOOLEAN MODE) * 2 DESC, MATCH(`products`.`name`, `products`.`description`, `description_extra`, `products`.`barcode`, `products`.`sku`, `products`.`model`, `products`.`mpn`, `products`.`keywords`) AGAINST (M16* IN BOOLEAN MODE) * 1 DESC limit 20)

/home/connexions/webapps/upsell-connexions/app/source/vendor/laravel/framework/src/Illuminate/Database/Connection.php (712)

Stack Trace:

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 (*-M16* 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 (M16 IN BOOLEAN MODE) * 2 DESC, MATCH(`products`.`name`, `products`.`description`, `description_extra`, `products`.`barcode`, `products`.`sku`, `products`.`model`, `products`.`mpn`, `products`.`keywords`) AGAINST (M16* 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)