Hi!
I am updating from v3.3.14 to 4.0.11 running on CentOS 6.7.
While trying to update the database schema using "cat scripts/DBUpdate-to-4.mysql.sql | mysql -p -f -u root otrs", I encountered below errors:
INFO: Foreign key constraint FK_ticket_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_history_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_ticket_history_valid_id_id does not exist, skipping.
What do these errors mean? Please help how to fix this.
Thanks!
Error on updating to 4.0.11
Moderator: crythias
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Error on updating to 4.0.11
It means what it says. And it's more of an index issue.
Also, it's INFO, not WARNING or ERROR.
Summary: it is trying to drop (delete) indexes that don't exist. This is not inherently a problem as the goal is that they are gone anyway.
Also, it's INFO, not WARNING or ERROR.
Summary: it is trying to drop (delete) indexes that don't exist. This is not inherently a problem as the goal is that they are gone anyway.
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
-
philiutr
- Znuny newbie
- Posts: 10
- Joined: 09 Sep 2015, 08:15
- Znuny Version: 3.3.14
- Real Name: Phil
- Company: EWS
<SOLVED> Re: Error on updating to 4.0.11
Noted, am now testing the upgraded environment and everything seems to work. Thanks!