We don’t have any users with that email address. Maybe you used a different one

Hey @philengel,

1) That is not an error from this plugin. It looks like you may also be using Custom WP Login?

Try deactivating that plugin and see if you still get the error.

2) Yes – it is normal to only see part of the e-mail. I truncate the strings when displaying it to the end user.

Let me know how you get on with disabling the other plugin and trying it again.

Thanks,

Tom

Hi Tom, created a new wp instance(v5.3.2), only installed external login and still get the same error, no such email.

are there specific mysql table specifications that is required perhaps?(column function and types?)

Hey @philengel,

Good question but I don’t believe there are any specific requirements on the database.

Can you please double check you have checkbox ticked that enables the plugin code. It is one of the first checkboxes in the settings.

If you have the next thing would be to check your php error logs for anything useful to share with me here. Please make sure you redact any private information.

If you can’t see any useful logs, I’ll add a feature to the plugin that adds additional logs to the php error logs to further help us diagnose the problem. Been meaning to add this feature for some time.

For now, as described above, check the plugin logic is enabled in the plugin setting and let me know if you can see anything useful in the current logs.

Thanks,

Tom

The problem was a plugin called Profilegrid, great plugin otherwise..
Am still looking for a solution for custom user fields(20 fields) that need to be associated with external users, any suggestions?

Does this thread answer your question?

https://www.ads-software.com/support/topic/map-additional-field/

If any of it doesn’t make sense just ask ??

Thanks Tom, I’m fairly new to all of this, have been looking at the other posts but would need more help..

Hey @philengel,

Apologies for the delay.

Basically to add the required functionality to the plugin, you would need to add a small bit of custom code to your functions.php file in your theme.

An example of this can be seen below.

Basically, when a user is authenticated from the external database, the function philengel_exlog_add_additional_user_data will get called and you get access to the new user that was created in wordpress ($wp_user) and all the data from the user table where the user name and password were stored on the external database ($exlog_user_data).

In the below example I use WordPress’ add_user_meta function to add a new meta field called ‘fav_colour’ to the WordPress database. The data I’m storing in that meta field in wordpress is from the ‘favourite_colour’ field from the external database.

You could call add_user_meta() again for each of the different bits of data from that table you wanted to store.

function philengel_exlog_add_additional_user_data($wp_user, $exlog_user_data) {
  add_user_meta(
    $wp_user->ID,                          // User ID
    'fav_colour',                          // WP Meta field key
    $exlog_user_data['favourite_colour'],  // External table data
    false                                  // Not unique
  );
}

add_action('exlog_hook_action_authenticated', 'philengel_exlog_add_additional_user_data', 10, 2);

If you have any further questions, don’t hesitate to get back in contact ??

Thanks,

Tom

Hi Tom, after successful login I can see the user was created under WordPress users but that user info is not in the WP database, is it suppose to be? if so, where?

Can you please confirm which type of database it is?
-MySQL
– PostgreSQL
– mssql?

MySQL

Apologies for that brief message before I was out and only had my phone to send a quick one.

Cool, just checking as someone has just flagged a bug with MSSQL that means it won’t call the described hook. Wanted to rule this out.

May I suggest that the next step is to:
1) ensure that the external database is what is authenticating the user
– To double check this, use the setting to disable local login. That way if you do login it must be with the external database
2) ensure that the hook is getting called when a user is authenticated with the external database
– To check this I am going to suggest you put the following code in your functions.php file so that you can check the logs and make sure you can see the notes.

function philengel_exlog_add_additional_user_data($wp_user, $exlog_user_data) {
    error_log('----------------philengel--START----------------------');

    add_user_meta(
        $wp_user->ID,                          // User ID
        'fav_colour',                          // WP Meta field key
        'red',                                 // String
        false                                  // Not unique
    );

    error_log('----------------philengel--END----------------------');

}

add_action('exlog_hook_action_authenticated', 'philengel_exlog_add_additional_user_data', 10, 2);

In your PHP error logs you should see two logs next to each other. This is what I saw when I just tested the code . . .

[Mon Jan 13 17:41:20.403030 2020] [php7:notice] [pid 88] [client 177.23.0.1:46688] ----------------philengel--START----------------------, referer: //localhost:8000/wp-login.php
[Mon Jan 13 17:41:20.404221 2020] [php7:notice] [pid 88] [client 177.23.0.1:46688] ----------------philengel--END----------------------, referer: //localhost:8000/wp-login.php

Secondly in the wp_usermeta table you should find a meta_key of “fav_color” for one of the entries and that same entry will have the value field stored as “red”.

Let me know which of this you can’t see.

Hey @philengel,

Just checking in to see if you got any further ??

Thanks,

Tom