Data for custom column field disapears after adding a user Criteria

iamzoli

Hello,
I've created a Custom Queue "TestQue" with a column that is part of a User field.

And it works the column is populated

The Problem is that as soon i added in Criteria another user field to filter by, the data is filtered but columns custom data is empty
it seems that the problem appears only if i filter after custom fields doesnt matter witch one.

Thank you for your help

KevinTheJedi

iamzoli

We have a patch for this coming next release. You should always search GitHub for a patch before posting:

https://github.com/osTicket/osTicket/pull/6583

Cheers.

iamzoli

Hello Kevin,
thank you for your response we applied the fix but sadly had no effect.
I'll had to undo it because it was generating DBErrors #1064.

DB Error #1064

[SELECT A1.topic_id FROM ost_help_topic A1 WHERE A1.topic = 'Suport / Sesizare TOP eroare in functionare' AND A1.topic_pid = ORDER BY A1.topic ASC LIMIT 1] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY A1.topic ASC LIMIT 1' at line 1 ---- Backtrace ---- #0 C:\inetpub\wwwroot\osticket\include\mysqli.php(211): osTicket->logDBError() #1 C:\inetpub\wwwroot\osticket\include\class.orm.php(3482): db_query() #2 C:\inetpub\wwwroot\osticket\include\class.orm.php(3538): MySqlExecutor->execute() #3 C:\inetpub\wwwroot\osticket\include\class.orm.php(2081): MySqlExecutor->getRow() #4 C:\inetpub\wwwroot\osticket\include\class.orm.php(2054): FlatArrayIterator->{closure}() #5 C:\inetpub\wwwroot\osticket\include\class.orm.php(2033): CallbackSimpleIterator->next() #6 C:\inetpub\wwwroot\osticket\include\class.orm.php(2042): CallbackSimpleIterator->rewind() #7 C:\inetpub\wwwroot\osticket\include\class.orm.php(1713): CallbackSimpleIterator->valid() #8 C:\inetpub\wwwroot\osticket\include\class.orm.php(1723): CachedResultSet->fillTo() #9 C:\inetpub\wwwroot\osticket\include\class.orm.php(1337): CachedResultSet->asArray() #10 C:\inetpub\wwwroot\osticket\include\class.orm.php(1341): QuerySet->all() #11 C:\inetpub\wwwroot\osticket\include\class.topic.php(419): QuerySet->first() #12 C:\inetpub\wwwroot\osticket\include\class.topic.php(437): Topic::getIdByName() #13 C:\inetpub\wwwroot\osticket\scp\helptopics.php(41): Topic->update() #14 {main}

We got a lot of sql errors with different syntax's

Ill just post some more info maybe something catches your eyes.
Actualy we are using mariadb
osTicket Version v1.18 (724de45) — Up to date
Web Server Software Microsoft-IIS/10.0
MySQL Version 10.9.4
PHP Version 8.2.6

Custom Field OP how its created

Database column

Database values

The only thing strange that i find that when creating the column for the field i have 2 entries for it and it seems is valid for all custom fields but only the one without user is working, maybe its normal, ive put the second one a secondary datasource but with no effect

We are in a test system so i could empty tables if needed.

Thank you for your time.

KevinTheJedi

iamzoli

Try this line instead:

return empty($val) ? (is_int($val) ? $val : NULL) : (($quote) ? "'$val'" : $val);

Cheers.

KevinTheJedi

iamzoli

I updated the line above btw.

Cheers.

iamzoli

KevinTheJedi
Hello Kevin,
I've tried the line of code

But now all queues are empty and all sql give errors

iamzoli

Hello Kevin, ive tried to play with the return code but with no luck, have any other ideas ?

KevinTheJedi

iamzoli

Can you drop your _ticket__cdata table, run cron a bunch of times until the table is recreated and fully repopulated, and retest?

Cheers.

iamzoli

Hello Kevin,
Here is how the table looked before de drop

After the drop, runned 10 times cron with comand. C:\path\to\php\php.exe -f C:\path\to\osTicket\api\cron.php
and this is the table now

Also tried to runned the cron a bunch a time with each of the line in mysql that you suggested but with no effect

KevinTheJedi

iamzoli

Interesting. I’ll just have to try and replicate at this point as I’m not sure what’s going on in your case.

Cheers.

iamzoli

Hello Kevin, Thanks for the help. If you need something from us please let us know.