You are not logged in.
Hi
I got such an error:
SQL Error "1062": Duplicate entry '12-0' for key 'glpi_plugin_mreporting_profiles.profiles_id_reports' in query "INSERT INTO `glpi_plugin_mreporting_profiles` (`profiles_id`) VALUES ('12')"
I'm getting this error after installing the plugin > going to any profile > clicking on the save button (without any configuration of profile permissions).
How can I solve it?
GLPI 10.0.7
Last edited by WebGreg (2023-07-25 14:03:39)
--
GLPI 10.0.7
GLPI-Inventory 1.2.1
Ubuntu Server 20.04 LTS
Offline
Which version of the mreporting plugin do you have installed?
GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.
Offline
1.8.2
--
GLPI 10.0.7
GLPI-Inventory 1.2.1
Ubuntu Server 20.04 LTS
Offline
Do you have the full stacktrace from the files/_log/sql-errors.log log?
GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.
Offline
[2023-07-26 18:58:19] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370
*** MySQL query error:
SQL: INSERT INTO `glpi_plugin_mreporting_profiles` (`profiles_id`) VALUES ('12')
Error: Duplicate entry '12-0' for key 'glpi_plugin_mreporting_profiles.profiles_id_reports'
Backtrace :
src/DBmysql.php:1320
src/CommonDBTM.php:722 DBmysql->insert()
src/CommonDBTM.php:1317 CommonDBTM->addToDB()
marketplace/mreporting/inc/profile.class.php:184 CommonDBTM->add()
marketplace/mreporting/inc/profile.class.php:86 PluginMreportingProfile->createAccess()
src/CommonGLPI.php:689 PluginMreportingProfile::displayTabContentForItem()
ajax/common.tabs.php:116 CommonGLPI::displayStandardTab()
public/index.php:73 require()
--
GLPI 10.0.7
GLPI-Inventory 1.2.1
Ubuntu Server 20.04 LTS
Offline
I confirm the issue, although I don't really know that much about the plugin so making a fix may take a while.
GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.
Offline
Hi.
I don't know if I did the right thing, but I opened an issue on guthub, but there is only the option to report vulnerabilities.
--
GLPI 10.0.7
GLPI-Inventory 1.2.1
Ubuntu Server 20.04 LTS
Offline
More Reporting is one of the plugins that only has community support on the forums, or support through GLPI Network, so bug reports aren't open on GitHub for it.
GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.
Offline