No table name set on execute migration in Lumen

Question

I'm facing this error when attempting to run the migration in Lumen Framework:

$ php artisan migrate:install

 [Illuminate\Database\QueryException]                                                                   
  SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' (SQL: create table ``  
   (`migration` varchar(255) not null, `batch` int not null) default character set utf8 collate utf8_unicode_ci)     

  [PDOException]                                                                   
  SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''

And now I have no idea what's going on.

Note that the table that is not being created is the one which controls the migrations at all.

I have, but not found nothing similar. also, I've tried to reinstall the whole system, but still the same error — henriale, Oct 01 '15 at 04:23
In one of your migrations files you have put the table name as blank/empty. Please double check all of the migration files and make sure whether all of them have table names. — Mustafa Ehsan Alokozay, Oct 01 '15 at 06:06
make sure in your migration you have something similar to this : Schema::create('tableName', function (Blueprint $table) { //table fields } — Abdelrahman Magraby, Oct 01 '15 at 08:20
the migration file is Ok. The one that doesn't work is the migration table, when I run `php artisan migration:install` — henriale, Oct 01 '15 at 10:24

score 49 · Accepted Answer · answered Oct 03 '15 at 18:07

49

I found the solution myself!

Just add the name of the table on database config array and it's done!

'migrations' => 'migrations',

answered Oct 03 '15 at 18:07

henriale

1,012
9
21

3

Works for me, what a silly thing. When you create a custom config/database.php file (in Lumen), you have to add this solution to the main array, on the level of 'connections'. – Tominator Mar 07 '17 at 10:44
4

This worked for me, I was adding this hint in the wrong place. It should be added outside of the connections map. Check out https://github.com/laravel/lumen-framework/issues/248 for details – Abhishek Asthana Mar 22 '17 at 00:01
1

Worked for me as well, that's a quite silly problem as you said; why is it still not the documentation? – Mathieu Bour Aug 08 '17 at 05:03
saved my day. tvm – josevoid Jan 11 '20 at 06:51
1

You're the real god – Ageng D. Prastyawan Feb 01 '20 at 02:49
Worked for me on fresh install of Lumen8 with mysql8 thanks :D – thiout_p Oct 25 '20 at 22:53

score 6 · Answer 2 · edited Nov 22 '19 at 21:42

6

<?php
return [

    'default' => 'external',
    'migrations' => 'migrations',
    'connections' => [
        // your connections
    ],
];

edited Nov 22 '19 at 21:42

OrElse

9,709
39
140
253

answered Nov 22 '19 at 19:53

lorajc

81
1
4

The key here is: you need the `'migrations' => 'migrations'` part. – George May 27 '20 at 22:44
It could be kind to add where to put this `config/database.php` – Jicao Dec 07 '21 at 09:17
Please see https://github.com/laravel/laravel/blob/9.x/config/database.php where to put that part. – frankfurt-laravel Mar 10 '22 at 07:41

No table name set on execute migration in Lumen

2 Answers2