Issue while Updating Database Schema when Upgrading from OTRS 3.3.6 to OTRS 4

Moderator: crythias

Locked
ftahoces
Znuny newbie
Posts: 22
Joined: 30 Mar 2016, 10:49
Znuny Version: 5.0.12

Issue while Updating Database Schema when Upgrading from OTRS 3.3.6 to OTRS 4

Post by ftahoces »

Hello

I have a problem when I'm updating database scripts while updating from OTRS 3.3.6 to OTRS 4
When I am into updating my MySQL Database schema, I get the following error:

[ ]# cat scripts/DBUpdate-to-4.mysql.sql | mysql -p -f -uotrs otrs
Enter password:
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.[/i][/b][/b][/i][/i]

Because it was a info message, I continued to the Database migration script step, where I get the following error:

-bash-4.1$ scripts/DBUpdate-to-4.pl
Base class package "Template::Provider" is empty.
(Perhaps you need to 'use' the module which defines that package first,
or make that module available in @INC (@INC contains: /opt/otrs/Custom /opt/otrs/Kernel/cpan-lib /opt/otrs /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .).
at /opt/otrs/Kernel/Output/Template/Provider.pm line 17
BEGIN failed--compilation aborted at /opt/otrs/Kernel/Output/Template/Provider.pm line 17.
Compilation failed in require at scripts/DBUpdate-to-4.pl line 33.
BEGIN failed--compilation aborted at scripts/DBUpdate-to-4.pl line 33.

Someone knows why I get this error?

Thanks in advance
wurzel
Znuny guru
Posts: 3273
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Issue while Updating Database Schema when Upgrading from OTRS 3.3.6 to OTRS 4

Post by wurzel »

Hi,

the database info messages should be OK. I would have continued, too.


It seems, that something is missing, but I am not 100% sure.

Do you have all Perl Modules?

what is the output of

Code: Select all

shell> /opt/otrs/bin/otrs.CheckModules.pl
Florian
OTRS 2025 SILVER (Prod)
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
Locked