Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Database IntegrityError in admin

Got a fresh install of askbot pulled from pip.

I have got some trouble using the admin so I activated the debug mode in settings.py.

Whenever I try to delete a user, I have this error :

DatabaseError at /admin/auth/user/
relation "group_messaging_lastvisittime" does not exist
LINE 1: ..., "auth_user"."consecutive_days_visit_count" FROM "group_mes...

when I try to just update a User's record, I got this error after pressing Save button :

IntegrityError at /admin/auth/user/3/
update or delete on table "auth_user_groups" violates foreign key constraint "authusergroups_ptr_id_refs_id_5cdfc23b7859c44e" on table "askbot_groupmembership"
DETAIL:  Key (id)=(5) is still referenced from table "askbot_groupmembership".

It's a fresh install but at installation time, when I issued the command

python manage.py migrate askbot

I has a problem with postgres pip driver and server mismatch. So I had to fix the problem and re-run :

python manage.py migrate askbot

Would it be the cause of this messy database state ?

How can I resolve it ? (I'm not used to django)