On 1/19/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > jobs:~/Projects/media mitch$ python manage.py sqlreset tunica | mysql > --user=tunica --password=notmypassword tunica > ERROR 1064 (42000) at line 18: 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 'None) NOT NULL, > `genre_id` integer UNSIGNED NOT NULL REFERENCES `tunica_genr' at > line 5 > > I've also tried saving the output of the sqlreset command to a file and > sourcing it within an interactive mysql session but that fails in the > same way. > > Is there a bug in the sqlreset command? Or am I doing something silly?
Try running "python manage.py validate". If you get any errors, fix the errors and retry your "sqlreset" command. If you don't get any errors, show us the entire CREATE TABLE statement generated by "sqlreset" for the table that includes the genre_id field snippet you pasted above. We'll figure this out! Adrian -- Adrian Holovaty holovaty.com | djangoproject.com | chicagocrime.org
