Error in registration

[Pastroious]

Code Select Expand

Database Error: ERROR:  null value in column "message_labels" of relation "smf_members" violates not-null constraint
DETAIL:  Failing row contains (17, TestUser, 1680036580, 0, 0, , 0, TestUser, 0, 0, 0, , , 0, , null, <<<<edit>>>>, [email protected], , 1004-01-01, , , 1, , , 0, , 0, 0, , 8.172.255.26, 8.172.255.26, , , 0, 3, , 0, , , 4, 0, <<<<edit>>>>, , 0, , 1, 0, UTC, , ).
Postgresql 15.2
SMF 2.1.3

[Pastroious]

 hxxp:forum.test.net/index.php?action=signup2 [nonactive]
/var/www/forum.test.net/Sources/Subs-Members.php (Line 722)

[Kindred]

What mods do you have?

[Pastroious]

My fault, I installed a clean SMF for test and all works flawless.
I do not see in members table column named message_labels

It is a long (5 years) story about my forum and the database.
Forum upgraded 2.015 > 2.016 > 2.017 > 2.018 > 2.019 > 2.1
and database 11 > 12 > 13 > 14 > 15
Only one mod was installed long time ago - Recount Member Posts 1.1

I deleted this column in the table. Now all works OK
Sorry for the confusion

[Arantor]

Wow, a Postgres user! That makes... 4?

[Oldiesmann]

That's a leftover column from 2.0. Prior to 2.1, we stored PM labels as a serialized string in the members table. That information was moved to its own table in 2.1.