今天在使用第三方包laravel-admin时，出现错误：SQLSTATE[42000]:Syntaxerrororaccessviolation:1103Incorrecttablename''，折腾了半天，终于找到解决办法，原来如此为配置文件缓存不清除。1.问题vagrant@homestead:~/Code/laravel-shop$phpartisanadmin:install报错信息：InConnection.phpline664:SQLSTATE[42000]:Syntaxerrororaccessviolation:1103Incorrecttablename''(SQL:创建表``（`id`intunsignednotnullauto_increment主键，`username`varchar(190)notnull，`password`varchar(60)notnull，`name`varchar(255)notnull，`avatar`varchar(255)null,`remember_token`varchar(100)null,`created_at`timestampnulll,`updated_at`timestampnull)defaultcharactersetutf8mb4collat??eutf8mb4_unicode_ci)InConnection.phpline452:SQLSTATE[42000]:语法错误或accessviolation:1103Incorrecttablename''二、解决方案database/migrations/2016_01_04_173148_create_admin_table.phpcreate(config('admin.database.users_table'),function(Blueprint$table){$table->increments('id');$table->string('用户名',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('名称',50)->unique();$table->string('鼻涕虫',50);$表->时间戳（）；});Schema::connection($connection)->create(config('admin.database.permissions_table'),function(Blueprint$table){$table->increments('id');$table->string('名称',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'),函数(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();});图式::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'),函数(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'),函数(Blueprint$table){$table->integer('user_id');$table->integer('permission_id');$table->index(['user_id','permission_id']);$table->timestamps();});模式::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'),函数(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();});}/***反转迁移。**@returnvoid*/publicfunctiondown(){$connection=config('admin.database.connection')?:config('database.default');模式::连接on($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$phpartisanconfig:cache再次执行发布指令，就可以了：vagrant@homestead:~/Code/laravel-shop$phpartisanadmin:installMigrating:2016_01_04_173148_create_admin_tableMigrated:2016_01_04_173148_create_admin_tableAdmindirectorywascreated:/app/AdminHomeControllerfilewascreated:/app/Admin/Controllers/HomeController.phpExampleControllerfilewas创建：/app/Admin/Controllers/ExampleController.phpBootstrap文件创建：/app/Admin/bootstrap.phpRoutes文件创建：/app/Admin/routes.phpvagrant@homestead:~/Code/laravel-shop$
