have you set your database information in your config file and have you created your database and tables? also, let us see your model.
On Feb 13, 11:22 am, Neil Ablang <[email protected]> wrote: > Hello, > > My turbogears application is working fine with paster serve. > > But when deployedto Apache Httpd, Im encountering the error: > NoSuchColumnError: "Could not locate column in row for column > > Without database access there are no errors. > > What have I done wrong? I used the procedure to install turbogears as > describe in turbogears main page. > > Error transcript provided below: > > Best Regards, > > Neil Ablang > > [Wed Feb 13 17:08:24 2013] [error] [client ] stateList = > DBSession.query(StateCountyRecDate).all() > [Wed Feb 13 17:08:24 2013] [error] [client ] File > "/usr/local/turbogears/sorter/lib/python2.6/site-packages/SQLAlchemy-0.7.9- > py2.6-linux-i686.egg/sqlalchemy/orm/query.py", > line 2115, in all > [Wed Feb 13 17:08:24 2013] [error] [client ] return list(self) > [Wed Feb 13 17:08:24 2013] [error] [client ] File > "/usr/local/turbogears/sorter/lib/python2.6/site-packages/SQLAlchemy-0.7.9- > py2.6-linux-i686.egg/sqlalchemy/orm/query.py", > line 2348, in instances > [Wed Feb 13 17:08:24 2013] [error] [client ] rows = [process[0](row, > None) for row in fetch] > [Wed Feb 13 17:08:24 2013] [error] [client ] File > "/usr/local/turbogears/sorter/lib/python2.6/site-packages/SQLAlchemy-0.7.9- > py2.6-linux-i686.egg/sqlalchemy/orm/mapper.py", > line 2029, in _instance > [Wed Feb 13 17:08:24 2013] [error] [client ] tuple([row[column] for > column in pk_cols]) > [Wed Feb 13 17:08:24 2013] [error] [client ] File > "/usr/local/turbogears/sorter/lib/python2.6/site-packages/SQLAlchemy-0.7.9- > py2.6-linux-i686.egg/sqlalchemy/engine/base.py", > line 2834, in _key_fallback > [Wed Feb 13 17:08:24 2013] [error] [client ] > expression._string_or_unprintable(key)) > [Wed Feb 13 17:08:24 2013] [error] [client ] NoSuchColumnError: "Could not > locate column in row for column 'StateCountyRecDate.record_id'" -- You received this message because you are subscribed to the Google Groups "TurboGears" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/turbogears?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
