详细Laravel5.5执行表迁移命令出现表为空的解决方案
发布:smiling 来源: PHP粉丝网 添加日期:2021-10-10 13:41:28 浏览: 评论:0
今天在使用一个第三方包 laravel-admin 时,出现了这样的错误:SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '',折腾了好久,终于知道了解决方法,原来是配置文件的缓存没有清理。
一、问题
vagrant@homestead:~/Code/laravel-shop$ php artisan admin:install
错误提示:
- In Connection.php line 664:
- SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' (SQL: create table `` (`id` int uns
- igned not null auto_increment primary key, `username` varchar(190) not null, `password` varchar(60) not null, `name
- ` varchar(255) not null, `avatar` varchar(255) null, `remember_token` varchar(100) null, `created_at` timestamp nul
- l, `updated_at` timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci)
- In Connection.php line 452:
- SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''
二、解决方案
database/migrations/2016_01_04_173148_create_admin_table.php
- <?php
- use Illuminate\Database\Migrations\Migration;
- use Illuminate\Database\Schema\Blueprint;
- class CreateAdminTable extends Migration
- {
- /**
- * Run the migrations.
- *
- * @return void
- */
- public function up()
- {
- $connection = config('admin.database.connection') ?: config('database.default');
- // dd(app('config'));
- Schema::connection($connection)->create(config('admin.database.users_table'), function (Blueprint $table) {
- $table->increments('id');
- $table->string('username', 190)->unique();
- $table->string('password', 60);
- $table->string('name');
- $table->string('avatar')->nullable();
- $table->string('remember_token', 100)->nullable();
- $table->timestamps();
- });
- Schema::connection($connection)->create(config('admin.database.roles_table'), function (Blueprint $table) {
- $table->increments('id');
- $table->string('name', 50)->unique();
- $table->string('slug', 50);
- $table->timestamps();
- });
- Schema::connection($connection)->create(config('admin.database.permissions_table'), function (Blueprint $table) {
- $table->increments('id');
- $table->string('name', 50)->unique();
- $table->string('slug', 50);
- $table->string('http_method')->nullable();
- $table->text('http_path')->nullable();
- $table->timestamps();
- });
- Schema::connection($connection)->create(config('admin.database.menu_table'), function (Blueprint $table) {
- $table->increments('id');
- $table->integer('parent_id')->default(0);
- $table->integer('order')->default(0);
- $table->string('title', 50);
- $table->string('icon', 50);
- $table->string('uri', 50)->nullable();
- $table->timestamps();
- });
- Schema::connection($connection)->create(config('admin.database.role_users_table'), function (Blueprint $table) {
- $table->integer('role_id');
- $table->integer('user_id');
- $table->index(['role_id', 'user_id']);
- $table->timestamps();
- });
- Schema::connection($connection)->create(config('admin.database.role_permissions_table'), function (Blueprint $table) {
- $table->integer('role_id');
- $table->integer('permission_id');
- $table->index(['role_id', 'permission_id']);
- $table->timestamps();
- });
- Schema::connection($connection)->create(config('admin.database.user_permissions_table'), function (Blueprint $table) {
- $table->integer('user_id');
- $table->integer('permission_id');
- $table->index(['user_id', 'permission_id']);
- $table->timestamps();
- });
- Schema::connection($connection)->create(config('admin.database.role_menu_table'), function (Blueprint $table) {
- $table->integer('role_id');
- $table->integer('menu_id');
- $table->index(['role_id', 'menu_id']);
- $table->timestamps();
- });
- Schema::connection($connection)->create(config('admin.database.operation_log_table'), function (Blueprint $table) {
- $table->increments('id');
- $table->integer('user_id');
- $table->string('path');
- $table->string('method', 10);
- $table->string('ip', 15);
- $table->text('input');
- $table->index('user_id');
- $table->timestamps();
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- $connection = config('admin.database.connection') ?: config('database.default');
- Schema::connection($connection)->dropIfExists(config('admin.database.users_table'));
- Schema::connection($connection)->dropIfExists(config('admin.database.roles_table'));
- Schema::connection($connection)->dropIfExists(config('admin.database.permissions_table'));
- Schema::connection($connection)->dropIfExists(config('admin.database.menu_table'));
- Schema::connection($connection)->dropIfExists(config('admin.database.user_permissions_table'));
- Schema::connection($connection)->dropIfExists(config('admin.database.role_users_table'));
- Schema::connection($connection)->dropIfExists(config('admin.database.role_permissions_table'));
- Schema::connection($connection)->dropIfExists(config('admin.database.role_menu_table'));
- Schema::connection($connection)->dropIfExists(config('admin.database.operation_log_table'));
- }
- }
清除配置文件缓存
vagrant@homestead:~/Code/laravel-shop$ php artisan config:cache
再次执行发布命令,就可以了:
- vagrant@homestead:~/Code/laravel-shop$ php artisan admin:install
- Migrating: 2016_01_04_173148_create_admin_table
- Migrated: 2016_01_04_173148_create_admin_table
- Admin directory was created: /app/Admin
- HomeController file was created: /app/Admin/Controllers/HomeController.php
- ExampleController file was created: /app/Admin/Controllers/ExampleController.php
- Bootstrap file was created: /app/Admin/bootstrap.php
- Routes file was created: /app/Admin/routes.php
- vagrant@homestead:~/Code/laravel-shop$
Tags: Laravel5 5 迁移命令
相关文章
- ·如何在laravel 5中使用DB事务?(2020-01-31)
- ·Laravel5中contracts详解(2021-05-15)
- ·Laravel 5 学习笔记(2021-05-15)
- ·Laravel 5.5官方推荐的Nginx配置学习教程(2021-08-11)
- ·laravel5 使用try catch的实例详解(2021-08-21)
- ·Laravel5.5中利用Passport实现Auth认证的方法(2021-08-22)
- ·Laravel 5.5基于内置的Auth模块实现前后台登陆详解(2021-08-25)
- ·Laravel5.2使用Captcha生成验证码实现登录(session巨坑)(2021-08-26)
- ·Laravel 5.4.36中session没有保存成功问题的解决(2021-09-03)
- ·在Laravel5.6中使用Swoole的协程数据库查询(2021-10-01)
- ·Laravel5.5以下版本中如何自定义日志行为详解(2021-10-20)
- ·Laravel5框架添加自定义辅助函数的方法(2021-10-20)
- ·laravel5使用freetds连接sql server的方法(2021-11-02)
- ·Laravel5.4框架使用socialite实现github登录的方法(2021-11-13)
- ·Laravel5.7框架安装与使用学习笔记图文详解(2021-11-14)
- ·Laravel5.7 Eloquent ORM快速入门详解(2021-11-16)
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)