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(), ];