Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Dylert on April 19, 2019, 02:59:24 PM

Title: Impossible to register to my forum
Post by: Dylert 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', '[email protected]', '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!
Title: Re: Impossible to register to my forum
Post by: Kindred 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
Title: Re: Impossible to register to my forum
Post by: Dylert on April 19, 2019, 04:52:40 PM
Quote from: Kindred 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.

Thanks a lot! The solution above worked! :)