Hi, after upgrade osTicket 1.9 to 1.14 r2 I have problem with just one user. I can find that user in search Users but when I click on that account I have error 500.
PHP log file looks like this:
`[16-Jun-2020 07:36:08 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /var/www/html/ticket/include/class.orm.php:1363
Stack trace:
#0 /var/www/html/ticket/include/class.orm.php(606): QuerySet->one()
#1 /var/www/html/ticket/scp/users.php(23): VerySimpleModel::lookup(Array)
#2 {main}
thrown in /var/www/html/ticket/include/class.orm.php on line 1363
[16-Jun-2020 07:36:16 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /var/www/html/ticket/include/class.orm.php:1363
Stack trace:
#0 /var/www/html/ticket/include/class.orm.php(606): QuerySet->one()
#1 /var/www/html/ticket/include/ajax.users.php(124): VerySimpleModel::lookup(Array)
#2 /var/www/html/ticket/include/class.dispatcher.php(145): UsersAjaxAPI->preview('604')
#3 /var/www/html/ticket/include/class.dispatcher.php(38): UrlMatcher->dispatch('/604/preview', Array)
#4 /var/www/html/ticket/include/class.dispatcher.php(120): Dispatcher->resolve('/604/preview', Array)
#5 /var/www/html/ticket/include/class.dispatcher.php(38): UrlMatcher->dispatch('/users/604/prev...', NULL)
#6 /var/www/html/ticket/scp/ajax.php(311): Dispatcher->resolve('/users/604/prev...')
#7 {main}
thrown in /var/www/html/ticket/include/class.orm.php on line 1363
[16-Jun-2020 07:36:55 UTC] PHP Warning: session_regenerate_id(): Cannot regenerate session id - session is not active in /var/www/html/ticket/open.php on line 49
[16-Jun-2020 07:38:58 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /var/www/html/ticket/include/class.orm.php:1363
Stack trace:
#0 /var/www/html/ticket/include/class.orm.php(606): QuerySet->one()
#1 /var/www/html/ticket/scp/users.php(23): VerySimpleModel::lookup(Array)
#2 {main}
thrown in /var/www/html/ticket/include/class.orm.php on line 1363
[16-Jun-2020 07:38:58 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /var/www/html/ticket/include/class.orm.php:1363
Stack trace:
#0 /var/www/html/ticket/include/class.orm.php(606): QuerySet->one()
#1 /var/www/html/ticket/scp/users.php(23): VerySimpleModel::lookup(Array)
#2 {main}
thrown in /var/www/html/ticket/include/class.orm.php on line 1363
[16-Jun-2020 07:39:06 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /var/www/html/ticket/include/class.orm.php:1363
Stack trace:
#0 /var/www/html/ticket/include/class.orm.php(606): QuerySet->one()
#1 /var/www/html/ticket/include/class.search.php(534): VerySimpleModel::lookup(Array)
#2 /var/www/html/ticket/include/class.signal.php(98): MysqlSearchBackend->IndexOldStuff(NULL, Array)
#3 /var/www/html/ticket/scp/autocron.php(66): Signal::send('cron', NULL, Array)
#4 {main}
thrown in /var/www/html/ticket/include/class.orm.php on line 1363
[16-Jun-2020 07:39:14 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /var/www/html/ticket/include/class.orm.php:1363
Stack trace:
#0 /var/www/html/ticket/include/class.orm.php(606): QuerySet->one()
#1 /var/www/html/ticket/scp/users.php(23): VerySimpleModel::lookup(Array)
#2 {main}
thrown in /var/www/html/ticket/include/class.orm.php on line 1363
[16-Jun-2020 07:57:50 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /var/www/html/ticket/include/class.orm.php:1363
Stack trace:
#0 /var/www/html/ticket/include/class.orm.php(606): QuerySet->one()
#1 /var/www/html/ticket/include/class.search.php(534): VerySimpleModel::lookup(Array)
#2 /var/www/html/ticket/include/class.signal.php(98): MysqlSearchBackend->IndexOldStuff(NULL, Array)
#3 /var/www/html/ticket/scp/autocron.php(66): Signal::send('cron', NULL, Array)
#4 {main}
thrown in /var/www/html/ticket/include/class.orm.php on line 1363
[16-Jun-2020 07:57:51 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /var/www/html/ticket/include/class.orm.php:1363
Stack trace:
#0 /var/www/html/ticket/include/class.orm.php(606): QuerySet->one()
#1 /var/www/html/ticket/scp/users.php(23): VerySimpleModel::lookup(Array)
#2 {main}
thrown in /var/www/html/ticket/include/class.orm.php on line 1363
[16-Jun-2020 07:57:51 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /var/www/html/ticket/include/class.orm.php:1363
Stack trace:
#0 /var/www/html/ticket/include/class.orm.php(606): QuerySet->one()
#1 /var/www/html/ticket/scp/users.php(23): VerySimpleModel::lookup(Array)
#2 {main}
thrown in /var/www/html/ticket/include/class.orm.php on line 1363`
I need help with this.
