On Dec 29, 11:04 pm, garagefan <monkeygar...@gmail.com> wrote: > awesome... it was all in that [:1]! > > now, next issue... > > "OperationalError at /admin/galleries/gallery/ > (1054, "Unknown column 'galleries_gallery.status' in 'field list'")" > > i just added the status field as i wasn't worried about any of that > previously... now, it appears to be causing issues. I've ran syncdb, > but it doesn't seem to be adding this new column. I gather it is very > very important to consider your required fields before syncing > originally... how do i go about fixing this issue? > > thanks again
Syncdb doesn't modify existing tables. If you don't have any data you need to keep, you can run ./manage.py reset galleries Note that this will completely delete and recreate your tables. If you want to preserve existing data, you'll need to go into your database shell (via ./manage.py dbshell) and run the SQL to modify your table manually - something like ALTER TABLE `galleries_gallery` ADD COLUMN `status` VARCHAR(1) NOT NULL; (guessing at the column definition, change as required). -- DR. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
