Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG]按照Wiki说明进行配2022.12.1版本无法安装 #1840

Closed
blainehuang1028 opened this issue Mar 18, 2023 · 1 comment
Closed

[BUG]按照Wiki说明进行配2022.12.1版本无法安装 #1840

blainehuang1028 opened this issue Mar 18, 2023 · 1 comment
Labels
bug-user-report

Comments

@blainehuang1028
Copy link

blainehuang1028 commented Mar 18, 2023 •
edited
Loading

Environment 环境

Ubuntu22.04
Nginx
PHP 8.1 with OPcache
MariaDB 10.6
phpMyAdmin

Bug Info

根据Wiki中Oneinstack安装说明进行安装，设置完config后执行命令，报错

`bash update.sh
Unable to load class: \App\Command\Migration
PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'item' in 'where clause' in /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php:414
Stack trace:
#0 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(414): PDO->prepare()
#1 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#4 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#5 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#9 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#10 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#11 /data/wwwroot/blainehuang.me/src/Command/Tool.php(104): Illuminate\Database\Eloquent\Builder->first()
#12 /data/wwwroot/blainehuang.me/src/Command/Tool.php(44): App\Command\Tool->importAllSettings()
#13 /data/wwwroot/blainehuang.me/xcat(51): App\Command\Tool->boot()
#14 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'item' in 'where clause' (SQL: select * from `config` where `item` = payment_gateway limit 1) in /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#9 /data/wwwroot/blainehuang.me/src/Command/Tool.php(104): Illuminate\Database\Eloquent\Builder->first()
#10 /data/wwwroot/blainehuang.me/src/Command/Tool.php(44): App\Command\Tool->importAllSettings()
#11 /data/wwwroot/blainehuang.me/xcat(51): App\Command\Tool->boot()
#12 {main}
  thrown in /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php on line 760
(1/3) 请输入管理员邮箱：blainehuang@outlook.com
(2/3) 请输入管理员账户密码：q7s5x3QQ
(3/3) 按 Y 或 y 确认创建：Y
PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'class' in 'where clause' in /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php:414
Stack trace:
#0 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(414): PDO->prepare()
#1 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#4 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#5 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#9 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#10 /data/wwwroot/blainehuang.me/src/Models/Setting.php(29): Illuminate\Database\Eloquent\Builder->get()
#11 /data/wwwroot/blainehuang.me/src/Command/Tool.php(267): App\Models\Setting::getClass()
#12 /data/wwwroot/blainehuang.me/src/Command/Tool.php(44): App\Command\Tool->createAdmin()
#13 /data/wwwroot/blainehuang.me/xcat(51): App\Command\Tool->boot()
#14 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'class' in 'where clause' (SQL: select * from `config` where `class` = register) in /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /data/wwwroot/blainehuang.me/src/Models/Setting.php(29): Illuminate\Database\Eloquent\Builder->get()
#9 /data/wwwroot/blainehuang.me/src/Command/Tool.php(267): App\Models\Setting::getClass()
#10 /data/wwwroot/blainehuang.me/src/Command/Tool.php(44): App\Command\Tool->createAdmin()
#11 /data/wwwroot/blainehuang.me/xcat(51): App\Command\Tool->boot()
#12 {main}
  thrown in /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php on line 760
====== Clash for Windows 开始 ======
- 本地不存在 Clash for Windows，检测到当前最新版本为 0.20.18
目标文件夹 /data/wwwroot/blainehuang.me/app/../public/clients/ 不存在，创建中...
PHP Fatal error:  Uncaught Error: Call to undefined function App\Command\system() in /data/wwwroot/blainehuang.me/src/Command/ClientDownload.php:53
Stack trace:
#0 /data/wwwroot/blainehuang.me/src/Command/ClientDownload.php(226): App\Command\ClientDownload->getSourceFile()
#1 /data/wwwroot/blainehuang.me/src/Command/ClientDownload.php(41): App\Command\ClientDownload->getSoft()
#2 /data/wwwroot/blainehuang.me/xcat(51): App\Command\ClientDownload->boot()
#3 {main}
  thrown in /data/wwwroot/blainehuang.me/src/Command/ClientDownload.php on line 53
fatal: detected dubious ownership in repository at '/data/wwwroot/blainehuang.me'
To add an exception for this directory, call:

        git config --global --add safe.directory /data/wwwroot/blainehuang.me
fatal: detected dubious ownership in repository at '/data/wwwroot/blainehuang.me'
To add an exception for this directory, call:

        git config --global --add safe.directory /data/wwwroot/blainehuang.me
fatal: detected dubious ownership in repository at '/data/wwwroot/blainehuang.me'
To add an exception for this directory, call:

        git config --global --add safe.directory /data/wwwroot/blainehuang.me
rm: cannot remove 'storage/framework/smarty/compile/*': No such file or directory
Loading composer repositories with package information
Info from https://repo.packagist.org: #StandWithUkraine
Updating dependencies
Nothing to modify in lock file
Installing dependencies from lock file (including require-dev)
Nothing to install, update or remove
Package phploc/phploc is abandoned, you should avoid using it. No replacement was suggested.
Generating optimized autoload files
60 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
No security vulnerability advisories found
You are already using the latest available Composer version 2.5.4 (stable channel).
Phinx by CakePHP - https://phinx.org.

using config file phinx.php
using config parser php
using migration paths 
 - /data/wwwroot/blainehuang.me/db/migrations
using seed paths 
 - /data/wwwroot/blainehuang.me/db/seeds
warning no environment specified, defaulting to: production
using adapter mysql
using database sspanel
ordering by creation time

 == 20220522184308 FixUserMoneyField: migrating 
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'money' in 'user' in /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:192
Stack trace:
#0 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(192): PDO->exec()
#1 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Util/AlterInstructions.php(108): Phinx\Db\Adapter\PdoAdapter->execute()
#2 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(626): Phinx\Db\Util\AlterInstructions->execute()
#3 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(1001): Phinx\Db\Adapter\PdoAdapter->executeAlterSteps()
#4 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(477): Phinx\Db\Adapter\PdoAdapter->executeActions()
#5 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/TimedOutputAdapter.php(420): Phinx\Db\Adapter\AdapterWrapper->executeActions()
#6 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Plan/Plan.php(151): Phinx\Db\Adapter\TimedOutputAdapter->executeActions()
#7 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(719): Phinx\Db\Plan\Plan->execute()
#8 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(627): Phinx\Db\Table->executeActions()
#9 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(686): Phinx\Db\Table->update()
#10 /data/wwwroot/blainehuang.me/db/migrations/20220522184308_fix_user_money_field.php(15): Phinx\Db\Table->save()
#11 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(108): FixUserMoneyField->change()
#12 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(388): Phinx\Migration\Manager\Environment->executeMigration()#13 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(359): Phinx\Migration\Manager->executeMigration()
#14 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(122): Phinx\Migration\Manager->migrate()
#15 /data/wwwroot/blainehuang.me/vendor/symfony/console/Command/Command.php(312): Phinx\Console\Command\Migrate->execute()
#16 /data/wwwroot/blainehuang.me/vendor/symfony/console/Application.php(1022): Symfony\Component\Console\Command\Command->run()
#17 /data/wwwroot/blainehuang.me/vendor/symfony/console/Application.php(314): Symfony\Component\Console\Application->doRunCommand()
#18 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(70): Symfony\Component\Console\Application->doRun()
#19 /data/wwwroot/blainehuang.me/vendor/symfony/console/Application.php(168): Phinx\Console\PhinxApplication->doRun()
#20 /data/wwwroot/blainehuang.me/vendor/robmorgan/phinx/bin/phinx(28): Symfony\Component\Console\Application->run()
#21 /data/wwwroot/blainehuang.me/vendor/bin/phinx(120): include('...')
#22 {main}
备份成功


新增配置项通常带有默认值，因此通常即使不作任何改动网站也可以正常运行

迁移完成
PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'item' in 'where clause' in /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php:414
Stack trace:
#0 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(414): PDO->prepare()
#1 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#4 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#5 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#9 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#10 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#11 /data/wwwroot/blainehuang.me/src/Command/Tool.php(104): Illuminate\Database\Eloquent\Builder->first()
#12 /data/wwwroot/blainehuang.me/src/Command/Tool.php(44): App\Command\Tool->importAllSettings()
#13 /data/wwwroot/blainehuang.me/xcat(51): App\Command\Tool->boot()
#14 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'item' in 'where clause' (SQL: select * from `config` where `item` = payment_gateway limit 1) in /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /data/wwwroot/blainehuang.me/vendor/illuminate/database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#9 /data/wwwroot/blainehuang.me/src/Command/Tool.php(104): Illuminate\Database\Eloquent\Builder->first()
#10 /data/wwwroot/blainehuang.me/src/Command/Tool.php(44): App\Command\Tool->importAllSettings()
#11 /data/wwwroot/blainehuang.me/xcat(51): App\Command\Tool->boot()
#12 {main}`
@Simonaorg
Copy link

这个问题怎么解决的啊， 我也遇到了，检查了数据库对接没问题啊

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug-user-report
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@blainehuang1028 @Simonaorg