I have a reasonably complex schema that I attempting to manage with SQLAlchemy. I just added some tables in code and tried re-creating the database, and got an error that looks like this:
################## 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\tisdiscrete BOOL, \n\tminlevel INTEGER, \n\tmaxlevel INTEGER, \n\tPRIMARY KEY (id) \n)' at line 5") '\nCREATE TABLE alertscheme (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tname VARCHAR(128), \n\t`desc` VARCHAR(1024), \n \tvaluetype VARCHAR, \n\tisdiscrete BOOL, \n\tminlevel INTEGER, \n \tmaxlevel INTEGER, \n\tPRIMARY KEY (id)\n)\n\n' {} ################## As far as I can tell, this is an error generated by SQLAlchemy creating bad SQL from the Python code. How should I go about debugging this? Thanks, Mike --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---