Sep 2024
6 / 6
Oct 2024
Oct 2024
grochap
Sep '24

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:

screenshot-itabio_com_br-2024_09_20-09_33_25
screenshot-itabio_com_br-2024_09_20-09_33_25.png1920x911 110 KB

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

Thank you in advance

  • created

    Sep '24

  • last reply

    Oct '24
  • 5

    replies

  • 272

    views

  • 3

    users

  • 3

    likes

  • 3
RalfBeckerEGroupware GmbH
Sep '24

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

21 days later
artuselias
Oct '24

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.

RalfBeckerEGroupware GmbH
Oct '24

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

RalfBeckerEGroupware GmbH
Oct '24

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
Oct '24

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);