Forum GLPI-Project

WebGreg

Member

Registered: 2020-02-27

Posts: 740

MySQL query warning - DOUBLE value - how to fix?

Hi

How do you solve problems with duplicate values? In the log I found this entry:

  SQL: SELECT `glpi_peripherals`.`id`, `networkports_mac`.`id` AS `portid_mac`, `networkports_ifnumber`.`id` AS `portid_ifnumber` FROM `glpi_peripherals` LEFT JOIN `glpi_networkports` AS `networkports_mac` ON (`glpi_peripherals`.`i
d` = `networkports_mac`.`items_id` AND `networkports_mac`.`itemtype` = 'Peripheral') LEFT JOIN `glpi_networkports` AS `networkports_ifnumber` ON (`glpi_peripherals`.`id` = `networkports_ifnumber`.`items_id` AND `networkports_ifnumb
er`.`itemtype` = 'Peripheral') WHERE (`networkports_mac`.`mac` IN ('74:xx:xx:xx:xx:b0')) AND (`networkports_ifnumber`.`logical_number` = 'bridge/BAGG2/sfp-sfpplus6')
  Warnings:
1292: Truncated incorrect DOUBLE value: 'bridge/BAGG2/sfp-sfpplus6'

SOLVED - after update 10.0.4 > 10.0.6-dev looks OK.

Last edited by WebGreg (2023-01-04 12:13:14)

---

--
GLPI 10.0.17
GLPI-Inventory 1.4.0
Ubuntu Server 20.04 LTS

WebGreg

Member

Registered: 2020-02-27

Posts: 740

Re: MySQL query warning - DOUBLE value - how to fix?

Any hint how to fix it?

---

--
GLPI 10.0.17
GLPI-Inventory 1.4.0
Ubuntu Server 20.04 LTS

WebGreg

Member

Registered: 2020-02-27

Posts: 740

Re: MySQL query warning - DOUBLE value - how to fix?

---

--
GLPI 10.0.17
GLPI-Inventory 1.4.0
Ubuntu Server 20.04 LTS

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,813

Website

Re: MySQL query warning - DOUBLE value - how to fix?

"Truncated incorrect DOUBLE value" refers to the "double" numeric type which is basically a decimal number, not duplicate. SQL warnings were enabled for 10.0 so in cases where we are accidentally trying to search for a text value in numeric columns there is now this warning shown. It is a bug.

---

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: 740

Re: MySQL query warning - DOUBLE value - how to fix?

Hi cconard96. Thank you for your response.

Should I register a new issue with this message or just wait because you know about it?

---

--
GLPI 10.0.17
GLPI-Inventory 1.4.0
Ubuntu Server 20.04 LTS

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,813

Website

Re: MySQL query warning - DOUBLE value - how to fix?

Please open an issue on the GitHub. I'm working on another project/feature so I may accidentally forget to look into this when I have a chance to switch tasks.
Please include the full stack trace too from the sql-errors.log log file.

---

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: 740

Re: MySQL query warning - DOUBLE value - how to fix?

https://github.com/glpi-project/glpi/issues/13522

---

--
GLPI 10.0.17
GLPI-Inventory 1.4.0
Ubuntu Server 20.04 LTS

WebGreg

Member

Registered: 2020-02-27

Posts: 740

Re: MySQL query warning - DOUBLE value - how to fix?

Up

---

--
GLPI 10.0.17
GLPI-Inventory 1.4.0
Ubuntu Server 20.04 LTS