Hello,
I'm a Django newbie, and I'm trying to set up a model that includes
the following table:
class Team(models.Model):
school = models.ForeignKey(School,
unique_for_year="season_start_date")
season_start_date = models.DateField()
division = models.ForeignKey(Division)
coach_first = models.CharField("coach's first name", maxlength=50,
blank=True)
coach_last = models.CharField("coach's last name", maxlength=50,
blank=True)
coach_email = models.EmailField("coach's email address",
blank=True)
coach_phone = models.PhoneNumberField("coach's phone", blank=True)
team_picture = models.ImageField(upload_to="team", blank=True)
players = models.ManyToManyField(Player, blank=True)
class Admin:
pass
class Meta:
order_with_respect_to = 'school'
When trying to add a team in the Django admin interface, I get this
error:
Traceback (most recent call last):
File "C:\Python25\lib\site-packages\django\core\handlers\base.py" in
get_response
77. response = callback(request, *callback_args, **callback_kwargs)
File "C:\Python25\lib\site-packages\django\contrib\admin\views
\decorators.py" in _checklogin
55. return view_func(request, *args, **kwargs)
File "C:\Python25\lib\site-packages\django\views\decorators\cache.py"
in _wrapped_view_func
39. response = view_func(request, *args, **kwargs)
File "C:\Python25\lib\site-packages\django\contrib\admin\views
\main.py" in add_stage
254. new_object = manipulator.save(new_data)
File "C:\Python25\lib\site-packages\django\db\models\manipulators.py"
in save
108. new_object.save()
File "C:\Python25\lib\site-packages\django\db\models\base.py" in save
238. ','.join(placeholders)), db_values)
File "C:\Python25\lib\site-packages\django\db\backends\util.py" in
execute
12. return self.cursor.execute(sql, params)
File "C:\Python25\lib\site-packages\MySQLdb\cursors.py" in execute
166. self.errorhandler(self, exc, value)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py" in
defaulterrorhandler
35. raise errorclass, errorvalue
OperationalError at /admin/football/team/add/
(1093, "You can't specify target table 'football_team' for update in
FROM clause")
which appears to stem from this SELECT statement:
"INSERT INTO `football_team`
(`school_id`,`season_start_date`,`division_id`,`coach_first`,`coach_last`,`coach_email`,`coach_phone`,`team_picture`,`_order`)
VALUES ('2','2005-09-10','2','','','','','',(SELECT COUNT(*) FROM
`football_team` WHERE `school_id` = '2'))"
This error disappears if I remove the Meta class. So what am I doing
wrong when I include it?
Thanks,
charles
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
