Error Joining
Posted
#5786
(In Topic #1366)

Standard member

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

The staff have been provided a ‘stack trace’ which may help them diagnose the problem.
Posted

Site director

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 Mastodon. Follow me on Minds (where I am most active). Support me on Patreon
- 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.
Posted

Standard member

1 guest and 0 members have just viewed this.