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

网络编程 2024/9/25 佚名

3 2 1

无为清净楼资源网 Design By www.qnjia.com

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

<"htmlcode">

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$

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

Laravel5.5执行表迁移命令,Laravel5.5,迁移命令