./yii migrate --interactive=0 --migrationPath=@fecshop/migrations/mysqldb 导入数据库报错

安装报错 · jayfir · 于 5年前 发布 · 2159 次阅读
Exception: 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 3
The SQL being executed was: 
			INSERT INTO `admin_user_role` (`id`, `user_id`, `role_id`) VALUES
			(1, 2, 4),
			(2, 2, 12),
			 (/www/web/fecshop/vendor/yiisoft/yii2/db/Schema.php:664)
#0 /www/web/fecshop/vendor/yiisoft/yii2/db/Command.php(1263): yii\db\Schema->convertException(Object(PDOException), '\n\t\t\tINSERT INTO...')
#1 /www/web/fecshop/vendor/yiisoft/yii2/db/Command.php(1075): yii\db\Command->internalExecute('\n\t\t\tINSERT INTO...')
#2 /www/web/fecshop/vendor/yiisoft/yii2/db/Migration.php(219): yii\db\Command->execute()
#3 /www/web/fecshop/vendor/fancyecommerce/fecshop/migrations/mysqldb/m170228_072156_fecshop_tables.php(506): yii\db\Migration->execute('\n\t\t\tINSERT INTO...')
#4 /www/web/fecshop/vendor/yiisoft/yii2/db/Migration.php(114): m170228_072156_fecshop_tables->safeUp()
#5 /www/web/fecshop/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(725): yii\db\Migration->up()
#6 /www/web/fecshop/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(199): yii\console\controllers\BaseMigrateController->migrateUp('m170228_072156_...')
#7 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0)
#8 /www/web/fecshop/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#9 /www/web/fecshop/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#10 /www/web/fecshop/vendor/yiisoft/yii2/console/Controller.php(148): yii\base\Controller->runAction('', Array)
#11 /www/web/fecshop/vendor/yiisoft/yii2/base/Module.php(528): yii\console\Controller->runAction('', Array)
#12 /www/web/fecshop/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('migrate', Array)
#13 /www/web/fecshop/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('migrate', Array)
#14 /www/web/fecshop/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest(Object(yii\console\Request))
#15 /www/web/fecshop/yii(82): yii\base\Application->run()
#16 {main}
*** failed to apply m170228_072156_fecshop_tables (time: 0.061s)


0 from 16 migrations were applied.

Migration failed. The rest of the migrations are canceled.
共收到 6 条回复
Fecmall#15年前 0 个赞

mysql8?

搜索下找找原因

jayfir#25年前 0 个赞

@Fecshop [#1楼](#comment1) 找到原因了,,是fecshop最新版 1.4.6迁移文件的引号引起的问题

vendor\fancyecommerce\fecshop\migrations\mysqldb\m170228_072156_fecshop_tables.php

更改后的文件为: 全双引号

Fecmall#35年前 0 个赞

说一下具体的文件代码位置,具体是哪行?很多人都不报错的。 说一下有问题的地方,已经相应的修改

jayfir#45年前 0 个赞

报错以及修改位置

Fecmall#55年前 0 个赞

多谢,回去改一下。

qingdao#65年前 0 个赞

已经在青岛安稳下来,发布了一个子版本修复了这个问题:

http://www.fecshop.com/topic/1243

添加回复 (需要登录)
需要 登录 后方可回复, 如果你还没有账号请点击这里 注册
Your Site Analytics