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.
