osTicket (v1.11) Search probleem

sakbari

Dear Support

I have upgrade my systeem op osTicket (v1.11) now i have i probleem when i users has for example 2 open tickets see screenshot

https://screenshots.firefox.com/HWMXG4D8GjDF4M23/helpdesk.qxsystems.nl

when i clik on it

https://screenshots.firefox.com/dn0FuT5IYecdteLW/helpdesk.qxsystems.nl

i get to use all tickets to see which is open

https://screenshots.firefox.com/Fi6jryJCA466kAmF/helpdesk.qxsystems.nl

how can i slow this

ntozier

I cannot replicate this on my installation.

sakbari

when i edit Adanced Search
i miss User / email adres

see screen shot

https://screenshots.firefox.com/EKdpCZPy4Vaz5Ygd/helpdesk.qxsystems.nl

ntozier

Add other Field.

Select User / Email Address.

sakbari

Dear ntozier

I've tried but I can not save that

ntozier

Sorry don't follow you.
Save Search is on the screen shot that you provided.

sakbari

here is my screenshot

https://screenshots.firefox.com/xPCWVV3cw2WE2wiv/helpdesk.qxsystems.nl

sakbari

how can i reset all users settings to default

ntozier

In your screen shot you haven't selected email address.

Not sure what you mean.

sakbari

Dear ntozier

We heve big probleem with search options

example
we cannot search for a ticket based on e-mail

when we search on email we get a long list with all tickets

see screenshot
https://screenshots.firefox.com/hTx9FQaxETSwRF8f/helpdesk.qxsystems.nl

continue when a user has multiple tickets
https://screenshots.firefox.com/zM4NaB25Lon2y3fX/helpdesk.qxsystems.nl

when we want to see which 3 tickets we get a long list

https://screenshots.firefox.com/nwocKc8q1JJDuHB5/helpdesk.qxsystems.nl

sakbari

Dear notzier

I have check my setting we have 2 systeem in 1 systeem with probleem in all Queue we have FROM -- Settings

Primary Data Source User /Naam

see screenshot
https://screenshots.firefox.com/66OEz21Cgj1AbMN7/helpdesk.qxsystems.nl

in other systeem with no probleem we have User / Full name

sakbari

PHP Fatal error: Uncaught OrmException: Model UserCdata does not have a relation called emails in /var/www/html/include/class.orm.php:2414\nStack trace:\n#0 /var/www/html/include/class.orm.php(2432): SqlCompiler->{closure}('emails', 'UserCdata')\n#1 /var/www/html/include/class.orm.php(2568): SqlCompiler->getField('address', 'UserCdata')\n#2 /var/www/html/include/class.orm.php(2606): SqlCompiler->compileQ(Object(Q), 'Ticket', true)\n#3 /var/www/html/include/class.orm.php(2911): SqlCompiler->compileConstraints(Array, 'Ticket')\n#4 /var/www/html/include/class.orm.php(2957): MySqlCompiler->getWhereHavingClause(Object(QuerySet))\n#5 /var/www/html/include/class.orm.php(1624): MySqlCompiler->compileSelect(Object(QuerySet))\n#6 /var/www/html/include/class.orm.php(2081): QuerySet->getQuery()\n#7 /var/www/html/include/class.orm.php(1690): HashArrayIterator->getIterator()\n#8 /var/www/html/include/class.orm.php(1565): CachedResultSet->construct(Object(HashArrayIterator))\n#9 /var/www/html/include/staff/templates/queue-tickets.tmpl.php(230): in /var/www/html/include/class.orm.php on line 2414, referer: https://helpdesk.qxsystems.nl/scp/tickets.php?a=search&status=open&uid=3688
[Tue Mar 12 12:34:47.604052 2019] [:error] [pid 9345] [client 185.48.101.178:7071] PHP Fatal error: Uncaught OrmException: Model UserCdata does not have a relation called emails in /var/www/html/include/class.orm.php:2414\nStack trace:\n#0 /var/www/html/include/class.orm.php(2432): SqlCompiler->{closure}('emails', 'UserCdata')\n#1 /var/www/html/include/class.orm.php(2568): SqlCompiler->getField('address', 'UserCdata')\n#2 /var/www/html/include/class.orm.php(2606): SqlCompiler->compileQ(Object(Q), 'Ticket', true)\n#3 /var/www/html/include/class.orm.php(2911): SqlCompiler->compileConstraints(Array, 'Ticket')\n#4 /var/www/html/include/class.orm.php(2957): MySqlCompiler->getWhereHavingClause(Object(QuerySet))\n#5 /var/www/html/include/class.orm.php(1624): MySqlCompiler->compileSelect(Object(QuerySet))\n#6 /var/www/html/include/class.orm.php(2081): QuerySet->getQuery()\n#7 /var/www/html/include/class.orm.php(1690): HashArrayIterator->getIterator()\n#8 /var/www/html/include/class.orm.php(1565): CachedResultSet->construct(Object(HashArrayIterator))\n#9 /var/www/html/include/staff/templates/queue-tickets.tmpl.php(230): in /var/www/html/include/class.orm.php on line 2414, referer: https://helpdesk.qxsystems.nl/scp/tickets.php?queue=2&dir=1&sort=4
[Tue Mar 12 12:34:50.001971 2019] [:error] [pid 9812] [client 185.48.101.178:30736] PHP Fatal error: Uncaught OrmException: Model UserCdata does not have a relation called emails in /var/www/html/include/class.orm.php:2414\nStack trace:\n#0 /var/www/html/include/class.orm.php(2432): SqlCompiler->{closure}('emails', 'UserCdata')\n#1 /var/www/html/include/class.orm.php(2568): SqlCompiler->getField('address', 'UserCdata')\n#2 /var/www/html/include/class.orm.php(2606): SqlCompiler->compileQ(Object(Q), 'Ticket', true)\n#3 /var/www/html/include/class.orm.php(2911): SqlCompiler->compileConstraints(Array, 'Ticket')\n#4 /var/www/html/include/class.orm.php(2957): MySqlCompiler->getWhereHavingClause(Object(QuerySet))\n#5 /var/www/html/include/class.orm.php(1624): MySqlCompiler->compileSelect(Object(QuerySet))\n#6 /var/www/html/include/class.orm.php(2081): QuerySet->getQuery()\n#7 /var/www/html/include/class.orm.php(1690): HashArrayIterator->getIterator()\n#8 /var/www/html/include/class.orm.php(1565): CachedResultSet->construct(Object(HashArrayIterator))\n#9 /var/www/html/include/staff/templates/queue-tickets.tmpl.php(230): in /var/www/html/include/class.orm.php on line 2414, referer: https://helpdesk.qxsystems.nl/scp/tickets.php?queue=adhoc,HTXxU9CCQ8
[Tue Mar 12 12:34:51.782498 2019] [:error] [pid 9730] [client 185.48.101.178:28885] PHP Fatal error: Uncaught OrmException: Model UserCdata does not have a relation called emails in /var/www/html/include/class.orm.php:2414\nStack trace:\n#0 /var/www/html/include/class.orm.php(2432): SqlCompiler->{closure}('emails', 'UserCdata')\n#1 /var/www/html/include/class.orm.php(2568): SqlCompiler->getField('address', 'UserCdata')\n#2 /var/www/html/include/class.orm.php(2606): SqlCompiler->compileQ(Object(Q), 'Ticket', true)\n#3 /var/www/html/include/class.orm.php(2911): SqlCompiler->compileConstraints(Array, 'Ticket')\n#4 /var/www/html/include/class.orm.php(2957): MySqlCompiler->getWhereHavingClause(Object(QuerySet))\n#5 /var/www/html/include/class.orm.php(1624): MySqlCompiler->compileSelect(Object(QuerySet))\n#6 /var/www/html/include/class.orm.php(2081): QuerySet->getQuery()\n#7 /var/www/html/include/class.orm.php(1690): HashArrayIterator->getIterator()\n#8 /var/www/html/include/class.orm.php(1565): CachedResultSet->construct(Object(HashArrayIterator))\n#9 /var/www/html/include/staff/templates/queue-tickets.tmpl.php(230): in /var/www/html/include/class.orm.php on line 2414, referer: https://helpdesk.qxsystems.nl/scp/index.php

sakbari

Dear all

When i Search on mail adres or user the from is always empty

see screenshot

https://screenshots.firefox.com/gdt30Zwyp4JuiWyS/helpdesk.qxsystems.nl

ntozier

You keep talking about search... and emails.

Yet your screen shots are queues (not searches), and the problem appears to be that you are not seeing the Users NAME. Even the screen shot of the queue data source is set to users name.

This appears to be the same as this thread:
https://forum.osticket.com/d/93600-solved-from-field-username-not-showing-in-lists

sakbari

Dear ntozier

i can not select User / Full name

if you want i can make a user for you to check it

sakbari

Dear user

i have still this probleem i can not select User /Fullname we have options User /Name

sakbari

Dear user

see my screenshot i we do not have User / Full Name