Where communities thrive

  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
  • 13:59

    amercader on master

    resource page source: show tran… Don't use c Merge pull request #6077 from c… (compare)

  • 13:59

    amercader on resource-source-translated-title


  • 13:59
    amercader closed #6077
  • 13:28
    amercader assigned #6070
  • 13:28
    amercader unlabeled #6070
  • 13:15
    amercader assigned #6074
  • 13:14
    amercader locked #6078
  • 13:14
    amercader closed #6078
  • 13:10
    amercader assigned #6077
  • 13:10
    amercader assigned #6048
  • 13:06
    amercader unlabeled #6048
  • 13:06

    amercader on resource-source-translated-title

    Don't use c (compare)

  • 13:06
    amercader synchronize #6077
  • 13:04
    amercader assigned #6081
  • 13:04
    amercader assigned #6076
  • 12:57
    amercader assigned #6082
  • 12:57
    amercader opened #6082
  • 12:26
    smotornyuk closed #4990
  • 12:25
    smotornyuk commented #4990
  • 10:36

    amercader on dev-v2.8

    Revert "[#6006] Fix auth error … [#6006] Better fix (compare)

so i have 2 exactly same themes outside different namings
if i put pluginA in the ckan.ini
the css is above ckan's
if i instead put plugin B in the ckan.ini the css is below ckans
NOT both plugins at the same time
Jari Voutilainen
if you add any html tag before super(), it probably renders it there where you assume it to render, ckan css is still somewhere else in html due to webassets
but it does not do that with pluginB?
Jari Voutilainen
the fix for that is to use webassets yourself :)
or use custom_styles block https://github.com/ckan/ckan/blob/2.9/ckan/templates/base.html#L82 which is later than styles block
asset doesnt work at all
toolkit.add_resource('public', 'ka')

{% block styles %}
{{ super() }}
{% asset 'ka/ka.css' %}

{% endblock %}

adding to custom_styles does work, atleast atm
lets see if i can figure out what changed in 2.9 since theres no documentation for migrations afaik? the changelog only mentions
All the static CSS/JS files must be bundled via a webassets.yml file, as opposed to the previously used, optional resource.config file. Check the Assets documentation for more details. (#4614)
we havent used resource.config , just the public directory directive

It is important to note that these assets will be added to the page as defined by the assets configuration, not in the location of the {% asset %} tag. Duplicate assets will not be added and any dependencies will be included as well as the assets, all in the correct order (see below for details).


especially that assets can move freely in the whole jinja block and not just above any other directive
And likely if I would be using assets ckan would still be on top since the order isn't guaranteed
1 reply
*in wrong order not on tolb
Is it safe to delete users from the ckan backend PostgreSQL DB table user if their status is state=deleted?
3 replies
how do i recreate the jobs table of the datapusher?
i cant even find a line mentioning the sqlite file in the github D:
Exception on /job/52ac3647-4930-4b0f-b837-3d597d2df456 [GET]
Traceback (most recent call last):
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/flask/app.py", line 2446, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/flask/app.py", line 1951, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/flask/app.py", line 1820, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/flask/app.py", line 1935, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/ckanserviceprovider/web.py", line 442, in job_status
    job_dict = db.get_job(job_id, limit=limit)
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/ckanserviceprovider/db.py", line 158, in get_job
    JOBS_TABLE.select().where(JOBS_TABLE.c.job_id == job_id)).first()
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2235, in execute
    return connection.execute(statement, *multiparams, **params)
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
    cursor, statement, parameters, context
  File "/usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (sqlite3.OperationalError) no such table: jobs
[SQL: SELECT jobs.job_id, jobs.job_type, jobs.status, jobs.data, jobs.error, jobs.requested_timestamp, jobs.finished_timestamp, jobs.sent_data, jobs.result_url, jobs.api_key, jobs.job_key
FROM jobs
WHERE jobs.job_id = ?]
[parameters: ('52ac3647-4930-4b0f-b837-3d597d2df456',)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
welp fixed it by deleting the sqlite file again
Process completed but unable to post to result_url
had a 401, so i changed nginx config to allow local connections n checked it with curl, but the status of the job just went to "completed" instead of retrying
well more like the job is stuck at "Process completed but unable to post to result_url"
how do i restart the datapusher jobs?
tried deleting the jobs sqlite file, and restarting datapusher
now its there
curl localhost:8800
{"help":"\n Get help at:\n http://ckan-service-provider.readthedocs.org/."}
where does the error come from
[pid: 28521|app: 0|req: 9/9] () {36 vars in 540 bytes} [Mon Apr 12 12:48:29 2021] GET /job/52ac3647-4930-4b0f-b837-3d597d2df456 => generated 29 bytes in 1 msecs (HTTP/1.1 404) 2 headers in 78 bytes (1 switches on core 0)

the request hits datapusher
ckan --config /etc/ckan/default/ckan.ini jobs clear
also does not clean the job( i think the job is just missing on datapusher and it can actually connect to it just thinks "404" means its not the datapusher service??)
Hi, What is Schema in CKAN?
1 reply
Feng Hui-Chun

Hi, is there any way that might cause native extension (e.g. stats, text_view, etc.) unable to load? What I mean unable to load is:

ckan.plugins.core.PluginNotFoundException: stats


1 reply
Anyone know what part of the CKAN code controls the Bulk Edit tool of organization admin users and how it is related (or does not relate) to the schemas and validators of package create/updates (specifically the private field of the schema)?
3 replies
What about CKAN on CentOS?
Does anybody experience installing CKAN on CentOS? I have to proove staying on Ubuntu is more efficient than
8 replies
Sivan Grünberg
hi all
Sivan Grünberg
I'm experiencing some behavior from SOLR , for instance, to find a dataset one must search for the entire dataset name rather than just a part of it, or when a dataset author is in the name of an organization, all of its datasets are returned when searching for that name even though there's 0 datasets that this person has authored, a combination of letters and numbers is automatically broken down, and thus returns most of the datasets on disk when searched for etc, etc. Is there a central place in CKAN where the SOLR configuration lives so I can try and modify it to see if I can come with a human friendly search interface? :)
11 replies
quick question any easy way to have dataset search not have "covid19" interpreted as covid OR 19?
3 replies
Lalitha Prasad Ch
any way to assign sysadminapitoken during the installation?
9 replies
is it normal that after a template error every refresh of the page errors on
"StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back
[SQL: SELECT system_info.id AS system_info_id, system_info.key AS system_info_key, system_info.value AS system_info_value, system_info.state AS system_info_state
FROM system_info
WHERE system_info.key = %(key_1)s
LIMIT %(param_1)s]
[parameters: [{}]]"