MyBB Community Forums

Hey everyone,

Well after finally modifying the MyBB table structure to fix a PgSQL bug in the installer, I come to find more SQL errors in the admin control panel when creating custom profile fields. The error is as follows:

SQL Error:
    23505 - ERROR: duplicate key value violates unique constraint "mybb_profilefields_pkey" 

I will have a screenshot attached to this post as well. Any thoughts would be appreciated.

Thanks!
Alec

---

Well after trying a few more times it decided to work however this issue might need to be looked into, not exactly sure.

we would need the table and index definition to provide help.

Well I have encountered yet more errors in the admin control panel while editing a user this time. Will attach a screenshots for the error and table + index structure.

mybb_profilefields
[attachment=16564]
[attachment=16565]

Latest error message I received
[attachment=16563]

mybb_userfields
[attachment=16566]
[attachment=16567]

---

mybb_userfields_ufid_seq
[attachment=16569]