asked 2010-10-29 15:34:09 -0500Benoit
I don't know how it could have gotten in this state, but I have 3 questions in my database that do not have an entry in the question_revision table.
The questions display fine, but whenever I try to edit the question, I get an exception in query.py in __getitem__
Note that the ID in the table are sequential. There is no hole...
A few questions:
Something muste be out of hand. I've seen this problem on an installation where the program was trowing an exception between the time question is saved and the revision is intended to be saved.
The exception was
SMTPError, but in your case it could be something else, like for example some people missing
EmailFeedSetting values for those accounts that you have created programmatically.
There are management commands that "bandaid" that and related issues, but to really fix this we need to find what throws the exception and why.
python manage.py fix_revisionless_posts #will create an initial revision python manage.py fix_answer_counts #fixes incorrect answer counts
You can also try postgres and the database backend. With postgres django will run every request in its own transaction and will help prevent situations where data becomes corrupted by rolling back transactions that had an uncaught exception. (With postgres you'll also get relevancy ranking on full text search and automatically "and"ed search. In mysql search is "od"ed and is not very specific). In MySQL at the moment you have to choose between support of transactions and the full text search capability.
Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.create your Q&A site
Asked: 2010-10-29 15:34:09 -0500
Seen: 47 times
Last updated: Nov 10 '10