[ckan-dev] CKAN 2.3 errors spatial
Florian May
florian.wendelin.mayer at gmail.com
Fri Mar 13 04:28:12 UTC 2015
Isabel, Julio,
this sounds awfully familiar... "It seems SqlAlchemy have renamed
ColumnComparator to Comparator, and used it interchangeably as shown here
<https://github.com/zzzeek/sqlalchemy/commit/59141d360e70d1a762719206e3cb0220b4c53fef#diff-25404d1d3cb1f5c742f17079a58fbccbL220>
."
try using @chokoswitch <https://github.com/chokoswitch>'s patched
geoalchemy (using good old ColumnComparator) in ckanext-spatial's
pip-requirements.txt like so
<https://github.com/florianm/ckanext-spatial/blob/master/pip-requirements.txt>
and JTS1.13 (sourceforge <http://sourceforge.net/projects/jts-topo-suite/>)
as described in section "Customise SolR to CKAN schema" here
<https://github.com/opendata/CKAN-Multisite/issues/10>.
HTH,
Florian
On Fri, Mar 13, 2015 at 11:08 AM, Julio Acuña <
julio.acuna.carrillo at gmail.com> wrote:
> I have the same problem, it seems that ckanext-spatial doesn't play well
> with CKAN 2.3
>
> As far as I can tell, it has to do with the versions of sqlalchemy and
> geoalchemy, maybe a patched version of geoalchemy could make the trick, but
> I haven't try it yet.
>
> Check this post
> http://gis.stackexchange.com/questions/109498/geoalchemy-attributeerror-type-object-columnproperty-has-no-attribute-colum
>
> On Tue, Mar 10, 2015 at 7:44 AM, Isabel Ruiz <isaruizmellado at gmail.com>
> wrote:
>
>> Hello,
>>
>> I have upgraded to CKAN 2.3 and I have updated all my dependences (well,
>> I think I have updated them :) ).
>>
>> I have restarted jetty and apache2.
>>
>> When I run CKAN, it returns this spatial error:
>>
>> What can be wrong?
>>
>> Thanks !
>>
>>
>> [Tue Mar 10 13:23:47.184841 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] mod_wsgi (pid=8508): Target WSGI script
>> '/home/ckan/ckan/lib/default/bin/malaga.py' cannot be loaded as Python
>> module.
>> [Tue Mar 10 13:23:47.188418 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] mod_wsgi (pid=8508): Exception occurred processing
>> WSGI script '/home/ckan/ckan/lib/default/bin/malaga.py'.
>> [Tue Mar 10 13:23:47.189669 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] Traceback (most recent call last):
>> [Tue Mar 10 13:23:47.191245 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File "/home/ckan/ckan/lib/default/bin/malaga.py",
>> line 11, in <module>
>> [Tue Mar 10 13:23:47.193171 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] application = loadapp('config:%s' %
>> config_filepath)
>> [Tue Mar 10 13:23:47.194516 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
>> line 247, in loadapp
>> [Tue Mar 10 13:23:47.197398 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] return loadobj(APP, uri, name=name, **kw)
>> [Tue Mar 10 13:23:47.198877 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
>> line 272, in loadobj
>> [Tue Mar 10 13:23:47.200383 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] return context.create()
>> [Tue Mar 10 13:23:47.202156 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
>> line 710, in create
>> [Tue Mar 10 13:23:47.204564 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] return self.object_type.invoke(self)
>> [Tue Mar 10 13:23:47.205859 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
>> line 146, in invoke
>> [Tue Mar 10 13:23:47.207260 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] return fix_call(context.object,
>> context.global_conf, **context.local_conf)
>> [Tue Mar 10 13:23:47.208436 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/util.py",
>> line 56, in fix_call
>> [Tue Mar 10 13:23:47.209944 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] val = callable(*args, **kw)
>> [Tue Mar 10 13:23:47.211028 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/src/ckan/ckan/config/middleware.py", line 58,
>> in make_app
>> [Tue Mar 10 13:23:47.212776 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] load_environment(conf, app_conf)
>> [Tue Mar 10 13:23:47.213900 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/src/ckan/ckan/config/environment.py", line
>> 232, in load_environment
>> [Tue Mar 10 13:23:47.215991 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] p.load_all(config)
>> [Tue Mar 10 13:23:47.217006 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/src/ckan/ckan/plugins/core.py", line 134, in
>> load_all
>> [Tue Mar 10 13:23:47.218879 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] load(*plugins)
>> [Tue Mar 10 13:23:47.219960 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/src/ckan/ckan/plugins/core.py", line 148, in
>> load
>> [Tue Mar 10 13:23:47.221032 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] service = _get_service(plugin)
>> [Tue Mar 10 13:23:47.221484 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/src/ckan/ckan/plugins/core.py", line 254, in
>> _get_service
>> [Tue Mar 10 13:23:47.222504 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] return plugin.load()(name=plugin_name)
>> [Tue Mar 10 13:23:47.223038 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/pkg_resources/__init__.py",
>> line 2312, in load
>> [Tue Mar 10 13:23:47.227922 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] return self.resolve()
>> [Tue Mar 10 13:23:47.229201 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/pkg_resources/__init__.py",
>> line 2318, in resolve
>> [Tue Mar 10 13:23:47.230395 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] module = __import__(self.module_name,
>> fromlist=['__name__'], level=0)
>> [Tue Mar 10 13:23:47.231607 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/plugin.py",
>> line 15, in <module>
>> [Tue Mar 10 13:23:47.236024 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] from ckanext.spatial.lib import
>> save_package_extent,validate_bbox, bbox_query, bbox_query_ordered
>> [Tue Mar 10 13:23:47.237258 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/lib/__init__.py",
>> line 7, in <module>
>> [Tue Mar 10 13:23:47.239120 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] from ckanext.spatial.model import PackageExtent
>> [Tue Mar 10 13:23:47.240370 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/model/__init__.py",
>> line 9, in <module>
>> [Tue Mar 10 13:23:47.242079 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] from package_extent import *
>> [Tue Mar 10 13:23:47.243367 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/model/package_extent.py",
>> line 5, in <module>
>> [Tue Mar 10 13:23:47.245196 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] from geoalchemy import Geometry, GeometryColumn,
>> GeometryDDL, GeometryExtensionColumn
>> [Tue Mar 10 13:23:47.246382 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/geoalchemy/__init__.py",
>> line 2, in <module>
>> [Tue Mar 10 13:23:47.248250 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] from geoalchemy.base import *
>> [Tue Mar 10 13:23:47.249436 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] File
>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/geoalchemy/base.py",
>> line 242, in <module>
>> [Tue Mar 10 13:23:47.251387 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] class
>> SpatialComparator(ColumnProperty.ColumnComparator):
>> [Tue Mar 10 13:23:47.252634 2015] [:error] [pid 8508] [client
>> 172.16.92.1:33291] AttributeError: type object 'ColumnProperty' has no
>> attribute 'ColumnComparator'
>> --
>> Isabel M. Ruiz Mellado
>> http://about.me/isabelruiz
>>
>> _______________________________________________
>> ckan-dev mailing list
>> ckan-dev at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/ckan-dev
>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>
>>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150313/47a5156a/attachment-0003.html>
More information about the ckan-dev
mailing list