Default Tracker Queue

grochap 2024-09-20 12:40:57 UTC #1

Hi folks, nice to be here again.

We have deleted the tracker’s queue, and now we are not able ro create new ones.
We investigated into DB and not found where this is stored, neither config or tracker tables.

Now, any change in the tracker config is not being saved because an error complaining about the “default tracker queue”.

Error message:

How we can re-create a new default queue? in App or DB

Thank you in advance

RalfBecker 2024-09-23 08:10:08 UTC #2

8 is probably your old default, the one you deleted.

You need to select a new default.

It’s stored in egw_config table:

SELECT * FROM egw_config WHERE config_app='tracker' and config_name='default_tracker'

If you change something in egw_config directly in the DB, make sure to delete the cache (Admin > Clear cache and register hooks), it will have NO effect otherwise!

Ralf

artuselias 2024-10-14 13:51:41 UTC #3

I have the same issue.

 SELECT * FROM egw_config WHERE config_app='tracker' and config_name='default_tracker'

This returns 8.
I guess I need to add a queue manually, but I have no idea which values I need to insert to which table.

RalfBecker 2024-10-15 06:15:40 UTC #4

Mit dem folgenden SQL kannst Du die erste (noch existierende) Queue als Default Queue setzen:

REPLACE INTO egw_config (config_app, config_name, config_value) VALUES ('tracker','default_queue', (SELECT cat_id FROM egw_categories WHERE cat_appname='tracker' AND cat_data LIKE '%"tracker"%' limit 1))

Wie schon geschrieben: nach Änderungen in egw_config muss der Cache gelöscht werden!

Ralf

RalfBecker 2024-10-15 06:18:55 UTC #5

Gerade nochmal geschaut, ich kann dort aber auch, ohne irgendwas in der Datenbank zu machen, einfach eine gültige Queue auswählen.

Oder habt Ihr alle Queues gelöscht?

Ralf

artuselias 2024-10-15 08:11:51 UTC #6

Yes, the problem is that I deleted all of the queues (that shouldn’t be possible right?)
Anyways, thanks to your hint I was able to add a new default queue using this query:

insert into egw_categories (cat_appname, cat_name, cat_description, cat_data, last_mod) values ('tracker', 'Default', 'Default', 'a:1:{s:4:"type";s:7:"tracker";}', 1728979104);