Thank you for your participation
To resolve this error (if one exists), I need more information, please:
Are you using: multi site or buddypress or buddyboss?
What are the plugin settings?
like:
- Choose language (characters) in username
- Solved the problem of not being able to register with certain languages
Is this ‘wp_signups’ table exists in your database?
Hi there,
Thank you for your reply.
This is not a multi-site install, and I’m not using buddypress or buddyboss. I use Astra Pro theme, and fluent community, though fcom wasn’t installed when the error was reported in the log.
I use the plugin to filter characters in usernames during account creations, as I had users trying to use a “.” in the username, which created invalid accounts.
So my settings are simply: enable “not allow use only numbers in username”, “do not allow usernames that are email addresses” and “prevent the use of all symbols and letters accented in usernames. Then, in the “prevent the use of characters (symbols) permitted by WP” box, I simply added a “.” (full stop character).
I have no idea what this wp_signups the V5.0 of the plugin is looking for is. It’s not in the database. V4.2.1 doesn’t look for it, so there is no error. Make sure you test V5.0 with PHP 8.3 or above, it’s much more strict than previous versions. I have reverted to V4.2.1 for now and there is no error in the debug.log.
edit this file in: wp-content\plugins\restrict-usernames-emails-characters\inc\functions.php
and in line 269 replace this:
$_email = $email;
by:
$table = $wpdb->get_results( $wpdb->prepare(
"SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = %s AND TABLE_NAME = %s ",
$wpdb->dbname, $wpdb->prefix . 'signups' ) );
if ( empty( $table ) ) return false;
$_email = $email;
Thanks, I’ve done that on a staging site. Then?
The goal is simply to locate the problem. If the error message doesn’t appear, we’ll know exactly where the issue lies and can fix it in the next version.
Is the problem resolved after modifying the file?
Thanks. I thought you were asking me to do this as a debugging step, so I was waiting for the next ones.
I’ve installed V5.0 on the production site, but the error didn’t show up in the debug.log again.
If it does, I’ll let you know and will install the suggested fix. If I install the fix now, we’lll never know if it works or not.
If you don’t hear from me, it’s that the error never showed up again in the log.
OK, it looks like the error did happen after I installed 5.0:
[05-May-2026 12:57:18 UTC] WordPress database error Table ‘zs70nqh_hajs.wp_signups’ doesn’t exist for query SELECT * FROM wp_signups WHERE user_email = ‘[user email]’ made by edit_user, do_action_ref_array(‘user_profile_update_errors’), WP_Hook->do_action, WP_Hook->apply_filters, benrueeg_rue_plug_glob->_user_profile_update_errors, benrueeg_rue_plug_validation->signup_email_exists
But it looks like it might be a one-off, so changing the code after install won’t resolve it if it happens only once at install. I tried to register a new user with a “.” in the username, to make sure the plugin would fire (it did and refused the username), but there is no other entry in the debug.log.
Now, update the plugin to the latest version v5.0.1
-
This reply was modified 1 month ago by
Benaceur.
Thanks, I saw the update and I’ve just updated to 5.0.1
