Re: error restoring project

[Luke Skibinski Holt]

Ah excellent - I think it's natural to presume after fixing a bunch of
errors and updating paths after restoring from backup to a new dir that
the fault is more than likely on your end than with product.

For anyone who follows, 'ordering' should be a list and look like:

class META:
ordering=['title']
...


Luke Skibinski Holt

Re: error restoring project

[Max Battcher]

Luke Skibinski Holt wrote:

my hd failed the other day taking my db with it. I'm trying to restore
my project now, but I'm getting this error in the admin app:

ERROR: missing FROM-clause entry for table "auth_users" SELECT
"blogs_blogs"."user_id","blogs_blogs"."title","blogs_blogs"."desc","blogs_blogs"."entriespp","blogs_blogs"."disabled"
FROM "blogs_blogs" ORDER BY "auth_users"."username" DESC


This is a known issue (http://code.djangoproject.com/ticket/930) dealing 
with the One-To-One relationship.  The SQL is not creating the proper 
JOIN for the default ordering and you need to explicitly create an 
ordering='title' in your Meta class so that is isn't ordering based on a 
field in the other class.


I'm assuming this isn't being fixed right now because the Subclassing 
system will replace it.


--
--Max Battcher--
http://www.worldmaker.net/

error restoring project

[Luke Skibinski Holt]

my hd failed the other day taking my db with it. I'm trying to restore
my project now, but I'm getting this error in the admin app:

ERROR: missing FROM-clause entry for table "auth_users" SELECT
"blogs_blogs"."user_id","blogs_blogs"."title","blogs_blogs"."desc","blogs_blogs"."entriespp","blogs_blogs"."disabled"
FROM "blogs_blogs" ORDER BY "auth_users"."username" DESC

I'm getting it for both of my apps installed, both having one-to-one
relationships with the user. Other models within those apps that don't
have any relationship to the user (but to other models) are not
failing.

The steps I took to restore my project were
create database
manage.py init
manage.py createsuperuser
manage.py install admin
manage.py install 

I'm using the latest revision as of this posting. Any ideas on what is
going wrong? Did I miss something or do something in the wrong order?


Luke Skibinski Holt