Laravel custom register table

Question

I am trying to register an user using Laravel's native auth. Login works fine, but when I try to register a new user I get an error after submitting a form:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_db.user' doesn't exist

Of course, I made a table named users which I think has more sense and never had trouble up until now.

I am using Entrust for roles and permissions, so I had to change auth.php to:

'providers' => [
    'user' => [
        'driver' => 'eloquent',
        'model' => User::class,
    ],

but even if I make this:

'providers' => [
    'user' => [
        'driver' => 'eloquent',
        'model' => User::class,
        'table' => users
    ],

it submits a form on user table

Did you run the migrations? The users table is in the migrations provided by Laravel. — thisistg
– thisistg, Commented Jun 28, 2017 at 16:22
users and password_reset tables are already there in migration you have to run migrations — Sagar Gautam
– Sagar Gautam, Commented Jun 28, 2017 at 16:23
I told you I can log in...I couldn't log in if I hadn't ran the migrations first — Norgul
– Norgul, Commented Jun 28, 2017 at 16:25
@Norgul Can you check your App\User file? make sure that it has protected $table = "users"; — Ohgodwhy
– Ohgodwhy, Commented Jun 28, 2017 at 16:29
according to the error, the query attempts inserting into 'my_db.user' while your table is probably named users maybe in your model or config, you forgot writing the s — Amadeo Manouchehri
– Amadeo Manouchehri, Commented Jun 28, 2017 at 19:33

Vajira Prabuddhaka · Accepted Answer · 2017-10-31 11:28:11Z

1

First make sure you have properly created your model at User.php and correctly linked your user table. For example protected $table = 'user';

Then make sure to change validator function in the RegisterController.php.

Note: I think you getting error while validating inputs, not submitting to database. Because it checks already registered users(uniqueness) on the database, before adding to it. So, carefully check your email validation.

edited Oct 31, 2017 at 11:28

answered Oct 31, 2017 at 11:20

Vajira Prabuddhaka

9424 gold badges17 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel custom register table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related