Hi,
I've been trying for a few days now to update an old osticket from version 1.9.16 to 1.10
when I update I get "something went wrong" but then it finishes updating.
From the administration panel, system logs no errors appear.

But the ticket page is no longer visible and I get the following error in the php logs.

[Tue Jan 23 15:01:32.634222 2024] [proxy_fcgi:error] [pid 319530:tid 139977732052544] [remote] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught exception 'ObjectNotUnique' with message 'One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects.' in /var/www/clients/client9/web58/web/include/class.orm.php:1176\nStack trace:\n#0 /var/www/clients/client9/web58/web/include/class.dynamic_forms.php(482): QuerySet->one()\n#1 /var/www/clients/client9/web58/web/include/class.dynamic_forms.php(477): TicketForm::getNewInstance()\n#2 /var/www/clients/client9/web58/web/include/class.dynamic_forms.php(381): TicketForm::getInstance()\n#3 /var/www/clients/client9/web58/web/include/class.dynamic_forms.php(368): DynamicForm::getDynamicDataViewFields(Array)\n#4 /var/www/clients/client9/web58/web/include/class.dynamic_forms.php(291): DynamicForm::getCrossTabQuery('T', 'ticket_id')\n#5 /var/www/clients/client9/web58/web/include/class.dynamic_forms.php(285): DynamicForm::buildDynamicDataView(Array)\n#6 /var/www/clients/client9/web58/web/include/staff/tickets.inc.php(8): Dy...\n',

The database is quite large with more than 40 gigabytes of attachments and many tickets.
Below is a screenshot of system information.

Thanks for any help

furthermore in admin->tickets the "autoresponder" and "alerts and Notice" tabs are not clickable
and at the bottom of the page something seems to be missing in Ticket Attachment Settings.

in fact I cannot save changes to this page.
also php gives this error 🇦
AH01071: Got error 'PHP message: PHP Fatal error: Uncaught exception 'ObjectNotUnique' with message 'One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects.' in /var/www/clients/client9/web58/web/include/class.orm.php:1176\nStack trace:\n#0 /var/www/clients/client9/web58/web/include/staff/settings-tickets.inc.php(217): QuerySet->one()\n#1 /var/www/clients/client9/web58/web/scp/settings.php(57): include_once('/var/www/client...')\n#2 {main}\n thrown in /var/www/clients/client9/web58/web/include/class.orm.php on line 1176\n'

    sertecsrl

    I would simply restore from backup and redo the upgrade. You have many duplicate records in your db that shouldn't be there.

    Cheers.

      I would also recommend restoring and starting over.
      I am also curious why you are going from such and old version to such an old version.
      Support for 1.10.x ended in 2019.

      I have 3 systems with OS tickets, two of them migrated to 1.18 without problems, this one always gave an error. that's why I migrated to 10 because that's where the problem arises and so i can have a clear view on logs.
      However I found the problem, in the ost_form table by eliminating the last value the update occurs correctly:

      (1, 'U', 1, 'Contact Information', NULL, NULL, '2014-07-03 09:32:56', '2014-07-03 09:32:56'),
      (2, 'T', 1, 'Ticket Details', 'Please Describe Your Issue', 'This form will be attached to every ticket, regardless of its source. You can add any fields to this form and they will be available to all tickets, and will be searchable with advanced search and filterable.', '2014-07-03 09:32:56', '2015-02-27 14:01:42'),
      (3, 'C', 1, 'Company Information', 'Details available in email templates', NULL, '2014-07-03 09:32:56', '2014-07-03 09:32:56'),
      (4, 'O', 1, 'Organization Information', 'Details on user organization', NULL, '2014-07-03 09:32:56', '2014-07-03 09:32:56'),
      (5, 'L1', 1, 'Ticket Status Properties', 'Properties that can be set on a ticket status.', NULL, '2015-02-26 17:55:49', '2015-02-26 17:55:49'),
      (6, 'T', 1, 'Dettagli Ticket', 'Prego, descriva il suo problema', 'form per i ticket in italiano', '2015-03-04 15:47:49', '2015-03-05 17:55:06');

      Now i will proceed to 1.18

      Glad to hear that you resolved this, but I'm not that clear on what it is that you did to fix the issue.

      Write a Reply...