Revision history [back]
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)