详细Laravel5.5执行表迁移命令出现表为空的解决方案

2018-09-07 12:40

阅读:439

  今天在使用一个第三方包 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

  清除配置文件缓存

   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$

  以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持脚本之家。


评论


亲,登录后才可以留言!