2008-10-17, 08:30 AM
mybb1.4.2 and PostgreSQL. When trying to delete a user I get:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
0 - ERROR: update or delete on table "mybb_users" violates foreign key constraint "mybb_userfields_ufid_fkey" on table "mybb_userfields" DETAIL: Key (uid)=(3) is still referenced from table "mybb_userfields".
Query:
DELETE FROM mybb_users WHERE uid='3'
Any ideas ?
Thanks
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
0 - ERROR: update or delete on table "mybb_users" violates foreign key constraint "mybb_userfields_ufid_fkey" on table "mybb_userfields" DETAIL: Key (uid)=(3) is still referenced from table "mybb_userfields".
Query:
DELETE FROM mybb_users WHERE uid='3'
Any ideas ?
Thanks