Database Error: Field 'undeletable' doesn't have a default value

[Fassbier]

Hi there,

I already fixed the problem which I could find here multiple times, to add NULL in phymyadmin in smf_message to create new topics.

Now I`m stuck with ne personal message. Here I got the error like in the Subject. I added also here the "NULL" as Standard for "undeleteable" in "smf_personal_messages" but it didn`t fix the problem.
Any advice? any other with the same problem?


Databaseerror
Field 'undeletable' doesn't have a default value
Datei: /home/xxxx/smf/Sources/Subs-Post.php
Zeile: 1186



kind regards,
Fassbier


edit: just updated from 2.0 to 2.1, if helpful

[Kindred]

If you are still getting that exact message, then whatever change you think that you made either was tob the wrong location or did not successfully complete

There is no other fix,  other tab to remove the field entirely

[Doug Heffernan]

That field must have come from a custom mod as there is no such field in the smf_personal_messages table. If you still are using the mod that has added, uninstall it first and then remove said field from that table.

[mickjav]

If the data type for field in int I would use a default of 0

[Fassbier]

Thank you all for your answers.

I`d try to delete the field "undeleteable", same message if I want to send a PM.
I`d try to change to INT and 0, same.

Maybe there is a other table in service like smf_personal_messages? I`m pretty sure that I edit the right one.

kind regards,
Fassbier

[Fassbier]

got it, it is smf_pm_recipients.

I`m just a bit confused, there are just 2 mods installed and they have nothing to do with pm. wonder why undeletable is still there. I`ll find a way to tidy up.

thank you all!
kind regards,
Fassbier

[@rjen]

Mods usually do not remove fields from tables upon uninstalling. So you may have had a mod in the past that you uninstalled, that left the extra fields in the table.