handisb's avatar

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

I'm trying to add a new column to my users table in Lumen, but for some reason whenever I run php artisan migrate, it gives this error:


SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' (SQL: create table \` (`id` int uns`

igned not null auto_increment primary key, \migration` varchar(255) not null, `batch` int not null) default charact`

er set utf8 collate 'utf8_unicode_ci')


In PDOConnection.php line 66:

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

In PDOConnection.php line 64:

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

I'm using two databases, and my users table is in the second one. Each database has its own separate migration table. I have two database connections, and the default one is the "users" connection, while the other one is the "mysql" connection.

I am stumped as to what is going wrong. Any help would be appreciated.

0 likes
1 reply

Please or to participate in this conversation.