Unable to insert host_pci_device

[mmulesa]

Server version: 8.0.15 MySQL Community Server
Unable to insert, issue in column 'function', no column shielding in query

trace
Got 0 host_pci_device objects from DB

Storing host_pci_device[] failed: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'function, class_id, device_id, device_name, sub_device_id, vendor_id, vendor_nam' at line 1, query was: INSERT INTO host_pci_device (id, host_uuid, bus, slot, function, class_id, device_id, device_name, sub_device_id, vendor_id, vendor_name, sub_vendor_id, parent_bridge, vcenter_uuid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) {array (
'id' => '0000:00:00.0',
'host_uuid' => '̿{)\ N',
'bus' => '' . "\0" . '',
'slot' => '' . "\0" . '',
'function' => '' . "\0" . '',
'class_id' => 1536,
'device_id' => 3584,
'device_name' => 'Xeon E7 v2/Xeon E5 v2/Core i7 DMI2',
'sub_device_id' => 257,
'vendor_id' => -32634,
'vendor_name' => 'Intel Corporation',
'sub_vendor_id' => 4407,
'parent_bridge' => NULL,
'vcenter_uuid' => 'FmTh!P',
)}

[mmulesa]

HostPciDevice.php
worked for me

function in "`"

protected $defaultProperties
'function' => null

protected $propertyMap
'function' => 'function'

[Thomas-Gelf]

Thanks for reporting this! I faced this before, but then forgot about it.

[rychannel]

Any updates / workarounds for this?

[Thomas-Gelf]

@rychannel: does the workaround shown by @mmulesa work for you?

[rychannel]

To be honest, looking at their post, I'm not exactly sure what I'm supposed to do.