访问 user_addresses 报错
版本: laravel 6.8
我的问题有点多。sqluel pro无法连接到数据库,在终端可以用命令访问数据库。email_verified_at
可以在验证邮箱的时候插入数据库。但是创建工厂文件报错:
factory(App.odels.serAddress::class, 3)->create(['user_id' => 1])
Illuminate/Database/QueryException with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'province' in 'field list' (SQL: insert into `user_addresses` (`province`, `city`, `district`, `address`, `zip`, `contact_name`, `contact_phone`, `user_id`, `updated_at`, `created_at`) values (广东省, 深圳市, 福田区, 第14街道第446号, 036100, 万毅, 13245344115, 1, 2019-12-23 19:20:11, 2019-12-23 19:20:11))'
而 .env 文件配成 DB_HOST 配置成 localhost 才能访问网站,如果是 127.0.0.1 则 shop.test 访问不了。
DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=8000
DB_DATABASE=laravel-shop
DB_USERNAME=homestead
DB_PASSWORD=secret
访问 http://localhost:8000/user_addresses 报错
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_addresses.user_id' in 'where clause' (SQL: select * from user_addresses
where user_addresses
.user_id
= 5 and user_addresses
.user_id
is not null)
推荐文章: