[Libki-Users] Error message: Unknown column 'location'
Brought to you by:
kylemhall
|
From: Sean C. <sea...@gm...> - 2026-09-15 07:41:27
|
Since upgrading to r26.08.01, I notice a lot of these messages in the libki_server.log: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'location' in 'where clause' [for Statement "SELECT COUNT( * ) FROM `clients` `me` WHERE ( ( `instance` = ? AND `location` = ? AND `status` = ? ) )" with ParamValues: 0='', 1="Indumiso Research Commons", 2='online'] at /home/libki/libki-server/lib/Libki/Controller/API/Public/Datatables.pm line 69 Even in a new installation, the clients table does not have a location column: DESCRIBE clients; +-----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+----------------+ | instance | varchar(32) | NO | MUL | | | | id | int | NO | PRI | NULL | auto_increment | | name | varchar(191) | NO | | NULL | | | location_id | int | YES | MUL | NULL | | | status | varchar(191) | YES | | online | | | type | varchar(191) | YES | | NULL | | | ipaddress | varchar(191) | YES | | NULL | | | macaddress | varchar(191) | YES | | NULL | | | hostname | varchar(191) | YES | | NULL | | | last_registered | timestamp | YES | | NULL | | +-----------------+--------------+------+-----+---------+----------------+ 10 rows in set (0.01 sec) Should that be 'location_id' in Datatables.pm line 69? Sean |