New registrerad users

Update

I also checked the phpmyadmin feup_users table where I only see a few of the registered users. Seems like only some of the users gets registered and some of them dont!

Update

When the user clicks the link for confirming their email address is says that the confirmation code is invalid. Most likely because they’re not added to the database? Also someone tried to use the forgotten password function and didn’t receive the email. This user is also not in the database but the emails has been sent out that they’re registered.

Just spoke to my host and they explained that they’ve got an email limit per day.
In this case I now have the domain as admin email which I hope work.

But, this still doesn’t change the problem about the users that has registered but haven’t been written to the database. Is the system built the way where the sending of the email approves the call to write to the database?!?!?

Another update!

The problem about the email seem to be solved by adding the plugin using the PHP Mail() Function. Now the emails is sending out properly!

BUT, the users that registererd yesterday doesn’t show up in the database at all. But, when they now tries to re-register themselves they got the message that the user email is already registered. The user is not shown at all in system, nor in the database.

I did a SELECT “the email adress from the user” FROM test_EWD_FEUP_Users and there I see the email adress. But, nothing more than the address.
Can this be deleted for the users that registered but are not able to re-register?

Hi Martin,

Thank you for the detailed information. Sorry that the email sending issue interrupted registrations. It is for this reason – and to prevent your emails from being marked as spam – that we recommend using a plugin to send your emails via an external SMTP, like you seem to have done.

You mentioned that you did find the email addresses in the database table of users. Are you able to delete the email addresses from the database and try registering again?

Nope.. Not able to delete. I just find them through the sql method I wrote above.

Also if I add the email and user
Manually everything works fine. The user is added with the email that already exists!

Strange problem, it is! Joda style!

Hi Martin,

Do you have access to the database via phpMyAdmin? If so, you should be able to delete the specific rows that have these “stranded” email addresses from the table. If, as you mentioned, these users/email addresses don’t show in your WordPress admin, then, until you delete those rows from the table in the database, it doesn’t look like those email addresses will be able to register again.

How to delete them?

After you log in to phpMyAdmin, you will need to navigate to the database used for your WordPress install and then to the table called “EWD_FEUP_Users” and then click Browse. This should then show you a list of all the users. Click the little red “X” icon beside the user(s) that you want to remove.

Yeap… But that’s the thing!
I need to do the SELECT “email address” FROM EWD_users to show the email address. The user doesn’t register with all its Labels that was entered from the form.

I can not delete it from there!!!

In that case, go directly to the “EWD_FEUP_User_Fields” table in the database (this is where the default and custom fields are stored). Here you should see the email address(es) you’re looking for listed in the Field_Value column. Click on the little pencil to edit the row that has the email address you’re looking for in it, then erase the email address from the box that it’s in, and then click the Go button. This should remove the email address. You have to be more careful when using this table in the database because you could delete or mess up fields that you have created.