Thanks, that worked perfectly. right now i can lose the data as i'm still learning this all. I will have to look into editing the DB via the shell for future fixes
On Dec 29, 11:20 pm, Daniel Roseman <roseman.dan...@googlemail.com> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
