#wordpress 2021-09-24
2021-09-24 UTC
billbennettnz and [tw2113_Slack_] joined the channel
# 
[tw2113_Slack_] Bishop_Bautista Check your wp_sitemeta table and the `siteurl` meta key to make sure you didn’t accidentally add the https extra there
# billbennettnz Anyone here? I'm looking for a walkthrough on getting Micropub to connect IA Writer to my Wordpress blog. It should be trivial, but suddenly it isn't.
# Bishop_Bautista [tw2113_Slack_] checking
# billbennettnz I've got a simple test post in IA Writer. If I hit publish as a new draft on Micropub I get an invalid request message - nothing happens at the other end
# billbennettnz The authentication appeared to work...
# Bishop_Bautista [tw2113_Slack_] The site url looks correct only listing the site with a single https://
# Bishop_Bautista and nthe site loads find it not until I need to navigate to the My sites -> Network Admin -? section that I have the problem of the douple https://https://
# [tw2113_Slack_] anything off in the wp_site table and the domain column?
# [tw2113_Slack_] those shouldn’t hav HTTP(s) prefixes
# [tw2113_Slack_] just `mydomain.com` and similar
# billbennettnz I can get IA Writer linking direct to Wordpress, but thought I'd try the Micropub route
# Bishop_Bautista [tw2113_Slack_] so wp_sitemeta. -> siteurl. should not have https:// on it?
# [tw2113_Slack_] wp_sitemeta -> siteurl should. that one is fine with https://
# [tw2113_Slack_] wp_site -> domain should not
# Bishop_Bautista ok yea that one did not have the refix
# Bishop_Bautista prefix
# [tw2113_Slack_] those are the only obvious places I can think of to check that would be setting domain urls like that. Beyond that, I’d end up just doing some database browsing to try and fine the culprit. Perhaps do some queries that do “LIKE” checks. Eg `select * from wp_sitemeta where meta_value LIKE 'https://https/'`
# Bishop_Bautista [tw2113_Slack_] I ran a better search and replace and it snot finding it in the db :(
# [tw2113_Slack_] wp-config.php ?
# [tw2113_Slack_] i know you can set constants there that handle site/home urls
# Bishop_Bautista I'll check that next...thank you!
# Bishop_Bautista [tw2113_Slack_] can you take a look, nothing look wrong to me: https://paste.ofcode.org/edgpaXQEZgtpsPEhMSXRpi
# [tw2113_Slack_] glad to see you took out the DB creds first, smart. Beyond that, the only thing standing out is the https://site.site.com value on line 38
# [tw2113_Slack_] unless you temp changed that out too for the paste
# Bishop_Bautista ;)
# Bishop_Bautista shoudl that not have that format?
# Bishop_Bautista on line 38
# Bishop_Bautista I just replaced site.site.com
# Bishop_Bautista the rest was formatted as is
# [tw2113_Slack_] checked a local multisite that i happened to have and also client site that’s subdomain multisite
# [tw2113_Slack_] both don’t include the protocol
# Bishop_Bautista hmm ok let me remove it from there
# [tw2113_Slack_] so my local is `define('DOMAIN_CURRENT_SITE', 'wds.test');` while the client site is `define('DOMAIN_CURRENT_SITE', 'mysite.com');`
# [tw2113_Slack_] so that’s my best bet at the moment 😄
# Bishop_Bautista [tw2113_Slack_] you sir are a freakign genius!!!!
# Bishop_Bautista worked
# [tw2113_Slack_] yay!
# Bishop_Bautista Amazing!
# Bishop_Bautista WOULD HAVE never caught that, thank you [tw2113_Slack_]
# [tw2113_Slack_] glad I could help
# Bishop_Bautista :):):)
[fluffy], [snarfed], [chee], Zegnat[d], [manton], chee and Bishop_Bautista joined the channel