Warning (512): SQL Error: 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 '' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "SELECT * FROM teachers WHERE id = "
$error = "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 '' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 525
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 221
Model::query() - CORE/cake/libs/model/model.php, line 2292
Teacher::select_common() - APP/models/teacher.php, line 60
ModelHandlerComponent::getTeacherById() - APP/controllers/components/model_handler.php, line 52
TeachersController::teacher_reserve() - APP/controllers/teachers_controller.php, line 475
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Query: SELECT * FROM teachers WHERE id =
Warning (2): Invalid argument supplied for foreach() [APP/config/bootstrap.php, line 127]
//Query結果が一つかない場合
if($kubun == 0 ){
foreach($result_array as $result ){
query_to_model - APP/config/bootstrap.php, line 127
ModelHandlerComponent::getTeacherById() - APP/controllers/components/model_handler.php, line 53
TeachersController::teacher_reserve() - APP/controllers/teachers_controller.php, line 475
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Notice (8): Undefined variable: model [APP/config/bootstrap.php, line 139]
query_to_model - APP/config/bootstrap.php, line 139
ModelHandlerComponent::getTeacherById() - APP/controllers/components/model_handler.php, line 53
TeachersController::teacher_reserve() - APP/controllers/teachers_controller.php, line 475
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Warning (512): SQL Error: 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 (reserve_status = 'R' OR reserve_status = 'F' )
AND available_time >=' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "SELECT * FROM available_lessons WHERE teacher_id = AND (reserve_status = 'R' OR reserve_status = 'F' )
AND available_time >= '2025-10-03'
ORDER BY available_time ASC "
$error = "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 (reserve_status = 'R' OR reserve_status = 'F' )
AND available_time >=' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 525
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 221
Model::query() - CORE/cake/libs/model/model.php, line 2292
Teacher::select_common() - APP/models/teacher.php, line 60
ModelHandlerComponent::getAvailableLessonByTeacherId() - APP/controllers/components/model_handler.php, line 63
TeachersController::teacher_reserve() - APP/controllers/teachers_controller.php, line 476
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Query: SELECT * FROM available_lessons WHERE teacher_id = AND (reserve_status = 'R' OR reserve_status = 'F' )
AND available_time >= '2025-10-03'
ORDER BY available_time ASC
Warning (2): Invalid argument supplied for foreach() [APP/config/bootstrap.php, line 134]
$model = Array();
$i = 0;
foreach($result_array as $result ){
query_to_model - APP/config/bootstrap.php, line 134
ModelHandlerComponent::getAvailableLessonByTeacherId() - APP/controllers/components/model_handler.php, line 64
TeachersController::teacher_reserve() - APP/controllers/teachers_controller.php, line 476
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Warning (512): SQL Error: 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 Available_lesson.reserve_status IN ('R', 'F') AND Available_lesson.available' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "SELECT Available_lesson.id, Available_lesson.available_time, Lesson.id, Lesson.reservation_kinds FROM available_lessons as Available_lesson RIGHT JOIN lessons as Lesson ON ( Available_lesson.id = Lesson.available_lesson_id AND Lesson.lesson_status IN ( 'R', 'A', 'F' ) ) WHERE Available_lesson.teacher_id = AND Available_lesson.reserve_status IN ('R', 'F') AND Available_lesson.available_time >= '2025-10-03' AND Available_lesson.available_time < '2025-10-10 01:00:00' ORDER BY Available_lesson.available_time ASC"
$error = "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 Available_lesson.reserve_status IN ('R', 'F') AND Available_lesson.available' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 525
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 221
Model::query() - CORE/cake/libs/model/model.php, line 2292
TeachersController::teacherSched() - APP/controllers/teachers_controller.php, line 44
TeachersController::teacher_reserve() - APP/controllers/teachers_controller.php, line 555
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Query: SELECT Available_lesson.id, Available_lesson.available_time, Lesson.id, Lesson.reservation_kinds FROM available_lessons as Available_lesson RIGHT JOIN lessons as Lesson ON ( Available_lesson.id = Lesson.available_lesson_id AND Lesson.lesson_status IN ( 'R', 'A', 'F' ) ) WHERE Available_lesson.teacher_id = AND Available_lesson.reserve_status IN ('R', 'F') AND Available_lesson.available_time >= '2025-10-03' AND Available_lesson.available_time < '2025-10-10 01:00:00' ORDER BY Available_lesson.available_time ASC
