SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'response' at 医废系统添加sql记录系统执行时间之后出的bug #360
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
{
"code": "22001",
"msg": "SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'response' at row 1 (Connection: plugin.admin.mysql, SQL: insert into
iadminer_oplog(start_time,method,url,request,ip,created_at,updated_at,content,admin_id,response,end_time,running_time,sql_queries,sql_count,sql_time) values (1767549200.1616, get, /app/admin/report/select, {"page":"1","limit":"100","organ_name":"","dept_name":"","field":"id","order":"desc"}, 101.75.207.114, 2026-01-05 01:53:20, 2026-01-05 01:53:20, 查询 / 医废收集报表, 10, {"code":0,"msg":"ok","count":4941,"data":[{"id":9771963,"organ_name":"四川省儿童医院","sort_name":"本院","dept_name":"医学功能科","collection_name":"医学功能科","recl_name":"管云一","recl_idcard":" ","recl_time":"2026-01-04 15:56:41","waste_status":"出库","waste_type":"感染性废物","weight":"4","deposit_name":"暂存点",], 29, 563.2))","type": "failed",
"traces": "PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'response' at row 1 in /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/MySqlConnection.php:53
Stack trace:
#0 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/MySqlConnection.php(53): PDOStatement->execute()
#1 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Connection.php(813): Illuminate\Database\MySqlConnection->{closure:Illuminate\Database\MySqlConnection::insert():42}('insert into
ia...', Array) #2 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback('insert intoia...', Array, Object(Closure))#3 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/MySqlConnection.php(42): Illuminate\Database\Connection->run('insert into
ia...', Array, Object(Closure)) #4 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Query/Processors/MySqlProcessor.php(35): Illuminate\\Database\\MySqlConnection->insert('insert intoia...', Array, 'id')#5 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Query/Builder.php(3853): Illuminate\Database\Query\Processors\MySqlProcessor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ia...', Array, 'id')
#6 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Eloquent/Builder.php(2235): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#7 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Eloquent/Model.php(1436): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#8 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Eloquent/Model.php(1401): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#9 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Eloquent/Model.php(1240): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#10 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/iadminer/app/components/adminpower/middleware/AdminPlusOplog.php(202): Illuminate\Database\Eloquent\Model->save()
#11 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/iadminer/app/components/adminpower/middleware/AdminPlusOplog.php(170): plugin\iadminer\app\components\adminpower\middleware\AdminPlusOplog->insert_oplog()
#12 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/iadminer/app/components/adminpower/AdminOplog.php(42): plugin\iadminer\app\components\adminpower\middleware\AdminPlusOplog->response(Object(support\Request), Object(support\Response))
#13 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/iadminer/app/middleware/IadminerAdminPlus.php(100): plugin\iadminer\app\components\adminpower\AdminOplog->response(Object(support\Request), Object(support\Response))
#14 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/App.php(352): plugin\iadminer\app\middleware\IadminerAdminPlus->process(Object(support\Request), Object(Closure))
#15 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/admin/app/middleware/AccessControl.php(40): Webman\App::{closure:{closure:Webman\App::getCallback():349}:350}(Object(support\Request))
#16 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/App.php(352): plugin\admin\app\middleware\AccessControl->process(Object(support\Request), Object(Closure))
#17 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/webman/log/src/Middleware.php(97): Webman\App::{closure:{closure:Webman\App::getCallback():349}:350}(Object(support\Request))
#18 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/App.php(352): Webman\Log\Middleware->process(Object(support\Request), Object(Closure))
#19 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/App.php(180): Webman\App::{closure:{closure:Webman\App::getCallback():349}:350}(Object(support\Request))
#20 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Connection/TcpConnection.php(746): Webman\App->onMessage(Object(Workerman\Connection\TcpConnection), Object(support\Request))
#21 [internal function]: Workerman\Connection\TcpConnection->baseRead(Resource id #1808, true, NULL)
#22 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Events/Event.php(250): EventBase->loop()
#23 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1758): Workerman\Events\Event->run()
#24 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1554): Workerman\Worker::forkOneWorkerForLinux(Object(Workerman\Worker))
#25 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1534): Workerman\Worker::forkWorkersForLinux()
#26 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1903): Workerman\Worker::forkWorkers()
#27 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1838): Workerman\Worker::monitorWorkersForLinux()
#28 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(605): Workerman\Worker::monitorWorkers()
#29 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/support/App.php(147): Workerman\Worker::runAll()
#30 /var/opm/bin/mwims-web-dev-scet/mwims-web/start.php(5): support\App::run()
#31 {main}
Next Illuminate\Database\QueryException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'response' at row 1 (Connection: plugin.admin.mysql, SQL: insert into
iadminer_oplog(start_time,method,url,request,ip,created_at,updated_at,content,admin_id,response,end_time,running_time,sql_queries,sql_count,sql_time) values (1767549200.1616, get, /app/admin/report/select, {"page":"1","limit":"100","organ_name":"","dept_name":"","field":"id","order":"desc"}, 101.75.207.114, 2026-01-05 01:53:20, 2026-01-05 01:53:20, 查询 / 医废收集报表, 10, {"code":0,"msg":"ok","count":4941,"data":[{"id":9771963,"organ_name":"四川省儿童医院","sort_name":"本院","dept_name":"医学功能科","collection_name":"医学功能科","recl_name":"管云一","recl_idcard":" ","recl_time":"2026-01-04 15:56:41","waste_status":"出库","waste_type":"感染性废物","weight":"4","deposit_name":"暂存点",)) in /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Connection.php:826Stack trace:
#0 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Connection.php(780): Illuminate\Database\Connection->runQueryCallback('insert into
ia...', Array, Object(Closure)) #1 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run('insert intoia...', Array, Object(Closure))#2 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Query/Processors/MySqlProcessor.php(35): Illuminate\Database\MySqlConnection->insert('insert into
ia...', Array, 'id') #3 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Query/Builder.php(3853): Illuminate\\Database\\Query\\Processors\\MySqlProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert intoia...', Array, 'id')#4 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Eloquent/Builder.php(2235): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#5 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Eloquent/Model.php(1436): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#6 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Eloquent/Model.php(1401): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#7 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/illuminate/database/Eloquent/Model.php(1240): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#8 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/iadminer/app/components/adminpower/middleware/AdminPlusOplog.php(202): Illuminate\Database\Eloquent\Model->save()
#9 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/iadminer/app/components/adminpower/middleware/AdminPlusOplog.php(170): plugin\iadminer\app\components\adminpower\middleware\AdminPlusOplog->insert_oplog()
#10 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/iadminer/app/components/adminpower/AdminOplog.php(42): plugin\iadminer\app\components\adminpower\middleware\AdminPlusOplog->response(Object(support\Request), Object(support\Response))
#11 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/iadminer/app/middleware/IadminerAdminPlus.php(100): plugin\iadminer\app\components\adminpower\AdminOplog->response(Object(support\Request), Object(support\Response))
#12 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/App.php(352): plugin\iadminer\app\middleware\IadminerAdminPlus->process(Object(support\Request), Object(Closure))
#13 /var/opm/bin/mwims-web-dev-scet/mwims-web/plugin/admin/app/middleware/AccessControl.php(40): Webman\App::{closure:{closure:Webman\App::getCallback():349}:350}(Object(support\Request))
#14 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/App.php(352): plugin\admin\app\middleware\AccessControl->process(Object(support\Request), Object(Closure))
#15 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/webman/log/src/Middleware.php(97): Webman\App::{closure:{closure:Webman\App::getCallback():349}:350}(Object(support\Request))
#16 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/App.php(352): Webman\Log\Middleware->process(Object(support\Request), Object(Closure))
#17 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/App.php(180): Webman\App::{closure:{closure:Webman\App::getCallback():349}:350}(Object(support\Request))
#18 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Connection/TcpConnection.php(746): Webman\App->onMessage(Object(Workerman\Connection\TcpConnection), Object(support\Request))
#19 [internal function]: Workerman\Connection\TcpConnection->baseRead(Resource id #1808, true, NULL)
#20 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Events/Event.php(250): EventBase->loop()
#21 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1758): Workerman\Events\Event->run()
#22 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1554): Workerman\Worker::forkOneWorkerForLinux(Object(Workerman\Worker))
#23 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1534): Workerman\Worker::forkWorkersForLinux()
#24 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1903): Workerman\Worker::forkWorkers()
#25 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(1838): Workerman\Worker::monitorWorkersForLinux()
#26 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/workerman/src/Worker.php(605): Workerman\Worker::monitorWorkers()
#27 /var/opm/bin/mwims-web-dev-scet/mwims-web/vendor/workerman/webman-framework/src/support/App.php(147): Workerman\Worker::runAll()
#28 /var/opm/bin/mwims-web-dev-scet/mwims-web/start.php(5): support\App::run()
#29 {main}"
}
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'response' at 医废系统添加sql记录系统执行时间之后to SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'response' at 医废系统添加sql记录系统执行时间之后出的bug