Hi,

I have seen a few threads about AD etc however we have no plugins installed, we are running standard OS Ticket.
When I try to search for a user it doesn't show anyone, both when creating a ticket & when searching the user directory.

could you please adivse



      dlfitzer

      Sounds like a cdata issue or something similar. Please check all your logs for any related errors.

      Cheers.

          KevinTheJedi Hi Kevin,

          Below is a recent log.

          DB Error #1054
          [SELECT COUNT(*) FROM (SELECT A1.id FROM ostn7_user A1 LEFT JOIN ostn7_user_email A2 ON (A1.id = A2.user_id) LEFT JOIN ostn7_organization A3 ON (A1.org_id = A3.id) LEFT JOIN ostn7_user__cdata A4 ON (A1.id = A4.user_id) WHERE (A2.address LIKE '%ryan%' OR A1.name LIKE '%ryan%' OR A3.name LIKE '%ryan%' OR A4.phone LIKE '%ryan%')) __] Unknown column 'A4.phone' in 'where clause'

          ---- Backtrace ----
          #0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(...')
          #1 (root)/include/class.orm.php(3466): db_query('SELECT COUNT(          )...', true, true)
          #2 (root)/include/class.orm.php(3522): MySqlExecutor->execute()
          #3 (root)/include/class.orm.php(2952): MySqlExecutor->getRow()
          #4 (root)/include/class.orm.php(1380): MySqlCompiler->compileCount(Object(QuerySet))
          #5 (root)/include/staff/users.inc.php(47): QuerySet->count()
          #6 (root)/scp/users.php(212): require('/home/superchan...')
          #7 {main}

          We are receiving alot of these every time we do something with a ticket.

          Kind regards,

              Write a Reply...