[ckan-dev] CKAN 2.3 errors spatial

Isabel Ruiz isaruizmellado at gmail.com
Wed Apr 8 10:59:20 UTC 2015


Hi!

Yes, we have upgraded CKAN and ckanext-spatial and now geojson previews
works!

Thanks !!!!

On Wed, Apr 8, 2015 at 11:42 AM, Adrià Mercader <adria.mercader at okfn.org>
wrote:

> Hi,
>
> ckanext-spatial should now work with CKAN 2.3.
> Please see previous email on the list for details.
>
> Thanks
>
> Adrià
>
> On 23 March 2015 at 02:43, Florian May <florian.wendelin.mayer at gmail.com>
> wrote:
> > Mol be, Adria!
> >
> > Give me a yell if there's anything I can assist you with. Happy to put
> in a
> > few dev hours if required - keen to learn how to upgrade third party deps
> > like leaflet-draw.
> >
> > Cheers,
> > Florian
> >
> > On Sat, Mar 21, 2015 at 1:20 AM, Adrià Mercader <adria.mercader at okfn.org
> >
> > wrote:
> >>
> >> Thanks Florian,
> >>
> >> I have some time set aside next week to bring ckanext-spatial up to
> >> speed with 2.3 and will definitely check your pointers.
> >>
> >>
> >> Adrià
> >>
> >> On 17 March 2015 at 17:44, Julio Acuña <julio.acuna.carrillo at gmail.com>
> >> wrote:
> >> > Thanks Florian and Adrià, I will be looking forward for the fix.
> >> >
> >> > On Fri, Mar 13, 2015 at 9:17 PM, Florian May
> >> > <florian.wendelin.mayer at gmail.com> wrote:
> >> >>
> >> >> Adrià,
> >> >>
> >> >> I've had a shot at fixing these. I suggest the fixes should be
> re-done
> >> >> in
> >> >> a more orderly fashion, but see my comments on details of the upgrade
> >> >> and my
> >> >> sandbox (link in comments) for a working implementation.
> >> >> Happy to assist / re-implement where appropriate and required!
> >> >>
> >> >> https://github.com/ckan/ckanext-spatial/pull/93
> >> >>
> >> >> Cheers,
> >> >> Florian
> >> >>
> >> >> On Fri, Mar 13, 2015 at 5:44 PM, Adrià Mercader
> >> >> <adria.mercader at okfn.org>
> >> >> wrote:
> >> >>>
> >> >>> Hi,
> >> >>>
> >> >>> The current master branch of ckanext-spatial will not work with 2.3
> >> >>> doing to requirements incompatibilities. This should be easy to fix
> >> >>> but we need to set some time aside to review it properly. I'll let
> the
> >> >>> list know when we can find some resources to work on this, hopefully
> >> >>> very soon.
> >> >>>
> >> >>> Cheers,
> >> >>>
> >> >>> Adrià
> >> >>>
> >> >>> On 13 March 2015 at 04:28, Florian May
> >> >>> <florian.wendelin.mayer at gmail.com>
> >> >>> wrote:
> >> >>> > Isabel, Julio,
> >> >>> >
> >> >>> > this sounds awfully familiar... "It seems SqlAlchemy have renamed
> >> >>> > ColumnComparator to Comparator, and used it interchangeably as
> shown
> >> >>> > here."
> >> >>> > try using @chokoswitch's patched geoalchemy (using good old
> >> >>> > ColumnComparator) in ckanext-spatial's pip-requirements.txt like
> so
> >> >>> > and
> >> >>> > JTS1.13 (sourceforge) as described in section "Customise SolR to
> >> >>> > CKAN
> >> >>> > schema" here.
> >> >>> >
> >> >>> > 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
> >> >>> >>
> >> >>> >
> >> >>> >
> >> >>> > _______________________________________________
> >> >>> > 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
> >> >>
> >> >>
> >> >>
> >> >> _______________________________________________
> >> >> 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
> >> >
> >> _______________________________________________
> >> 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
> >
> _______________________________________________
> 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
>



-- 
Isabel M. Ruiz Mellado
http://about.me/isabelruiz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150408/f26d14d3/attachment-0003.html>


More information about the ckan-dev mailing list