Bonjour,
J'ai le même genre de problème que vous.
Voilà mon erreur :
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`db_lrs/TDossier`, CONSTRAINT `TDossier_numdossier_TMedaille_tdossier_numdossier` FOREIGN KEY (`NumDossier`) REFERENCES `TMedaille` (`TDossier_NumDossier`))
Et voilà mon schéma :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98
| TMedaille:
connection: doctrine
tableName: TMedaille
columns:
nummedaille:
type: integer(4)
fixed: false
unsigned: true
primary: true
autoincrement: false
tdossier_numdossier:
type: integer(4)
fixed: false
unsigned: true
primary: false
notnull: true
autoincrement: false
tprofile_numprofile:
type: integer(4)
fixed: false
unsigned: true
primary: false
notnull: true
autoincrement: false
tnuance_numnuance:
type: integer(4)
fixed: false
unsigned: true
primary: false
notnull: true
autoincrement: false
tclasse_numclasse:
type: integer(4)
fixed: false
unsigned: true
primary: false
notnull: true
autoincrement: false
roul:
type: enum(6)
fixed: false
unsigned: false
values:
- INRA
- SAULON
primary: false
notnull: true
autoincrement: false
annee:
type: integer(8)
fixed: false
unsigned: false
primary: true
autoincrement: false
relations:
TClasse:
local: tclasse_numclasse
foreign: numclasse
type: one
TDossier:
onUpdate: CASCADE
onDelete: CASCADE
local: tdossier_numdossier
foreign: numdossier
type: one
TNuance:
local: tnuance_numnuance
foreign: numnuance
type: one
TProfile:
local: tprofile_numprofile
foreign: numprofile
type: one
TSoudure:
local: nummedaille
foreign: tmedaille_nummedaille
type: many
TDossier:
connection: doctrine
tableName: TDossier
columns:
numdossier:
type: integer(4)
fixed: false
unsigned: true
primary: true
autoincrement: false
annee:
type: integer(8)
fixed: false
unsigned: false
primary: false
autoincrement: false
relations:
TMedaille:
local: numdossier
foreign: tdossier_numdossier
type: many |
Je ne peux pas changer le numéro de dossier d'une médaille, j'ai l'erreur qui apparaît.
Qqun a une idée?
Partager