Advertisement:

Author Topic: Impossible to register to my forum  (Read 232 times)

Offline Dylert

  • Jr. Member
  • **
  • Posts: 257
  • Gender: Male
    • Hellasforum
Impossible to register to my forum
« on: April 19, 2019, 02:59:24 PM »
Unfortunately nobody can register to my forum at the moment. I have checked the smf_log_errors in the database and it says:

Database error: Field 'profile_views' doesn't have a default value<br /><br /><br />         INSERT INTO smf_members(`member_name`, `email_address`, `passwd`, `password_salt`, `posts`, `date_registered`, `member_ip`, `member_ip2`, `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`, `aim`, `yim`, `msn`, `time_format`, `signature`, `avatar`, `usertitle`, `secret_question`, `secret_answer`, `additional_groups`, `ignore_boards`, `smiley_set`, `openid_uri`, `is_activated`, `hide_email`)<br />         VALUES<br />            ('Senter', 'ssdsdsd@dfdfdff.no', '1cd78cc712031b8d5b3444fedda7ce9744ba0285', '42d6', 0, 1555699218, '', '', '71dcd9f7eb', 'Senter', '', 1, 0, 4, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1)


File: /customers/d/7/7/hellasforum.net/httpd.www/Sources/Subs-Members.php

How can I fix this? Any suggestions? My forum is at http://www.hellasforum.net

Thanks in advance!

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,500
  • Gender: Male
    • Kindred-999 on GitHub
Re: Impossible to register to my forum
« Reply #1 on: April 19, 2019, 03:41:20 PM »
Go to the database.
Fine the table with the column "profile_views" (looks like it might be in the smf_members table)
set the default value (usually NULL) for that column.


Or...

remove the mod that uses that column
and then delete the column from the database
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Dylert

  • Jr. Member
  • **
  • Posts: 257
  • Gender: Male
    • Hellasforum
Re: Impossible to register to my forum
« Reply #2 on: April 19, 2019, 04:52:40 PM »
Go to the database.
Fine the table with the column "profile_views" (looks like it might be in the smf_members table)
set the default value (usually NULL) for that column.

Thanks a lot! The solution above worked! :)