Whoops, looks like something went wrong.

2/2 QueryException in Connection.php line 624: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id ' at line 1 (SQL: select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id desc )

  1. in Connection.php line 624
  2. at Connection->runQueryCallback('select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id desc ', array(), object(Closure)) in Connection.php line 580
  3. at Connection->run('select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id desc ', array(), object(Closure)) in Connection.php line 297
  4. at Connection->select('select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id desc ') in Model.php line 66
  5. at Model->get(' n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 ', ' and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 ', 'n.product_stt asc, n.id desc', '', ' join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id ') in BrandController.php line 434
  6. at BrandController->index2('kosoom', 'den-led-panel-op-tran-noi-loai-vuong')
  7. at call_user_func_array(array(object(BrandController), 'index2'), array('name1' => 'kosoom', 'name2' => 'den-led-panel-op-tran-noi-loai-vuong')) in compiled.php line 8287
  8. at Controller->callAction('index2', array('name1' => 'kosoom', 'name2' => 'den-led-panel-op-tran-noi-loai-vuong')) in compiled.php line 8354
  9. at ControllerDispatcher->call(object(BrandController), object(Route), 'index2') in compiled.php line 8333
  10. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  11. at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
  12. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  13. at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
  14. at Pipeline->then(object(Closure)) in compiled.php line 8334
  15. at ControllerDispatcher->callWithinStack(object(BrandController), object(Route), object(Request), 'index2') in compiled.php line 8320
  16. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\BrandController', 'index2') in compiled.php line 7317
  17. at Route->runWithCustomDispatcher(object(Request)) in compiled.php line 7288
  18. at Route->run(object(Request)) in compiled.php line 6954
  19. at Router->Illuminate\Routing\{closure}(object(Request))
  20. at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
  21. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  22. at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
  23. at Pipeline->then(object(Closure)) in compiled.php line 6955
  24. at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 6944
  25. at Router->dispatchToRoute(object(Request)) in compiled.php line 6929
  26. at Router->dispatch(object(Request)) in compiled.php line 1935
  27. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  28. at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
  29. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 12083
  30. at ShareErrorsFromSession->handle(object(Request), object(Closure)) in compiled.php line 8944
  31. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 10785
  32. at StartSession->handle(object(Request), object(Closure)) in compiled.php line 8944
  33. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 11789
  34. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in compiled.php line 8944
  35. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 11738
  36. at EncryptCookies->handle(object(Request), object(Closure)) in compiled.php line 8944
  37. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 2478
  38. at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in compiled.php line 8944
  39. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  40. at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
  41. at Pipeline->then(object(Closure)) in compiled.php line 1891
  42. at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 1880
  43. at Kernel->handle(object(Request)) in index.php line 136

1/2 PDOException in Connection.php line 292: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id ' at line 1

  1. in Connection.php line 292
  2. at PDO->prepare('select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id desc ') in Connection.php line 292
  3. at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id desc ', array()) in Connection.php line 616
  4. at Connection->runQueryCallback('select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id desc ', array(), object(Closure)) in Connection.php line 580
  5. at Connection->run('select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id desc ', array(), object(Closure)) in Connection.php line 297
  6. at Connection->select('select n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 from `product` n join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id where 1 and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 GROUP BY n.id ORDER BY n.product_stt asc, n.id desc ') in Model.php line 66
  7. at Model->get(' n.id,nl.product_unit,nl.product_thumb,n.product_code,n.product_promotion,nl.product_name,n.product_code,n.product_model1,n.product_model2,n.product_model3,bl.brand_name,n.product_stt,n.product_price_nhanvien,n.product_percent4 ', ' and n.product_vn=1 and n.product_hide =1 and nl.lang ="vn" and n.product_brand in(2400) and (n.product_cate=) and n.product_stt != 1000 ', 'n.product_stt asc, n.id desc', '', ' join product_lang nl on n.id = nl.product_id join brand_lang bl on nl.product_brand = bl.id join categories c on n.product_cate = c.id ') in BrandController.php line 434
  8. at BrandController->index2('kosoom', 'den-led-panel-op-tran-noi-loai-vuong')
  9. at call_user_func_array(array(object(BrandController), 'index2'), array('name1' => 'kosoom', 'name2' => 'den-led-panel-op-tran-noi-loai-vuong')) in compiled.php line 8287
  10. at Controller->callAction('index2', array('name1' => 'kosoom', 'name2' => 'den-led-panel-op-tran-noi-loai-vuong')) in compiled.php line 8354
  11. at ControllerDispatcher->call(object(BrandController), object(Route), 'index2') in compiled.php line 8333
  12. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  13. at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
  14. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  15. at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
  16. at Pipeline->then(object(Closure)) in compiled.php line 8334
  17. at ControllerDispatcher->callWithinStack(object(BrandController), object(Route), object(Request), 'index2') in compiled.php line 8320
  18. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\BrandController', 'index2') in compiled.php line 7317
  19. at Route->runWithCustomDispatcher(object(Request)) in compiled.php line 7288
  20. at Route->run(object(Request)) in compiled.php line 6954
  21. at Router->Illuminate\Routing\{closure}(object(Request))
  22. at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
  23. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  24. at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
  25. at Pipeline->then(object(Closure)) in compiled.php line 6955
  26. at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 6944
  27. at Router->dispatchToRoute(object(Request)) in compiled.php line 6929
  28. at Router->dispatch(object(Request)) in compiled.php line 1935
  29. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  30. at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
  31. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 12083
  32. at ShareErrorsFromSession->handle(object(Request), object(Closure)) in compiled.php line 8944
  33. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 10785
  34. at StartSession->handle(object(Request), object(Closure)) in compiled.php line 8944
  35. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 11789
  36. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in compiled.php line 8944
  37. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 11738
  38. at EncryptCookies->handle(object(Request), object(Closure)) in compiled.php line 8944
  39. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 2478
  40. at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in compiled.php line 8944
  41. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  42. at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
  43. at Pipeline->then(object(Closure)) in compiled.php line 1891
  44. at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 1880
  45. at Kernel->handle(object(Request)) in index.php line 136