DataBase Error
Posted: 12 Dec 2015, 11:22
I am new o laravel and aimeos too.I was trying to add stock level and product property type. It shows an error like this :
Error (-1)
Executing statement "
INSERT INTO "mshop_product_property" (
"parentid", "siteid", "typeid", "langid", "value", "mtime", "editor",
"ctime"
) VALUES (
0, 1, 1, 'en', '100', '2015-12-12 11:20:28', '', '2015-12-12 11:20:28'
)
" failed: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("iseeyoo"."mshop_product_property", CONSTRAINT "fk_mspropr_parentid" FOREIGN KEY ("parentid") REFERENCES "mshop_product" ("id") ON DELETE CASCADE ON UPDATE CASCADE)
How can it be solved??
Error (-1)
Executing statement "
INSERT INTO "mshop_product_property" (
"parentid", "siteid", "typeid", "langid", "value", "mtime", "editor",
"ctime"
) VALUES (
0, 1, 1, 'en', '100', '2015-12-12 11:20:28', '', '2015-12-12 11:20:28'
)
" failed: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("iseeyoo"."mshop_product_property", CONSTRAINT "fk_mspropr_parentid" FOREIGN KEY ("parentid") REFERENCES "mshop_product" ("id") ON DELETE CASCADE ON UPDATE CASCADE)
How can it be solved??