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 )
- in Connection.php line 624
- 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
- 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
- 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
- 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
- at BrandController->index2('kosoom', 'den-led-panel-op-tran-noi-loai-vuong')
- 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
- at Controller->callAction('index2', array('name1' => 'kosoom', 'name2' => 'den-led-panel-op-tran-noi-loai-vuong')) in compiled.php line 8354
- at ControllerDispatcher->call(object(BrandController), object(Route), 'index2') in compiled.php line 8333
- at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
- at Pipeline->then(object(Closure)) in compiled.php line 8334
- at ControllerDispatcher->callWithinStack(object(BrandController), object(Route), object(Request), 'index2') in compiled.php line 8320
- at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\BrandController', 'index2') in compiled.php line 7317
- at Route->runWithCustomDispatcher(object(Request)) in compiled.php line 7288
- at Route->run(object(Request)) in compiled.php line 6954
- at Router->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
- at Pipeline->then(object(Closure)) in compiled.php line 6955
- at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 6944
- at Router->dispatchToRoute(object(Request)) in compiled.php line 6929
- at Router->dispatch(object(Request)) in compiled.php line 1935
- at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 12083
- at ShareErrorsFromSession->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 10785
- at StartSession->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 11789
- at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 11738
- at EncryptCookies->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 2478
- at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
- at Pipeline->then(object(Closure)) in compiled.php line 1891
- at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 1880
- 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
- in Connection.php line 292
- 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
- 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
- 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
- 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
- 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
- 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
- at BrandController->index2('kosoom', 'den-led-panel-op-tran-noi-loai-vuong')
- 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
- at Controller->callAction('index2', array('name1' => 'kosoom', 'name2' => 'den-led-panel-op-tran-noi-loai-vuong')) in compiled.php line 8354
- at ControllerDispatcher->call(object(BrandController), object(Route), 'index2') in compiled.php line 8333
- at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
- at Pipeline->then(object(Closure)) in compiled.php line 8334
- at ControllerDispatcher->callWithinStack(object(BrandController), object(Route), object(Request), 'index2') in compiled.php line 8320
- at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\BrandController', 'index2') in compiled.php line 7317
- at Route->runWithCustomDispatcher(object(Request)) in compiled.php line 7288
- at Route->run(object(Request)) in compiled.php line 6954
- at Router->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
- at Pipeline->then(object(Closure)) in compiled.php line 6955
- at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 6944
- at Router->dispatchToRoute(object(Request)) in compiled.php line 6929
- at Router->dispatch(object(Request)) in compiled.php line 1935
- at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8952
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 12083
- at ShareErrorsFromSession->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 10785
- at StartSession->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 11789
- at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 11738
- at EncryptCookies->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in compiled.php line 2478
- at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in compiled.php line 8944
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 8935
- at Pipeline->then(object(Closure)) in compiled.php line 1891
- at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 1880
- at Kernel->handle(object(Request)) in index.php line 136