How do you configure mod_wsgi for Apache? Which configuration file did you use there? development.init/deployment.ini_tmpl? Which configuration file did you use to create the database - was sqlalchemy.uri the same?
Maybe post the relevant configuration files here (check for passwords, of course...). Am Donnerstag, 14. Februar 2013 01:32:59 UTC+1 schrieb Neil Ablang: > > Hello, > > > here is my table from model folder. Its working on my paster serve setup. > Yes the DB is created, The __init__.py has also been updated to add the > models below. > > thanks in advance for any help. > > > # -*- coding: utf-8 -*- > """Sample model module.""" > > from sqlalchemy import * > from sqlalchemy.orm import mapper, relation > from sqlalchemy import Table, ForeignKey, Column > from sqlalchemy.types import Integer, Unicode > #from sqlalchemy.orm import relation, backref > > from sorter.model import DeclarativeBase, metadata, DBSession > > > class SortedFiles(DeclarativeBase): > """Table for Sorted Files""" > __tablename__ = "BNTSortedFiles" > > record_id = Column(Integer, primary_key=True) > fileName = Column(String,nullable=True,unique=True) > docTitle = Column(String,nullable=True) > docTag = Column(String,nullable=True) > docType = Column(String,nullable=True) > recDate = Column(String,nullable=True) > group = Column(String,nullable=True) > jobName = Column(String,nullable=True) > stateCounty = Column(String,nullable=True) > ftpPath = Column(String,nullable=True) > move = Column(Boolean,nullable=False,default='False') > dispatch = Column(Boolean,nullable=False,default='False') > done= Column(Boolean,nullable=False,default='False') > > class StateCountyRecDate(DeclarativeBase): > """Table for State County Recording Date""" > __tablename__ = "StateCountyRecDate" > > record_id = Column(Integer, primary_key=True) > recDate = Column(String,nullable=True) > stateCounty = Column(String,nullable=True) > dtaImgStatus = Column(Boolean,nullable=False,default='False') > > On Thursday, February 14, 2013 3:15:39 AM UTC+8, Mengu wrote: >> >> 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.
