Error which impedes new registrations

[FragaCampos]

Hi there.
Today I received information that users can no longer register on my forum.
This was strange, because it never happened in more than 10 years, but I went and tried to register a new account and it's true.
After filling the required fields to register, I get a message saying

"Error in the database
Please, try again. If you see this error again, contact the admins"

If I login and check the error log, I see this:

Code Select Expand

Erro na base de dados: Field 'topics' doesn't have a default value


INSERT INTO smf_members(`member_name`, `email_address`, `passwd`, `password_salt`, `posts`, `date_registered`, `member_ip`, `member_ip2`, `is_spammer`, `validation_code`, `real_name`, `personal_text`, `pm_email_notify`, `id_theme`, `id_post_group`, `lngfile`, `buddy_list`, `pm_ignore_list`, `message_labels`, `website_title`, `website_url`, `location`, `icq`, `facebook`, `myspace`, `twitter`, `googleplus`, `linkedin`, `youtube`, `deviantart`, `pinterest`, `aim`, `yim`, `msn`, `skype`, `gtalk`, `time_format`, `signature`, `avatar`, `usertitle`, `secret_question`, `secret_answer`, `additional_groups`, `ignore_boards`, `smiley_set`, `openid_uri`, `is_activated`, `gender`, `hide_email`)
VALUES
('Tyler', '<emailaddress>', '3bfcb15244578bb082318f5f19dc0c220e86adfe', 'c567', 0, 1584898447, '201.37.164.241', '201.37.164.241', '0', '', 'Tyler', '', 1, 0, 4, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 0, 1)
Apply Filter: Only show the errors from this file
File: /home/docsptco/public_html/Sources/Subs-Members.php
Line: 797


What can this be?


Btw, this is what I have on line 797:

   // Register them into the database.
   $smcFunc['db_insert']('',
      '{db_prefix}members',
      $column_names,
      $values,
      array('id_member')
797   );
   $memberID = $smcFunc['db_insert_id']('{db_prefix}members', 'id_member');

[Kindred]

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

so...   go to your database (phpmyadmin)
find the about_me topics field (might be int he members table)
change the column to have a default value of NULL

[FragaCampos]

Thank you for your reply, Kindred.

I searched for "topics" in the database structure, but, unfortunately, I really don't know what I'm looking for.
Can you please point me more specifically where can I search for that?

[FragaCampos]

OK, I found a "topics" column in smf_members table.

That column is set to "None"


Should I set it to Null? Is that it?

Isn't this a core SMF column?

[FragaCampos]

OK, I went ahead and change that value to NULL and my registrations are back online. 

Thank you very much once again!