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 MariaDB server version for the right syntax to use near 'GROUP BY n.id ORDER BY n.id desc limit 0,4' at line 1 (SQL: select n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName from `photos` n left join account acc on acc.ID=n.user_photos where 1 and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos= GROUP BY n.id ORDER BY n.id desc limit 0,4)

  1. in Connection.php line 624
  2. at Connection->runQueryCallback('select n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName from `photos` n left join account acc on acc.ID=n.user_photos where 1 and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos= GROUP BY n.id ORDER BY n.id desc limit 0,4', array(), object(Closure)) in Connection.php line 580
  3. at Connection->run('select n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName from `photos` n left join account acc on acc.ID=n.user_photos where 1 and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos= GROUP BY n.id ORDER BY n.id desc limit 0,4', array(), object(Closure)) in Connection.php line 297
  4. at Connection->select('select n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName from `photos` n left join account acc on acc.ID=n.user_photos where 1 and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos= GROUP BY n.id ORDER BY n.id desc limit 0,4') in Model.php line 66
  5. at Model->get('n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName', ' and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos=', 'n.id desc', '0,4', 'left join account acc on acc.ID=n.user_photos') in Product.php line 148
  6. at Product->ProductProvince('construction-supplies')
  7. at call_user_func_array(array(object(Product), 'ProductProvince'), array('name' => 'construction-supplies')) in compiled.php line 8287
  8. at Controller->callAction('ProductProvince', array('name' => 'construction-supplies')) in compiled.php line 8354
  9. at ControllerDispatcher->call(object(Product), object(Route), 'ProductProvince') 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(Product), object(Route), object(Request), 'ProductProvince') in compiled.php line 8320
  16. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\Product', 'ProductProvince') 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 52

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 MariaDB server version for the right syntax to use near 'GROUP BY n.id ORDER BY n.id desc limit 0,4' at line 1

  1. in Connection.php line 292
  2. at PDO->prepare('select n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName from `photos` n left join account acc on acc.ID=n.user_photos where 1 and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos= GROUP BY n.id ORDER BY n.id desc limit 0,4') in Connection.php line 292
  3. at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName from `photos` n left join account acc on acc.ID=n.user_photos where 1 and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos= GROUP BY n.id ORDER BY n.id desc limit 0,4', array()) in Connection.php line 616
  4. at Connection->runQueryCallback('select n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName from `photos` n left join account acc on acc.ID=n.user_photos where 1 and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos= GROUP BY n.id ORDER BY n.id desc limit 0,4', array(), object(Closure)) in Connection.php line 580
  5. at Connection->run('select n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName from `photos` n left join account acc on acc.ID=n.user_photos where 1 and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos= GROUP BY n.id ORDER BY n.id desc limit 0,4', array(), object(Closure)) in Connection.php line 297
  6. at Connection->select('select n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName from `photos` n left join account acc on acc.ID=n.user_photos where 1 and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos= GROUP BY n.id ORDER BY n.id desc limit 0,4') in Model.php line 66
  7. at Model->get('n.*,acc.ID as ID_Acc,acc.Es_Img_Status,acc.Es_Hinh,acc.Es_BossName', ' and n.User_Duyet>0 and n.type_photos=1 and n.id_info_photos=', 'n.id desc', '0,4', 'left join account acc on acc.ID=n.user_photos') in Product.php line 148
  8. at Product->ProductProvince('construction-supplies')
  9. at call_user_func_array(array(object(Product), 'ProductProvince'), array('name' => 'construction-supplies')) in compiled.php line 8287
  10. at Controller->callAction('ProductProvince', array('name' => 'construction-supplies')) in compiled.php line 8354
  11. at ControllerDispatcher->call(object(Product), object(Route), 'ProductProvince') 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(Product), object(Route), object(Request), 'ProductProvince') in compiled.php line 8320
  18. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\Product', 'ProductProvince') 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 52