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 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?hl=en -~----------~----~----~----~------~----~------~--~---