Deleting an object that is involved in a many to many relationship using an intermediary model whose primary key is renamed at the db level fails because the generated SELECT statement is wrong.
In the example below, clicking on 'Delete' of an 'AdSalesAccount?' results in "OperationalError?: (1054, "Unknown column 'ad_order_listing_bridge.id' in 'field list'")"
Error occurs in django\db\models\sql\query.py in execute_sql on line 2370:
Traceback:
File "C:\Python25\lib\site-packages\django\core\handlers\base.py" in get_response
87. response = middleware_method(request, callback, callback_args, callback_kwargs)
File "build\bdist.win32\egg\firepython\middleware.py" in process_view
305. return self._profile_wrap(callback)(*args, **callback_kwargs)
File "C:\Python25\lib\site-packages\django\contrib\admin\sites.py" in root
480. return self.model_page(request, *url.split('/', 2))
File "C:\Python25\lib\site-packages\django\views\decorators\cache.py" in _wrapped_view_func
44. response = view_func(request, *args, **kwargs)
File "C:\Python25\lib\site-packages\django\contrib\admin\sites.py" in model_page
499. return admin_obj(request, rest_of_url)
File "C:\Python25\lib\site-packages\django\contrib\admin\options.py" in __call__
1092. return self.delete_view(request, unquote(url[:-7]))
File "C:\Python25\lib\site-packages\django\contrib\admin\options.py" in delete_view
1009. get_deleted_objects(deleted_objects, perms_needed, request.user, obj, opts, 1, self.admin_site)
File "C:\Python25\lib\site-packages\django\contrib\admin\util.py" in get_deleted_objects
125. for sub_obj in getattr(obj, rel_opts_name).all():
File "C:\Python25\lib\site-packages\django\db\models\query.py" in _result_iter
110. self._fill_cache()
File "C:\Python25\lib\site-packages\django\db\models\query.py" in _fill_cache
707. self._result_cache.append(self._iter.next())
File "C:\Python25\lib\site-packages\django\db\models\query.py" in iterator
242. for row in self.query.results_iter():
File "C:\Python25\lib\site-packages\django\db\models\sql\query.py" in results_iter
287. for rows in self.execute_sql(MULTI):
File "C:\Python25\lib\site-packages\django\db\models\sql\query.py" in execute_sql
2370. cursor.execute(sql, params)
The reason is invalid SQL is generated here:
sql = u'SELECT `ad_order_listing_bridge`.`id`, #####Should be ad_orderId
`ad_order_listing_bridge`.`ad_order_listing_bridgeId`, `ad_order_listing_bridge`.`ad_orderId`, `ad_order_listing_bridge`.`listingId` FROM `ad_order_listing_bridge` WHERE `ad_order_listing_bridge`.`ad_orderId` = %s '}}}
{{{
#!python
AdSalesModel = models.Model
class AdSalesAccount(AdSalesModel):
id = models.AutoField(primary_key=True, db_column='accountId')
class Meta:
db_table = u'account'
ordering = ('-date_created', 'name')
using = 'adsales'
class AdSalesAdOrder(models.Model):
id = models.AutoField(primary_key=True, db_column='ad_orderId')
account = models.ForeignKey(AdSalesAccount, db_column='accountId')
listings = models.ManyToManyField('AdSalesListing', through='AdSalesAdOrderListingBridge')
class Meta:
db_table = u'ad_order'
ordering = ('-date_created', )
using = 'adsales'
class AdSalesAdOrderListingBridge(models.Model):
id = models.IntegerField(db_column='ad_order_listing_bridgeId')
adorder = models.ForeignKey(AdSalesAdOrder, db_column='ad_orderId')
listing = models.ForeignKey('AdSalesListing', db_column='listingId')
class Meta:
using = 'adsales'
db_table = u'ad_order_listing_bridge'
class AdSalesListing(AdSalesModel):
id = models.AutoField(primary_key=True, db_column='listingId')
class Meta:
db_table = u'listing'
ordering = ("-date_created", "descriptive_line")
using = 'adsales'
}}}
