Issue initializing database for ckanext-validation on CKAN 2.11.3

[duanjunhyq]

Hi,

I’m using CKAN 2.11.3 and tried to add the ckanext-validation plugin, but I encountered an error when initializing the database.

if not tables_exist():
File "/home/ubuntu/ckan/lib/default/lib/python3.10/site-packages/ckanext/validation/model.py", line 53, in tables_exist
return Validation.table.exists()
File "", line 2, in exists
File "/usr/lib/ckan/default/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 468, in warned
return fn(*args, **kwargs)
File "/usr/lib/ckan/default/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 941, in exists
bind = _bind_or_error(self)
File "/usr/lib/ckan/default/lib/python3.10/site-packages/sqlalchemy/sql/base.py", line 1659, in _bind_or_error
raise exc.UnboundExecutionError(msg)
sqlalchemy.exc.UnboundExecutionError: Table object 'validation' is not bound to an Engine or Connection. Execution can not proceed without a database to execute against.

Steps I followed:

git clone https://github.com/ckan/ckanext-validation.git
cd ckanext-validation
pip install -r requirements.txt
python setup.py develop

2. Added validation to the ckan.plugins section of /etc/ckan/default/ckan.ini

3. Ran:

ckan -c /etc/ckan/default/ckan.ini validation init-db

At step 3, I got the above error.

Could you please advise if there’s something I’m missing or if this is a compatibility issue with CKAN 2.11.3?

Thanks,
Jun

[duttonw]

Could you give https://github.com/qld-gov-au/ckanext-validation a go, we are still trying to integrate the divergent forks. We do know that the qld-gov-au version can run on latest.

[ThrawnCA]

The qld-gov-au fork does indeed have updated code to fix the database initialisation. We would have tried to merge it upstream, but it has diverged so far that that's hard to do. Might be able to merge just that module, though.

[duanjunhyq]

Thanks very much for your replies, and apologies for the late response — I was away on vacation. My CKAN version is 2.11.3. After installing the qld-gov-au fork, I am still encountering the following error: File "/home/ubuntu/ckan/lib/default/lib/python3.10/site-packages/ckanext/validation/model.py", line 53, in tables_exist return Validation.__table__.exists() File "<string>", line 2, in exists File "/usr/lib/ckan/default/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 468, in warned return fn(*args, **kwargs) File "/usr/lib/ckan/default/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 941, in exists bind = _bind_or_error(self) File "/usr/lib/ckan/default/lib/python3.10/site-packages/sqlalchemy/sql/base.py", line 1659, in _bind_or_error raise exc.UnboundExecutionError(msg) sqlalchemy.exc.UnboundExecutionError: Table object 'validation' is not bound to an Engine or Connection. Execution can not proceed without a database to execute against.

…

On Wed, Aug 13, 2025 at 7:32 PM ThrawnCA ***@***.***> wrote: *ThrawnCA* left a comment (ckan/ckanext-validation#118) <#118 (comment)> The qld-gov-au fork does indeed have updated code to fix the database initialisation. We would have tried to merge it upstream, but it has diverged so far that that's hard to do. Might be able to merge just that module, though. — Reply to this email directly, view it on GitHub <#118 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AENZ27E5FUO6SXM6HAYIK7L3NPYMTAVCNFSM6AAAAACDPLL7SWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTCOBWGU2DKMRQHA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[ThrawnCA]

My CKAN version is 2.11.3. After installing the qld-gov-au fork, I am still
encountering the following error:

Do you mean the qld-gov-au fork of CKAN, or of the ckanext-validation plugin? It's the plugin that fixes this error. (And the line where your error occurs does not exist in the forked plugin.)

[duanjunhyq]

I installed https://github.com/qld-gov-au/ckanext-validation, but I was still getting the error. I’ve fixed it by modifying model.py, and it’s working now. Specifically, I replaced the tables_exist() in ckanext-validation/model.py with: from ckan.model import meta from sqlalchemy import inspect def tables_exist(): if not meta.engine: return False inspector = inspect(meta.engine) return inspector.has_table(Validation.__tablename__)

…

On Thu, Aug 21, 2025 at 3:41 PM ThrawnCA ***@***.***> wrote: *ThrawnCA* left a comment (ckan/ckanext-validation#118) <#118 (comment)> My CKAN version is 2.11.3. After installing the qld-gov-au fork, I am still encountering the following error: Do you mean the qld-gov-au fork of CKAN, or of the ckanext-validation plugin? It's the plugin that fixes this error. (And the line where your error occurs does not exist in the forked plugin.) — Reply to this email directly, view it on GitHub <#118 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AENZ27CUQWKRRLCLDEMF3AT3OZDIHAVCNFSM6AAAAACDPLL7SWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTEMJSGI3TOOJZGI> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[ThrawnCA]

I installed https://github.com/qld-gov-au/ckanext-validation, but I was
still getting the error. I’ve fixed it by modifying model.py, and it’s
working now.

Specifically, I replaced the tables_exist() in ckanext-validation/model.py
with:

That...doesn't make sense. The current master https://github.com/qld-gov-au/ckanext-validation/blob/4059f6f9a8800b7f326d7f86534d8e15e8d3e881/ckanext/validation/model.py doesn't have a tables_exist function.

What branch or tag did you install?

[duanjunhyq]

I see your point. The tables_exist() function is in the ckan/ckanext-validation master branch ( https://github.com/ckan/ckanext-validation/blob/master/ckanext/validation/model.py ), but not in the qld-gov-au/ckanext-validation repo you mentioned. I may not properly remove my previous ckanext-validation. Thanks for catching that!

…

On Sun, Aug 24, 2025 at 4:00 PM ThrawnCA ***@***.***> wrote: *ThrawnCA* left a comment (ckan/ckanext-validation#118) <#118 (comment)> I installed https://github.com/qld-gov-au/ckanext-validation, but I was still getting the error. I’ve fixed it by modifying model.py, and it’s working now. Specifically, I replaced the tables_exist() in ckanext-validation/model.py with: That...doesn't make sense. The current master https://github.com/qld-gov-au/ckanext-validation/blob/4059f6f9a8800b7f326d7f86534d8e15e8d3e881/ckanext/validation/model.py doesn't *have* a tables_exist function. What branch or tag did you install? — Reply to this email directly, view it on GitHub <#118 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AENZ27ERBOY6DYVLIJTPSMD3PI7ZHAVCNFSM6AAAAACDPLL7SWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTEMJYGQZTGOJQGY> . You are receiving this because you authored the thread.Message ID: ***@***.***>