Error Joining

Post

Posted
Rating:
#5786 (In Topic #1366)
Avatar
Standard member
rgscriven is in the usergroup ‘Fan in action’
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, 'test@hotmail.com', '', '', '', 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 error code.png 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. 




 
Online now: No Back to the top

Post

Posted
Rating:
#5799
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
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.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#5801
Avatar
Standard member
rgscriven is in the usergroup ‘Fan in action’
thankyou all working now as i just recreated the website and members table
Online now: No Back to the top
1 guest and 0 members have just viewed this.

Statistics

Users online:

gabriel58, MVLipwig, amit.nigam, deepu_ms, John Connor, Philip, Vaiva, ManojSree

Forum statistics:
  • 1,052 topics, 5,087 posts, 5,914 members
  • Our newest member is joon1
Birthdays:
Back to Top