Re: unknown column in field list

2009-04-11 Thread Malcolm Tredinnick
On Sat, 2009-04-11 at 18:56 -0700, nixon66 wrote: > I have a legacy database that I used inspectdb to create the models. > I cleaned up the models, set primary keys, foriegn keys etc. But when > I tried to create a view I get an "unknown column activity.fp_id_id > in field li

unknown column in field list

2009-04-11 Thread nixon66
Forgot to add the view I'm using. def country_detail(request, country): c = Country.objects.get(slug=country) lobbyists = Activity.objects.filter(country=c) return render_to_response('country/country_detail.html', {'country':c, 'lobbyists':lobbyists})

Re: unknown column in field list

2009-04-11 Thread nixon66
11, 9:56 pm, nixon66 <nixon@gmail.com> wrote: > I have a legacy database that I used  inspectdb to create the models. > I cleaned up the models, set primary keys, foriegn keys etc. But when > I tried to create a view  I get an "unknown column activity.fp_id_id > in field

unknown column in field list

2009-04-11 Thread nixon66
I have a legacy database that I used inspectdb to create the models. I cleaned up the models, set primary keys, foriegn keys etc. But when I tried to create a view I get an "unknown column activity.fp_id_id in field list". I'm not sure why its appending an extra id to the end of a

Re: Unknown column in field list

2009-03-11 Thread Malcolm Tredinnick
ill not do anything. You either have to add the column manually to the database table or use one of the various migration tools around (e.g. django-evolution, south, dbmigrations) > > > (1054, "Unknown column 'tickets_ticket.ext_email' in 'field list'"). > > I tried dro

Unknown column in field list

2009-03-11 Thread mike171562
Hello, I tried to add a column to one of my models named Ticket. I ran a syncdb with no errors, but when i load my app I get the following error. (1054, "Unknown column 'tickets_ticket.ext_email' in 'field list'"). I tried dropping my Database and recreating to no avail. Anyone