That's not seeming like such a huge problem to me. Out of curiosity, does
the error continue to occur if you remove the single quotes around
AuthorCategory? I noticed earlier that you have that code defined before
BookCategory ... generally you only need quotes if you have not yet defined
the relationship model.
I feel certain the relationship itself is not the problem. I say this
because I am doing something similar with some extensive subclassing of
Satchmo's Product class like so:
class CustomProdOne(Product):
special_field = models.CharField()
class CustomProdTwo(Product):
prod_one = models.ForeignKey(CustomProdOne)
... more fields ...
class CustomProdThree(Product):
prod_one = models.ForeignKey(CustomProdOne)
prod_two = models.ForeignKey(CustomProdTwo)
... more fields ...
So, essentially I am doing the same thing, and more.
Any chance you still receive the error if you completely drop all tables and
re-syncdb from scratch? I can't really see your schema from here, but Django
is being pretty clear that the column it is trying to access simply does not
exist in the db.
On Mon, Mar 23, 2009 at 10:48 PM, Jon <[email protected]> wrote:
>
> I think this is my issue:
> class BookCategory(Category):
> ....
> parent = models.ForeignKey('AuthorCategory')
> ...
>
> The field "parent" already exists in Category, and I'm trying to
> replace it with a subclass of Category. That is, a Category can have
> a Category as a parent, but I want a BookCategory to limit the choice
> of parents to AuthorCategories. I think there is probably a better
> way to do this.
>
> On Mar 23, 9:23 pm, Jon <[email protected]> wrote:
> > Here's the error. What I mean by a built-in query is that this is all
> > inside the Django admin. When I add a new BookCategory through the
> > admin and hit save, I get this error. Thanks again for all your help
> > in trying to pin down what's going on.
> > Environment:
> >
> > Request Method: POST
> > Request URL:http://localhost:8081/admin/custom_satchmo/bookcategory/add/
> > Django Version: 1.0-final-SVN-unknown
> > Python Version: 2.5.2
> > Installed Applications:
> > ['django.contrib.admin',
> > 'django.contrib.admindocs',
> > 'django.contrib.auth',
> > 'django.contrib.contenttypes',
> > 'django.contrib.comments',
> > 'django.contrib.sessions',
> > 'django.contrib.sitemaps',
> > 'django.contrib.sites',
> > 'satchmo',
> > 'satchmo.caching',
> > 'satchmo.configuration',
> > 'satchmo.shop',
> > 'satchmo.contact',
> > 'satchmo.product',
> > 'satchmo.shipping',
> > 'satchmo.payment',
> > 'satchmo.discount',
> > 'satchmo.giftcertificate',
> > 'satchmo.supplier',
> > 'satchmo.thumbnail',
> > 'satchmo.l10n',
> > 'satchmo.tax',
> > 'satchmo.recentlist',
> > 'satchmo.wishlist',
> > 'satchmo.upsell',
> > 'satchmo.productratings',
> > 'store.site',
> > 'store.custom_satchmo']
> > Installed Middleware:
> > ('django.middleware.common.CommonMiddleware',
> > 'django.contrib.sessions.middleware.SessionMiddleware',
> > 'django.middleware.locale.LocaleMiddleware',
> > 'django.contrib.auth.middleware.AuthenticationMiddleware',
> > 'django.middleware.doc.XViewMiddleware',
> > 'satchmo.shop.SSLMiddleware.SSLRedirect',
> > 'satchmo.recentlist.middleware.RecentProductMiddleware')
> >
> > Traceback:
> > File "/var/lib/python-support/python2.5/django/core/handlers/base.py"
> > in get_response
> > 86. response = callback(request, *callback_args,
> > **callback_kwargs)
> > File "/var/lib/python-support/python2.5/django/contrib/admin/sites.py"
> > in root
> > 158. return self.model_page(request, *url.split('/',
> > 2))
> > File "/var/lib/python-support/python2.5/django/views/decorators/
> > cache.py" in _wrapped_view_func
> > 44. response = view_func(request, *args, **kwargs)
> > File "/var/lib/python-support/python2.5/django/contrib/admin/sites.py"
> > in model_page
> > 177. return admin_obj(request, rest_of_url)
> > File "/var/lib/python-support/python2.5/django/contrib/admin/
> > options.py" in __call__
> > 191. return self.add_view(request)
> > File "/var/lib/python-support/python2.5/django/db/transaction.py" in
> > _commit_on_success
> > 238. res = func(*args, **kw)
> > File "/var/lib/python-support/python2.5/django/contrib/admin/
> > options.py" in add_view
> > 502. self.save_model(request, new_object, form,
> > change=False)
> > File "/var/lib/python-support/python2.5/django/contrib/admin/
> > options.py" in save_model
> > 376. obj.save()
> > File "/usr/lib/python2.5/site-packages/satchmo/product/models.py" in
> > save
> > 223. self.slug = slugify(self.name, instance=self)
> > File "/usr/lib/python2.5/site-packages/satchmo/utils/unique_id.py" in
> > slugify
> > 95. while get_query():
> > File "/var/lib/python-support/python2.5/django/db/models/query.py" in
> > __nonzero__
> > 185. iter(self).next()
> > File "/var/lib/python-support/python2.5/django/db/models/query.py" in
> > _result_iter
> > 179. self._fill_cache()
> > File "/var/lib/python-support/python2.5/django/db/models/query.py" in
> > _fill_cache
> > 612. self._result_cache.append(self._iter.next
> > ())
> > File "/var/lib/python-support/python2.5/django/db/models/query.py" in
> > iterator
> > 269. for row in self.query.results_iter():
> > File "/var/lib/python-support/python2.5/django/db/models/sql/query.py"
> > in results_iter
> > 206. for rows in self.execute_sql(MULTI):
> > File "/var/lib/python-support/python2.5/django/db/models/sql/query.py"
> > in execute_sql
> > 1700. cursor.execute(sql, params)
> > File "/var/lib/python-support/python2.5/django/db/backends/util.py" in
> > execute
> > 19. return self.cursor.execute(sql, params)
> > File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/
> > base.py" in execute
> > 167. return Database.Cursor.execute(self, query, params)
> >
> > Exception Type: OperationalError at /admin/custom_satchmo/bookcategory/
> > add/
> > Exception Value: no such column:
> > custom_satchmo_authorcategory.category_ptr_id
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Satchmo 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/satchmo-users?hl=en
-~----------~----~----~----~------~----~------~--~---
