#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
Main Support Forums
How-to and Troubles...
Registration error:...
 
Share:
Share
Tweet
Share
Notifications
Clear all

[Solved] Registration error: couldn't register you... please contact the site admin!

    Last Post
RSS

Sujal
Posts: 8
 Sujal
Topic starter
August 27, 2021 6:32 am
(@sujal)
Active Member
Joined: 9 months ago

Hi there,

I have this site and I just installed wpforo so it is a fresh installation. Though, I used buddyboss for forums only before this plugin and I think now that is deactivated, it couldn't have sent the issue.

I tried to register as a new user in a guest window without any console errors or wp debugging errors. But, the error as stated: couldn't register you... please contact the site admin! appears at the top right corner.

I enabled user accounts may be registered from my multisite network and enabled wpforo registration with email link. I use wordfence for security and once I enabled login and registration captcha on wordfence and it did pose a problem but since then I disabled captcha and it just gets me this error.

I don't use any caching plugin, the only plugins I have activated for now are: astra pro, footnotes by mark cheret, health check and troubleshooting,  query monitor, really simple ssl, Stop Generating Unnecessary Thumbnails, updraftplus, wordfence, wp debugging by andy fragen and wp file manager along with wpforo. Previously I had also activated http headers plugin by Dimitar Avanov but I deactivated it.

I use the popular astra theme by brainstorm force along with astra pro.

Please note that this is a multisite installation.

Let me know if you need some additional information to help me troubleshoot this problem.

 Screenshot-34.png
Topic Tags
registration registration bug login error
4 Replies
Sujal
Posts: 8
 Sujal
Topic starter
August 27, 2021 6:37 am
(@sujal)
Active Member
Joined: 9 months ago

Okay. I get some jquery warnings in the console if that might be the problem.

 Screenshot-35.png
Sujal
Posts: 8
 Sujal
Topic starter
August 27, 2021 7:22 am
(@sujal)
Active Member
Joined: 9 months ago
[27-Aug-2021 06:12:52 UTC] WordPress database error Unknown column 'spam' in 'field list' for query INSERT INTO `QdcpzrKAusers` (`user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `display_name`, `user_login`, `spam`) VALUES ('$P$BT93a9y7aztndBC/JcJjcNaB5rYq8S/', 'drno', 'email@gmail.com', '', '2021-08-27 06:12:52', '', 'drno', 'drno', 0) made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wpForo->init, do_action('wpforo_after_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->do_actions, do_action('wpforo_action_wpforo_registration'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->registration, wpForoMember->create, register_new_user, wp_create_user, wp_insert_user, QM_DB->query

[27-Aug-2021 06:12:52 UTC] WordPress database error Unknown column 'spam' in 'where clause' for query SELECT COUNT(ID) as c FROM QdcpzrKAusers WHERE spam = '0' AND deleted = '0' made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wpForo->init, do_action('wpforo_after_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->do_actions, do_action('wpforo_action_wpforo_registration'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->registration, wpForoMember->create, register_new_user, wp_create_user, wp_insert_user, do_action('user_register'), WP_Hook->do_action, WP_Hook->apply_filters, wp_maybe_update_network_user_counts, wp_update_network_user_counts, QM_DB->query

[27-Aug-2021 06:16:59 UTC] WordPress database error Unknown column 'spam' in 'field list' for query INSERT INTO `QdcpzrKAusers` (`user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `display_name`, `user_login`, `spam`) VALUES ('$P$BIdrRsE.vl0jc8Wl52e8CikKBhLt3K1', 'drno', 'email@gmail.com', '', '2021-08-27 06:16:59', '', 'drno', 'drno', 0) made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wpForo->init, do_action('wpforo_after_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->do_actions, do_action('wpforo_action_wpforo_registration'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->registration, wpForoMember->create, register_new_user, wp_create_user, wp_insert_user, QM_DB->query

[27-Aug-2021 06:16:59 UTC] WordPress database error Unknown column 'spam' in 'where clause' for query SELECT COUNT(ID) as c FROM QdcpzrKAusers WHERE spam = '0' AND deleted = '0' made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wpForo->init, do_action('wpforo_after_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->do_actions, do_action('wpforo_action_wpforo_registration'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->registration, wpForoMember->create, register_new_user, wp_create_user, wp_insert_user, do_action('user_register'), WP_Hook->do_action, WP_Hook->apply_filters, wp_maybe_update_network_user_counts, wp_update_network_user_counts, QM_DB->query

[27-Aug-2021 06:18:00 UTC] WordPress database error Unknown column 'spam' in 'field list' for query INSERT INTO `QdcpzrKAusers` (`user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `display_name`, `user_login`, `spam`) VALUES ('$P$BmEWuMnQ3QtFJLK1v4nAm4d4AphZBf.', 'drno', 'email@gmail.com', '', '2021-08-27 06:18:00', '', 'drno', 'drno', 0) made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wpForo->init, do_action('wpforo_after_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->do_actions, do_action('wpforo_action_wpforo_registration'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->registration, wpForoMember->create, register_new_user, wp_create_user, wp_insert_user, QM_DB->query

[27-Aug-2021 06:18:00 UTC] WordPress database error Unknown column 'spam' in 'where clause' for query SELECT COUNT(ID) as c FROM QdcpzrKAusers WHERE spam = '0' AND deleted = '0' made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wpForo->init, do_action('wpforo_after_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->do_actions, do_action('wpforo_action_wpforo_registration'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->registration, wpForoMember->create, register_new_user, wp_create_user, wp_insert_user, do_action('user_register'), WP_Hook->do_action, WP_Hook->apply_filters, wp_maybe_update_network_user_counts, wp_update_network_user_counts, QM_DB->query

[27-Aug-2021 06:34:24 UTC] WordPress database error Unknown column 'spam' in 'field list' for query INSERT INTO `QdcpzrKAusers` (`user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `display_name`, `user_login`, `spam`) VALUES ('$P$B1Ooketeq1VeoPfA096aSFlxpDrDCV1', 'drno', 'email@gmail.com', '', '2021-08-27 06:34:24', '', 'drno', 'drno', 0) made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wpForo->init, do_action('wpforo_after_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->do_actions, do_action('wpforo_action_wpforo_registration'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->registration, wpForoMember->create, register_new_user, wp_create_user, wp_insert_user, QM_DB->query

[27-Aug-2021 06:34:24 UTC] WordPress database error Unknown column 'spam' in 'where clause' for query SELECT COUNT(ID) as c FROM QdcpzrKAusers WHERE spam = '0' AND deleted = '0' made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wpForo->init, do_action('wpforo_after_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->do_actions, do_action('wpforo_action_wpforo_registration'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->registration, wpForoMember->create, register_new_user, wp_create_user, wp_insert_user, do_action('user_register'), WP_Hook->do_action, WP_Hook->apply_filters, wp_maybe_update_network_user_counts, wp_update_network_user_counts, QM_DB->query

After further investigation, I got the debug log and if I can show you, it read as: And I really think all the errors I am having for my users are due to this spam column though as I can see in the database, there is a column name spam in the users table and as there is only 1 user i.e., me it shows the value of spam as 0. This is multisite and I somewhere read there is always this spam column in a multisite. Please help me finish this problem with my forum.

 
1 Reply
Chris
 Chris
Admin
(@chris)
Joined: 10 months ago

Support Team
Posts: 1368
August 27, 2021 10:49 am
Reply toSujalSujal

Hi @sujal,

wpForo doesn't have such a phrase response, that may come from another plugin.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Sujal
Posts: 8
 Sujal
Topic starter
September 2, 2021 2:33 pm
(@sujal)
Active Member
Joined: 9 months ago

Hey, could you please just remove my website url from the topic? I think I am getting some fake users from here. Anyways, just help me getting my site url off this page and remove this reply too.

And yeah, the issue's now solved. I just created a fresh installation of wordpress multisite and copied the site by hand from scratch as the database was actually too corrupted to import to another fresh installation which I checked through localhost.

Chris liked
  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • Hiding login and registration links
    2 months ago
  • Add topic doesnt work and loop
    8 months ago
  • not enough data to create this user
    9 months ago
  • recaptcha trouble
    11 months ago
  • Use Verifalia API in wpforo in order to check an email is valid before sending verification email.
    1 year ago
Topic Tags:  registration (36), registration bug (2), login error (10),

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages wpforo-advanced-attachments-128x128 wpforo-embeds-128x128 wpForo User Custom Fields addon wpForo – Blog Cross Posting addon wpForo Ads Manager wpForo – WooCommerce Memberships Integration wpForo Emoticons wpForo – Tenor GIFs Integration
View all Addons »

Recent Topics

  • How to prevent forum users from PASTING / posting multiple colors and font sizes...??

    By Noved, 14 hours ago

  • purchase of add on and it says payment pending

    By ReddBeard, 1 day ago

  • Costume text and image on every forum

    By Vijiki, 2 days ago

  • Forum topics and pages not indexing

    By Vijiki, 2 days ago

  • Can't send confirmation email from topics when suscribe for new topic

    By gilbau, 2 days ago

  • Can't add shortcodes to wpForo

    By avorai, 2 days ago

Topic Tags

  • translation49
  • css49
  • plugin conflict48
  • seo45
  • new features44
  • buddypress42
  • ultimate member40
  • avatar40
  • forum40
  • moderation38
  • login38
  • registration36
  • threaded layout35
  • cache33
  • editor32
  • menu32
  • shortcode31
  • spam29
  • phrases28
  • forum accesses28
View all tags (2163)

Recent Posts

  • RE: Show Likers with their avatar

    Have now found the correct code 😀 are these 3 lines ...

    By Tutrix, 8 hours ago

  • RE: How to prevent forum users from PASTING / posting multiple colors and font sizes...??

    @noved add this to custom css #wpforo #wpforo-wrap ...

    By Tutrix, 10 hours ago

  • RE: Costume text and image on every forum

    @vijiki There is no wpForo2 for the moment. Also forget...

    By dimalifragis, 23 hours ago

  • RE: Can't add shortcodes to wpForo

    @avorai So, SAC.PHP is crashing and it is wpForo the ca...

    By dimalifragis, 23 hours ago

  • RE: purchase of add on and it says payment pending

    Hi @reddbeard, Please move this topic to gVectors Sup...

    By Robert, 1 day ago

  • RE: Can't send confirmation email from topics when suscribe for new topic

    @gilbau, wpForo uses WordPress wp_mail() function. wp...

    By Robert, 2 days ago

  • RE: Forum topics and pages not indexing

    So all is ok from wpForo site. I have nothing to add he...

    By Robert, 2 days ago

Share:
Share
Tweet
Share
  Forum Statistics
20 Forums
9,757 Topics
49.5 K Posts
5 Online
43.7 K Members

Latest Post: Show Likers with their avatar Our newest member: claudettecrotea Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2022 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation