QueryException: SQLSTATE[42000]: Syntax error or access violation: 1064 #324

Open
opened 2026-01-01 17:36:44 +08:00 by bigtran · 0 comments
Owner

Next Illuminate\Database\QueryException: 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 '' at line 1 (Connection: plugin.admin.mysql, SQL: select facility_id as id,facility_name as title, true as last,0 as facility_parent_id from ect_meta_facilities where facility_type=5 and department_id = ;) in /var/webman-dev/ectms-web/vendor/illuminate/database/Connection.php:829
Stack trace:
#0 /var/webman-dev/ectms-web/vendor/illuminate/database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback()
#1 /var/webman-dev/ectms-web/vendor/illuminate/database/Connection.php(414): Illuminate\Database\Connection->run()
#2 /var/webman-dev/ectms-web/plugin/admin/app/common/sqlbig.php(66): Illuminate\Database\Connection->select()
#3 /var/webman-dev/ectms-web/plugin/admin/app/controller/EctMetaFacilityController.php(301): plugin\admin\app\common\sqlbig::get_data()
#4 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(335): plugin\admin\app\controller\EctMetaFacilityController->storage_json()
#5 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(358): Webman\App::{closure:Webman\App::getCallback():333}()
#6 /var/webman-dev/ectms-web/plugin/iadminer/app/middleware/IadminerAdminPlus.php(81): Webman\App::{closure:Webman\App::getCallback():356}()
#7 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(351): plugin\iadminer\app\middleware\IadminerAdminPlus->process()
#8 /var/webman-dev/ectms-web/plugin/admin/app/middleware/AccessControl.php(47): Webman\App::{closure:{closure:Webman\App::getCallback():348}:349}()
#9 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(351): plugin\admin\app\middleware\AccessControl->process()
#10 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(178): Webman\App::{closure:{closure:Webman\App::getCallback():348}:349}()
#11 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Connection/TcpConnection.php(750): Webman\App->onMessage()
#12 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Events/Select.php(406): Workerman\Connection\TcpConnection->baseRead()
#13 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Worker.php(1756): Workerman\Events\Select->run()
#14 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Worker.php(1552): Workerman\Worker::forkOneWorkerForLinux()
#15 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Worker.php(1532): Workerman\Worker::forkWorkersForLinux()
#16 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Worker.php(601): Workerman\Worker::forkWorkers()
#17 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/support/App.php(152): Workerman\Worker::runAll()
#18 /var/webman-dev/ectms-web/start.php(5): support\App::run()
#19 {main} [] []

Next Illuminate\Database\QueryException: 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 '' at line 1 (Connection: plugin.admin.mysql, SQL: select facility_id as id,facility_name as title, true as last,0 as facility_parent_id from ect_meta_facilities where facility_type=5 and department_id = ;) in /var/webman-dev/ectms-web/vendor/illuminate/database/Connection.php:829 Stack trace: #0 /var/webman-dev/ectms-web/vendor/illuminate/database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback() #1 /var/webman-dev/ectms-web/vendor/illuminate/database/Connection.php(414): Illuminate\Database\Connection->run() #2 /var/webman-dev/ectms-web/plugin/admin/app/common/sqlbig.php(66): Illuminate\Database\Connection->select() #3 /var/webman-dev/ectms-web/plugin/admin/app/controller/EctMetaFacilityController.php(301): plugin\admin\app\common\sqlbig::get_data() #4 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(335): plugin\admin\app\controller\EctMetaFacilityController->storage_json() #5 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(358): Webman\App::{closure:Webman\App::getCallback():333}() #6 /var/webman-dev/ectms-web/plugin/iadminer/app/middleware/IadminerAdminPlus.php(81): Webman\App::{closure:Webman\App::getCallback():356}() #7 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(351): plugin\iadminer\app\middleware\IadminerAdminPlus->process() #8 /var/webman-dev/ectms-web/plugin/admin/app/middleware/AccessControl.php(47): Webman\App::{closure:{closure:Webman\App::getCallback():348}:349}() #9 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(351): plugin\admin\app\middleware\AccessControl->process() #10 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/App.php(178): Webman\App::{closure:{closure:Webman\App::getCallback():348}:349}() #11 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Connection/TcpConnection.php(750): Webman\App->onMessage() #12 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Events/Select.php(406): Workerman\Connection\TcpConnection->baseRead() #13 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Worker.php(1756): Workerman\Events\Select->run() #14 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Worker.php(1552): Workerman\Worker::forkOneWorkerForLinux() #15 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Worker.php(1532): Workerman\Worker::forkWorkersForLinux() #16 /var/webman-dev/ectms-web/vendor/workerman/workerman/src/Worker.php(601): Workerman\Worker::forkWorkers() #17 /var/webman-dev/ectms-web/vendor/workerman/webman-framework/src/support/App.php(152): Workerman\Worker::runAll() #18 /var/webman-dev/ectms-web/start.php(5): support\App::run() #19 {main} [] []
Sign in to join this conversation.