Error searching users

farleyfernando

I inform the user, but it is not returning an error 500.. follow

ntozier

Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.

Environment details? (see Admin panel -> Dashboard -> Information)

farleyfernando

ntozier

This response does not provide the requested information.

farleyfernando

KevinTheJedi

@farleyfernando

You will need to click the request in the network tab after it fails to see what it's returning. If you don't see anything there then you will need to consult all related error logs (general server logs, Apache error logs, PHP error logs, MySQL error logs, etc.) for related errors.

Cheers.

ganapathi

Even i faced the same problem once upgraded to 1.15.3.1.

Its due to phone field removed from user__cdata table but user search using phone field , due to that DBError throws as unknown field of phone.
And also some area seen that note field also throws the same error.

ntozier

ganapathi Its due to phone field removed from user__cdata table but user search using phone field , due to that DBError throws as unknown field of phone.

This is not correct. Removing data from a temp table could break things, but most people will not go in and change the structure/schema of the table.

This could be from the removal of the phone number field from the Admin panel -> Manage -> Forms -> Contact Information. Note the variable for Phone Number should be phone.

techn0gichida

Unknown column 'A5.phone' in 'where clause' is the error I get with this latest version 1.15.3.1. I looked at the Forms->Contact Information and the phone variable is there.

ntozier

techn0gichida Unknown column 'A5.phone' in 'where clause'

This is only a partial error and we would need the rest of it to get an idea of what is going on.

techn0gichida

[SELECT A1.id, A1.name, A6.address FROM ost_user A1 LEFT JOIN ost_user_email A2 ON (A1.id = A2.user_id) LEFT JOIN ost_organization A3 ON (A1.org_id = A3.id) LEFT JOIN ost_user_account A4 ON (A1.id = A4.user_id) LEFT JOIN ost_user__cdata A5 ON (A1.id = A5.user_id) LEFT JOIN ost_user_email A6 ON (A1.default_email_id = A6.id) WHERE (A2.address LIKE '%Kev%' OR A1.name LIKE '%Kev%' OR A3.name LIKE '%Kev%' OR A4.username LIKE '%Kev%' OR A5.phone LIKE '%Kev%') LIMIT 25]

Unknown column 'A5.phone' in 'where clause' 
 
---- Backtrace ---- 
#0 (root)/include/mysqli.php(201): osTicket->logDBError() 
#1 (root)/include/class.orm.php(3466): db_query() 
#2 (root)/include/class.orm.php(3522): MySqlExecutor->execute() 
#3 (root)/include/class.orm.php(2070): MySqlExecutor->getRow() 
#4 (root)/include/class.orm.php(2043): FlatArrayIterator->{closure}() 
#5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next() 
#6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind() 
#7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid() 
#8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo() 
#9 (root)/include/class.orm.php(1729): CachedResultSet->asArray() 
#10 (root)/include/ajax.users.php(98): CachedResultSet->getIterator() 
#11 (root)/include/class.dispatcher.php(145): UsersAjaxAPI->search() 
#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch() 
#13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve() 
#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch() 
#15 (root)/scp/ajax.php(316): Dispatcher->resolve() 
#16 {main}

ntozier

I'd drop the ost_user__cdata table and then search for a user and see if it fixes itself.

ganapathi

Great. It's works for me too. I didn't expected it should create automatically even with data. I have no idea how data got filled-up from where too. May i know if there any other table and data would automatically created like this.

ntozier

all the cdata tables are generated automatically by the system.

TechBytes

Hi Guys, We had this issue this morning with our fresh install. The simplest solution it to do the following:

1) Navigate to "Admin panel -> Manage -> Forms
2) Select "contact information" from the list to edit.
3) Find the "Phone Number" field, and change the "type" from the default "phone" to "short answer", as well ensuring that the "variable" Field reads "phone" like suggested previously. The solution is simply the "short answer" type.
4) Follow techbytes.ca on Instagram and give us a like 🙂

KevinTheJedi

@TechBytes

While that may work you will lose the perks of the Phone Number field type. The suggested solution can be found here:

https://github.com/osTicket/osTicket/issues/6043#issuecomment-1004396603

Cheers.