sovrgn

Hi There, I am also having this issue. The recordings save as .m4a files, which seems to be supported by the current WP version. Not sure what I’m missing here, should be straightforward upload…

Clearly it’s broken, WP that is..I have tried a media upload, browser upload, even uploaded the file via FTP to the media folder and it does not appear in the Media tab in WP dashboard.

It’s probably a security feature or something, but it LITERALLY says .m4a is supported, so what am I missing? lol

Hi Steve,

I made my admin on the WordPress DB and the other db with external users. This way, you can access the site directly without needing access to the external DB.

Also check the box in the External Login plugin to ensure that the WordPress DB will also login. I think the way Tom set it up is that WP db will always be present, so best to put your admin there.

Hi Tom

I was unable to pull the additional data using exlog_user_data(“column name”); but I found a workaround using wpdb to pull the additional meta data from the table.

Hi Tom,

I get the ‘Unable to add additional field’ , and I double checked that tokenscore exists in the external DB and that the name corresponds correctly.

here’s one for a new user:

[09-Oct-2020 09:25:49 UTC] EXLOG-START
[09-Oct-2020 09:25:49 UTC] array (
‘user_login’ => ‘newuser5’,
‘first_name’ => ”,
‘last_name’ => ”,
‘user_pass’ => ‘password’,
‘role’ => ‘subscriber’,
‘user_email’ => ‘[email protected]’,
)
[09-Oct-2020 09:25:49 UTC] PHP Notice: Undefined index: tokenscore in /home/server/website/wp-content/themes/theme-child/functions.php on line 6
[09-Oct-2020 09:25:49 UTC] Unable to add additional field
[09-Oct-2020 09:25:49 UTC] EXLOG-END

So, i’m assuming it’s pulling the necessary data correctly, like the user name, email etc. but not recognizing the additional index in the external DB? Am I missing something on my end possibly?

For example, do I need to include something extra for the tokenscore? i.e. table name or prefix something like wp_ ?

Hi Tom, thanks for the response. I responded last night, but it seem that the reply wasn’t sent through.

I’ve used the above suggestion, and the error notice is for a missing Index, namely ‘tokenscore’ – I am not sure if Exlog can’t find the ‘tokenscore’ column.

I have checked the WP_usermeta to verify that both ‘virtualwallet’ and ‘tokens’ exist for the user. I created this meta using PODS and tested it from the user profile page in the backend. It works, and creates the meta etc.

Problem seems to be pulling the ‘tokenscore’ index. A bit stuck, so looked around at $WPDB, which may be an option.

Hi Tom,

I did some testing and saw that it didn’t update.

yes it does. I was thinking along the same lines however I like your idea behind the redirect. I’m glad it’s opensource, this means it can be customised without *hopefully* breaking.

Will work out some other details, but this plugin looks to be about just right!

Regards,

SOVRGN

.

I’ve got it working.

Pulls the users through to the WP db. What happens if someone resets their password from the profile page? Does it update the hash/salt on the external DB?

Seems to be running fine, not really ‘multisite’ now as I have it on a subdomain and on sole WP installation.

• This reply was modified 4 years, 4 months ago by sovrgn.

Hey Tom, fully understand and appreciate the work you have put in already!

I’ve created a new WP site, so I’ll test it out from vanilla. Should also be set up to the one WP account, although I have a multisite set up, the site where the plugin will work is on it’s own installation.

Will update or close in a few days once I get through it.

Thanks

SOVRGN

An update:

Somehow two of the 4 users have been added to the users page in WordPress. This seemed to happen after adding (WP_ALLOW_MULTISITE, true) and refreshing the page.

Hasn’t worked since, as in it hasn’t added the new users, so I have my doubts.
What seems to be the error is the notice for undefined index, assuming that it is not mapping the right meta?

success!

Hi @tbenyon

Good news! I’ve managed to get it to work. I simply changed the Database host from the ip address of the server to localhost. I mean, it may as well be right ??

Now when I pull the data from the table, it works.

Thanks it is working correctly. Thanks for the support!

Thanks, it works.