Posts.objects.published() not being updated when new object added to database

[Dan Conner]

My site is running basic.blog, with a Django release somewhere around
0.98, using manage.py runfcgi method=prefork, and
postgresql_psycopg2 / Postgres database.

When I create a new post object, it doesn't make it in to the
Post.objects.published() queryset.

If I go to terminal, run manage.py shell and run the query, the object
is included in the queryset. The columns in the database are getting
set correctly.

If I restart the fcgi processes, the post is included in
the .published() queryset.

I'm not using any caching mechanism (that I know of).

And I'm perplexed. I know this is probably not an issue with the
basic.blog application itself, but would anyone with more experience
know where to look for why the new posts are not showing up.

Thanks,
dc

[Dan Conner]

nevermind. just a discrepancy between server time and local javascript
client time. I think.

[JGAllen23]

I'm having the same issue, but it's not a server vs local time issue
because on my category page the blog entry shows up. If I click on
the blog, it goes to a 404 page. If I restart the webserver,
everything works.

Any ideas?

[Christos Trochalakis]

On Thu, Dec 11, 2008 at 4:20 AM, JGAllen23 <j.greg...@gmail.com> wrote:
>
> I'm having the same issue, but it's not a server vs local time issue
> because on my category page the blog entry shows up. If I click on
> the blog, it goes to a 404 page. If I restart the webserver,
> everything works.
>
> Any ideas?
>

I have opened a bug report for that a few days ago here:

http://code.google.com/p/django-basic-apps/issues/detail?id=27

There is a patch there that you can apply until there is an upstream fix.

-christos