internal server error on registration

asked 2012-08-21 11:38:43 -0600

ankur gravatar image

updated 2012-08-21 20:33:45 -0600

todofixthis gravatar image

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

edit retag flag offensive close merge delete

Comments

ankur gravatar imageankur ( 2012-08-21 11:39:20 -0600 )edit

I 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 gravatar imageKim SJ ( 2012-12-04 13:27:22 -0600 )edit