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
Upgrade 5 to 6 Issue: Cannot add or update a child row
Moderator: crythias
Re: Upgrade 5 to 6 Issue: Cannot add or update a child row
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com