Hi,
ich habe eine unschöne Fehlermeldung im Support Data Connector.
habe alle invaled Angent überprüft, leider keine Tickets gefunden. Also Sauber.
Cache habe ich auch geleert, aber die Meldung bleibt.
Habt ihr Idee, wie ich direkt aus der DB löschen kann.
Danke für die Hilfe
There are invalid users with locked tickets
There are invalid users with locked tickets
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 3963
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: There are invalid users with locked tickets
Hi,
na die Meldung wir schon stimmen. Damit kannst Du das in der SQL-Box mal prüfen und sehen welche Tickets das sind:
SELECT id,tn,title
FROM ticket
WHERE user_id IN (SELECT id FROM users WHERE valid_id<>(SELECT id FROM valid WHERE name='valid'))
AND ticket_lock_id IN (SELECT id FROM ticket_lock_type WHERE name='lock')
- Roy
na die Meldung wir schon stimmen. Damit kannst Du das in der SQL-Box mal prüfen und sehen welche Tickets das sind:
SELECT id,tn,title
FROM ticket
WHERE user_id IN (SELECT id FROM users WHERE valid_id<>(SELECT id FROM valid WHERE name='valid'))
AND ticket_lock_id IN (SELECT id FROM ticket_lock_type WHERE name='lock')
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Re: There are invalid users with locked tickets
Hallo Roy,
Dankeschön, hat funktioniert.
Dankeschön, hat funktioniert.
-
- Administrator
- Posts: 3963
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: There are invalid users with locked tickets
Hi,
schön zu hören. War dann wohl nicht so sauber
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?