Field 'about_me' doesn't have a default value

Started by palmdoc, March 23, 2020, 06:38:16 AM

Previous topic - Next topic

palmdoc

Hi everyone
Suddenly I cannot add new members to my forum though it was working yesterday

Field 'about_me' doesn't have a default value
File: /home/xxx/public_html/mysite/forum/Sources/Subs-Members.php
Line: 774

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17, while your database is at version 2.0.15. The above error might possibly go away if you execute the latest version of upgrade.php.

Appreciate any help!

Kindred

looks like you installed a mod at some point that added a field called "about me".
Your host upgraded the mySQL installation.
the mod author never mput a default value for that field.

so...   go to your database (phpmyadmin)
find the about_me field (might be int he members table)
change the column to have a default value of NULL
Сл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."

palmdoc

Thanks so much for the reply!
Indeed there is a filed "about_me" in the _members table
Changing it now..... and the problem has gone away.
Thank you thank you!

Advertisement: