Forum GestSup

Bonjour,

Lors de la création d'un ticket j'ai ces messages. Avez vous eu ce souci

SELECT DISTINCT tincidents.*
FROM tincidents, tstates WHERE tincidents.state=tstates.id AND tincidents.user LIKE '%' AND tincidents.u_group LIKE '%' AND tincidents.technician LIKE '1' AND tincidents.t_group LIKE '%' AND tincidents.techread LIKE '%' AND tincidents.disable='0' AND (tincidents.category LIKE '%') AND tincidents.subcat LIKE '%' AND tincidents.id LIKE '%' AND tincidents.user LIKE '%' AND tincidents.date_create LIKE '%%' AND tincidents.state LIKE '1' AND tincidents.priority LIKE '%' AND tincidents.criticality LIKE '%' AND tincidents.title LIKE '%%%'
ORDER BY tstates.number, tincidents.priority, tincidents.criticality, tincidents.date_create DESC
LIMIT 0, 14

SELECT COUNT(DISTINCT tincidents.id)
FROM tincidents, tstates WHERE tincidents.state=tstates.id AND tincidents.user LIKE '%' AND tincidents.u_group LIKE '%' AND tincidents.technician LIKE '1' AND tincidents.t_group LIKE '%' AND tincidents.techread LIKE '%' AND tincidents.disable='0' AND (tincidents.category LIKE '%') AND tincidents.subcat LIKE '%' AND tincidents.id LIKE '%' AND tincidents.user LIKE '%' AND tincidents.date_create LIKE '%%' AND tincidents.state LIKE '1' AND tincidents.priority LIKE '%' AND tincidents.criticality LIKE '%' AND tincidents.title LIKE '%%%'

Tu dois être en mode débuggage, c'est pour ça qu'il t'affiche les requêtes SQL de la page en cours.

Tout à fait merci beaucoup.

Bon week-end