trying to Update otrs 5.0.42 to znuny 6.0.48 on Debian. (test machine).
Problem
Code: Select all
su - otrs
otrs@test-klon:~$ bin/otrs.Console.pl Admin::Package::List
Listing all installed packages...
+----------------------------------------------------------------------------+
| Name: OTRSAppointmentCalendar
| Version: 5.0.2
| Vendor: xxx
| URL: http://otrs.org/
| License: GNU AFFERO GENERAL PUBLIC LICENSE Version 3, November 2007
| Description: The Appointment Calendar package.
+----------------------------------------------------------------------------+
Done.
otrs@test-klon:~$ bin/otrs.Console.pl Admin::Package::Uninstall OTRSAppointmentCalendar
Uninstalling package...
+----------------------------------------------------------------------------+
| OTRSAppointmentCalendar-5.0.2
| Uninstallation Information
| ATTENTION
| If you uninstall this package, all database tables that were created during
| installation will be deleted. All data from this table will be irrevocably
| lost.
| ((enjoy))
+----------------------------------------------------------------------------+
Code:
$Kernel::OM->Get('var::packagesetup::OTRSAppointmentCalendar')->CodeUninstall();
Notice: DROP TABLE IF EXISTS calendar_appointment_ticket
Notice: DROP TABLE IF EXISTS calendar_appointment
Notice: DROP TABLE IF EXISTS calendar
Notice: Removed file: /opt/otrs/Kernel/Config/Files/OTRSAppointmentCalendar.xml
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Class/ReturnValue.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Class/Accessor.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Class/Accessor/Chained.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Class/Accessor/Fast.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Class/Accessor/Chained/Fast.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Property.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/FreeBusy.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/TimeZone.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Event.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Journal.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Todo.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Alarm.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/TimeZone/Standard.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/TimeZone/Daylight.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Alarm/Procedure.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Alarm/None.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Alarm/Display.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Alarm/URI.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Alarm/Email.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Data/ICal/Entry/Alarm/Audio.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Date/ICal.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Date/Leapyear.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Date/ICal/Duration.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Devel/StackTrace.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Devel/StackTrace/Frame.pm
Notice: Removed file: /opt/otrs/Kernel/cpan-lib/Text/vFile/asData.pm
Notice: Removed file: /opt/otrs/Kernel/Language/de_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Language/es_CO_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Language/es_MX_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Language/es_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Language/hu_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Language/pt_BR_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Language/ru_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Language/sr_Cyrl_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Language/sr_Latn_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Language/zh_CN_OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Modules/AgentAppointmentAgendaOverview.pm
Notice: Removed file: /opt/otrs/Kernel/Modules/AdminAppointmentNotificationEvent.pm
Notice: Removed file: /opt/otrs/Kernel/Modules/AgentAppointmentCalendarManage.pm
Notice: Removed file: /opt/otrs/Kernel/Modules/AgentAppointmentCalendarOverview.pm
Notice: Removed file: /opt/otrs/Kernel/Modules/AgentAppointmentEdit.pm
Notice: Removed file: /opt/otrs/Kernel/Modules/AgentAppointmentImport.pm
Notice: Removed file: /opt/otrs/Kernel/Modules/AgentAppointmentList.pm
Notice: Removed file: /opt/otrs/Kernel/Modules/AgentAppointmentPluginSearch.pm
Notice: Removed file: /opt/otrs/Kernel/Modules/PublicCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/LinkObject/Appointment.pm
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Preferences/AppointmentNotificationEvent.pm
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/AAANotification.tt
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/AdminAppointmentNotificationEventTransportEmailSettings.tt
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/AdminAppointmentNotificationEvent.tt
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/AgentAppointmentAgendaOverview.tt
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/AgentAppointmentImport.tt
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/AgentAppointmentCalendarManage.tt
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/AgentAppointmentCalendarOverview.tt
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/AgentAppointmentEdit.tt
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/PublicCalendar.tt
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Dashboard/AppointmentCalendar.pm
Notice: Removed file: /opt/otrs/Kernel/Output/HTML/Templates/Standard/AgentDashboardAppointmentCalendar.tt
Notice: Removed file: /opt/otrs/Kernel/System/Calendar.pm
Notice: Removed file: /opt/otrs/Kernel/System/CalendarTemplateGenerator.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Event/Transport/Email.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Event/Transport/Base.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Appointment.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Helper.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Plugin.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Plugin/Ticket.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Event/Notification.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Event/TicketAppointments.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Export/ICal.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Import/ICal.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Ticket/DynamicField.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Ticket/EscalationTime.pm
Notice: Removed file: /opt/otrs/Kernel/System/Calendar/Ticket/PendingTime.pm
Notice: Removed file: /opt/otrs/Kernel/System/Daemon/DaemonModules/SchedulerTaskWorker/CalendarAppointment.pm
Notice: Removed file: /opt/otrs/Kernel/System/LinkObject/Appointment.pm
Notice: Removed file: /opt/otrs/Kernel/System/Ticket/Event/TicketAppointments.pm
Notice: Removed file: /opt/otrs/scripts/test/Calendar/Event/Transport/Email.t
Notice: Removed file: /opt/otrs/scripts/test/Calendar.t
Notice: Removed file: /opt/otrs/scripts/test/Calendar/Appointment.t
Notice: Removed file: /opt/otrs/scripts/test/Calendar/Helper.t
Notice: Removed file: /opt/otrs/scripts/test/Calendar/Plugin.t
Notice: Removed file: /opt/otrs/scripts/test/Calendar/TicketAppointments.t
Notice: Removed file: /opt/otrs/scripts/test/Calendar/Export/ICal.t
Notice: Removed file: /opt/otrs/scripts/test/Calendar/Import/ICal.t
Notice: Removed file: /opt/otrs/scripts/test/Selenium/Agent/Admin/AdminAppointmentNotificationEvent.t
Notice: Removed file: /opt/otrs/scripts/test/Selenium/Agent/AgentAppointmentAgendaOverview.t
Notice: Removed file: /opt/otrs/scripts/test/Selenium/Agent/AgentAppointmentCalendarManage.t
Notice: Removed file: /opt/otrs/scripts/test/Selenium/Agent/AgentAppointmentCalendarOverview.t
Notice: Removed file: /opt/otrs/scripts/test/Selenium/Agent/AgentAppointmentCreate.t
Notice: Removed file: /opt/otrs/scripts/test/Selenium/Agent/AgentAppointmentDashboardWidget.t
Notice: Removed file: /opt/otrs/scripts/test/Selenium/Agent/AgentAppointmentNotification.t
Notice: Removed file: /opt/otrs/scripts/test/Selenium/Agent/AgentAppointmentTimeZone.t
Notice: Removed file: /opt/otrs/scripts/test/sample/Calendar/SampleCalendar.ics
Notice: Removed file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/thirdparty/fullcalendar-3.0.1/fullcalendar.css
Notice: Removed file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/thirdparty/fullcalendar-3.0.1/fullcalendar.min.css
Notice: Removed file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/thirdparty/fullcalendar-scheduler-1.4.0/scheduler.css
Notice: Removed file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/thirdparty/fullcalendar-scheduler-1.4.0/scheduler.min.css
Notice: Removed file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/thirdparty/spectrum-1.8.0/spectrum.css
Notice: Removed file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/Core.AppointmentCalendar.css
Notice: Removed file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/Core.AppointmentCalendar.Agenda.css
Notice: Removed file: /opt/otrs/var/httpd/htdocs/skins/Agent/default/css/Core.AppointmentCalendar.Manage.css
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/thirdparty/fullcalendar-3.0.1/fullcalendar.js
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/thirdparty/fullcalendar-3.0.1/fullcalendar.min.js
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/thirdparty/fullcalendar-scheduler-1.4.0/scheduler.js
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/thirdparty/fullcalendar-scheduler-1.4.0/scheduler.min.js
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/thirdparty/momentjs-2.13.0/moment.min.js
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/thirdparty/clipboard.js-1.5.12/clipboard.js
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/thirdparty/clipboard.js-1.5.12/clipboard.min.js
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/thirdparty/spectrum-1.8.0/spectrum.js
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/Core.Agent.AppointmentCalendar.js
Notice: Removed file: /opt/otrs/var/httpd/htdocs/js/Core.Agent.AppointmentCalendar.Manage.js
Notice: Removed file: /opt/otrs/var/packagesetup/OTRSAppointmentCalendar.pm
Notice: Removed file: /opt/otrs/doc/en/OTRSAppointmentCalendar.pdf
Done.
Code: Select all
su - otrs
otrs@test-klon:~$ scripts/DBUpdate-to-6.pl
Migration started ...
Checking requirements ...
Requirement check for: Check framework version ...
Requirement check for: Check required Perl version ...
Requirement check for: Check required database version ...
Requirement check for: Check database charset ...
Requirement check for: Check required Perl modules ...
Requirement check for: Check if database has been backed up ...
Did you backup the database? [Y]es/[N]o: Y
Requirement check for: Migrate PostMaster pre-filters that execute system commands ...
Requirement check for: Migrate dashboard widgets that execute system commands ...
Requirement check for: Upgrade database structure ...
Requirement check for: Migrating time zone configuration ...
The currently configured time offset is 2 hours, these are the suggestions for a corresponding OTRS time zone:
Africa/Ceuta
Africa/Johannesburg
Africa/Juba
Africa/Khartoum
Africa/Maputo
Africa/Tripoli
Africa/Windhoek
Antarctica/Troll
CET
Europe/Andorra
Europe/Belgrade
Europe/Berlin
Europe/Brussels
Europe/Budapest
Europe/Gibraltar
Europe/Kaliningrad
Europe/Madrid
Europe/Malta
Europe/Paris
Europe/Prague
Europe/Rome
Europe/Tirane
Europe/Vienna
Europe/Warsaw
Europe/Zurich
MET
It seems that Europe/Berlin should be the correct time zone to set for your OTRS.
Enter the time zone to use for OTRSTimeZone (leave empty to show a list of all available time zones): Europe/Berlin
Enter the time zone to use for UserDefaultTimeZone (leave empty to show a list of all available time zones): Europe/Berlin
Requirement check for: Update calendar appointment future tasks ...
Requirement check for: Migrate GenericAgent jobs configuration ...
Requirement check for: Migrate TicketAppointment rules configuration ...
Requirement check for: Create entries in new article table ...
Requirement check for: Migrate ArticleType in ProcessManagement Data ...
Requirement check for: Migrate ArticleType in PostMaster filters ...
Requirement check for: Remove Generic Agent system commands ...
Executing tasks ...
Step 1 of 49: Check framework version ...
Step 2 of 49: Check required Perl version ...
Step 3 of 49: Check required database version ...
Step 4 of 49: Check database charset ...
Step 5 of 49: Check required Perl modules ...
Step 6 of 49: Check installed CPAN modules for known vulnerabilities ...
Step 7 of 49: Check if database has been backed up ...
Step 8 of 49: Migrate PostMaster pre-filters that execute system commands ...
Step 9 of 49: Migrate dashboard widgets that execute system commands ...
Step 10 of 49: Upgrade database structure ...
Step 11 of 49: Migrate configuration ...
Step 12 of 49: Refresh configuration cache after migration of OTRS 5 settings ...
Step 13 of 49: Migrating ticket storage configuration ...
Step 14 of 49: Migrating article search index configuration ...
Step 15 of 49: Migrating ticket zoom customer information widget configuration ...
Step 16 of 49: Drop deprecated table gi_object_lock_state ...
Step 17 of 49: Migrate PossibleNextActions setting ...
Step 18 of 49: Migrate ZoomExpand setting ...
Step 19 of 49: Migrating time zone configuration ...
Step 20 of 49: Migrating modified settings ...
Step 21 of 49: Create appointment calendar tables ...
Step 22 of 49: Create ticket number counter tables ...
Step 23 of 49: Update calendar appointment future tasks ...
Step 24 of 49: Add basic appointment notification for reminders ...
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.32.1 OS: linux Time: Thu Oct 19 14:08:03 2023
Message: A notification with the name 'Appointment reminder notification' already exists.
Traceback (1315):
Module: Kernel::System::NotificationEvent::NotificationAdd Line: 311
Module: scripts::DBUpdateTo6::AddAppointmentCalendarNotification::Run Line: 169
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 156
Module: scripts::DBUpdateTo6::Run Line: 68
Module: scripts/DBUpdate-to-6.pl Line: 88
Not possible to complete migration, check previous messages for more information.