When you uninstall a mod always check to see if it causes problems. If it does then manually check to see if all of the code is removed before removing any others. If you still have problems then proceed to the next mod and do the same.

Quote from: Ronald on Apr 13, 2019, 06:12 PMI have a member wishing to register on my forum, and can't do it. I tried to pre register this member and I get the following error.

Field 'inactive_mail' doesn't have a default value
File: /home/coffeeti/public_html/Sources/Subs-Members.php
Line: 725

Any ideas..

go into the database and add a default value to that field of 0

Quote from: live627 on Apr 14, 2019, 12:40 AMgo into the database and add a default value to that field of 0

Not sure what you mean, so I included that part below.

// Theme variables too?
   if (!empty($theme_vars))
   {
      $inserts = array();
      foreach ($theme_vars as $var => $val)
         $inserts[] = array($memberID, $var, $val);
      $smcFunc['db_insert']('insert',
         '{db_prefix}themes',
         array('id_member' => 'int', 'variable' => 'string-255', 'value' => 'string-65534'),
         $inserts,
         array('id_member', 'variable')
      );
   }

He means you should go into phpmyadmin. Search for the 'inactive_mail' field and enter a zero into it. Currently, it has nothing in it.

Quote from: Skhilled on Apr 14, 2019, 02:27 PMHe means you should go into phpmyadmin. Search for the 'inactive_mail' field and enter a zero into it. Currently, it has nothing in it.

Sorry I can not find inactive_mail in the phpmyadmin.

It might be a column in smf_members

Yes I found it now under SMF Members. But I see nothing about putting a 0 in, there are 0's in place and also this number in a few of the places. 1544661379

I also place a image of it: You cannot view this attachment.

In the inactive_mail column it shows the word none. It should show a 0 there if I read it right. You will have to click on the change link and add the 0 in there somewhere.

Quote from: Bigguy on Apr 14, 2019, 08:58 PMIn the inactive_mail column it shows the word none. It should show a 0 there if I read it right. You will have to click on the change link and add the 0 in there somewhere.

Changed from None to 0

Still doesn't work. Tried registering an account got this message: Please try again. If you come back to this error screen, report the error to an administrator.

Checking the error log I see this:

Type of error: Database
Database Error: Field 'sent_mail' doesn't have a default value


INSERT INTO smf_members(`member_name`, `email_address`, `passwd`, `password_salt`, `posts`, `date_registered`, `member_ip`, `member_ip2`, `validation_code`, `real_name`, `personal_text`, `id_theme`, `id_post_group`, `lngfile`, `buddy_list`, `pm_ignore_list`, `website_title`, `website_url`, `time_format`, `signature`, `avatar`, `usertitle`, `secret_question`, `secret_answer`, `additional_groups`, `ignore_boards`, `smiley_set`, `timezone`, `is_activated`)
VALUES
('Arcade Guy', 'aracdeguy38@gmail.com', '$2y$12$Pgj3Rq6cYi1o1Z6Bn7gC0ePNJ5Hl3jEDzqniNbVCbNeHZ6d/ea/ea', '09ad', 0, 1555294155, unhex('3273b005'), unhex('3273b005'), 'd7fe73e141', 'Arcade Guy', '', 0, 4, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'America/Toronto', 0) https://coffeetimeunlimited.com/index.php?action=signup2
/home/coffeeti/public_html/Sources/Subs-Members.php (Line 710)

You need to change the default value for sent_mail to 0 as well

Quote from: Oldiesmann on Apr 14, 2019, 09:35 PMYou need to change the default value for sent_mail to 0 as well

Changed and still get a error trying to register..

I wonder if putting null in there would work...

Quote from: Bigguy on Apr 15, 2019, 08:27 AMI wonder if putting null in there would work...

I looked at a test board I have running with RC2, those are not in smf members. Maybe RC2 is different

Maybe it is.