Whoops, looks like something went wrong.
2/2
QueryException in Connection.php line 713:
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 shikuguns.todofuken_id=todofukens.todofuken_id and todofukens.chihou_id=chih' at line 1 (SQL: select chihous.chihou_id, chihous.chihou_real_name, chihous.chihou_name, todofukens.todofuken_id, todofukens.todofuken_eng, todofukens.todofuken_name, shikuguns.shikugun_id,shikuguns.shikugun_name from chihous, todofukens, shikuguns where shikuguns.shikugun_id= and shikuguns.todofuken_id=todofukens.todofuken_id and todofukens.chihou_id=chihous.chihou_id)
- in Connection.php line 713
- at Connection->runQueryCallback(object(Expression), array(), object(Closure)) in Connection.php line 669
- at Connection->run(object(Expression), array(), object(Closure)) in Connection.php line 342
- at Connection->select(object(Expression))
- at call_user_func_array(array(object(MySqlConnection), 'select'), array(object(Expression))) in DatabaseManager.php line 317
- at DatabaseManager->__call('select', array(object(Expression))) in Facade.php line 217
- at DatabaseManager->select(object(Expression)) in Facade.php line 217
- at Facade::__callStatic('select', array(object(Expression))) in JobsController.php line 175
- at DB::select(object(Expression)) in JobsController.php line 175
- at JobsController->view('4635', object(Request))
- at call_user_func_array(array(object(JobsController), 'view'), array('id' => '4635', object(Request))) in Controller.php line 80
- at Controller->callAction('view', array('id' => '4635', object(Request))) in ControllerDispatcher.php line 146
- at ControllerDispatcher->call(object(JobsController), object(Route), 'view') in ControllerDispatcher.php line 94
- at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
- at Pipeline->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
- at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96
- at ControllerDispatcher->callWithinStack(object(JobsController), object(Route), object(Request), 'view') in ControllerDispatcher.php line 54
- at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\JobsController', 'view') in Route.php line 174
- at Route->runController(object(Request)) in Route.php line 140
- at Route->run(object(Request)) in Router.php line 724
- at Router->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 64
- at VerifyCsrfToken->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
- at ShareErrorsFromSession->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 62
- at StartSession->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
- at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
- at EncryptCookies->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
- at Pipeline->then(object(Closure)) in Router.php line 726
- at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699
- at Router->dispatchToRoute(object(Request)) in Router.php line 675
- at Router->dispatch(object(Request)) in Kernel.php line 246
- at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
- at CheckForMaintenanceMode->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
- at Pipeline->then(object(Closure)) in Kernel.php line 132
- at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
- at Kernel->handle(object(Request)) in index.php line 54
1/2
PDOException in Connection.php line 333:
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 shikuguns.todofuken_id=todofukens.todofuken_id and todofukens.chihou_id=chih' at line 1
- in Connection.php line 333
- at PDO->prepare('select chihous.chihou_id, chihous.chihou_real_name, chihous.chihou_name, todofukens.todofuken_id, todofukens.todofuken_eng, todofukens.todofuken_name, shikuguns.shikugun_id,shikuguns.shikugun_name from chihous, todofukens, shikuguns where shikuguns.shikugun_id= and shikuguns.todofuken_id=todofukens.todofuken_id and todofukens.chihou_id=chihous.chihou_id') in Connection.php line 333
- at Connection->Illuminate\Database\{closure}(object(MySqlConnection), object(Expression), array()) in Connection.php line 706
- at Connection->runQueryCallback(object(Expression), array(), object(Closure)) in Connection.php line 669
- at Connection->run(object(Expression), array(), object(Closure)) in Connection.php line 342
- at Connection->select(object(Expression))
- at call_user_func_array(array(object(MySqlConnection), 'select'), array(object(Expression))) in DatabaseManager.php line 317
- at DatabaseManager->__call('select', array(object(Expression))) in Facade.php line 217
- at DatabaseManager->select(object(Expression)) in Facade.php line 217
- at Facade::__callStatic('select', array(object(Expression))) in JobsController.php line 175
- at DB::select(object(Expression)) in JobsController.php line 175
- at JobsController->view('4635', object(Request))
- at call_user_func_array(array(object(JobsController), 'view'), array('id' => '4635', object(Request))) in Controller.php line 80
- at Controller->callAction('view', array('id' => '4635', object(Request))) in ControllerDispatcher.php line 146
- at ControllerDispatcher->call(object(JobsController), object(Route), 'view') in ControllerDispatcher.php line 94
- at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
- at Pipeline->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
- at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96
- at ControllerDispatcher->callWithinStack(object(JobsController), object(Route), object(Request), 'view') in ControllerDispatcher.php line 54
- at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\JobsController', 'view') in Route.php line 174
- at Route->runController(object(Request)) in Route.php line 140
- at Route->run(object(Request)) in Router.php line 724
- at Router->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 64
- at VerifyCsrfToken->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
- at ShareErrorsFromSession->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 62
- at StartSession->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
- at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
- at EncryptCookies->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
- at Pipeline->then(object(Closure)) in Router.php line 726
- at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699
- at Router->dispatchToRoute(object(Request)) in Router.php line 675
- at Router->dispatch(object(Request)) in Kernel.php line 246
- at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
- at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
- at CheckForMaintenanceMode->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
- at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline->Illuminate\Routing\{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
- at Pipeline->then(object(Closure)) in Kernel.php line 132
- at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
- at Kernel->handle(object(Request)) in index.php line 54