# Search in warehouse error
**URL:** https://discuss.tryton.org/t/search-in-warehouse-error/5948
**Category:** Developer
**Tags:** stock
**Created:** [February 18, 2023, 10:39pm UTC](https://discuss.tryton.org/t/search-in-warehouse-error/5948 "2023-02-18T22:39:04Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Niddorcahm](https://discuss.tryton.org/u/Niddorcahm)
#### Post date: [February 18, 2023, 10:39pm UTC](https://discuss.tryton.org/t/search-in-warehouse-error/5948/1 "2023-02-18T22:39:05Z")
Hello. Good morning everyone.
I can’t fix the following error that appears when entering **stock/Locations**.
Tryton does not perform the search when selecting a **warehouse** in either lots or products selection.
```auto
Traceback (most recent call last):
File "/trytond/wsgi.py", line 117, in dispatch_request
return endpoint(request, **request.view_args)
File "/trytond/protocols/dispatcher.py", line 47, in rpc
request, database_name, *request.rpc_params)
File "/trytond/wsgi.py", line 84, in auth_required
return wrapped(*args, **kwargs)
File "/trytond/protocols/wrappers.py", line 159, in wrapper
return func(request, pool, *args, **kwargs)
File "/trytond/protocols/dispatcher.py", line 180, in _dispatch
result = rpc.result(meth(*c_args, **c_kwargs))
File "/trytond/model/modelsql.py", line 1353, in search
cursor.execute(*select)
File "/trytond/backend/postgresql/database.py", line 74, in execute
cursor.execute(self, sql, args)
psycopg2.ProgrammingError: can't adapt type 'Select'
Fault: can't adapt type 'Select'
```
Help, please.. Thank you very much
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [February 19, 2023, 10:09am UTC](https://discuss.tryton.org/t/search-in-warehouse-error/5948/2 "2023-02-19T10:09:18Z")
> [@Niddorcahm](#):
>
> I can’t fix the following error that appears when entering **stock/Locations**.
> Tryton does not perform the search when selecting a **warehouse** in either lots or products selection.
I do not understand the step to follow to reproduce.
> [@Niddorcahm](#):
>
> `psycopg2.ProgrammingError: can't adapt type 'Select'`
It seems that a `python-sql` `Select` object is passed as parameter in the query.
So looking at the generated query should be insightful.
---
### Author:  [@Niddorcahm](https://discuss.tryton.org/u/Niddorcahm)
#### Post date: [February 19, 2023, 12:18pm UTC](https://discuss.tryton.org/t/search-in-warehouse-error/5948/3 "2023-02-19T12:18:48Z")
Hello, I share a screen print of the step where the error occurs.
Thank you very much
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [February 19, 2023, 12:21pm UTC](https://discuss.tryton.org/t/search-in-warehouse-error/5948/4 "2023-02-19T12:21:49Z")
Can not reproduce on demo server.
---
### Author:  [@Niddorcahm](https://discuss.tryton.org/u/Niddorcahm)
#### Post date: [March 5, 2023, 7:08pm UTC](https://discuss.tryton.org/t/search-in-warehouse-error/5948/5 "2023-03-05T19:08:16Z")
I’ve been looking for a possible solution for two weeks but I can’t find the error.
any ideas?
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [March 6, 2023, 9:54am UTC](https://discuss.tryton.org/t/search-in-warehouse-error/5948/6 "2023-03-06T09:54:57Z")
Maybe you do not have a recent enough python-sql library. I’m thinking about [Support Select queries in conditionals and functions (#73) · Issues · Tryton / python-sql · GitLab](https://foss.heptapod.net/tryton/python-sql/-/issues/73)