Queues using custom form fields issue

HansAlbers

osTicket version 1.18.1.
Webserver: nginx/1.22.1.
MySQL Version: 8.4.6
PHP Version: 8.2.29

Hello all,

I have a custom form which adds product information to tickets. I have a R&D department setup and tickets created for that dpt always do contain the product information form. That form includes a product line and product both fields being populated from a custom list of possible values. Another custom form adds R&D specific information to the tickets, among which a field "Firmware released for" which contains the products for which the firmware was already released, being populated with values from the same product list as mentioned.

The issue I have:

I'm trying to create queues which show the R&D tickets, filtered by ticket status being "Waiting for firmware". In the queue, I'm selecting by ticket status being "Waiting for release" and in the columns I'm showing the product from the product information form and the "released for" from the R&D form. This goes well, I'm seeing what I should see.
Now the issue:
In the selection criteria, I need to select only tickets for certain products. As soon as I add that selection to the Queue search criteria, i.e. "Prodduct" does not contain "a certain product" then the queue does not show the data anymore from the custom "R&D" information, it simply leaves the column empty.
Worse: When I also add selection criteria from the custom R&D form, the queue breaks completely and nothing is shown anymore.

I did already dive into the queue tables to see if there was anything wrong, i.e. any ghost entries in the tables, but even after I found some that I removed, the problem doesn't go away.

When I remove the selection criterium from the R&D form again, the queue works again. The idea I had was to create firmware queues for each of our products, and these queues would contain all the tickets in which the product is listed, but not the tickets in which the "already released for" contains that procuct.

Am I asking too much from the queue system maybe? Any suggestions or hints welcome.

Many thanks, Hans

KevinTheJedi

HansAlbers

Can you share screenshots so I can better follow you? Screenshots of the queue, criteria, the form and field type, and anything else you may think would be helpful. Also, when the queue breaks entirely check your error logs (webserver and/or php error logs) for any related errors.

Cheers.

HansAlbers

Hi Kevin,

Ok here we go. To start, the two custom forms we're using which are added to all the R&D tickets which is configured as such using the Help-Topics where you tick the forms and fields that need to add to the tickets.

Product Form:

R&D Form:

Queue criteria without the filter to exclude "Ndevor" from the queue:

Output from the queue without the filter to exclude "Ndevor" from the queue:

As you see, the columns "Related Support ticket" and "Firmware released for" are populated. (The fields are not filled in all tickets, this output is correct).

Now I add a product filter to the criteria of the queue, as we don't want the queue to show tickets that involve the product "Ndevor".

With this added to the criteria, the output in the queue is showing the correct tickets (The ones which have "Ndevor" in the product field are no longer appearing which is correct) but the columns "Related Support ticket" and "Firmware released for" are no longer populated.

It gets worse when I add an additional filter, to rule out tickets where for a specific product the firmware was already released (so the product is added in the "Firmware released for" field in the ticket. My filter looks like:

Which gives no output anymore:

This queue being empty, I suspect is simply because of the "Firmware released for" field has become empty, and the filter has nothing to filter for. I have additionally found out that a criteria "does not contain", will not work correctly on empty field, it will exclude tickets where that field is empty, allthough I would think and empty field should pass any "Does not contain" parameter.

Hope you can make some sense out of this.

KevinTheJedi

HansAlbers

Please perform the following steps outside of business hours as it will affect the whole system. Go to include/class.orm.php, go to the execute() function for class MySqlExecutor (looks like this), under the $sql = ... line put var_dump($sql);, and save the changes. Then go to the FW queue without the "Firmware" condition, reload the page, copy the full SQL statement for the queue. Then reverse the change to the file, save the changes, go back to the queue, reload the page to get rid of the SQL outputs, add the "Firmware" condition on the queue, go back to the file, add the changes back, save the changes, reload the queue, copy the new SQL statement, remove the changes from the file, and save changes.

Then post both SQL statements in this thread so I can review.

Cheers.

HansAlbers

It took a bit of time to get this done, sorry for the delay. Adding the dump sql actually made the Que look very messy, as the dump goes to stdout and messes up the queue view heavily. I'm not sure which part of the sql dump you would need, so I went copy pasting from top of page to bottom all the pieces of sql dump I found. I also made dumps of the entire html page as it appeared in case we need it. Can't upload that however. Below are the sql dumps as I copy pasted from the screen. Hope it makes any sense.

`SQL Dump without the FW filter

string(91) "SELECT COUNT() FROM (SELECT A1.id FROM ost_config A1 WHERE A1.namespace = 'core') __" string(62) "SELECT A1. FROM ost_config A1 WHERE A1.namespace = 'core'" string(131) "SELECT A1., A1.session_expire < NOW() AS is_expired FROM ost_session A1 WHERE A1.session_id = 'o1neu0kdhej58ucf0eq6n4k37g'" string(77) "SELECT A1. FROM ost_queue_sort A1 WHERE A1.id = 6 ORDER BY A1.name ASC" string(55) "SELECT A1.* FROM ost_plugin A1 ORDER BY A1.name ASC" string(73) "SELECT A1.* FROM ost_plugin A1 WHERE A1.id = 5 ORDER BY A1.name ASC" string(73) "SELECT A1.* FROM ost_plugin A1 WHERE A1.id = 7 ORDER BY A1.name ASC" string(73) "SELECT A1.* FROM ost_plugin A1 WHERE A1.id = 4 ORDER BY A1.name ASC" string(113) "SELECT A1.* FROM ost_plugin_instance A1 WHERE A1.plugin_id = 5 AND A1.flags & 1 != 0 ORDER BY A1.name ASC" string(73) "SELECT A1.* FROM ost_plugin A1 WHERE A1.id = 5 ORDER BY A1.name ASC" string(107) "SELECT COUNT() FROM (SELECT A1.id FROM ost_config A1 WHERE A1.namespace = 'plugin.5.instance.24') __" string(78) "SELECT A1. FROM ost_config A1 WHERE A1.namespace = 'plugin.5.instance.24'" string(113) "SELECT A1.* FROM ost_plugin_instance A1 WHERE A1.plugin_id = 7 AND A1.flags & 1 != 0 ORDER BY A1.name ASC" string(73) "SELECT A1.* FROM ost_plugin A1 WHERE A1.id = 7 ORDER BY A1.name ASC" string(107) "SELECT COUNT() FROM (SELECT A1.id FROM ost_config A1 WHERE A1.namespace = 'plugin.7.instance.26') __" string(78) "SELECT A1. FROM ost_config A1 WHERE A1.namespace = 'plugin.7.instance.26'" string(113) "SELECT A1.* FROM ost_plugin_instance A1 WHERE A1.plugin_id = 4 AND A1.flags & 1 != 0 ORDER BY A1.name ASC" string(73) "SELECT A1.* FROM ost_plugin A1 WHERE A1.id = 4 ORDER BY A1.name ASC" string(107) "SELECT COUNT() FROM (SELECT A1.id FROM ost_config A1 WHERE A1.namespace = 'plugin.4.instance.23') __" string(78) "SELECT A1. FROM ost_config A1 WHERE A1.namespace = 'plugin.4.instance.23'" string(98) "SELECT COUNT() FROM (SELECT A1.id FROM ost_config A1 WHERE A1.namespace = 'mysqlsearch') __" string(69) "SELECT A1. FROM ost_config A1 WHERE A1.namespace = 'mysqlsearch'" string(61) "SELECT A1.* FROM ost_staff A1 WHERE A1.username = 'HansA'" string(95) "SELECT COUNT() FROM (SELECT A1.id FROM ost_config A1 WHERE A1.namespace = 'staff.57') __" string(66) "SELECT A1. FROM ost_config A1 WHERE A1.namespace = 'staff.57'" string(760) "SELECT A1.id, A1.parent_id, A1.columns_id, A1.sort_id, A1.flags, A1.staff_id, A1.sort, A1.title, A1.config, A1.filter, A1.root, A1.path, A1.created, A1.updated, CASE WHEN A1.sort = 0 THEN 999 ELSE A1.sort END AS _sort, A2.id, A2.parent_id, A2.columns_id, A2.sort_id, A2.flags, A2.staff_id, A2.sort, A2.title, A2.config, A2.filter, A2.root, A2.path, A2.created, A2.updated, A3.id, A3.root, A3.name, A3.columns, A3.updated FROM ost_queue A1 LEFT JOIN ost_queue A2 ON (A1.parent_id = A2.id) LEFT JOIN ost_queue_sort A3 ON (A1.sort_id = A3.id) WHERE (A1.flags & 2 != 0 OR A1.staff_id = 57) AND NOT A1.flags & 4 != 0 ORDER BY A1.parent_id ASC, _sort ASC, A1.title ASC" string(605) "SELECT A1.id, A1.parent_id, A1.columns_id, A1.sort_id, A1.flags, A1.staff_id, A1.sort, A1.title, A1.config, A1.filter, A1.root, A1.path, A1.created, A1.updated, A2.id, A2.parent_id, A2.columns_id, A2.sort_id, A2.flags, A2.staff_id, A2.sort, A2.title, A2.config, A2.filter, A2.root, A2.path, A2.created, A2.updated, A3.id, A3.root, A3.name, A3.columns, A3.updated FROM ost_queue A1 LEFT JOIN ost_queue A2 ON (A1.parent_id = A2.id) LEFT JOIN ost_queue_sort A3 ON (A1.sort_id = A3.id) WHERE A1.id = '83' ORDER BY A1.sort ASC" string(86) "SELECT A1.* FROM ost_queue_config A1 WHERE A1.queue_id = 83 AND A1.staff_id = 57" string(48) "SELECT A1.* FROM ost_role A1 WHERE A1.id = 1" string(76) "SELECT A1.* FROM ost_form A1 WHERE A1.type = 'T' ORDER BY A1.title ASC" string(72) "SELECT A1.* FROM ost_form A1 WHERE A1.id = 2 ORDER BY A1.title ASC" string(391) "SELECT A1.id, A1.form_id, A1.flags, A1.type, A1.label, A1.name, A1.configuration, A1.sort, A1.hint, A1.created, A1.updated, A2.id, A2.pid, A2.type, A2.flags, A2.title, A2.instructions, A2.name, A2.notes, A2.created, A2.updated FROM ost_form_field A1 LEFT JOIN ost_form A2 ON (A1.form_id = A2.id) WHERE A1.form_id = 2 ORDER BY A1.sort ASC" string(53) "SELECT A1.* FROM ost_list A1 ORDER BY A1.name ASC" string(88) "SELECT A1.* FROM ost_translation A1 WHERE A1.lang = 'en_US' AND A1.type = 'phrase'" string(338) "SELECT A1.entry_id, A1.field_id, A1.value, A1.value_id, A2.id, A2.form_id, A2.flags, A2.type, A2.label, A2.name, A2.configuration, A2.sort, A2.hint, A2.created, A2.updated FROM ost_form_entry_values A1 JOIN ost_form_field A2 ON (A1.field_id = A2.id) WHERE A1.entry_id IS NULL ORDER BY A2.sort ASC" string(390) "SELECT A1.id, A1.form_id, A1.flags, A1.type, A1.label, A1.name, A1.configuration, A1.sort, A1.hint, A1.created, A1.updated, A2.id, A2.pid, A2.type, A2.flags, A2.title, A2.instructions, A2.name, A2.notes, A2.created, A2.updated FROM ost_form_field A1 LEFT JOIN ost_form A2 ON (A1.form_id = A2.id) WHERE A2.type = 'G' ORDER BY A1.sort ASC" string(76) "SELECT A1.* FROM ost_form A1 WHERE A1.type = 'U' ORDER BY A1.title ASC" string(391) "SELECT A1.id, A1.form_id, A1.flags, A1.type, A1.label, A1.name, A1.configuration, A1.sort, A1.hint, A1.created, A1.updated, A2.id, A2.pid, A2.type, A2.flags, A2.title, A2.instructions, A2.name, A2.notes, A2.created, A2.updated FROM ost_form_field A1 LEFT JOIN ost_form A2 ON (A1.form_id = A2.id) WHERE A1.form_id = 1 ORDER BY A1.sort ASC" string(76) "SELECT A1.* FROM ost_form A1 WHERE A1.type = 'O' ORDER BY A1.title ASC" string(391) "SELECT A1.id, A1.form_id, A1.flags, A1.type, A1.label, A1.name, A1.configuration, A1.sort, A1.hint, A1.created, A1.updated, A2.id, A2.pid, A2.type, A2.flags, A2.title, A2.instructions, A2.name, A2.notes, A2.created, A2.updated FROM ost_form_field A1 LEFT JOIN ost_form A2 ON (A1.form_id = A2.id) WHERE A1.form_id = 4 ORDER BY A1.sort ASC" string(391) "SELECT A1.queue_id, A1.column_id, A1.staff_id, A1.bits, A1.sort, A1.heading, A1.width, A2.id, A2.flags, A2.name, A2.primary, A2.secondary, A2.filter, A2.truncate, A2.annotations, A2.conditions, A2.extra FROM ost_queue_columns A1 JOIN ost_queue_column A2 ON (A1.column_id = A2.id) WHERE A1.queue_id = 83 AND A1.staff_id = 0 ORDER BY A1.sort ASC" string(79) "SELECT A1.* FROM ost_queue_column A1 WHERE A1.id = 1 ORDER BY A1.name ASC" string(79) "SELECT A1.* FROM ost_queue_column A1 WHERE A1.id = 2 ORDER BY A1.name ASC" string(80) "SELECT A1.* FROM ost_queue_column A1 WHERE A1.id = 16 ORDER BY A1.name ASC" string(79) "SELECT A1.* FROM ost_queue_column A1 WHERE A1.id = 3 ORDER BY A1.name ASC" string(79) "SELECT A1.* FROM ost_queue_column A1 WHERE A1.id = 5 ORDER BY A1.name ASC" string(80) "SELECT A1.* FROM ost_queue_column A1 WHERE A1.id = 39 ORDER BY A1.name ASC" string(80) "SELECT A1.* FROM ost_queue_column A1 WHERE A1.id = 40 ORDER BY A1.name ASC"

string(87) "SELECT A1.* FROM ost_list A1 WHERE A1.type = 'ticket-status' ORDER BY A1.name ASC" string(124) "SELECT A1.* FROM ost_ticket_status A1 WHERE A1.mode & 1 != 0 AND A1.state IN ('open', 'closed') ORDER BY A1.sort ASC"
string(2445) "SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.created AS created, B6.subject AS cdata__subject, B6.priority AS cdata__priority, MAX(A4.value) AS entries__answers!40__value, A1.isanswered = '0' AS 2GkBZxz, B7.expire > NOW() AND NOT B7.staff_id = 57 AS _locked, B6.priority REGEXP '\"?(?string(108) "SELECT A1.* FROM ost_list_items A1 WHERE A1.list_id = 2 AND A1.status & 1 != 0 ORDER BY A1.value ASC" string(77) "SELECT A1.* FROM ost_ticket_priority A1 ORDER BY A1.priority_urgency DESC" string(85) "SELECT A1.* FROM ost_list_items A1 WHERE A1.list_id = 2 AND A1.id = 158 LIMIT 1" string(71) "SELECT A1.* FROM ost_list A1 WHERE A1.id = 2 ORDER BY A1.name ASC" string(77) "SELECT A1.* FROM ost_form A1 WHERE A1.type = 'L2' ORDER BY A1.title ASC" string(392) "SELECT A1.id, A1.form_id, A1.flags, A1.type, A1.label, A1.name, A1.configuration, A1.sort, A1.hint, A1.created, A1.updated, A2.id, A2.pid, A2.type, A2.flags, A2.title, A2.instructions, A2.name, A2.notes, A2.created, A2.updated FROM ost_form_field A1 LEFT JOIN ost_form A2 ON (A1.form_id = A2.id) WHERE A1.form_id = 14 ORDER BY A1.sort ASC" string(85) "SELECT A1.* FROM ost_list_items A1 WHERE A1.list_id = 2 AND A1.id = 159 LIMIT 1" string(71) "SELECT A1.* FROM ost_list A1 WHERE A1.id = 2 ORDER BY A1.name ASC" string(85) "SELECT A1.* FROM ost_list_items A1 WHERE A1.list_id = 2 AND A1.id = 158 LIMIT 1" string(85) "SELECT A1.* FROM ost_list_items A1 WHERE A1.list_id = 2 AND A1.id = 159 LIMIT 1" string(85) "SELECT A1.* FROM ost_list_items A1 WHERE A1.list_id = 2 AND A1.id = 158 LIMIT 1" string(85) "SELECT A1.* FROM ost_list_items A1 WHERE A1.list_id = 2 AND A1.id = 159 LIMIT 1" string(85) "SELECT A1.* FROM ost_list_items A1 WHERE A1.list_id = 2 AND A1.id = 158 LIMIT 1"

string(10214) "UPDATE ost_session SET session_data = 'csrf|a:2:{s:5:\"token\";s:40:\"7ca54ec603a2a8c831536bde4b334dfe78f16197\";s:4:\"time\";i:1756818686;}staff|a:1:{s:4:\"auth\";a:2:{s:4:\"dest\";s:25:\"/scp/tickets.php?id=13107\";s:3:\"msg\";s:23:\"Authentication Required\";}}auth|a:1:{s:5:\"staff\";a:3:{s:2:\"id\";i:57;s:3:\"key\";s:11:\"local:HansA\";s:3:\"2fa\";N;}}:token|a:1:{s:5:\"staff\";s:76:\"77aebd76fcf8bf71895896247c5a972d:1756818671:1dec8c26a2eb2abbf18d27b6b9739a59\";}TIME_BOMB|i:1756881936;cfg:core|a:1:{s:11:\"db_timezone\";s:3:\"UTC\";}lastcroncall|i:1756818580;:msgs|a:0:{}::Q:T|i:83;sort|a:1:{i:5;a:2:{s:9:\"queuesort\";O:9:\"QueueSort\":7:{s:2:\"ht\";a:5:{s:2:\"id\";i:6;s:4:\"root\";N;s:4:\"name\";s:11:\"Create Date\";s:7:\"columns\";s:12:\"[\"-created\"]\";s:7:\"updated\";s:19:\"2022-11-17 08:55:08\";}s:5:\"dirty\";a:0:{}s:7:\"new\";b:0;s:11:\"deleted\";b:0;s:12:\"deferred\";a:0:{}s:8:\"_columns\";a:1:{s:7:\"created\";b:1;}s:6:\"_extra\";N;}s:3:\"dir\";i:0;}}:form-data|N;:Q:users|O:8:\"QuerySet\":16:{s:5:\"model\";s:4:\"User\";s:11:\"constraints\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:4:{s:25:\"emailsaddresscontains\";s:5:\"nenad\";s:14:\"namecontains\";s:5:\"nenad\";s:19:\"orgnamecontains\";s:5:\"nenad\";s:22:\"cdataphonecontains\";s:5:\"nenad\";}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:1:{i:0;s:4:\"name\";}s:7:\"related\";b:0;s:6:\"values\";a:7:{s:2:\"id\";s:2:\"id\";s:4:\"name\";s:4:\"name\";s:22:\"default_emailaddress\";s:22:\"default_emailaddress\";s:11:\"accountid\";s:11:\"accountid\";s:15:\"accountstatus\";s:15:\"accountstatus\";s:7:\"created\";s:7:\"created\";s:7:\"updated\";s:7:\"updated\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:1:{s:12:\"ticket_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"ticket_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";s:7:\"tickets\";s:8:\"distinct\";b:0;s:10:\"constraint\";b:0;}}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:2;s:8:\"compiler\";s:13:\"MySqlCompiler\";}:U:tickets|O:8:\"QuerySet\":16:{s:5:\"model\";s:6:\"Ticket\";s:11:\"constraints\";a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:13:\"ticket_idin\";O:8:\"QuerySet\":16:{s:5:\"model\";s:6:\"Ticket\";s:11:\"constraints\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:7:\"user_id\";i:5264;}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:0:{}s:7:\"related\";b:0;s:6:\"values\";a:1:{i:0;s:9:\"ticket_id\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:0:{}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:1:{i:0;a:2:{i:0;O:8:\"QuerySet\":16:{s:5:\"model\";s:6:\"Ticket\";s:11:\"constraints\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:30:\"threadcollaboratorsuser_id\";i:5264;}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:0:{}s:7:\"related\";b:0;s:6:\"values\";a:1:{i:0;s:9:\"ticket_id\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:0:{}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:3;s:8:\"compiler\";s:13:\"MySqlCompiler\";}i:1;b:0;}}s:7:\"options\";a:0:{}s:4:\"iter\";i:3;s:8:\"compiler\";s:13:\"MySqlCompiler\";}}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:3:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:13:\"statusstate\";s:4:\"open\";i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:6:{s:8:\"staff_id\";i:57;s:34:\"threadreferralsagentstaff_id\";i:57;i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:25:\"child_threadobject_type\";s:1:\"C\";s:40:\"child_threadreferralsagentstaff_id\";i:57;}}}}s:11:\"team_idin\";a:2:{i:0;i:8;i:1;i:9;}s:36:\"threadreferralsteamteam_idin\";a:2:{i:0;i:8;i:1;i:9;}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:25:\"child_threadobject_type\";s:1:\"C\";s:42:\"child_threadreferralsteamteam_idin\";a:2:{i:0;i:8;i:1;i:9;}}}}}}}}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:2:{s:11:\"dept_idin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}s:31:\"threadreferralsdeptidin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}}}i:2;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:25:\"child_threadobject_type\";s:1:\"C\";s:37:\"child_threadreferralsdeptidin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}}}}}}}}s:16:\"path_constraints\";a:1:{s:4:\"lock\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:16:\"lockexpiregt\";O:11:\"SqlFunction\":3:{s:5:\"alias\";N;s:4:\"func\";s:3:\"NOW\";s:4:\"args\";a:0:{}}}}}}s:8:\"ordering\";a:1:{i:0;s:8:\"-created\";}s:7:\"related\";b:0;s:6:\"values\";a:21:{s:8:\"staff_id\";s:8:\"staff_id\";s:16:\"stafffirstname\";s:16:\"stafffirstname\";s:15:\"stafflastname\";s:15:\"stafflastname\";s:10:\"teamname\";s:10:\"teamname\";s:7:\"team_id\";s:7:\"team_id\";s:13:\"locklock_id\";s:13:\"locklock_id\";s:14:\"lockstaff_id\";s:14:\"lockstaff_id\";s:9:\"isoverdue\";s:9:\"isoverdue\";s:9:\"status_id\";s:9:\"status_id\";s:12:\"statusname\";s:12:\"statusname\";s:13:\"statusstate\";s:13:\"statusstate\";s:6:\"number\";s:6:\"number\";s:14:\"cdatasubject\";s:14:\"cdatasubject\";s:9:\"ticket_id\";s:9:\"ticket_id\";s:6:\"source\";s:6:\"source\";s:7:\"dept_id\";s:7:\"dept_id\";s:10:\"deptname\";s:10:\"deptname\";s:7:\"user_id\";s:7:\"user_id\";s:28:\"userdefault_emailaddress\";s:28:\"userdefault_emailaddress\";s:10:\"username\";s:10:\"username\";s:10:\"lastupdate\";s:10:\"lastupdate\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:3:{s:12:\"collab_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"collab_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";s:21:\"threadcollaborators\";s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:16:\"attachment_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:16:\"attachment_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:36:\"threadentriesattachmentsinline\";}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:28:\"threadentriesattachments\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:12:\"thread_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"thread_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:30:\"threadentriesflagshasbit\";i:4;}}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:19:\"threadentriesid\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:1:{i:0;s:9:\"ticket_id\";}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:2;s:8:\"compiler\";s:13:\"MySqlCompiler\";}::Q:A|s:0:\"\";:QA::sort|a:2:{i:0;s:7:\"created\";i:1;i:0;}:Q:tasks|O:8:\"QuerySet\":16:{s:5:\"model\";s:4:\"Task\";s:11:\"constraints\";a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:13:\"flagshasbit\";i:1;}}}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:4:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:13:\"flagshasbit\";i:1;s:8:\"staff_id\";i:57;}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:16:\"ticketstaff_id\";i:57;s:21:\"ticketstatusstate\";s:4:\"open\";}}i:2;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:11:\"dept_idin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}}}i:3;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:11:\"team_idin\";a:2:{i:0;i:8;i:1;i:9;}s:13:\"flagshasbit\";i:1;}}}}}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:1:{i:0;s:8:\"-created\";}s:7:\"related\";b:0;s:6:\"values\";a:13:{s:2:\"id\";s:2:\"id\";s:6:\"number\";s:6:\"number\";s:7:\"created\";s:7:\"created\";s:8:\"staff_id\";s:8:\"staff_id\";s:7:\"team_id\";s:7:\"team_id\";s:16:\"stafffirstname\";s:16:\"stafffirstname\";s:15:\"stafflastname\";s:15:\"stafflastname\";s:10:\"teamname\";s:10:\"teamname\";s:10:\"deptname\";s:10:\"deptname\";s:12:\"cdatatitle\";s:12:\"cdatatitle\";s:5:\"flags\";s:5:\"flags\";s:14:\"ticketnumber\";s:14:\"ticketnumber\";s:17:\"ticketticket_id\";s:17:\"ticketticket_id\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:3:{s:12:\"collab_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"collab_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";s:21:\"threadcollaborators\";s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:16:\"attachment_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:16:\"attachment_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:36:\"threadentriesattachmentsinline\";}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:28:\"threadentriesattachments\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:12:\"thread_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"thread_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:30:\"threadentriesflagshasbit\";i:4;}}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:19:\"threadentriesid\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:2;s:8:\"compiler\";s:13:\"MySqlCompiler\";}', session_updated = NOW() WHERE ost_session.session_id = 'o1neu0kdhej58ucf0eq6n4k37g' LIMIT 1" string(45) "SELECT A1.id, A1.name FROM ost_event A1"
Copyright © 2006-2025 string(142) "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ost_form_entry' AND TABLE_SCHEMA = DATABASE() ORDER BY ORDINAL_POSITION" string(366) "SELECT A1.id, A1.form_id, A1.object_id, A1.object_type, A1.sort, A1.extra, A1.created, A1.updated, A2.id, A2.pid, A2.type, A2.flags, A2.title, A2.instructions, A2.name, A2.notes, A2.created, A2.updated FROM ost_form_entry A1 LEFT JOIN ost_form A2 ON (A1.form_id = A2.id) WHERE A1.object_type = 'C' ORDER BY A1.sort ASC" string(334) "SELECT A1.entry_id, A1.field_id, A1.value, A1.value_id, A2.id, A2.form_id, A2.flags, A2.type, A2.label, A2.name, A2.configuration, A2.sort, A2.hint, A2.created, A2.updated FROM ost_form_entry_values A1 JOIN ost_form_field A2 ON (A1.field_id = A2.id) WHERE A1.entry_id = 2 ORDER BY A2.sort ASC" Newland EMEA BV All Rights Reserved.

string(10214) "UPDATE ost_session SET session_data = 'csrf|a:2:{s:5:\"token\";s:40:\"7ca54ec603a2a8c831536bde4b334dfe78f16197\";s:4:\"time\";i:1756818580;}staff|a:1:{s:4:\"auth\";a:2:{s:4:\"dest\";s:25:\"/scp/tickets.php?id=13107\";s:3:\"msg\";s:23:\"Authentication Required\";}}auth|a:1:{s:5:\"staff\";a:3:{s:2:\"id\";i:57;s:3:\"key\";s:11:\"local:HansA\";s:3:\"2fa\";N;}}:token|a:1:{s:5:\"staff\";s:76:\"c59778870b4ad17787e24795ca30545e:1756818578:1dec8c26a2eb2abbf18d27b6b9739a59\";}TIME_BOMB|i:1756881936;cfg:core|a:1:{s:11:\"db_timezone\";s:3:\"UTC\";}lastcroncall|i:1756818034;:msgs|a:0:{}::Q:T|i:83;sort|a:1:{i:5;a:2:{s:9:\"queuesort\";O:9:\"QueueSort\":7:{s:2:\"ht\";a:5:{s:2:\"id\";i:6;s:4:\"root\";N;s:4:\"name\";s:11:\"Create Date\";s:7:\"columns\";s:12:\"[\"-created\"]\";s:7:\"updated\";s:19:\"2022-11-17 08:55:08\";}s:5:\"dirty\";a:0:{}s:7:\"new\";b:0;s:11:\"deleted\";b:0;s:12:\"deferred\";a:0:{}s:8:\"_columns\";a:1:{s:7:\"created\";b:1;}s:6:\"_extra\";N;}s:3:\"dir\";i:0;}}:form-data|N;:Q:users|O:8:\"QuerySet\":16:{s:5:\"model\";s:4:\"User\";s:11:\"constraints\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:4:{s:25:\"emailsaddresscontains\";s:5:\"nenad\";s:14:\"namecontains\";s:5:\"nenad\";s:19:\"orgnamecontains\";s:5:\"nenad\";s:22:\"cdataphonecontains\";s:5:\"nenad\";}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:1:{i:0;s:4:\"name\";}s:7:\"related\";b:0;s:6:\"values\";a:7:{s:2:\"id\";s:2:\"id\";s:4:\"name\";s:4:\"name\";s:22:\"default_emailaddress\";s:22:\"default_emailaddress\";s:11:\"accountid\";s:11:\"accountid\";s:15:\"accountstatus\";s:15:\"accountstatus\";s:7:\"created\";s:7:\"created\";s:7:\"updated\";s:7:\"updated\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:1:{s:12:\"ticket_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"ticket_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";s:7:\"tickets\";s:8:\"distinct\";b:0;s:10:\"constraint\";b:0;}}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:2;s:8:\"compiler\";s:13:\"MySqlCompiler\";}:U:tickets|O:8:\"QuerySet\":16:{s:5:\"model\";s:6:\"Ticket\";s:11:\"constraints\";a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:13:\"ticket_idin\";O:8:\"QuerySet\":16:{s:5:\"model\";s:6:\"Ticket\";s:11:\"constraints\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:7:\"user_id\";i:5264;}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:0:{}s:7:\"related\";b:0;s:6:\"values\";a:1:{i:0;s:9:\"ticket_id\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:0:{}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:1:{i:0;a:2:{i:0;O:8:\"QuerySet\":16:{s:5:\"model\";s:6:\"Ticket\";s:11:\"constraints\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:30:\"threadcollaboratorsuser_id\";i:5264;}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:0:{}s:7:\"related\";b:0;s:6:\"values\";a:1:{i:0;s:9:\"ticket_id\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:0:{}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:3;s:8:\"compiler\";s:13:\"MySqlCompiler\";}i:1;b:0;}}s:7:\"options\";a:0:{}s:4:\"iter\";i:3;s:8:\"compiler\";s:13:\"MySqlCompiler\";}}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:3:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:13:\"statusstate\";s:4:\"open\";i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:6:{s:8:\"staff_id\";i:57;s:34:\"threadreferralsagentstaff_id\";i:57;i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:25:\"child_threadobject_type\";s:1:\"C\";s:40:\"child_threadreferralsagentstaff_id\";i:57;}}}}s:11:\"team_idin\";a:2:{i:0;i:8;i:1;i:9;}s:36:\"threadreferralsteamteam_idin\";a:2:{i:0;i:8;i:1;i:9;}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:25:\"child_threadobject_type\";s:1:\"C\";s:42:\"child_threadreferralsteamteam_idin\";a:2:{i:0;i:8;i:1;i:9;}}}}}}}}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:2:{s:11:\"dept_idin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}s:31:\"threadreferralsdeptidin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}}}i:2;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:25:\"child_threadobject_type\";s:1:\"C\";s:37:\"child_threadreferralsdeptidin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}}}}}}}}s:16:\"path_constraints\";a:1:{s:4:\"lock\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:16:\"lockexpiregt\";O:11:\"SqlFunction\":3:{s:5:\"alias\";N;s:4:\"func\";s:3:\"NOW\";s:4:\"args\";a:0:{}}}}}}s:8:\"ordering\";a:1:{i:0;s:8:\"-created\";}s:7:\"related\";b:0;s:6:\"values\";a:21:{s:8:\"staff_id\";s:8:\"staff_id\";s:16:\"stafffirstname\";s:16:\"stafffirstname\";s:15:\"stafflastname\";s:15:\"stafflastname\";s:10:\"teamname\";s:10:\"teamname\";s:7:\"team_id\";s:7:\"team_id\";s:13:\"locklock_id\";s:13:\"locklock_id\";s:14:\"lockstaff_id\";s:14:\"lockstaff_id\";s:9:\"isoverdue\";s:9:\"isoverdue\";s:9:\"status_id\";s:9:\"status_id\";s:12:\"statusname\";s:12:\"statusname\";s:13:\"statusstate\";s:13:\"statusstate\";s:6:\"number\";s:6:\"number\";s:14:\"cdatasubject\";s:14:\"cdatasubject\";s:9:\"ticket_id\";s:9:\"ticket_id\";s:6:\"source\";s:6:\"source\";s:7:\"dept_id\";s:7:\"dept_id\";s:10:\"deptname\";s:10:\"deptname\";s:7:\"user_id\";s:7:\"user_id\";s:28:\"userdefault_emailaddress\";s:28:\"userdefault_emailaddress\";s:10:\"username\";s:10:\"username\";s:10:\"lastupdate\";s:10:\"lastupdate\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:3:{s:12:\"collab_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"collab_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";s:21:\"threadcollaborators\";s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:16:\"attachment_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:16:\"attachment_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:36:\"threadentriesattachmentsinline\";}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:28:\"threadentriesattachments\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:12:\"thread_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"thread_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:30:\"threadentriesflagshasbit\";i:4;}}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:19:\"threadentriesid\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:1:{i:0;s:9:\"ticket_id\";}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:2;s:8:\"compiler\";s:13:\"MySqlCompiler\";}::Q:A|s:0:\"\";:QA::sort|a:2:{i:0;s:7:\"created\";i:1;i:0;}:Q:tasks|O:8:\"QuerySet\":16:{s:5:\"model\";s:4:\"Task\";s:11:\"constraints\";a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:13:\"flagshasbit\";i:1;}}}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:4:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:13:\"flagshasbit\";i:1;s:8:\"staff_id\";i:57;}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:16:\"ticketstaff_id\";i:57;s:21:\"ticketstatusstate\";s:4:\"open\";}}i:2;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:11:\"dept_idin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}}}i:3;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:11:\"team_idin\";a:2:{i:0;i:8;i:1;i:9;}s:13:\"flagshasbit\";i:1;}}}}}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:1:{i:0;s:8:\"-created\";}s:7:\"related\";b:0;s:6:\"values\";a:13:{s:2:\"id\";s:2:\"id\";s:6:\"number\";s:6:\"number\";s:7:\"created\";s:7:\"created\";s:8:\"staff_id\";s:8:\"staff_id\";s:7:\"team_id\";s:7:\"team_id\";s:16:\"stafffirstname\";s:16:\"stafffirstname\";s:15:\"stafflastname\";s:15:\"stafflastname\";s:10:\"teamname\";s:10:\"teamname\";s:10:\"deptname\";s:10:\"deptname\";s:12:\"cdatatitle\";s:12:\"cdatatitle\";s:5:\"flags\";s:5:\"flags\";s:14:\"ticketnumber\";s:14:\"ticketnumber\";s:17:\"ticketticket_id\";s:17:\"ticketticket_id\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:3:{s:12:\"collab_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"collab_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";s:21:\"threadcollaborators\";s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:16:\"attachment_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:16:\"attachment_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:36:\"threadentriesattachmentsinline\";}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:28:\"threadentriesattachments\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:12:\"thread_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"thread_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:30:\"threadentriesflagshasbit\";i:4;}}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:19:\"threadentriesid\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:2;s:8:\"compiler\";s:13:\"MySqlCompiler\";}', session_updated = NOW() WHERE ost_session.session_id = 'o1neu0kdhej58ucf0eq6n4k37g' LIMIT 1" string(45) "SELECT A1.id, A1.name FROM ost_event A1"

HansAlbers

SQL dump with the FW filter:

string(708) "SELECT A1.team_id, A1.staff_id, A1.flags, A2.staff_id, A2.dept_id, A2.role_id, A2.username, A2.firstname, A2.lastname, A2.passwd, A2.backend, A2.email, A2.phone, A2.phone_ext, A2.mobile, A2.signature, A2.lang, A2.timezone, A2.locale, A2.notes, A2.isactive, A2.isadmin, A2.isvisible, A2.onvacation, A2.assigned_only, A2.show_assigned_tickets, A2.change_passwd, A2.max_page_size, A2.auto_refresh_rate, A2.default_signature_type, A2.default_paper_size, A2.extra, A2.permissions, A2.created, A2.lastlogin, A2.passwdreset, A2.updated FROM ost_team_member A1 JOIN ost_staff A2 ON (A1.staff_id = A2.staff_id) WHERE A1.staff_id = 57" string(1777) "SELECT COUNT() FROM (SELECT A1.ticket_id FROM ost_ticket A1 JOIN ost_ticket_status A2 ON (A1.status_id = A2.id) JOIN ost_form_entry A3 ON (A3.object_type = 'T' AND A1.ticket_id = A3.object_id) LEFT JOIN ost_form_entry_values A4 ON (A3.id = A4.entry_id AND A4.field_id = 40 AND A4.field_id = 40) LEFT JOIN ost_form_entry_values A5 ON (A3.id = A5.entry_id AND A5.field_id = 67 AND A5.field_id = 67) LEFT JOIN ost_thread A6 ON (A6.object_type = 'T' AND A1.ticket_id = A6.object_id) LEFT JOIN ost_thread_referral A7 ON (A6.id = A7.thread_id) LEFT JOIN ost_staff A8 ON (A7.object_type = 'S' AND A7.object_id = A8.staff_id) LEFT JOIN ost_thread B0 ON (A1.ticket_id = B0.object_id AND B0.object_type = 'C') LEFT JOIN ost_thread_referral B1 ON (B0.id = B1.thread_id) LEFT JOIN ost_staff B2 ON (B1.object_type = 'S' AND B1.object_id = B2.staff_id) LEFT JOIN ost_team B3 ON (A7.object_type = 'E' AND A7.object_id = B3.team_id) LEFT JOIN ost_team B4 ON (B1.object_type = 'E' AND B1.object_id = B4.team_id) LEFT JOIN ost_department B5 ON (A7.object_type = 'D' AND A7.object_id = B5.id) LEFT JOIN ost_department B6 ON (B1.object_type = 'D' AND B1.object_id = B6.id) WHERE A2.id IN (15) AND A2.state = 'open' AND A1.dept_id = 9 AND NOT A4.value REGEXP '\"?(?
string(473) "SELECT A1.queue_id, A1.sort_id, A1.bits, A1.sort, A2.id, A2.root, A2.name, A2.columns, A2.updated, A3.id, A3.parent_id, A3.columns_id, A3.sort_id, A3.flags, A3.staff_id, A3.sort, A3.title, A3.config, A3.filter, A3.root, A3.path, A3.created, A3.updated FROM ost_queue_sorts A1 JOIN ost_queue_sort A2 ON (A1.sort_id = A2.id) JOIN ost_queue A3 ON (A1.queue_id = A3.id) WHERE A1.queue_id = 83 ORDER BY A1.sort ASC" string(65) "SELECT COUNT() FROM (SELECT A1.id FROM ost_queue_sort A1) __"

string(2521) "SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.created AS created, B7.subject AS cdata__subject, B7.priority AS cdata__priority, MAX(A4.value) AS entries__answers!40__value, MAX(A5.value) AS entries__answers!67__value, A1.isanswered = '0' AS 2GkBZxz, B8.expire > NOW() AND NOT B8.staff_id = 57 AS _locked, B7.priority REGEXP '\"?(?

string(366) "SELECT A1.id, A1.form_id, A1.object_id, A1.object_type, A1.sort, A1.extra, A1.created, A1.updated, A2.id, A2.pid, A2.type, A2.flags, A2.title, A2.instructions, A2.name, A2.notes, A2.created, A2.updated FROM ost_form_entry A1 LEFT JOIN ost_form A2 ON (A1.form_id = A2.id) WHERE A1.object_type = 'C' ORDER BY A1.sort ASC" string(334) "SELECT A1.entry_id, A1.field_id, A1.value, A1.value_id, A2.id, A2.form_id, A2.flags, A2.type, A2.label, A2.name, A2.configuration, A2.sort, A2.hint, A2.created, A2.updated FROM ost_form_entry_values A1 JOIN ost_form_field A2 ON (A1.field_id = A2.id) WHERE A1.entry_id = 2 ORDER BY A2.sort ASC"

string(10214) "UPDATE ost_session SET session_data = 'csrf|a:2:{s:5:\"token\";s:40:\"7ca54ec603a2a8c831536bde4b334dfe78f16197\";s:4:\"time\";i:1756819198;}staff|a:1:{s:4:\"auth\";a:2:{s:4:\"dest\";s:25:\"/scp/tickets.php?id=13107\";s:3:\"msg\";s:23:\"Authentication Required\";}}auth|a:1:{s:5:\"staff\";a:3:{s:2:\"id\";i:57;s:3:\"key\";s:11:\"local:HansA\";s:3:\"2fa\";N;}}:token|a:1:{s:5:\"staff\";s:76:\"c0b826fe4045e06797fda9c407267240:1756819144:1dec8c26a2eb2abbf18d27b6b9739a59\";}TIME_BOMB|i:1756881936;cfg:core|a:1:{s:11:\"db_timezone\";s:3:\"UTC\";}lastcroncall|i:1756818974;:msgs|a:0:{}::Q:T|i:83;sort|a:1:{i:5;a:2:{s:9:\"queuesort\";O:9:\"QueueSort\":7:{s:2:\"ht\";a:5:{s:2:\"id\";i:6;s:4:\"root\";N;s:4:\"name\";s:11:\"Create Date\";s:7:\"columns\";s:12:\"[\"-created\"]\";s:7:\"updated\";s:19:\"2022-11-17 08:55:08\";}s:5:\"dirty\";a:0:{}s:7:\"new\";b:0;s:11:\"deleted\";b:0;s:12:\"deferred\";a:0:{}s:8:\"_columns\";a:1:{s:7:\"created\";b:1;}s:6:\"_extra\";N;}s:3:\"dir\";i:0;}}:form-data|N;:Q:users|O:8:\"QuerySet\":16:{s:5:\"model\";s:4:\"User\";s:11:\"constraints\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:4:{s:25:\"emailsaddresscontains\";s:5:\"nenad\";s:14:\"namecontains\";s:5:\"nenad\";s:19:\"orgnamecontains\";s:5:\"nenad\";s:22:\"cdataphonecontains\";s:5:\"nenad\";}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:1:{i:0;s:4:\"name\";}s:7:\"related\";b:0;s:6:\"values\";a:7:{s:2:\"id\";s:2:\"id\";s:4:\"name\";s:4:\"name\";s:22:\"default_emailaddress\";s:22:\"default_emailaddress\";s:11:\"accountid\";s:11:\"accountid\";s:15:\"accountstatus\";s:15:\"accountstatus\";s:7:\"created\";s:7:\"created\";s:7:\"updated\";s:7:\"updated\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:1:{s:12:\"ticket_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"ticket_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";s:7:\"tickets\";s:8:\"distinct\";b:0;s:10:\"constraint\";b:0;}}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:2;s:8:\"compiler\";s:13:\"MySqlCompiler\";}:U:tickets|O:8:\"QuerySet\":16:{s:5:\"model\";s:6:\"Ticket\";s:11:\"constraints\";a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:13:\"ticket_idin\";O:8:\"QuerySet\":16:{s:5:\"model\";s:6:\"Ticket\";s:11:\"constraints\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:7:\"user_id\";i:5264;}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:0:{}s:7:\"related\";b:0;s:6:\"values\";a:1:{i:0;s:9:\"ticket_id\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:0:{}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:1:{i:0;a:2:{i:0;O:8:\"QuerySet\":16:{s:5:\"model\";s:6:\"Ticket\";s:11:\"constraints\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:30:\"threadcollaboratorsuser_id\";i:5264;}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:0:{}s:7:\"related\";b:0;s:6:\"values\";a:1:{i:0;s:9:\"ticket_id\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:0:{}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:3;s:8:\"compiler\";s:13:\"MySqlCompiler\";}i:1;b:0;}}s:7:\"options\";a:0:{}s:4:\"iter\";i:3;s:8:\"compiler\";s:13:\"MySqlCompiler\";}}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:3:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:13:\"statusstate\";s:4:\"open\";i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:6:{s:8:\"staff_id\";i:57;s:34:\"threadreferralsagentstaff_id\";i:57;i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:25:\"child_threadobject_type\";s:1:\"C\";s:40:\"child_threadreferralsagentstaff_id\";i:57;}}}}s:11:\"team_idin\";a:2:{i:0;i:8;i:1;i:9;}s:36:\"threadreferralsteamteam_idin\";a:2:{i:0;i:8;i:1;i:9;}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:25:\"child_threadobject_type\";s:1:\"C\";s:42:\"child_threadreferralsteamteam_idin\";a:2:{i:0;i:8;i:1;i:9;}}}}}}}}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:2:{s:11:\"dept_idin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}s:31:\"threadreferralsdeptidin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}}}i:2;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:25:\"child_threadobject_type\";s:1:\"C\";s:37:\"child_threadreferralsdeptidin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}}}}}}}}s:16:\"path_constraints\";a:1:{s:4:\"lock\";a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:16:\"lockexpiregt\";O:11:\"SqlFunction\":3:{s:5:\"alias\";N;s:4:\"func\";s:3:\"NOW\";s:4:\"args\";a:0:{}}}}}}s:8:\"ordering\";a:1:{i:0;s:8:\"-created\";}s:7:\"related\";b:0;s:6:\"values\";a:21:{s:8:\"staff_id\";s:8:\"staff_id\";s:16:\"stafffirstname\";s:16:\"stafffirstname\";s:15:\"stafflastname\";s:15:\"stafflastname\";s:10:\"teamname\";s:10:\"teamname\";s:7:\"team_id\";s:7:\"team_id\";s:13:\"locklock_id\";s:13:\"locklock_id\";s:14:\"lockstaff_id\";s:14:\"lockstaff_id\";s:9:\"isoverdue\";s:9:\"isoverdue\";s:9:\"status_id\";s:9:\"status_id\";s:12:\"statusname\";s:12:\"statusname\";s:13:\"statusstate\";s:13:\"statusstate\";s:6:\"number\";s:6:\"number\";s:14:\"cdatasubject\";s:14:\"cdatasubject\";s:9:\"ticket_id\";s:9:\"ticket_id\";s:6:\"source\";s:6:\"source\";s:7:\"dept_id\";s:7:\"dept_id\";s:10:\"deptname\";s:10:\"deptname\";s:7:\"user_id\";s:7:\"user_id\";s:28:\"userdefault_emailaddress\";s:28:\"userdefault_emailaddress\";s:10:\"username\";s:10:\"username\";s:10:\"lastupdate\";s:10:\"lastupdate\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:3:{s:12:\"collab_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"collab_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";s:21:\"threadcollaborators\";s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:16:\"attachment_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:16:\"attachment_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:36:\"threadentriesattachmentsinline\";}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:28:\"threadentriesattachments\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:12:\"thread_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"thread_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:30:\"threadentriesflagshasbit\";i:4;}}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:19:\"threadentriesid\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:1:{i:0;s:9:\"ticket_id\";}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:2;s:8:\"compiler\";s:13:\"MySqlCompiler\";}::Q:A|s:0:\"\";:QA::sort|a:2:{i:0;s:7:\"created\";i:1;i:0;}:Q:tasks|O:8:\"QuerySet\":16:{s:5:\"model\";s:4:\"Task\";s:11:\"constraints\";a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:13:\"flagshasbit\";i:1;}}}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:2;i:2;a:4:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:13:\"flagshasbit\";i:1;s:8:\"staff_id\";i:57;}}i:1;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:16:\"ticketstaff_id\";i:57;s:21:\"ticketstatusstate\";s:4:\"open\";}}i:2;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:11:\"dept_idin\";a:3:{i:0;i:1;i:1;i:5;i:2;i:9;}}}i:3;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:2:{s:11:\"team_idin\";a:2:{i:0;i:8;i:1;i:9;}s:13:\"flagshasbit\";i:1;}}}}}}}s:16:\"path_constraints\";a:0:{}s:8:\"ordering\";a:1:{i:0;s:8:\"-created\";}s:7:\"related\";b:0;s:6:\"values\";a:13:{s:2:\"id\";s:2:\"id\";s:6:\"number\";s:6:\"number\";s:7:\"created\";s:7:\"created\";s:8:\"staff_id\";s:8:\"staff_id\";s:7:\"team_id\";s:7:\"team_id\";s:16:\"stafffirstname\";s:16:\"stafffirstname\";s:15:\"stafflastname\";s:15:\"stafflastname\";s:10:\"teamname\";s:10:\"teamname\";s:10:\"deptname\";s:10:\"deptname\";s:12:\"cdatatitle\";s:12:\"cdatatitle\";s:5:\"flags\";s:5:\"flags\";s:14:\"ticketnumber\";s:14:\"ticketnumber\";s:17:\"ticketticket_id\";s:17:\"ticketticket_id\";}s:5:\"defer\";a:0:{}s:10:\"aggregated\";b:0;s:11:\"annotations\";a:3:{s:12:\"collab_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"collab_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";s:21:\"threadcollaborators\";s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:16:\"attachment_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:16:\"attachment_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:36:\"threadentriesattachmentsinline\";}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:28:\"threadentriesattachments\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}s:12:\"thread_count\";O:12:\"SqlAggregate\":5:{s:5:\"alias\";s:12:\"thread_count\";s:4:\"func\";s:5:\"COUNT\";s:4:\"expr\";O:7:\"SqlCase\":5:{s:5:\"alias\";N;s:5:\"cases\";a:1:{i:0;a:2:{i:0;O:1:\"Q\":3:{i:0;i:0;i:1;i:0;i:2;a:1:{s:30:\"threadentriesflagshasbit\";i:4;}}i:1;N;}}s:4:\"else\";O:8:\"SqlField\":5:{s:5:\"alias\";N;s:8:\"operator\";N;s:8:\"operands\";N;s:5:\"level\";i:0;s:5:\"field\";s:19:\"threadentriesid\";}s:4:\"func\";s:4:\"CASE\";s:4:\"args\";a:0:{}}s:8:\"distinct\";b:1;s:10:\"constraint\";b:0;}}s:5:\"extra\";a:0:{}s:8:\"distinct\";a:0:{}s:4:\"lock\";b:0;s:5:\"chain\";a:0:{}s:7:\"options\";a:0:{}s:4:\"iter\";i:2;s:8:\"compiler\";s:13:\"MySqlCompiler\";}', session_updated = NOW() WHERE ost_session.session_id = 'o1neu0kdhej58ucf0eq6n4k37g' LIMIT 1" string(45) "SELECT A1.id, A1.name FROM ost_event A1"

HansAlbers

I apologize beforehand in case this is not the output you were looking for. I would need to understand how to capture the correct part that you need, I currently don't know that.