search

JulioAugustoS / glpi-orderservice

Plugin that generates order of services through the tickets
GNU General Public License v3.0
5 stars 7 forks source link

SQL Error #11

Open roshanroche opened 6 years ago

roshanroche commented 6 years ago

Hi, i tried to install the plugin on Glpi9.2.4 and 9.3.0 im getting this error while clicking on the plugin link. image

im getting the following errors in Sql logs

SQL: INSERT INTO glpi_plugins (name,version,author,license,homepage,state,directory) VALUES ('Ordem de Servio','2.0.0','<a href=\"mailto:contato@julioaugusto.me\">Julio Augusto','GPLv3','https://github.com/JulioAugustoS/glpiorderservice','2','orderservice') Error: Duplicate entry 'orderservice' for key 'unicity'

** MySQL query error: SQL: SELECT content FROM glpi_itilsolutions WHERE itemtype = 'Ticket' AND items_id = '12' AND status = 3 ORDER BY id DESC LIMIT 1

Error: Table 'gshelpdesk9.2.4.glpi_itilsolutions' doesn't exist Backtrace : plugins/orderservice/inc/common.class.php:146
plugins/orderservice/inc/common.class.php:180 CommonOrderService::selTicketSolution() plugins/orderservice/inc/orderservice.class.php:51 CommonOrderService->selDates() plugins/orderservice/setup.php:80 PluginOrderService->printOsTicketOpen() plugins/orderservice/setup.php:111 PluginOrderServiceConfig::showForTicket() inc/commonglpi.class.php:482 PluginOrderServiceConfig::displayTabContentForItem() ajax/common.tabs.php:96 CommonGLPI::displayStandardTab()

JulioAugustoS commented 6 years ago

Hello, do you have any other plugins installed in this glpi?

roshanroche commented 6 years ago

hi @JulioAugustoS , yes i have other plugins installed as well.

Plugins list

Barcode | 2.1.0 | AGPLv3+ | Enabled | David DURIEUX & Jean Marc GRISARD & Vincent MAZZONI |   | Yes | Disable | Uninstall Behaviours | 2.0.2 | AGPLv3+ | Enabled | Remi Collet, Nelly Mahu-Lasson |   | Yes | Disable | Uninstall Dashboard | 0.9.4 | GPLv2+ | Enabled | Stevenes Donato |   | Yes | Disable | Uninstall Escalation | 2.2.3 | GPLv2+ | Enabled | Teclib' |   | Yes | Disable | Uninstall File injection | 2.5.2 | GPLv2+ | Enabled | Walid Nouh, Remi Collet, Nelly Mahu-Lasson, Xavier Caillaud |   | Yes | Disable | Uninstall FusionInventory | 9.2+2.0 | AGPLv3+ | Enabled | David DURIEUX & FusionInventory team |   | Yes | Disable | Uninstall GLPI Modifications | 1.1.9 | GPLv2+ | Enabled | Stevenes Donato |   | Yes | Disable | Uninstall ItilCategory Groups | 2.0.2 |   | Enabled | TECLIB' |   | Yes | Disable | Uninstall More Reporting | 1.4.1 | GPLv2+ | Enabled | Teclib' & Infotel |   | Yes | Disable | Uninstall More satisfaction | 1.2.1 | GPLv2+ | Enabled | TECLIB', Infotel |   | Yes | Disable | Uninstall Objects management | 2.5.2 | GPLv2+ | Enabled | Teclib' & siprossii |   | Yes | Disable | Uninstall Ordem de Serviço | 2.0.0 | GPLv3 | Enabled | Julio Augusto |   | Yes | Disable | Uninstall Others alerts | 2.0.0 | GPLv2+ | Enabled | Infotel / Konstantin Kabassanov |   | Yes | Disable | Uninstall Print to pdf | 1.3.1.1 | GPLv3+ | Enabled | Remi Collet, Nelly Mahu-Lasson |   | Yes | Disable | Uninstall Printer counters | 1.4.1 | GPLv2+ | Enabled | Infotel |   | Yes | Disable | Uninstall Process Maker | 3.2.8 |   | Enabled | Olivier Moron |   | Yes | Disable | Uninstall Reports | 1.11.3 | GPLv3+ | Enabled | Nelly Mahu-Lasson, Remi Collet |   | Yes | Disable | Uninstall Sim cards management | 1.4.2 | GPLv2+ | Enabled | El Sendero, Walid Nouh, Thierry Bugier Pineau, Anthony Piesset, Dethegeek |   | Yes | Disable | Uninstall Timeline of tickets | 9.2+1.0 | AGPLv3+ | Enabled | Nelly Mahu-Lasson && David Durieux && Xavier Caillaud |   | Yes | Disable | Uninstall Timezones | 2.2.0 | GPLv2+ | Enabled | Olivier Moron |   | Yes | Disable | Uninstall

JulioAugustoS commented 6 years ago

Hello Friend, as I could see in the message that you sent the error, the same is occurring when trying to install the plugin, do the following click unseal the orderservice plugin so that his table in the database is deleted, remove the glpi plugin folder, va in the list of plugins and click clean where my plugin is, then paste the folder again into the glpi plugins and try to install again.

Matheushfb commented 6 years ago

Hello @JulioAugustoS i don't have any extra plugins and has the same problem.....

JulioAugustoS commented 6 years ago

Hello friend, very strange because I am using it in my glpi and has a company that also uses without problems, but I will do a test installing version 9.2.4 of glpi and return with a feedback for you.

NiiL762 commented 6 years ago

Hello friends,

I have the same problem, any ideas?