没有sql文件.执行./init, ./yii migrate 报错.

[GordonHuangYong]

执行./init报错.

./yii migrate
又报错

整个项目也没有发现sql文件.无法正常运行.

[osakey]

看错误你数据库 配置有问题。 把 localhost 改成 127.0.0.1吧

[kingwon]

m130524_201442_init 里面如果设置数据库为$tableOptions = 'CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ENGINE=InnoDB';
会报下面的错误；

Apply the above migrations? (yes|no) [no]:yes
*** applying m130524_201442_init
> create table {{%user}} ...Exception 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
The SQL being executed was: CREATE TABLE user (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
username varchar(255) NOT NULL UNIQUE,
auth_key varchar(32) NOT NULL,
password_hash varchar(255) NOT NULL,
password_reset_token varchar(255) UNIQUE,
email varchar(255) NOT NULL UNIQUE,
status smallint(6) NOT NULL DEFAULT 10,
created_at int(11) NOT NULL,
updated_at int(11) NOT NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ENGINE=InnoDB'

in E:\Code\richin-cms\vendor\yiisoft\yii2\db\Schema.php:664

Error Info:
Array
(
[0] => 42000
[1] => 1071
[2] => Specified key was too long; max key length is 767 bytes
)

[secretgao]

mysql 版本问题 用5.7+ 就没事了