Bonjour,
Afin de tester la nouvelle version (3.2.56) de gestsup dans notre infra nous avons mis à jour notre environnement de qualité.
Cependant lors de nos tests pour créer un ticket nous obtenons l'erreur suivante :
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('admin.gestsup'@'%') does not exist in /var/www/html/core/ticket.php:413 Stack trace: #0 /var/www/html/core/ticket.php(413): PDOStatement->execute(Array) #1 /var/www/html/ticket.php(95): include('/var/www/html/c...') #2 /var/www/html/main.php(532): include('/var/www/html/t...') #3 /var/www/html/index.php(408): require('/var/www/html/m...') #4 {main} thrown in /var/www/html/core/ticket.php on line 413
OS : debian
Version de php 8.2.29
Merci d'avance pour votre aide
Problème lors de création de ticket
erreur supplémentaire :
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation in /var/www/html/core/ticket.php:407 Stack trace: #0 /var/www/html/core/ticket.php(407): PDOStatement->execute(Array) #1 /var/www/html/ticket.php(95): include('/var/www/html/c...') #2 /var/www/html/main.php(532): include('/var/www/html/t...') #3 /var/www/html/index.php(408): require('/var/www/html/m...') #4 {main} thrown in /var/www/html/core/ticket.php on line 407
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation in /var/www/html/core/ticket.php:407 Stack trace: #0 /var/www/html/core/ticket.php(407): PDOStatement->execute(Array) #1 /var/www/html/ticket.php(95): include('/var/www/html/c...') #2 /var/www/html/main.php(532): include('/var/www/html/t...') #3 /var/www/html/index.php(408): require('/var/www/html/m...') #4 {main} thrown in /var/www/html/core/ticket.php on line 407