[Live-demo] [OSGeo] #917: mapfish demo not working

[OSGeo]

#917: mapfish demo not working
---------------------+------------------------------------------------------
 Reporter:  kalxas   |        Owner:  live-demo@…              
     Type:  defect   |       Status:  reopened                 
 Priority:  major    |    Milestone:  OSGeoLive6.5             
Component:  LiveDVD  |   Resolution:                           
 Keywords:  6.5      |  
---------------------+------------------------------------------------------

Comment(by kalxas):

 I used
 {{{
 #cd /usr/local/lib/mapfish/MapfishSample
 #./buildout/bin/paster serve development.ini
 }}}
 to get into a debugging mode and then navigated to
 http://localhost/mapfishsample/osgeolive/wsgi/pois
 This gives me the following error:

 {{{
 URL: http://127.0.0.1:5000/admin/Poi/models
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/WebError-0.10.3-py2.7.egg/weberror/evalexception.py',
 line 431 in respond
   app_iter = self.application(environ, detect_start_response)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/Beaker-1.5.4-py2.7.egg/beaker/middleware.py',
 line 152 in __call__
   return self.wrap_app(environ, session_start_response)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/Routes-1.12.3-py2.7.egg/routes/middleware.py',
 line 131 in __call__
   response = self.app(environ, start_response)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/Pylons-1.0-py2.7.egg/pylons/wsgiapp.py',
 line 107 in __call__
   response = self.dispatch(controller, environ, start_response)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/Pylons-1.0-py2.7.egg/pylons/wsgiapp.py',
 line 312 in dispatch
   return controller(environ, start_response)
 File '/usr/local/lib/mapfish/MapfishSample/mapfishsample/lib/base.py',
 line 18 in __call__
   return WSGIController.__call__(self, environ, start_response)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/Pylons-1.0-py2.7.egg/pylons/controllers/core.py',
 line 211 in __call__
   response = self._dispatch_call()
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/Pylons-1.0-py2.7.egg/pylons/controllers/core.py',
 line 162 in _dispatch_call
   response = self._inspect_call(func)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/Pylons-1.0-py2.7.egg/pylons/controllers/core.py',
 line 105 in _inspect_call
   result = self._perform_call(func, args)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/Pylons-1.0-py2.7.egg/pylons/controllers/core.py',
 line 57 in _perform_call
   return func(**args)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/FormAlchemy-1.4-py2.7.egg/formalchemy/ext/pylons/controller.py',
 line 267 in index
   page = self.get_page()
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/FormAlchemy-1.4-py2.7.egg/formalchemy/ext/pylons/controller.py',
 line 173 in get_page
   return Page(collection, **options)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/WebHelpers-1.2-py2.7.egg/webhelpers/paginate.py',
 line 407 in __init__
   self.item_count = len(self.collection)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/WebHelpers-1.2-py2.7.egg/webhelpers/paginate.py',
 line 266 in __len__
   return self.obj.count()
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py',
 line 2177 in count
   return self.from_self(col).scalar()
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py',
 line 1827 in scalar
   ret = self.one()
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py',
 line 1796 in one
   ret = list(self)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py',
 line 1839 in __iter__
   return self._execute_and_instances(context)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py',
 line 1854 in _execute_and_instances
   result = conn.execute(querycontext.statement, self._params)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py',
 line 1399 in execute
   params)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py',
 line 1532 in _execute_clauseelement
   compiled_sql, distilled_params
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py',
 line 1640 in _execute_context
   context)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py',
 line 1633 in _execute_context
   context)
 File
 '/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.2-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py',
 line 325 in do_execute
   cursor.execute(statement, parameters)
 ProgrammingError: (ProgrammingError) column poi_osm.the_geom does not
 exist
 LINE 2: FROM (SELECT ST_AsBinary(poi_osm.the_geom) AS poi_osm_the_ge...
                                  ^
  'SELECT count(*) AS count_1 \nFROM (SELECT ST_AsBinary(poi_osm.the_geom)
 AS poi_osm_the_geom, poi_osm.gid AS poi_osm_gid, poi_osm.id AS poi_osm_id,
 poi_osm.rating AS poi_osm_rating, poi_osm.name AS poi_osm_name,
 poi_osm.code_dept AS poi_osm_code_dept, poi_osm.type_desc AS
 poi_osm_type_desc, poi_osm.type AS poi_osm_type, poi_osm.theme AS
 poi_osm_theme, poi_osm.geom AS poi_osm_geom \nFROM poi_osm) AS anon_1' {}
 }}}

 Then I tried to fix this issue in [9534] by changing the geometry column
 in the file layers.ini
 The osm_poi table in postgis has a geometry column named "geom" instead of
 "the_geom".
 I am not sure if this is a Pylons specific thing, but changing the column
 name in layers.ini and running the buildout again still produces the same
 error. Is the geometry column name hard-coded somewhere?

-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/917#comment:10>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.