[SOLVED] SQL Warning after update from 9 to 10

WebGreg · 2022-08-23 17:17:51

Hi.

Today I noticed that when I go to Assets > Computers and sort by IP, I get a warning:

SQL Warnings: 
1411: Incorrect string value: '`glpidb`.`glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`name`' for function inet_aton 
1411: Incorrect string value: '`glpidb`.`glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`name`' for function inet_aton 
1411: Incorrect string value: '`glpidb`.`glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`name`' for function inet_aton 
1411: Incorrect string value: '`glpidb`.`glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`name`' for function inet_aton 
1411: Incorrect string value: '`glpidb`.`glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`name`' for function inet_aton 
1411: Incorrect string value: '`glpidb`.`glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`name`' for function inet_aton in query 
"SELECT DISTINCT `glpi_computers`.`id` AS id, 'myuser' AS currentuser, `glpi_computers`.`entities_id`, `glpi_computers`.`is_recursive`,
 `glpi_computers`.`name` AS `ITEM_Computer_1`, `glpi_computers`.`id` AS `ITEM_Computer_1_id`, 
GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`name`, '__NULL__'), '$#$',`glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`id`) 
ORDER BY `glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`id` SEPARATOR '$$##$$') 
AS `ITEM_Computer_126`, `glpi_agents`.`last_contact` 
AS `ITEM_Computer_902`, `glpi_computers`.`date_mod` 
AS `ITEM_Computer_19`, `glpi_computers`.`contact` 
AS `ITEM_Computer_7`, `glpi_locations`.`completename` 
AS `ITEM_Computer_3`, `glpi_computers`.`otherserial` 
AS `ITEM_Computer_6`, `glpi_states`.`completename` 
AS `ITEM_Computer_31`, `glpi_computers`.`serial`
AS `ITEM_Computer_5`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_computerantiviruses`.`is_uptodate`, '__NULL__'), '$#$',`glpi_computerantiviruses`.`id`) 
ORDER BY `glpi_computerantiviruses`.`id` SEPARATOR '$$##$$') 
AS `ITEM_Computer_170`, `glpi_sockets`.`id` 
AS `ITEM_Computer_1310`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_sockets_4371a472fe73b6d359d0ff27ed58927e`.`name`, '__NULL__'), '$#$',`glpi_sockets_4371a472fe73b6d359d0ff27ed58927e`.`id`) 
ORDER BY `glpi_sockets_4371a472fe73b6d359d0ff27ed58927e`.`id` SEPARATOR '$$##$$') 
AS `ITEM_Computer_22`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_plugin_tag_tags_23e0c5a3c33f9fc3341d81fc24a0e3a5`.`name`, '__NULL__'), '$#$',`glpi_plugin_tag_tags_23e0c5a3c33f9fc3341d81fc24a0e3a5`.`id`) 
ORDER BY `glpi_plugin_tag_tags_23e0c5a3c33f9fc3341d81fc24a0e3a5`.`id` SEPARATOR '$$##$$') 
AS `ITEM_Computer_10500`, `glpi_operatingsystemversions_9719987b154aaf3b42c3db32aef59090`.`name` 
AS `ITEM_Computer_46`, `glpi_operatingsystemeditions_9719987b154aaf3b42c3db32aef59090`.`name` 
AS `ITEM_Computer_63`, `glpi_computermodels`.`name` 
AS `ITEM_Computer_40`, `glpi_agents`.`version` 
AS `ITEM_Computer_903`, `glpi_agents`.`name` 
AS `ITEM_Computer_900`, `glpi_agents`.`id` 
AS `ITEM_Computer_900_id`, `glpi_computers`.`date_creation` 
AS `ITEM_Computer_121`, `glpi_computers`.`comment` 
AS `ITEM_Computer_16` FROM `glpi_computers` LEFT JOIN `glpi_ipaddresses`
AS `glpi_ipaddresses_937b8c393ea02752d06397f2628684f5` ON (`glpi_computers`.`id` = `glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`mainitems_id` 
AND `glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`mainitemtype` = 'Computer' 
AND `glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`is_deleted` = '0' ) 
LEFT JOIN `glpi_agents` ON (`glpi_computers`.`id` = `glpi_agents`.`items_id` AND `glpi_agents`.`itemtype` = 'Computer' ) 
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` = `glpi_locations`.`id` ) 
LEFT JOIN `glpi_links_itemtypes` ON (`glpi_links_itemtypes`.`itemtype` = 'Computer' ) 
LEFT JOIN `glpi_links` AS `glpi_links_ff2a378adbb623734295d631bc0c6584` ON (`glpi_links_itemtypes`.`links_id` = `glpi_links_ff2a378adbb623734295d631bc0c6584`.`id` )
LEFT JOIN `glpi_states` ON (`glpi_computers`.`states_id` = `glpi_states`.`id` ) 
LEFT JOIN `glpi_computerantiviruses` ON (`glpi_computers`.`id` = `glpi_computerantiviruses`.`computers_id` ) 
LEFT JOIN `glpi_sockets` ON (`glpi_computers`.`id` = `glpi_sockets`.`items_id` AND `glpi_sockets`.`itemtype` = 'Computer' ) 
LEFT JOIN `glpi_networkports` ON (`glpi_computers`.`id` = `glpi_networkports`.`items_id` AND `glpi_networkports`.`itemtype` = 'Computer' ) 
LEFT JOIN `glpi_networkportethernets` AS `glpi_networkportethernets_23c902de5f3b180b2aef9e32e62e03a6` 
ON (`glpi_networkports`.`id` = `glpi_networkportethernets_23c902de5f3b180b2aef9e32e62e03a6`.`networkports_id` ) 
LEFT JOIN `glpi_sockets` AS `glpi_sockets_4371a472fe73b6d359d0ff27ed58927e` ON (`glpi_networkportethernets_23c902de5f3b180b2aef9e32e62e03a6`.`id` = `glpi_sockets_4371a472fe73b6d359d0ff27ed58927e`.`networkports_id` ) 
LEFT JOIN `glpi_plugin_tag_tagitems` ON (`glpi_computers`.`id` = `glpi_plugin_tag_tagitems`.`items_id` AND `glpi_plugin_tag_tagitems`.`itemtype` = 'Computer' ) 
LEFT JOIN `glpi_plugin_tag_tags` AS `glpi_plugin_tag_tags_23e0c5a3c33f9fc3341d81fc24a0e3a5` ON (`glpi_plugin_tag_tagitems`.`plugin_tag_tags_id` = `glpi_plugin_tag_tags_23e0c5a3c33f9fc3341d81fc24a0e3a5`.`id` ) 
LEFT JOIN `glpi_items_operatingsystems` ON (`glpi_computers`.`id` = `glpi_items_operatingsystems`.`items_id` AND `glpi_items_operatingsystems`.`itemtype` = 'Computer' ) 
LEFT JOIN `glpi_operatingsystemversions` AS `glpi_operatingsystemversions_9719987b154aaf3b42c3db32aef59090` ON (`glpi_items_operatingsystems`.`operatingsystemversions_id` = `glpi_operatingsystemversions_9719987b154aaf3b42c3db32aef59090`.`id` )
LEFT JOIN `glpi_operatingsystemeditions` AS `glpi_operatingsystemeditions_9719987b154aaf3b42c3db32aef59090` ON (`glpi_items_operatingsystems`.`operatingsystemeditions_id` = `glpi_operatingsystemeditions_9719987b154aaf3b42c3db32aef59090`.`id` )
LEFT JOIN `glpi_computermodels` ON (`glpi_computers`.`computermodels_id` = `glpi_computermodels`.`id` ) WHERE `glpi_computers`.`is_deleted` = 0 AND `glpi_computers`.`is_template` = 0 GROUP BY `glpi_computers`.`id` 
ORDER BY INET_ATON(`glpi_ipaddresses_937b8c393ea02752d06397f2628684f5`.`name`) ASC LIMIT 30, 15"

Last edited by WebGreg (2022-08-26 17:14:26)

WebGreg · 2022-08-25 12:00:03

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

WebGreg · 2022-08-26 17:18:10

The problem was with inet_aton function.
The developers changed it to inet6_aton - IPv6 version.

Forum GLPI-Project

Announcement

#1 2022-08-23 17:17:51

[SOLVED] SQL Warning after update from 9 to 10

#2 2022-08-25 12:00:03

Re: [SOLVED] SQL Warning after update from 9 to 10

#3 2022-08-26 17:18:10

Re: [SOLVED] SQL Warning after update from 9 to 10

Board footer