TrevorJones
Forum Replies Created
-
Forum: Networking WordPress
In reply to: Shared login between subdirectory installI suppose could it be a solution to just copy all tables from the site_wp2 database into the wp1 database, then setting both wp-config files to use the wp1 db but different table prefixes…
Probably how I’m now guessing it’s supposed to be set up?EDIT
Well, I just tried that and problem solved!
Looks like no way to access another databases user/meta tables?
Cheers!Forum: Networking WordPress
In reply to: Shared login between subdirectory installVery new to WP, I kind of understood multisite but wasn’t sure where to post about this (kind of related).
I would have chosen the multisite approach but I kind of had this lumped on me and it’s too far down the line to go back (course website with all courses/quizzes already complete in both languages…) I’ve also looked into Polylang but again, too much work to go back…
Now the site is in it’s final stages I’ve just been implementing the course purchase which involves the customer creating an account which is activated after they complete a payment through WooCommerce plugin. The main issue is that the sites have been set up to use separate user/usermeta tables in different databases… So purchasing a site licence in one language doesn’t create an account in the other sites database. I need both main EN site and the subdirectory site to use the same user tables.
The database looks like this:
site_wp1
>wp1_users
>wp1_usermetasite_wp2
>wp2_users
>wp2_usermetaI think targeting site_wp1.wp1_users from the subdirectory site is causing the problem as the query on login/out seems to be appending site_wp2. before the query ending up with “site_wp2.site_wp1.wp1_users”