I tried to upgrade Osticket from 1.12 to 15.7, i followed all steps in this docs link but the upgrade failed.
The PHP Error
PHP Fatal error: Uncaught Error: Call to a member function set() on null in /public_html/include/class.schedule.php:370
Stack trace:
#0 /include/upgrader/streams/core/00c949a6-8b923d61.task.php(9): Schedule::create(Array)
#1 /include/class.upgrader.php(348): ScheduleCreator->run(30)
#2 /include/class.upgrader.php(121): StreamUpgrader->doTask()
#3 /include/ajax.upgrader.php(35): Upgrader->call('doTask', Array)
#4 /include/class.dispatcher.php(145): UpgraderAjaxAPI->upgrade()
#5 /include/class.dispatcher.php(38): UrlMatcher->dispatch('/upgrader', NULL)
#6 /scp/ajax.php(316): Dispatcher->resolve('/upgrader')
#7 {main}
thrown in /include/class.schedule.php on line 370
The database size is big about 50G
In Osticket error log, i found
DB Error #1062
[INSERT INTO ost_scheduleSETid= 1,flags= 1,name= 'Monday - Friday 8am - 5pm with U.S. Holidays',created= NOW(),updated= NOW()] Duplicate entry '1' for key 'PRIMARY'<br /> <br /> ---- Trace ----<br /> #0 (racine)/include/mysqli.php(201): osTicket->logDBError('DB Error #1062', '[INSERT INTOo...')
#1 (racine)/include/class.orm.php(3466): db_query('INSERT INTO os...', true, true)<br /> #2 (racine)/include/class.orm.php(658): MySqlExecutor->execute()<br /> #3 (racine)/include/class.schedule.php(319): VerySimpleModel->save(false)<br /> #4 (racine)/include/class.schedule.php(364): Schedule->save()<br /> #5 (racine)/include/class.schedule.php(369): Schedule::create(Array)<br /> #6 (racine)/include/upgrader/streams/core/00c949a6-8b923d61.task.php(9): Schedule::create(Array)<br /> #7 (racine)/include/class.upgrader.php(348): ScheduleCreator->run(30)<br /> #8 (racine)/include/class.upgrader.php(121): StreamUpgrader->doTask()<br /> #9 (racine)/include/ajax.upgrader.php(35): Upgrader->call('doTask', Array)<br /> #10 (racine)/include/class.dispatcher.php(145): UpgraderAjaxAPI->upgrade()<br /> #11 (racine)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/upgrader', NULL)<br /> #12 (racine)/scp/ajax.php(316): Dispatcher->resolve('/upgrader')<br /> #13 {main}
OS: Centos 7.9
WHM/Cpanel v102.0.15
Firefox 99.0 (64-bit)
MySQL: 5.7
PHP: 7.2
Apache: 2.4.53
I noticed that cron job was working.
Thanks