Integrity constraint violation fk_msproli_pid

Questions around the TYPO3 integration and plugins
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!
cnoelker
Advanced
Posts: 142
Joined: 20 Feb 2016, 18:21

Integrity constraint violation fk_msproli_pid

Post by cnoelker » 22 Jul 2025, 13:23

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

cnoelker
Advanced
Posts: 142
Joined: 20 Feb 2016, 18:21

Re: Integrity constraint violation fk_msproli_pid

Post by cnoelker » 22 Jul 2025, 13:50

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.

Post Reply