Unknown column 'glpi_plugin_room_roomtypes_type.name' in 'field list'

[mrcmdc]

When trying to customize columns to view with type:

Unknown column 'glpi_plugin_room_roomtypes_type.name' in 'field list'

And you can't see the items. Just the error.

GLPI version:
GLPI 10.0.10 Copyright (C) 2015-2023 Teclib' and contributors

[shrinivasmane]

To resolve it

First, update the schema of the table
ALTER TABLE glpi_plugin_room_roomtypes ADD COLUMN type VARCHAR(255);

populate the record if added types for the room
UPDATE glpi_plugin_room_roomtypes SET type = name;

then update the room.class.php from your room plugin directory
my is : /var/www/html/glpi/marketplace/room/inc

update the section below (line 64)

$tab[] = [
'id' => '2',
'table' => 'glpi_plugin_room_roomtypes',
'field' => 'type',
'name' => __('type', 'room'),
'datatype' => 'itemlink',
'itemlink_type' => $this->getType(),
];