Im getting internal server error on registration.This was running fine from a week
IntegrityError at /account/register/null value in column "hide_ignored_questions" violates not-null constraint
Request Method: POST Request URL: http://www.heapstack.net/account/register/Django Version: 1.3.1 Exception Type: IntegrityError Exception Value: null value in column "hide_ignored_questions" violatesnot-nullconstraint Exception Location: /home/woocation/webapps/askbot_codeguru/lib/python2.7/Django-1.3.1-py2.7.egg/django/db/backends/postgresql_psycopg2/base.py in execute, line 44 Python Executable: /usr/local/bin/python Python Version: 2.7.3 Python Path: ['/home/woocation/webapps/askbot_codeguru/lib/python2.7/askbot-0.7.43-py2.7.egg', '/home/woocation/webapps/askbot_codeguru/lib/python2.7/django_threaded_multihost-1.4_1-py2.7.egg', '/home/woocation/webapps/askbot_codeguru/lib/python2.7/South-0.7.6-py2.7.egg', '/home/woocation/webapps/askbot_codeguru/lib/python2.7/Coffin-0.3.6-py2.7.egg', '/home/woocation/webapps/askbot_codeguru/lib/python2.7/django_recaptcha_works-0.3.4-py2.7.egg', '/home/woocation/webapps/askbot_codeguru/lib/python2.7/markdown2-2.0.1-py2.7.egg', '/home/woocation/webapps/askbot_codeguru/lib/python2.7/lamson-1.1-py2.7.egg', '/home/woocation/webapps/askbot_codeguru/lib/python2.7/akismet-0.2.0-py2.7.egg', '/home/woocation/webapps/ask
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 siteAsked: 2012-08-21 11:38:43 -0500
Seen: 38 times
Last updated: Aug 21 '12
Copyright Askbot, 2010-2011. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Website url is http://www.heapstack.net
ankur ( 2012-08-21 11:39:20 -0500 )editI fixed this by hacking the database using phpPgAdmin; setting default values for the columns hide_ignored_questions (false), tag_filter_setting (false), response_count (0). No idea if this is a good idea, (or whether these defaults are correct), but at least the site doesn't throw errors when I create a new user! I have an uncomfortable feeling that my site is half-migrated. :-/
Kim SJ ( 2012-12-04 13:27:22 -0500 )edit