the String() type requires a length on MySQL, since MySQL has no
length-less VARCHAR construct.
mhearne808[insert-at-sign-here]gmail[insert-dot-here]com wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
