QUICK NEWS

{NEW} - A new css video is up.

{OLD} - New video courtesy of Skhilled, Thanks for posting it up.

Video of the moment:


Internal Links

SMF Sites

Quick Info

Registration not working

Started by Ronald, Apr 13, 2019, 06:12 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Skhilled

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.

live627

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

Ronald

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')
      );
   }

Skhilled

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.

Ronald

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.

live627

It might be a column in smf_members

Ronald

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.

Bigguy

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.
"It's the American dream....cause ya have to be asleep to believe it." - George Carlin

Ronald

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

Ronald

#24
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)

Oldiesmann

You need to change the default value for sent_mail to 0 as well
Christian Metal Fans - https://www.christianmetal.fans

Ronald

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..

Bigguy

I wonder if putting null in there would work...
"It's the American dream....cause ya have to be asleep to believe it." - George Carlin

Ronald

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

Bigguy

"It's the American dream....cause ya have to be asleep to believe it." - George Carlin