News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Error in registration

Started by Pastroious, March 28, 2023, 04:55:08 PM

Previous topic - Next topic

Pastroious

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

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

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.
Michael Eshom
Christian Metal Fans

Advertisement: