Error during migration from 4.0.1 to 5.0.2

[nfplacide]

Hi All,
below the error i got during "Database migration script" : scripts/DBUpdate-to-5.pl

-----------
Step 7 of 16: Migrate notifications to event based notifications...ERROR: OTRS-DBUpdate-to-5.pl-20 Perl: 5.14.2 OS: linux Time: Fri Nov 6 19:42:23 2015

Message: Can't add notification 'Old Ticket new note notification ( Duplicate Name )', notification already exists!

Traceback (14073):
Module: Kernel::System::NotificationEvent::NotificationAdd Line: 271
Module: main::_MigrateNotifications Line: 1105
Module: scripts/DBUpdate-to-5.pl Line: 158

error.
------------

Kindly see what is wrong

[nfplacide]

And when i ran :
root@it-gel-01:/opt/otrs# cat scripts/DBUpdate-to-5.mysql.sql | mysql -p -f -u root otrs
Enter password:

Below the Error

-------
ERROR 1061 (42000) at line 4: Duplicate key name 'link_relation_list_source'
ERROR 1061 (42000) at line 5: Duplicate key name 'link_relation_list_target'
ERROR 1050 (42S01) at line 9: Table 'scheduler_task' already exists
ERROR 1050 (42S01) at line 28: Table 'scheduler_future_task' already exists
ERROR 1050 (42S01) at line 47: Table 'scheduler_recurrent_task' already exists
ERROR 1091 (42000) at line 68: Can't DROP 'text2'; check that column/key exists
ERROR 1050 (42S01) at line 72: Table 'notification_event_message' already exists
ERROR 1050 (42S01) at line 87: Table 'cloud_service_config' already exists
ERROR 1005 (HY000) at line 101: Can't create table 'otrs.#sql-ecf_2e' (errno: 121)
ERROR 1005 (HY000) at line 102: Can't create table 'otrs.#sql-ecf_2e' (errno: 121)
ERROR 1005 (HY000) at line 103: Can't create table 'otrs.#sql-ecf_2e' (errno: 121)
ERROR 1005 (HY000) at line 104: Can't create table 'otrs.#sql-ecf_2e' (errno: 121)

[crythias]

duplicate means you've already done that
can't drop because it's not there not a problem
can't create files ... check if you're not running InnoDB.

[nfplacide]

Thanks for you reply.

root@it-gel-01:/opt/otrs# mysqladmin -u root -p variables | grep have_innodb
Enter password:
| have_innodb | YES |



Yes, engine is Innodb.

[crythias]

That doesn't necessarily mean the tables are innodb.

[nfplacide]

Then how can i check it Please ?

See below the registration info of my server :

otrs%20host%202.PNG

Regards,

[nfplacide]

After fixing the PB with the DB :
My dashboard is empty (but the tickets appear in Tickets meu). And below are the error :

----------
Module Kernel/Output/HTML/DashboardEventsTicketCalendar.pm not in @INC (/opt/otrs/Custom /opt/otrs/Kernel/cpan-lib /opt/otrs/ /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . /etc/apache2)

Mon Nov 9 20:20:34 2015 error OTRS-CGI-20 Module Kernel/Output/HTML/DashboardTicketGeneric.pm not in @INC (/opt/otrs/Custom /opt/otrs/Kernel/cpan-lib /opt/otrs/ /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . /etc/apache2)

Mon Nov 9 20:20:34 2015 error OTRS-CGI-20 Module Kernel/Output/HTML/DashboardTicketGeneric.pm not in @INC (/opt/otrs/Custom /opt/otrs/Kernel/cpan-lib /opt/otrs/ /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . /etc/apache2)

Mon Nov 9 20:20:34 2015 error OTRS-CGI-20 Module Kernel/Output/HTML/DashboardTicketQueueOverview.pm not in @INC (/opt/otrs/Custom /opt/otrs/Kernel/cpan-lib /opt/otrs/ /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . /etc/apache2)

Mon Nov 9 20:20:34 2015 error OTRS-CGI-20 Module Kernel/Output/HTML/DashboardCalendar.pm not in @INC (/opt/otrs/Custom /opt/otrs/Kernel/cpan-lib /opt/otrs/ /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . /etc/apache2)

Mon Nov 9 20:20:34 2015 error OTRS-CGI-20 Module Kernel/Output/HTML/DashboardTicketStatsGeneric.pm not in @INC (/opt/otrs/Custom /opt/otrs/Kernel/cpan-lib /opt/otrs/ /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . /etc/apache2)

Mon Nov 9 20:20:12 2015 error OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-20 There was an error executing Execute() in Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch: ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-20 Perl: 5.14.2 OS: linux Time: Mon Nov 9 20:20:12 2015

[crythias]

Items registered but don't exist. Maybe rebuild config or check SysConfig.