{"action":"created","issue":{"url":"https://api.github.com/repos/pluginsGLPI/formcreator/issues/1385","repository_url":"https://api.github.com/repos/pluginsGLPI/formcreator","labels_url":"https://api.github.com/repos/pluginsGLPI/formcreator/issues/1385/labels{/name}","comments_url":"https://api.github.com/repos/pluginsGLPI/formcreator/issues/1385/comments","events_url":"https://api.github.com/repos/pluginsGLPI/formcreator/issues/1385/events","html_url":"https://github.com/pluginsGLPI/formcreator/issues/1385","id":431964417,"node_id":"MDU6SXNzdWU0MzE5NjQ0MTc=","number":1385,"title":"Bug avec les apostrophes","user":{"login":"bbouillonmons","id":49519665,"node_id":"MDQ6VXNlcjQ5NTE5NjY1","avatar_url":"https://avatars1.githubusercontent.com/u/49519665?v=4","gravatar_id":"","url":"https://api.github.com/users/bbouillonmons","html_url":"https://github.com/bbouillonmons","followers_url":"https://api.github.com/users/bbouillonmons/followers","following_url":"https://api.github.com/users/bbouillonmons/following{/other_user}","gists_url":"https://api.github.com/users/bbouillonmons/gists{/gist_id}","starred_url":"https://api.github.com/users/bbouillonmons/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bbouillonmons/subscriptions","organizations_url":"https://api.github.com/users/bbouillonmons/orgs","repos_url":"https://api.github.com/users/bbouillonmons/repos","events_url":"https://api.github.com/users/bbouillonmons/events{/privacy}","received_events_url":"https://api.github.com/users/bbouillonmons/received_events","type":"User","site_admin":false},"labels":[{"id":118186334,"node_id":"MDU6TGFiZWwxMTgxODYzMzQ=","url":"https://api.github.com/repos/pluginsGLPI/formcreator/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":{"login":"btry","id":14139801,"node_id":"MDQ6VXNlcjE0MTM5ODAx","avatar_url":"https://avatars2.githubusercontent.com/u/14139801?v=4","gravatar_id":"","url":"https://api.github.com/users/btry","html_url":"https://github.com/btry","followers_url":"https://api.github.com/users/btry/followers","following_url":"https://api.github.com/users/btry/following{/other_user}","gists_url":"https://api.github.com/users/btry/gists{/gist_id}","starred_url":"https://api.github.com/users/btry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/btry/subscriptions","organizations_url":"https://api.github.com/users/btry/orgs","repos_url":"https://api.github.com/users/btry/repos","events_url":"https://api.github.com/users/btry/events{/privacy}","received_events_url":"https://api.github.com/users/btry/received_events","type":"User","site_admin":false},"assignees":[{"login":"btry","id":14139801,"node_id":"MDQ6VXNlcjE0MTM5ODAx","avatar_url":"https://avatars2.githubusercontent.com/u/14139801?v=4","gravatar_id":"","url":"https://api.github.com/users/btry","html_url":"https://github.com/btry","followers_url":"https://api.github.com/users/btry/followers","following_url":"https://api.github.com/users/btry/following{/other_user}","gists_url":"https://api.github.com/users/btry/gists{/gist_id}","starred_url":"https://api.github.com/users/btry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/btry/subscriptions","organizations_url":"https://api.github.com/users/btry/orgs","repos_url":"https://api.github.com/users/btry/repos","events_url":"https://api.github.com/users/btry/events{/privacy}","received_events_url":"https://api.github.com/users/btry/received_events","type":"User","site_admin":false}],"milestone":null,"comments":4,"created_at":"2019-04-11T11:10:04Z","updated_at":"2019-04-11T12:50:36Z","closed_at":null,"author_association":"NONE","body":"Bonjour,\r\n\r\nGLPI 9.4.1.1 - FormCreator v 2.8.0\r\n\r\nNous avons connu un petit problème hier dans le plugin FormCreator.\r\nNos formulaires étaient créés depuis un bon moment, et nous testions la mise à disposition pour notamment les utilisateurs.\r\nD'un seul coup, les questions de deux de nos formulaires ont complètement disparu, et aucun solution ne pouvait être trouvée, excepté un imort d'une sauvegarde des formulaires que nous avions fait précédemment.\r\n\r\nEn examinant de plus près, voilà l'erreur que nous avons découvert :\r\n\r\n\r\n[2019-04-10 14:49:04] glpisqllog.ERROR: DBmysql::query() in /var/www/glpi/inc/dbmysql.class.php line 177\r\n   MySQL query error:\r\n  SQL: UPDATE `glpi_plugin_formcreator_questions` SET `values` = 'L'imprimante ne s'allume pas\r\nL'imprimante n'imprime rien\r\nBourrage papier\r\nTraces noires ou grises lors de l'impression\r\nTraces blanches lors de l'impression\r\n' WHERE `id` = '222'\r\n  Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'imprimante ne s'allume pas\r\nL'imprimante n'imprime rien\r\nBourrage papier\r\n\r\n\r\nIl semble qu'il y ait des problèmes pour l'interprétation de l'apostrophe dans le plugin, et cela cause la suppression des questions dans les formulaires et dans la DB.\r\n\r\nBien à vous,"},"comment":{"url":"https://api.github.com/repos/pluginsGLPI/formcreator/issues/comments/482100818","html_url":"https://github.com/pluginsGLPI/formcreator/issues/1385#issuecomment-482100818","issue_url":"https://api.github.com/repos/pluginsGLPI/formcreator/issues/1385","id":482100818,"node_id":"MDEyOklzc3VlQ29tbWVudDQ4MjEwMDgxOA==","user":{"login":"btry","id":14139801,"node_id":"MDQ6VXNlcjE0MTM5ODAx","avatar_url":"https://avatars2.githubusercontent.com/u/14139801?v=4","gravatar_id":"","url":"https://api.github.com/users/btry","html_url":"https://github.com/btry","followers_url":"https://api.github.com/users/btry/followers","following_url":"https://api.github.com/users/btry/following{/other_user}","gists_url":"https://api.github.com/users/btry/gists{/gist_id}","starred_url":"https://api.github.com/users/btry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/btry/subscriptions","organizations_url":"https://api.github.com/users/btry/orgs","repos_url":"https://api.github.com/users/btry/repos","events_url":"https://api.github.com/users/btry/events{/privacy}","received_events_url":"https://api.github.com/users/btry/received_events","type":"User","site_admin":false},"created_at":"2019-04-11T12:50:36Z","updated_at":"2019-04-11T12:50:36Z","author_association":"CONTRIBUTOR","body":"De ce que je vois les questions n'ont pas disparu. Je pense que vous avez tenté d'importer un formulaire précédemment exporté en JSON.\r\n\r\nLe formulaire n'existait pas au moment de l'import et certaines questions contenant une apostrophe n'ont pas pu être créées pour les raisons que vous avez identifié.\r\n\r\n"}}
{"actor":{"display_login":"btry"}}