Can you paste the query here? I think the problem is an unsupported feature by Mysql... Do you have another Mysql install to test?
On 3/2/06, Colleen Owens <[EMAIL PROTECTED]> wrote: > > I forgot to say this is with current Django trunk. > > ---------- Forwarded message ---------- > From: Colleen Owens > Date: Thu, 02 Mar 2006 03:34:08 -0000 > Subject: MySQL + FastCGI + Dreamhost = Trouble with foreign key in > admin > To: "Django users" <django-users@googlegroups.com> > > I'm getting an error when I try to modify a foreign key edited inline > in the admin interface using MySQL + FastCGI on a Dreamhost account. I > get the same type of error when I try to modify a Poll object (with > inline Choices) from the tutorial, so I know it's not my model that's > the problem. > > I've tried this with sqlite3 running on my local machine and I have no > problem with editing these models. I see from the chat logs that > someone else was having this problem a week or two ago, but he didn't > seem to figure it out (he switched to postgres and said that everything > worked fine). Unfortunately mysql is the easiest option on Dreamhost. > > OperationalError at /admin/polls/polls/add/ > (1093, "You can't specify target table 'polls_choices' for update in > FROM clause") > Request Method: POST > Request URL: http://<removed>/admin/polls/polls/add/ > Exception Type: OperationalError > Exception Value: (1093, "You can't specify target table > 'polls_choices' for update in FROM clause") > Exception Location: > /home/coowwa/local/lib/python2.4/site-packages/MySQLdb/connections.py > in defaulterrorhandler, line 32 > > > > -- Julio Nobrega - http://www.inerciasensorial.com.br --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---