Hello,
When i try to add a response Template, this error message is showing up:
Cannot add or update a child row: a foreign key constraint fails (`ctg-otrs`.`standard_template`, CONSTRAINT `FK_standard_template_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)), SQL: ' INSERT INTO standard_template (name, valid_id, comments, text, content_type, create_time, create_by, change_time, change_by, template_type) VALUES (?, ?, ?, ?, ?, '2014-06-06 09:48:33' , ?, '2014-06-06 09:48:33' , ?, ?)'
any ideas ?
foreign key constraint fail
Moderator: crythias
foreign key constraint fail
OTRS 4!
-
crythias
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: foreign key constraint fail
It sounds like your upgrade wasn't successful.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: foreign key constraint fail
indeed,
i corrected the error, and it came from the standard_template tables, which work better (for my system) Under MyISAM .... thank you anyhow!
i corrected the error, and it came from the standard_template tables, which work better (for my system) Under MyISAM .... thank you anyhow!
OTRS 4!