zxcv

第 665 位会员

会员
个人信息
  • 加入于 2018-10-19 12:15:18
  • 最后登录时间 5年前
个人成就
  • 发表文章次数 3
  • 发布回复次数 5
  • 个人主页浏览次数 0
docker安装1.5.0.0,数据库倒入报错:Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [1130]5年前

您说对了,重新执行./yii migrate --interactive=0 --migrationPath=@fecshop/migrations/mysqldb 后面没问题了。多谢!

docker安装1.5.0.0,数据库倒入报错:Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [1130]5年前

main-local.php:

'db' => [ 
            'class' => 'yii\db\Connection',
            'dsn' => 'mysql:host=mysql;dbname=fecshop',
            'username' => 'root',
            'password' => 'fecshopxfd3ffaads123456',
            'charset' => 'utf8',
        ],

docker-compose.yml:

mysql:  
    image: registry.cn-hangzhou.aliyuncs.com/fecshopsoft/mysql 
    restart: always
    volumes:  
      - ./db/mysql/data:/var/lib/mysql 
      - ./db/mysql/example_db:/var/example_db 
      - ./db/mysql/conf.d:/etc/mysql/conf.d      
    restart: always
    environment:
      - MYSQL_ROOT_PASSWORD=fecshopxfd3ffaads123456
      - MYSQL_DATABASE=fecshop
    networks:
      - code-network 

不折腾了,我还是先装旧版本

docker安装1.5.0.0,数据库倒入报错:Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [1130]5年前

会不会是以前的文档和1.5.0.0不匹配?后面继续报错:

mysql> use fecshop;
Database changed
mysql> source /var/example_db/mysql_fecshop.sql
Query OK, 0 rows affected, 1 warning (0.17 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

ERROR 1146 (42S02): Table 'fecshop.product_custom_option_qty' doesn't exist
ERROR 1146 (42S02): Table 'fecshop.product_flat_qty' doesn't exist

Your Site Analytics