API tools faq
paste
Advertisement
Guest User

ckanext-spatial error

a guest
Nov 13th, 2015
141
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.28 KB | None | 0 0
raw download clone embed print report
  1. URL: http://<ckan_url>:5000/dataset?q=&sort=score+desc%2C+metadata_modified+desc&ext_bbox=18.45703125%2C48.356249029540734%2C22.587890625%2C49.55372551347579&ext_prev_extent=18.10546875%2C47.487513008956554%2C22.939453125%2C50.3734961443035
  2. File '/usr/lib/ckan/default/lib/python2.7/site-packages/weberror/evalexception.py', line 431 in respond
  3. app_iter = self.application(environ, detect_start_response)
  4. File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 147 in __call__
  5. resp = self.call_func(req, *args, **self.kwargs)
  6. File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 208 in call_func
  7. return self.func(req, *args, **kwargs)
  8. File '/usr/lib/ckan/default/lib/python2.7/site-packages/fanstatic/publisher.py', line 234 in __call__
  9. return request.get_response(self.app)
  10. File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1053 in get_response
  11. application, catch_exc_info=False)
  12. File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1022 in call_application
  13. app_iter = application(self.environ, start_response)
  14. File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 147 in __call__
  15. resp = self.call_func(req, *args, **self.kwargs)
  16. File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 208 in call_func
  17. return self.func(req, *args, **kwargs)
  18. File '/usr/lib/ckan/default/lib/python2.7/site-packages/fanstatic/injector.py', line 54 in __call__
  19. response = request.get_response(self.app)
  20. File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1053 in get_response
  21. application, catch_exc_info=False)
  22. File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1022 in call_application
  23. app_iter = application(self.environ, start_response)
  24. File '/usr/lib/ckan/default/lib/python2.7/site-packages/beaker/middleware.py', line 73 in __call__
  25. return self.app(environ, start_response)
  26. File '/usr/lib/ckan/default/lib/python2.7/site-packages/beaker/middleware.py', line 155 in __call__
  27. return self.wrap_app(environ, session_start_response)
  28. File '/usr/lib/ckan/default/lib/python2.7/site-packages/routes/middleware.py', line 131 in __call__
  29. response = self.app(environ, start_response)
  30. File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/wsgiapp.py', line 125 in __call__
  31. response = self.dispatch(controller, environ, start_response)
  32. File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/wsgiapp.py', line 324 in dispatch
  33. return controller(environ, start_response)
  34. File '/root/ckan/lib/default/src/ckan/ckan/lib/base.py', line 348 in __call__
  35. res = WSGIController.__call__(self, environ, start_response)
  36. File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 221 in __call__
  37. response = self._dispatch_call()
  38. File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 172 in _dispatch_call
  39. response = self._inspect_call(func)
  40. File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 107 in _inspect_call
  41. result = self._perform_call(func, args)
  42. File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 60 in _perform_call
  43. return func(**args)
  44. File '/root/ckan/lib/default/src/ckan/ckan/controllers/package.py', line 254 in search
  45. query = get_action('package_search')(context, data_dict)
  46. File '/root/ckan/lib/default/src/ckan/ckan/logic/__init__.py', line 419 in wrapped
  47. result = _action(context, data_dict, **kw)
  48. File '/root/ckan/lib/default/src/ckan/ckan/logic/action/get.py', line 1448 in package_search
  49. data_dict = item.before_search(data_dict)
  50. File '/root/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/plugin.py', line 272 in before_search
  51. search_params = self._params_for_postgis_search(bbox, search_params)
  52. File '/root/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/plugin.py', line 366 in _params_for_postgis_search
  53. are_no_results = extents.count() == 0
  54. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/query.py', line 2571 in count
  55. return self.from_self(col).scalar()
  56. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/query.py', line 2215 in scalar
  57. ret = self.one()
  58. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/query.py', line 2184 in one
  59. ret = list(self)
  60. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/query.py', line 2227 in __iter__
  61. return self._execute_and_instances(context)
  62. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/query.py', line 2242 in _execute_and_instances
  63. result = conn.execute(querycontext.statement, self._params)
  64. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1449 in execute
  65. params)
  66. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1584 in _execute_clauseelement
  67. compiled_sql, distilled_params
  68. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1698 in _execute_context
  69. context)
  70. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1691 in _execute_context
  71. context)
  72. File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/default.py', line 331 in do_execute
  73. cursor.execute(statement, parameters)
  74. ProgrammingError: (ProgrammingError) operator is not unique: unknown || geometry
  75. LINE 4: ...= package.id AND package_extent.the_geom LIKE '%' || ST_Geom...
  76. ^
  77. HINT: Could not choose a best candidate operator. You might need to add explicit type casts.
  78. "SELECT count(*) AS count_1 \nFROM (SELECT ST_AsBinary(package_extent.the_geom) AS package_extent_the_geom, package_extent.package_id AS package_extent_package_id \nFROM package_extent, package \nWHERE package_extent.package_id = package.id AND package_extent.the_geom LIKE '%%' || ST_GeomFromText(%(ST_GeomFromText_1)s, %(ST_GeomFromText_2)s) || '%%' AND package.state = %(state_1)s) AS anon_1" {'ST_GeomFromText_1': 'POLYGON ((18.45703125 48.3562490295, 18.45703125 49.5537255135, 22.587890625 49.5537255135, 22.587890625 48.3562490295, 18.45703125 48.3562490295))', 'state_1': u'active', 'ST_GeomFromText_2': 4326}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!