Upgrade 5 to 6 Issue: Cannot add or update a child row

Moderator: crythias

Post Reply
cbg
Znuny expert
Posts: 169
Joined: 25 Jun 2016, 23:29
Znuny Version: 5.0.9

Upgrade 5 to 6 Issue: Cannot add or update a child row

Post by cbg »

Hi guys,

I ran into this issue, while using the update script in otrs 6:
Cannot add or update a child row: a foreign key constraint fails (`otrs`.`article`, CONSTRAINT `FK_article_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)) at /opt/otrs/Kernel/System/DB.pm line 470.

As far as I have understood, the script may not add or update a child row in the table articles.

Is this solveable?


Thanks for your suggestions...
Cheers,

cbg
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Upgrade 5 to 6 Issue: Cannot add or update a child row

Post by jojo »

it seems that you manually deleted users (agents) from the database
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Post Reply