You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2018-07-31 12:47:19

Pomme11
Member
Registered: 2006-07-07
Posts: 35
Website

[FormCreator 2.6.3] Plusieurs bugs

Bonjour,

Avec la version 2.6.3, j'ai plusieurs bugs :
* pas de màj du fil d'infos du ticket
* les compteurs en cours, en attente, validé, fermé sont identiques en valeurs
* les recherches des status des demandes étaient vides alors que des formulaires et tickets avaient été créés
* dans la partie administration : erreur lorsque je voulais visualiser les formulaires saisis (erreur "classique" avec écriture rouge)

J'ai également des erreurs dans les logs

[2018-07-30 16:13:37] glpisqllog.ERROR: DBmysql::query() in /var/www/glpi_9.3/inc/dbmysql.class.php line 180
  *** MySQL query error:
  SQL: SELECT *
                FROM `glpi_tickettasks` WHERE tickets_id =   AND (`is_private` = 0
                                 OR `users_id` ='428')  ORDER BY date DESC
  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (`is_private` = 0
                                 OR `users_id` ='428')  OR' at line 2
  Backtrace :
  inc/commondbtm.class.php:401
  inc/ticket.class.php:6785                          CommonDBTM->find()
  inc/ticket.class.php:6898                          Ticket->getTimelineItems()
  plugins/formcreator/inc/issue.class.php:242        Ticket->showTimeline()
  plugins/formcreator/inc/issue.class.php:161        PluginFormcreatorIssue->displaySimplified()
  plugins/formcreator/front/issue.form.php:65        PluginFormcreatorIssue->display()
  {"user":"428@WebServerTest","mem_usage":"0.001\", 6.22Mio)"}
[2018-07-30 16:13:35] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi_9.3/inc/toolbox.class.php line 657
  *** PHP Notice(8): Undefined variable: id
  Backtrace :
  plugins/formcreator/inc/issue.class.php:486
  plugins/formcreator/hook.php:262                   PluginFormcreatorIssue::giveItem()
  inc/search.class.php:4459                          plugin_formcreator_giveItem()
  inc/search.class.php:1388                          Search::giveItem()
  inc/search.class.php:98                            Search::constructData()
  inc/search.class.php:80                            Search::showList()
  plugins/formcreator/front/issue.php:62             Search::show()
  {"user":"428@WebServerTest","mem_usage":"0.001\", 6.09Mio)"}

Je suis passé en version dévelop, ces erreurs ont disparu : j'ai retrouvé le fil mis à jour ainsi que les bonnes incrémentations des compteurs.
En revanche il est dorénavant impossible aux profils self-service d'accéder aux formulaires afin d'en saisir un nouveau.
Précision : l'accès aux formulaires est "Utilisateur GLPI authentifié" mais j'ai essayé avec toutes les possibilités, sans succès ...
En tant que super admin je peux.

Les erreurs dans les logs sont différentes :

[2018-07-31 10:44:02] glpisqllog.ERROR: DBmysql::query() in /var/www/glpi_9.3/inc/dbmysql.class.php line 180
  *** MySQL query error:
  SQL: SELECT  `glpi_plugin_formcreator_forms`.* FROM `glpi_plugin_formcreator_forms` INNER JOIN `glpi_plugin_formcreator_sections` ON (`glpi_plugin_formcreator_forms`.`id` = `glpi_plugin_formcreator_sections`.`plugin_formcreator_sections_id`) INNER JOIN `glpi_plugin_formcreator_questions` ON (`glpi_plugin_formcreator_questions`.`plugin_formcreator_sections_id` = `glpi_plugin_formcreator_sections`.`id`) WHERE `glpi_plugin_formcreator_questions`.`id` = '33'
  Error: Unknown column 'glpi_plugin_formcreator_sections.plugin_formcreator_sections_id' in 'on clause'
  Backtrace :
  inc/dbmysqliterator.class.php:78
  inc/dbmysql.class.php:583                          DBmysqlIterator->execute()
  inc/commondbtm.class.php:322                       DBmysql->request()
  plugins/formcreator/inc/form.class.php:1267        CommonDBTM->getFromDBByRequest()
  plugins/formcreator/ajax/question_condition.php:52 PluginFormcreatorForm->getByQuestionId()
  {"user":"86@WebServerTest","mem_usage":"0.001\", 3.74Mio)"}
[2018-07-31 11:56:19] glpisqllog.ERROR: DBmysql::query() in /var/www/glpi_9.3/inc/dbmysql.class.php line 180
  *** MySQL query error:
  SQL: SELECT DISTINCT `glpi_reminders`.*
                   FROM `glpi_reminders`  LEFT JOIN `glpi_reminders_users`
                     ON (`glpi_reminders_users`.`reminders_id` = `glpi_reminders`.`id`)  LEFT JOIN `glpi_groups_reminders`
                        ON (`glpi_groups_reminders`.`reminders_id` = `glpi_reminders`.`id`)  LEFT JOIN `glpi_profiles_reminders`
                        ON (`glpi_profiles_reminders`.`reminders_id` = `glpi_reminders`.`id`)  LEFT JOIN `glpi_entities_reminders`
                        ON (`glpi_entities_reminders`.`reminders_id` = `glpi_reminders`.`id`)
                   WHERE `glpi_reminders`.`users_id` <> '86'
                          AND (`glpi_reminders`.`begin_view_date` IS NULL
                                    OR `glpi_reminders`.`begin_view_date` < '2018-07-31 11:56:19')
                              AND (`glpi_reminders`.`end_view_date` IS NULL
                                   OR `glpi_reminders`.`end_view_date` > '2018-07-31 11:56:19')
                         AND (`glpi_reminders`.`users_id` = '86'  OR `glpi_reminders_users`.`users_id` = '86'  OR (`glpi_groups_reminders`.`groups_id`
                                 IN ('1')
                            AND (`glpi_groups_reminders`.`entities_id` < 0
                                 OR (  1 ) ))  OR (`glpi_profiles_reminders`.`profiles_id`
                                 = '4'
                            AND (`glpi_profiles_reminders`.`entities_id` < 0
                                 OR (  1 ) )) OR ( `glpi_entities_reminders`.`entities_id` IN ('0')  ) )
                   ORDER BY `glpi_reminders`.`name`
  Error: MySQL server has gone away
  Backtrace :
  inc/reminder.class.php:1091
  inc/central.class.php:252                          Reminder::showListForCentral()
  inc/central.class.php:80                           Central::showMyView()
  inc/commonglpi.class.php:478                       Central::displayTabContentForItem()
  ajax/common.tabs.php:92                            CommonGLPI::displayStandardTab()
  {"user":"86@WebServerTest","mem_usage":"0.001\", 5.40Mio)"}
[2018-07-31 11:56:19] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi_9.3/inc/toolbox.class.php line 657
  *** PHP Notice(8): Trying to get property of non-object
  Backtrace :
  inc/dbmysql.class.php:287
  inc/reminder.class.php:1092                        DBmysql->numrows()
  inc/central.class.php:252                          Reminder::showListForCentral()
  inc/central.class.php:80                           Central::showMyView()
  inc/commonglpi.class.php:478                       Central::displayTabContentForItem()
  ajax/common.tabs.php:92                            CommonGLPI::displayStandardTab()
  {"user":"86@WebServerTest","mem_usage":"0.000\", 5.40Mio)"}

Dois-je tout supprimer/réinstaller ?


GLPI 9.4.5 - CentOS 7.7 - PHP 7.3.14 - MariaDB 10.4.11
Dashboard 1.7.7 | Data injection  2.7.1 | Diagrammes  2.1.3 | Form Creator 2.9.1 | FusionInventory 9.4+2.3 | Gestion des commandes 2.5.2 | Plus de rapports 1.6.1 | Tableau de bord 0.9.8 | Ticket Cleaner  2.5.1

Offline

#2 2018-07-31 13:12:44

btry
Moderator
Registered: 2015-10-01
Posts: 588

Re: [FormCreator 2.6.3] Plusieurs bugs

Bonjour

Je prévois une vesion 2.6.4 d'ici quelques semaines, créée à partir de la branche de développement. Il y a effectivement une regression dans develop pour accéder aux formulaires. C'est un correctif qui a été validé, mais qui introduit une régression détectée après coup. Je retravaillerai dessus.

L'erreur de colonne inexistante mériterait que vous ouvriez un ticket sur github et que vous fournissiez un moyen simple de reproduire le bug.

L'erreur "MySQL server has gone away" n'a qu'une infime chance d'être liée au plugin (une requête qui ferait planter Mysql est très peu probable et je ne vois pas mieux pour engager la responsabilité du plugin).

La dernière erreur pourrait révéler une incohérence dans la base de données. Si vous désinstallez et réinstallez le plugin vous perdrez les formulaires et les liens entre tickets et formulaires. Cette idée est à exclure autant que possible.


No support with MP - Always run an upgrade task on a testing instance before running it on production! Always backup before any upgrade task!

Offline

#3 2018-07-31 13:46:41

Pomme11
Member
Registered: 2006-07-07
Posts: 35
Website

Re: [FormCreator 2.6.3] Plusieurs bugs

Bonjour,

Je vous remercie pour toutes vos explications.
Je vais remettre la 2.6.3 afin de tenter de reproduire l'erreur pour le github.
Je suis encore en phase test, si la désinstallation/réinstallation peut résoudre des incohérences dans la base de données ça en vaut peut-être la peine.


GLPI 9.4.5 - CentOS 7.7 - PHP 7.3.14 - MariaDB 10.4.11
Dashboard 1.7.7 | Data injection  2.7.1 | Diagrammes  2.1.3 | Form Creator 2.9.1 | FusionInventory 9.4+2.3 | Gestion des commandes 2.5.2 | Plus de rapports 1.6.1 | Tableau de bord 0.9.8 | Ticket Cleaner  2.5.1

Offline

#4 2018-07-31 14:43:23

Pomme11
Member
Registered: 2006-07-07
Posts: 35
Website

Re: [FormCreator 2.6.3] Plusieurs bugs

Bonjour,

Je suis revenu en 2.6.3.
Je n'ai plus l'erreur de colonne inexistante mais j'ai ceci à présent :

[2018-07-31 14:31:16] glpisqllog.ERROR: DBmysql::query() in /var/www/glpi_9.3/inc/dbmysql.class.php line 180
  *** MySQL query error:
  SQL: SELECT *
                FROM `glpi_ticketfollowups` WHERE tickets_id =   AND (`is_private` = 0
                                OR `users_id` ='435')  ORDER BY date DESC
  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (`is_private` = 0
                                OR `users_id` ='435')  ORD' at line 2
  Backtrace :
  inc/commondbtm.class.php:401
  inc/ticket.class.php:6774                          CommonDBTM->find()
  inc/ticket.class.php:6898                          Ticket->getTimelineItems()
  plugins/formcreator/inc/issue.class.php:242        Ticket->showTimeline()
  plugins/formcreator/inc/issue.class.php:161        PluginFormcreatorIssue->displaySimplified()
  plugins/formcreator/front/issue.form.php:65        PluginFormcreatorIssue->display()
  {"user":"435@WebServerTest","mem_usage":"0.008\", 6.17Mio)"}
[2018-07-31 14:31:16] glpisqllog.ERROR: DBmysql::query() in /var/www/glpi_9.3/inc/dbmysql.class.php line 180
  *** MySQL query error:
  SQL: SELECT *
                FROM `glpi_tickettasks` WHERE tickets_id =   AND (`is_private` = 0
                                 OR `users_id` ='435')  ORDER BY date DESC
  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (`is_private` = 0
                                 OR `users_id` ='435')  OR' at line 2
  Backtrace :
  inc/commondbtm.class.php:401
  inc/ticket.class.php:6785                          CommonDBTM->find()
  inc/ticket.class.php:6898                          Ticket->getTimelineItems()
  plugins/formcreator/inc/issue.class.php:242        Ticket->showTimeline()
  plugins/formcreator/inc/issue.class.php:161        PluginFormcreatorIssue->displaySimplified()
  plugins/formcreator/front/issue.form.php:65        PluginFormcreatorIssue->display()
  {"user":"435@WebServerTest","mem_usage":"0.001\", 6.17Mio)"}
[2018-07-31 14:31:16] glpisqllog.ERROR: DBmysql::query() in /var/www/glpi_9.3/inc/dbmysql.class.php line 180
  *** MySQL query error:
  SQL: SELECT *
                FROM `glpi_documents_items` WHERE itemtype = 'Ticket' AND items_id =
  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
  Backtrace :
  inc/commondbtm.class.php:401
  inc/ticket.class.php:6796                          CommonDBTM->find()
  inc/ticket.class.php:6898                          Ticket->getTimelineItems()
  plugins/formcreator/inc/issue.class.php:242        Ticket->showTimeline()
  plugins/formcreator/inc/issue.class.php:161        PluginFormcreatorIssue->displaySimplified()
  plugins/formcreator/front/issue.form.php:65        PluginFormcreatorIssue->display()
  {"user":"435@WebServerTest","mem_usage":"0.001\", 6.17Mio)"}
[2018-07-31 14:37:59] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi_9.3/inc/toolbox.class.php line 657
  *** PHP Notice(8): Undefined index: id
  Backtrace :
  inc/ticket.class.php:7431
  plugins/formcreator/inc/issue.class.php:241        Ticket->showTimelineForm()
  plugins/formcreator/inc/issue.class.php:161        PluginFormcreatorIssue->displaySimplified()
  plugins/formcreator/front/issue.form.php:65        PluginFormcreatorIssue->display()
  {"user":"435@WebServerTest","mem_usage":"0.000\", 5.86Mio)"}
[2018-07-31 14:37:59] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi_9.3/inc/toolbox.class.php line 657
  *** PHP Notice(8): Undefined index: id
  Backtrace :
  inc/ticket.class.php:7245
  plugins/formcreator/inc/issue.class.php:242        Ticket->showTimeline()
  plugins/formcreator/inc/issue.class.php:161        PluginFormcreatorIssue->displaySimplified()
  plugins/formcreator/front/issue.form.php:65        PluginFormcreatorIssue->display()
  {"user":"435@WebServerTest","mem_usage":"0.002\", 6.25Mio)"}

Elle est survenue lorsque j'ai cliqué sur le ticket dans mes demandes d'assistance.
L'historique des actions est vide.
1533040561-capture.png


GLPI 9.4.5 - CentOS 7.7 - PHP 7.3.14 - MariaDB 10.4.11
Dashboard 1.7.7 | Data injection  2.7.1 | Diagrammes  2.1.3 | Form Creator 2.9.1 | FusionInventory 9.4+2.3 | Gestion des commandes 2.5.2 | Plus de rapports 1.6.1 | Tableau de bord 0.9.8 | Ticket Cleaner  2.5.1

Offline

#5 2018-08-10 10:47:32

btry
Moderator
Registered: 2015-10-01
Posts: 588

Re: [FormCreator 2.6.3] Plusieurs bugs

Bonjour

Pouvez-vous reporter sur un ticket github vos rapports de logs ?


No support with MP - Always run an upgrade task on a testing instance before running it on production! Always backup before any upgrade task!

Offline

Board footer

Powered by FluxBB