Star Repo
Integrity constraint violation fk_msproli_pid
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Integrity constraint violation fk_msproli_pid
Hello,
I have a problem with an TYPO3 extension aimeos 19.10.12 running on Linux, TYPO3 v. 9 and PHP 7.4. (Yes, I know that this is old and needs to be updated. We are working on it - but nevertheless, the current shop needs to be running.)
I don't know when this started. The products are always updated using XML import. Now, I noticed that changing any of the attributes or the text or media results in an error like this:
Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("dedivikj_db2"."mshop_product_list", CONSTRAINT "fk_msproli_pid" FOREIGN KEY ("parentid") REFERENCES "mshop_product_del" ("id") ON DELETE CASCADE ON UPDATE CASCADE): INSERT INTO "mshop_product_list" ( "parentid", "key", "type", "domain", "refid", "start", "end", "config", "pos", "status", "mtime", "editor", "siteid", "ctime" ) VALUES ( 8, 'attribute|variant|17', 'variant', 'attribute', '17', NULL, NULL, '[]', 1, 1, '2025-07-22 14:59:59', 'admin', 1, '2025-07-22 14:59:59' )
There is no table called mshop_product_del. And the error remains even when I tried to remove this foreign key (on a test system).
What can I do to make aimeos work again?
I searched the forum and found some entries where the table type should be changed. But this did not really apply to my situation.
Claudia
I have a problem with an TYPO3 extension aimeos 19.10.12 running on Linux, TYPO3 v. 9 and PHP 7.4. (Yes, I know that this is old and needs to be updated. We are working on it - but nevertheless, the current shop needs to be running.)
I don't know when this started. The products are always updated using XML import. Now, I noticed that changing any of the attributes or the text or media results in an error like this:
Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("dedivikj_db2"."mshop_product_list", CONSTRAINT "fk_msproli_pid" FOREIGN KEY ("parentid") REFERENCES "mshop_product_del" ("id") ON DELETE CASCADE ON UPDATE CASCADE): INSERT INTO "mshop_product_list" ( "parentid", "key", "type", "domain", "refid", "start", "end", "config", "pos", "status", "mtime", "editor", "siteid", "ctime" ) VALUES ( 8, 'attribute|variant|17', 'variant', 'attribute', '17', NULL, NULL, '[]', 1, 1, '2025-07-22 14:59:59', 'admin', 1, '2025-07-22 14:59:59' )
There is no table called mshop_product_del. And the error remains even when I tried to remove this foreign key (on a test system).
What can I do to make aimeos work again?
I searched the forum and found some entries where the table type should be changed. But this did not really apply to my situation.
Claudia
Re: Integrity constraint violation fk_msproli_pid
Additional information:
* I gave it a try with a real old database, but the same software: The error doesn't occur for that one. So, it seems to be related only to the database.
* I ran already the aimeos job to rebuild the index. This didn't change anything.
* I gave it a try with a real old database, but the same software: The error doesn't occur for that one. So, it seems to be related only to the database.
* I ran already the aimeos job to rebuild the index. This didn't change anything.