Forum GLPI-Project

WebGreg

Member

Registered: 2020-02-27

Posts: 729

More reporting - duplicate entry

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

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,424

Website

Re: More reporting - duplicate entry

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.

WebGreg

Member

Registered: 2020-02-27

Posts: 729

Re: More reporting - duplicate entry

1.8.2

---

--
GLPI 10.0.7
GLPI-Inventory 1.2.1
Ubuntu Server 20.04 LTS

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,424

Website

Re: More reporting - duplicate entry

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.

WebGreg

Member

Registered: 2020-02-27

Posts: 729

Re: More reporting - duplicate entry

[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

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,424

Website

Re: More reporting - duplicate entry

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.

WebGreg

Member

Registered: 2020-02-27

Posts: 729

Re: More reporting - duplicate entry

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.

https://github.com/pluginsGLPI/mreporti … -fjxg-gf3w

---

--
GLPI 10.0.7
GLPI-Inventory 1.2.1
Ubuntu Server 20.04 LTS

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,424

Website

Re: More reporting - duplicate entry

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.