On Aug 12, 3:13 pm, "[email protected]" <[email protected]> wrote: > 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' ()
are you using mysql4? $ paster setup-app development.ini Running setup_config() from tg201.websetup Creating tables Successfully setup using your model with mysql 5.0.51, it works for me. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
