六安人名，操作人界面，没有数据，返回报错 #99
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?
有几个表的department_id 是必填的
{
"code": "42S22",
"msg": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'department_id' in 'where clause' (Connection: plugin.admin.mysql, SQL: select count() as aggregate from
departmentwheredepartment_id= 24)","type": "failed",
"traces": "PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'department_id' in 'where clause' in phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Connection.php:423\nStack trace:\n#0 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Connection.php(423): PDO->prepare('select count()...')\n#1 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Connection.php(816): Illuminate\Database\Connection->{closure:Illuminate\Database\Connection::select():414}('select count()...', Array)\n#2 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback('select count()...', Array, Object(Closure))\n#3 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Connection.php(414): Illuminate\Database\Connection->run('select count()...', Array, Object(Closure))\n#4 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(2913): Illuminate\Database\Connection->select('select count()...', Array, true)\n#5 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(2902): Illuminate\Database\Query\Builder->runSelect()\n#6 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(3456): Illuminate\Database\Query\Builder->{closure:Illuminate\Database\Query\Builder::get():2901}()\n#7 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(2901): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))\n#8 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(3066): Illuminate\Database\Query\Builder->get()\n#9 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(3025): Illuminate\Database\Query\Builder->runPaginationCountQuery(Array)\n#10 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Eloquent/Builder.php(923): Illuminate\Database\Query\Builder->getCountForPagination()\n#11 phar:///var/opm/bin2/opm_ectms/plugin/admin/app/controller/Crud.php(289): Illuminate\Database\Eloquent\Builder->paginate(10)\n#12 phar:///var/opm/bin2/opm_ectms/plugin/admin/app/controller/Crud.php(73): plugin\admin\app\controller\Crud->doFormat(Object(Illuminate\Database\Eloquent\Builder), 'normal', 10)\n#13 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(335): plugin\admin\app\controller\Crud->select(Object(support\Request))\n#14 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(358): Webman\App::{closure:Webman\App::getCallback():333}(Object(support\Request))\n#15 phar:///var/opm/bin2/opm_ectms/plugin/iadminer/app/middleware/IadminerAdminPlus.php(81): Webman\App::{closure:Webman\App::getCallback():356}(Object(support\Request))\n#16 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(351): plugin\iadminer\app\middleware\IadminerAdminPlus->process(Object(support\Request), Object(Closure))\n#17 phar:///var/opm/bin2/opm_ectms/plugin/admin/app/middleware/AccessControl.php(47): Webman\App::{closure:{closure:Webman\App::getCallback():348}:349}(Object(support\Request))\n#18 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(351): plugin\admin\app\middleware\AccessControl->process(Object(support\Request), Object(Closure))\n#19 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(178): Webman\App::{closure:{closure:Webman\App::getCallback():348}:349}(Object(support\Request))\n#20 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Connection/TcpConnection.php(750): Webman\App->onMessage(Object(Workerman\Connection\TcpConnection), Object(support\Request))\n#21 [internal function]: Workerman\Connection\TcpConnection->baseRead(Resource id #959, true, NULL)\n#22 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Events/Event.php(250): EventBase->loop()\n#23 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Worker.php(1756): Workerman\Events\Event->run()\n#24 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Worker.php(1552): Workerman\Worker::forkOneWorkerForLinux(Object(Workerman\Worker))\n#25 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Worker.php(1532): Workerman\Worker::forkWorkersForLinux()\n#26 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Worker.php(601): Workerman\Worker::forkWorkers()\n#27 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/support/App.php(152): Workerman\Worker::runAll()\n#28 phar:///var/opm/bin2/opm_ectms/vendor/webman/console/src/Commands/ReStartCommand.php(31): support\App::run()\n#29 phar:///var/opm/bin2/opm_ectms/vendor/symfony/console/Command/Command.php(318): Webman\Console\Commands\ReStartCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n#30 phar:///var/opm/bin2/opm_ectms/vendor/symfony/console/Application.php(1092): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n#31 phar:///var/opm/bin2/opm_ectms/vendor/symfony/console/Application.php(359): Symfony\Component\Console\Application->doRunCommand(Object(Webman\Console\Commands\ReStartCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n#32 phar:///var/opm/bin2/opm_ectms/vendor/symfony/console/Application.php(194): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n#33 phar:///var/opm/bin2/opm_ectms/webman(73): Symfony\Component\Console\Application->run()\n#34 /var/opm/bin2/opm_ectms(5): require('phar:///var/opm...')\n#35 {main}\n\nNext Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'department_id' in 'where clause' (Connection: plugin.admin.mysql, SQL: select count() as aggregate from
departmentwheredepartment_id= 24) in phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Connection.php:829\nStack trace:\n#0 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback('select count()...', Array, Object(Closure))\n#1 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Connection.php(414): Illuminate\Database\Connection->run('select count()...', Array, Object(Closure))\n#2 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(2913): Illuminate\Database\Connection->select('select count()...', Array, true)\n#3 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(2902): Illuminate\Database\Query\Builder->runSelect()\n#4 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(3456): Illuminate\Database\Query\Builder->{closure:Illuminate\Database\Query\Builder::get():2901}()\n#5 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(2901): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))\n#6 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(3066): Illuminate\Database\Query\Builder->get()\n#7 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Query/Builder.php(3025): Illuminate\Database\Query\Builder->runPaginationCountQuery(Array)\n#8 phar:///var/opm/bin2/opm_ectms/vendor/illuminate/database/Eloquent/Builder.php(923): Illuminate\Database\Query\Builder->getCountForPagination()\n#9 phar:///var/opm/bin2/opm_ectms/plugin/admin/app/controller/Crud.php(289): Illuminate\Database\Eloquent\Builder->paginate(10)\n#10 phar:///var/opm/bin2/opm_ectms/plugin/admin/app/controller/Crud.php(73): plugin\admin\app\controller\Crud->doFormat(Object(Illuminate\Database\Eloquent\Builder), 'normal', 10)\n#11 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(335): plugin\admin\app\controller\Crud->select(Object(support\Request))\n#12 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(358): Webman\App::{closure:Webman\App::getCallback():333}(Object(support\Request))\n#13 phar:///var/opm/bin2/opm_ectms/plugin/iadminer/app/middleware/IadminerAdminPlus.php(81): Webman\App::{closure:Webman\App::getCallback():356}(Object(support\Request))\n#14 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(351): plugin\iadminer\app\middleware\IadminerAdminPlus->process(Object(support\Request), Object(Closure))\n#15 phar:///var/opm/bin2/opm_ectms/plugin/admin/app/middleware/AccessControl.php(47): Webman\App::{closure:{closure:Webman\App::getCallback():348}:349}(Object(support\Request))\n#16 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(351): plugin\admin\app\middleware\AccessControl->process(Object(support\Request), Object(Closure))\n#17 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/App.php(178): Webman\App::{closure:{closure:Webman\App::getCallback():348}:349}(Object(support\Request))\n#18 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Connection/TcpConnection.php(750): Webman\App->onMessage(Object(Workerman\Connection\TcpConnection), Object(support\Request))\n#19 [internal function]: Workerman\Connection\TcpConnection->baseRead(Resource id #959, true, NULL)\n#20 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Events/Event.php(250): EventBase->loop()\n#21 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Worker.php(1756): Workerman\Events\Event->run()\n#22 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Worker.php(1552): Workerman\Worker::forkOneWorkerForLinux(Object(Workerman\Worker))\n#23 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Worker.php(1532): Workerman\Worker::forkWorkersForLinux()\n#24 phar:///var/opm/bin2/opm_ectms/vendor/workerman/workerman/src/Worker.php(601): Workerman\Worker::forkWorkers()\n#25 phar:///var/opm/bin2/opm_ectms/vendor/workerman/webman-framework/src/support/App.php(152): Workerman\Worker::runAll()\n#26 phar:///var/opm/bin2/opm_ectms/vendor/webman/console/src/Commands/ReStartCommand.php(31): support\App::run()\n#27 phar:///var/opm/bin2/opm_ectms/vendor/symfony/console/Command/Command.php(318): Webman\Console\Commands\ReStartCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n#28 phar:///var/opm/bin2/opm_ectms/vendor/symfony/console/Application.php(1092): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n#29 phar:///var/opm/bin2/opm_ectms/vendor/symfony/console/Application.php(359): Symfony\Component\Console\Application->doRunCommand(Object(Webman\Console\Commands\ReStartCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n#30 phar:///var/opm/bin2/opm_ectms/vendor/symfony/console/Application.php(194): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n#31 phar:///var/opm/bin2/opm_ectms/webman(73): Symfony\Component\Console\Application->run()\n#32 /var/opm/bin2/opm_ectms(5): require('phar:///var/opm...')\n#33 {main}"}
最终解决是更新了 ect_user 表的 department_id