Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Error 500 when creating a ticket

Please, help me with this:

After upraded to 1.10.1:

A new ticket can'nt be created, this error can be found on httpd.log

[Tue Nov 21 11:16:24.923712 2017] [:error] [pid 31397] [client 192.168.0.20:58440] 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/html/include/class.orm.php:1176\nStack trace:\n#0 /var/www/html/include/class.orm.php(545): QuerySet->one()\n#1 /var/www/html/include/class.list.php(297): VerySimpleModel::lookup(Array)\n#2 /var/www/html/include/class.list.php(384): DynamicList->getConfigurationForm(true)\n#3 /var/www/html/include/class.dynamic_forms.php(1597): DynamicList->getForm()\n#4 /var/www/html/include/class.dynamic_forms.php(534): SelectionField->hasSubFields()\n#5 /var/www/html/include/class.filter.php(308): Bootstrap::{closure}()\n#6 /var/www/html/include/class.filter.php(321): Filter::getSupportedMatches()\n#7 /var/www/html/include/class.filter.php(711): Filter::getSupportedMatchFields()\n#8 /var/www/html/include/class.ticket.php(3041): TicketFilter->__construct('staff', Array)\n#9 /var/www/html/include/class.ticket.php(3182): Ticket::filterTicketData('staff in /var/www/html/include/class.orm.php on line 1176, referer: http://192.168.0.9/scp/tickets.php?a=open&uid=2

Any idea?

Thx

Comments

  • edited November 21
    after upgrade to 1.10.1 from?

    That error is telling you that there is 2 matching objects and there should only be one.  

    (edited because I suck today)
    Take a look at your ost_form table.  Do you have more multiple entries that have the same type L# entry?  (where # is a number).
  • 1.9.16

    I will take a look on thoose tables
  • No id duplicate on OST_LIST table

    image

    On OST_FORM_FILD can't see any duplicate too, table is a litle big, lets try to put some images too:


    image

    image

    thx again
    Screen Shot 11-21-17 at 03.13 PM.PNG
    882 x 367 - 30K
    Screen Shot 11-21-17 at 03.13 PM.PNG
    882 x 367 - 30K
    Screen Shot 11-21-17 at 03.23 PM.PNG
    189 x 680 - 22K
    Screen Shot 11-21-17 at 03.23 PM 001.PNG
    189 x 680 - 22K
  • Hello!

    in ost_form i found a duplicate entry thats solved when i change the L# to another value, but the custom form not load on ticket.

    How can i proceed now?

    Thx again
Sign In or Register to comment.