when someone wants to join and after they do the normal joining stuff they get this at the end so what could be causing the issues

An error has occurred 
Unfortunately a query has failed [INSERT INTO cre4_f_members (m_username, m_pass_hash_salted, m_pass_salt, m_theme, m_avatar_url, m_validated, m_validated_email_confirm_code, m_cache_num_posts, m_cache_warnings, m_max_email_attach_size_mb, m_join_time, m_timezone_offset, m_primary_group, m_last_visit_time, m_last_submit_time, m_is_perm_banned, m_preview_posts, m_dob_day, m_dob_month, m_dob_year, m_reveal_age, m_email_address, m_title, m_photo_url, m_photo_thumb_url, m_views_signatures, m_auto_monitor_contrib_content, m_highlighted_name, m_pt_allow, m_language, m_ip_address, m_allow_emails, m_allow_emails_from_staff, m_password_change_code, m_password_compat_scheme, m_on_probation_until, m_profile_views, m_total_sessions, m_auto_mark_read, m_signature, m_signature__text_parsed, m_signature__source_user, m_pt_rules_text, m_pt_rules_text__text_parsed, m_pt_rules_text__source_user) VALUES ('test1', '$2y$10$AlyRGtVe../ri6TRyGEQher.MJ7O6R02ZcZR1uNzGBwGYU6QcyTPe', 'b2e275775b660', '', 'themes/default/images/cns_default_avatars/default_set/eagle.png', 1, '2033543506', 0, 0, 5, 1556885350, 'Australia/Sydney', 9, 1556885350, 1556885350, 0, 0, 3, 1, 1989, 1, '[email protected]', '', '', '', 1, 1, 0, '*', 'EN', '1.132.109.52', 1, 1, '', '', NULL, 0, 0, 1, '', 'return unserialize(\"a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:39:\\"string_attach_5ccc2f669bdf73.71040200_1\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:39:\\"string_attach_5ccc2f669bdf73.71040200_1\\";s:68:\\"\$tpl_funcs[\'string_attach_5ccc2f669bdf73.71040200_1\']=\\"echo \\\\"\\\\";\\";\n\\";}}\");\n', 1, '', 'return unserialize(\"a:5:{i:0;a:1:{i:0;a:1:{i:0;a:5:{i:0;s:39:\\"string_attach_5ccc2f669bdf73.71040200_2\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\"\\";i:4;s:0:\\"\\";}}}i:1;a:0:{}i:2;s:10:\\":container\\";i:3;N;i:4;a:1:{s:39:\\"string_att ach_5ccc2f669bdf73.71040200_2\\";s:68:\\"\$tpl_funcs[\'string_attach_5ccc2f669bdf73.71040200_2\']=\\"echo \\\\"\\\\";\\";\n\\";}}\");\n', 1)] [Field 'id' doesn't have a default value] (version: 10.0.25, PHP version: 7.0.33, URL: /index.php?page=join&type=step3&redirect=https%3A%2F%2Fpowgamers.com%2Findex.php%3Fpage%3Dstart) 
The staff have been provided a ‘stack trace’ which may help them diagnose the problem. 




 

Hi,

This may happen if the database structure is corrupted somehow.
The 'id' field of your 'cre4_f_members' table needs to have 'auto_increment' set on it.

thankyou all working now as i just recreated the website and members table