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 list". I'm not sure wh

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
oh, forgot to add the view I'm using. Here is the view. 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}) On Apr 11

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 foriegnkey fie

Re: Unknown column in field list

2009-03-11 Thread Malcolm Tredinnick
On Wed, 2009-03-11 at 13:55 -0700, mike171562 wrote: > 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. If you change a model that already exists in the database, "syncdb" will not do anything. Yo

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 know about this