• Welcome to Simple Machines Community Forum. Please login or sign up.

Impossible to register to my forum

Started by Dylert, April 19, 2019, 02:59:24 PM

Previous topic - Next topic

Dylert

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!

Kindred

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.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Dylert

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! :) 

Advertisement: