i`m using Entrust and has 3 types of users (Admin,Moderator, Player); I have 2 tables: Users and Hall (Game place); All this users (Admin, Moderator, Player) are stored in the Users table; so Admin and Moderator can make Hall; Users connected with hall_id;
I did relationship in Hall with Users for Owner_Id (who created Hall); and i want do same back for Players;
Users: when i did something in migration like $table->foreign('hall_id')->references('id')->on('hall') => i have error; Of course I do not forget to register unsigned() and hall_id is integer;
[Illuminate\Database\QueryException] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
bingo
.#sql-396_1dc
, CONSTR AINTusers_hall_id_foreign
FOREIGN KEY (hall_id
) REFERENCEShall
(id
)) (SQL: alter tableusers
add constraintusers_hall_id_foreign
foreig n key (hall_id
) referenceshall
(id
))
I want get about hall information of Players
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire