Re: [Libki-Users] Error message: Unknown column 'location'

[Ian W. <ia...@by...>]

Libki Clients don't make use of this API endpoint, but if you have any old
instances of the public URL running in a browser, perhaps as part of a
kiosk or digital signage, then that page would need to be refreshed to the
fetch the updated HTML/JS, which points it at the /api/v2/clients endpoint

On Thu, Sep 17, 2026 at 1:41 AM Sean Carte <sea...@gm...> wrote:

> Thanks, Ian. So I just need to update the clients?
>
> Sean
>
> On Wed, 16 Sept 2026 at 18:08, Ian Walls <ia...@by...> wrote:
>
>> Sean,
>>
>>
>> Since Libki 26.05, Locations have been made a more primary data object in
>> Libki, which in turn has led tables like 'clients' to link to 'locations'
>> with a primary key instead of a string.  This has required a lot of
>> retrofitting across Libki of this very problem you're describing.   This
>> looks to be one of the places where the update didn't get applied, most
>> likely because the public admin page was also updated to use the API V2
>> endpoint for clients instead of /api/public/datatables/clients legacy
>> endpoint.  If you're still trying to consume from that endpoint, I think
>> that's what will lead to the error you're seeing.
>>
>>
>> Ian
>>
>> On Tue, Sep 15, 2026 at 3:41 AM Sean Carte <sea...@gm...> wrote:
>>
>>> 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
>>> _______________________________________________
>>> Libki-Users mailing list
>>> Lib...@li...
>>> https://lists.sourceforge.net/lists/listinfo/libki-users
>>>
>>
>>
>> --
>> *Ian Walls*
>> *Head of Special Projects*
>> ByWater Solutions <http://bywatersolutions.com>
>> Phone: (888) 900-8944
>> *pronouns*: (he/him)
>> *timezone*: Eastern
>>
>> <http://bywatersolutions.com>
>>
>> Follow us:
>> <https://www.facebook.com/ByWaterSolutions/>
>> <https://www.instagram.com/bywatersolutions/>
>> <https://www.youtube.com/user/bywatersolutions>
>> <https://twitter.com/ByWaterSolution>
>> <https://linkedin.com/company/bywater-solutions>
>> _______________________________________________
>> Libki-Users mailing list
>> Lib...@li...
>> https://lists.sourceforge.net/lists/listinfo/libki-users
>>
> _______________________________________________
> Libki-Users mailing list
> Lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libki-users
>


-- 
*Ian Walls*
*Head of Special Projects*
ByWater Solutions <http://bywatersolutions.com>
Phone: (888) 900-8944
*pronouns*: (he/him)
*timezone*: Eastern

<http://bywatersolutions.com>

Follow us:
<https://www.facebook.com/ByWaterSolutions/>
<https://www.instagram.com/bywatersolutions/>
<https://www.youtube.com/user/bywatersolutions>
<https://twitter.com/ByWaterSolution>
<https://linkedin.com/company/bywater-solutions>