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.

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

[BUG]生成数据库结构时报错 #1678

Closed
Miku-programm opened this issue Nov 25, 2022 · 1 comment
Closed

[BUG]生成数据库结构时报错 #1678

Miku-programm opened this issue Nov 25, 2022 · 1 comment

Comments

@Miku-programm
Copy link

Environment 环境

OS: ubuntu22.0
PHP version: 7.4
DB version: 5.5.26

Bug Info
在新装面板后用 php vendor/bin/phinx migrate命令生成数据库结构时报错

== 20000101000000 InitDatabase: migrating
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes in /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:192
Stack trace:
#0 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(192): PDO->exec()
#1 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php(357): Phinx\Db\Adapter\PdoAdapter->execute()
#2 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(349): Phinx\Db\Adapter\MysqlAdapter->createTable()
#3 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/TimedOutputAdapter.php(113): Phinx\Db\Adapter\AdapterWrapper->createTable()
#4 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Db/Plan/Plan.php(146): Phinx\Db\Adapter\TimedOutputAdapter->createTable()
#5 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(716): Phinx\Db\Plan\Plan->execute()
#6 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(612): Phinx\Db\Table->executeActions()
#7 /www/wwwroot/update.reimu.work/db/migrations/20000101000000_init_database.php(67): Phinx\Db\Table->create()
#8 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(111): InitDatabase->up()
#9 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(388): Phinx\Migration\Manager\Environment->executeMigration()
#10 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(359): Phinx\Migration\Manager->executeMigration()
#11 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(122): Phinx\Migration\Manager->migrate()
#12 /www/wwwroot/update.reimu.work/vendor/symfony/console/Command/Command.php(291): Phinx\Console\Command\Migrate->execute()
#13 /www/wwwroot/update.reimu.work/vendor/symfony/console/Application.php(1014): Symfony\Component\Console\Command\Command->run()
#14 /www/wwwroot/update.reimu.work/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#15 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(70): Symfony\Component\Console\Application->doRun()
#16 /www/wwwroot/update.reimu.work/vendor/symfony/console/Application.php(171): Phinx\Console\PhinxApplication->doRun()
#17 /www/wwwroot/update.reimu.work/vendor/robmorgan/phinx/bin/phinx(28): Symfony\Component\Console\Application->run()
#18 /www/wwwroot/update.reimu.work/vendor/bin/phinx(120): include('...')
#19 {main}
面板配置文件数据库填写是正确的账户密码,新建的数据库也能登入,不过这个报错我不知道是哪里出错了

@AutisticShark
Copy link
Contributor

DB 太舊。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants