Fixed me right up, dumb mistake. Thanks! On Aug 12, 8:18 pm, cd34 <[email protected]> wrote: > On Aug 12, 3:13 pm, "[email protected]" <[email protected]> > wrote: > > > > > Here is my model ... > > class Address(DeclarativeBase): > > __tablename__ = 'addresses' > > id = Column(Integer, primary_key=True) > > email_address = Column(String) > > people_id = Column(Integer, ForeignKey('users.id')) > > person = relation(Users, backref=backref('addresses', > > order_by=id)) > > def __init__(self, email_address): > > self.email_address = email_address > > def __repr__(self): > > return "<Address('%s')>" % self.email_address > > > when i run paster setup-app development.ini i get ... > > raise exc.DBAPIError.instance(statement, parameters, e, > > connection_invalidated=is_disconnect) > > sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1064, "You have > > an error in your SQL syntax; check the manual that corresponds to your > > MySQL server version for the right syntax to use near ' \n\tpeople_id > > INTEGER, \n\tPRIMARY KEY (id), \n\t FOREIGN KEY(people_id) REFERENCES > > u' at line 3") '\nCREATE TABLE addresses (\n\tid INTEGER NOT NULL > > AUTO_INCREMENT, \n\temail_address VARCHAR, \n\tpeople_id INTEGER, \n > > \tPRIMARY KEY (id), \n\t FOREIGN KEY(people_id) REFERENCES users (id) > > \n)\n\n' () > > In looking at this a little closer, it appears to be failing on > > email_address = Column(String) > > Try changing that to > > email_address = Column(Unicode(80)) > > to see if it works.
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
