Error Joining
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.
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.
Moderator
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.
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
1 guest and 0 members have recently viewed this.
