SQLSTATE[42S02] Error - Multi Tenancy

I'm trying to figure out multi tenancy, have ran through a couple docs / youtube videos and getting the following error:

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

select `academies`.*, `academy_user`.`user_id` as `pivot_user_id`, `academy_user`.`academy_id` as `pivot_academy_id` from `academies` inner join `academy_user` on `academies`.`id` = `academy_user`.`academy_id` where `academy_user`.`user_id` = 1 and `academies`.`deleted_at` is null

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

select `academies`.*, `academy_user`.`user_id` as `pivot_user_id`, `academy_user`.`academy_id` as `pivot_academy_id` from `academies` inner join `academy_user` on `academies`.`id` = `academy_user`.`academy_id` where `academy_user`.`user_id` = 1 and `academies`.`deleted_at` is null

I have an academies table, but no academy_user - I'm not sure what this is, surely that should just be user? Appreciate any help on this as I'm a bit out my depth.

Solution

Found the problem, posting here for future search of anyone having the same. May seem a simple one, but I didn't see anywhere in the docs where this was a step hence my struggling:

Jump to solution

Filament•2y ago•

6 replies

Hightower

SQLSTATE[42S02] Error - Multi Tenancy

I'm trying to figure out multi tenancy, have ran through a couple docs / youtube videos and getting the following error:

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

select `academies`.*, `academy_user`.`user_id` as `pivot_user_id`, `academy_user`.`academy_id` as `pivot_academy_id` from `academies` inner join `academy_user` on `academies`.`id` = `academy_user`.`academy_id` where `academy_user`.`user_id` = 1 and `academies`.`deleted_at` is null

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

select `academies`.*, `academy_user`.`user_id` as `pivot_user_id`, `academy_user`.`academy_id` as `pivot_academy_id` from `academies` inner join `academy_user` on `academies`.`id` = `academy_user`.`academy_id` where `academy_user`.`user_id` = 1 and `academies`.`deleted_at` is null

I have an academies table, but no academy_user - I'm not sure what this is, surely that should just be user? Appreciate any help on this as I'm a bit out my depth.

Solution

Found the problem, posting here for future search of anyone having the same. May seem a simple one, but I didn't see anywhere in the docs where this was a step hence my struggling:

Jump to solution

SQLSTATE[42S02] Error - Multi Tenancy

Similar Threads

SQLSTATE[42S02] Error - Multi Tenancy

Similar Threads

Similar Threads

Similar Threads