muckaveli

3 weeks later, I was finally able to solve this whole problem by accident.

My WordPress installation is finally connected to Google Merchant Center and this thread can be closed!

Troubleshooting

• /wp-admin/site-health.php kept telling me that there was a connection error with Jetpack (code 200), even though My-Jetpack stated that it was connected. Weird.
• I decided to deactivate all of my 44 plugins, refreshed site-health.php and the connection-error-message was gone
• Next I re-activated all of my plugins one at a time, while refreshing my site-health.php until the error came up again
• This way I’ve found out that it was caused by Make Paths Relative, a plugin I used to do just that. Somehow it seems to block Jetpacks connection and apparently also Google’s.
• Once Jetpack could connect successfully, I went over to Marketing > Google Listings & Ads and could establish the connection to the Merchant Center immediately without further trouble!

Lesson of the day

Whenever installing a new plugin, head immediately over to /wp-admin/site-health.php to see if it does anything to your WordPress installation that is resulting in errors that haven’t been there before.

@danielinhou Since you couldn’t help me, I went and hired someone to fix the problem for me. Here is his assessment:

“The issue was with your WooCommerce blocks.php file, which was causing conflicts. What we did was change the way the class was being called to make it compatible with PHP 8.0. Many people have reported and opened threads for MailPoet to address these issues. So, maybe in a month or two, when they release new plugin updates, they will fix it themselves.”

Just so you know, maybe you can come up with a patch for that. Thanks. This thread can be closed.

@theabhig this is the response of “claim overwrite”

Response
Request:  POST /wc/gla/mc/accounts/claim-overwrite
Status:   400
Response: {
    "message": "Attempting invalid claim overwrite.",
    "id": xxxxxxxxx
}

What should I try next?

@theabhig

Please see the attachment and let me know which one exactly you mean (since “reclaim URL” isn’t listed): https://imgur.com/a/XYsvmvY

• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.

@babylon1999 I did the whole conflict test to my live version:

• WordPress: Connected
• Google: Connected
• Merchant Center hitting “connect” resulted in: “Unable to insert site verification: The necessary verification token could not be found on your site.”
• /wp-admin/admin.php?page=connection-test-admin-page > MC Connection Status:

Response: {
    "id": xxxxxxxx,
    "status": "incomplete",
    "step": "verify"
}

MC Account Setup:

Request:  POST /wc/gla/mc/accounts
Status:   400
Response: {
    "message": "Unable to insert site verification: The necessary verification token could not be found on your site.",
    "errors": {
        "badRequest": "The necessary verification token could not be found on your site."
    }
}

@babylon1999

• I’ve installed the plugin “WP Staging” to create another staging version.
• In that staging version (mydomain.com/staging_version), I deactivated all plugins except for WooCommerce / Google Listings & Ads.
• In “Set up your accounts” WordPress.com and Google were already marked connected.
• Trying to connect Google Merchant Center resulted in “This Merchant Center account already has a verified and claim URL, mydomain.com”.

How that possible if mydomain.com states “Invalid site URL.”?

Did I do the conflict test right, or do I have to really use the live version to do it effectively? Thank you.

Thanks @anastas10s , here is the quicktoforget-link containing the lo.

I’m not sure if you are aware that I already did follow your colleague’s instructions above?

Disconnecting all these accounts

• MC diconnected
• Google disconnected
• Jetpack didn’t work on that page but via MyJetpack. Jetpack disconnected

Not being able to re-connect Jetpack or WordPress

When I went directly back to Google Listings & Ads “Set Up Your Account”, I wasn’t able to connect WordPress.com due to “Unable to connect your WordPress.com account. Please try again later.”.

I went back trying to re-connect Jetpack in MyJetpack and it stated “An error occured. Please try again.”

Going to https://domain.com/wp-admin/admin.php?page=connection-test-admin-page&action=connect&_wpnonce=52f029a046 leads to a “502 Bad Gateway”

“Testing WCS Connection” resulted in Jetpack User: “Connected with another user account”. With a GET response “{“statusCode”:401,”error”:”Unauthorized”,”message”:”Invalid credentials”,”attributes”:{“error”:”Invalid credentials”}}”.

MyJetpack then stated “site connected, user account NOT connected”. Clicking “connect” resulted in “Unfortunately, an unexpected error has occurred”.

I was able to finally reconnect Jetpack with WordPress using https://wordpress.com/jetpack/connect and entering my domain there.

Trying to re-connect Google Listings & Ads (“Set up your accounts”)

• WordPress.com : connected
• Google : connected
• Merchant Center (select an existing account) : Invalid Site URL ??

• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.

Hey @danielinhou the error can not be directly reproduced with MailPoet, but looking at WooCommerce > Status > Logs I’ll get this message:

2023-08-25T11:21:45+00:00 CRITICAL Uncaught TypeError: Illegal offset type in isset or empty in /var/www/vhosts/domain.com/development-clone/wp-includes/class-wp-dependencies.php:289
Stack trace:
#0 /var/www/vhosts/domain.com/development-clone/wp-content/plugins/mailpoet/lib/PostEditorBlocks/WooCommerceBlocksIntegration.php(87): WP_Dependencies->add_data()
#1 /var/www/vhosts/domain.com/development-clone/wp-content/plugins/mailpoet/lib/Config/Initializer.php(524): MailPoet\PostEditorBlocks\WooCommerceBlocksIntegration->init()
#2 /var/www/vhosts/domain.com/development-clone/wp-content/plugins/mailpoet/lib/Config/Initializer.php(334): MailPoet\Config\Initializer->setupWoocommerceBlocksIntegration()
#3 /var/www/vhosts/domain.com/development-clone/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize()
#4 /var/www/vhosts/domain.com/development-clone/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
#5 /var/www/vhosts/domain.com/development-clone/wp-includes/plugin.php(517): WP_Hook->do_action()
#6 /var/www/vhosts/domain.com/development-clone/wp-settings.php(623): do_action()
#7 /var/www/vhosts/domain.com/development-clone/wp-config.php(76): require_once('...')
#8 /var/www/vhosts/domain.com/development-clone/wp-load.php(50): require_once('...')
#9 /var/www/vhosts/domain.com/development-clone/wp-blog-header.php(13): require_once('...')
#10 /var/www/vhosts/domain.com/development-clone/index.php(17): require('...')
#11 {main}
  thrown in /var/www/vhosts/domain.com/development-clone/wp-includes/class-wp-dependencies.php on line 289

Doesn’t that mean that somewhere in the MailPoet plugin code, an array or object is being accessed with an incorrect type or an invalid key/index?

• This reply was modified 1 year, 2 months ago by muckaveli.

@babylon1999 thank you for your reply.

Status Report
I’ve created a gist. Can I somehow send it to you without posting it in public? Thanks.

Fatal Logs:
* Changed my actual domain to “domain.com“

2023-09-06T19:17:26+00:00 CRITICAL Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.wp_post_id' in 'field list' in /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
Stack trace:
#0 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(59): PDOStatement->execute()
#1 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(386): MailPoetVe in /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 59



2023-09-01T06:46:37+00:00 CRITICAL Uncaught Error: Call to a member function getStaticEvents() on null in /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/pixelyoursite/modules/facebook/facebook.php:428
Stack trace:
#0 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/pixelyoursite/includes/class-events-manager.php(152): PixelYourSite\Facebook->outputNoScriptEvents()
#1 /var/www/vhosts/domain.com/httpdocs/wp-includes/class-wp-hook.php(308): PixelYourSite\EventsManager->outputNoScriptData()
#2 /var/www/vhosts/domain.com/httpdocs/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
#3 /var/www/vhosts/domain.com/httpdocs/wp-includes/plugin.php(517): WP_Hook->do_action()
#4 /var/www/vhosts/domain.com/httpdocs/wp-includes/general-template.php(3065): do_action()
#5 /var/www/vhosts/domain.com/httpdocs/wp-includes/template-canvas.php(25): wp_footer()
#6 /var/www/vhosts/domain.com/httpdocs/wp-includes/template-loader.php(106): include('/var/www/vhosts...')
#7 /var/www/vhosts/domain.com/httpdocs/wp-blog-header.php(19): requir in /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/pixelyoursite/modules/facebook/facebook.php on line 428

Google Logs:

2023-09-05T19:46:18+00:00 ERROR Automattic\WooCommerce\GoogleListingsAndAds\Notes\NoteInitializer::add_notes Merchant Center account is not set up.

2023-08-08T16:08:24+00:00 ERROR Automattic\WooCommerce\GoogleListingsAndAds\Notes\NoteInitializer::add_notes Google account is not connected.

@bizanimesh Thank you for the reply, I’ll gladly use the contact form.

Regarding others finding this thread: is there a recommended procedure when it comes to Jetpack and cloning WordPress installations for development purposes?

It must be pretty common to have a live version and another (local or otherwise hidden-from-public) version as a development environment. Is there a proper way to connect Jetpack to this second version or should it always be disconnected while developing and re-connected when the live version will be updated with it?

• This reply was modified 1 year, 2 months ago by muckaveli.

Hey @babylon1999, thank you for your reply.

I didn’t know the connection-test admin site nor that jetpack was of any significance in all of this. However, I’ve found out that – due to me copying my WordPress installation into a dev-enviroment – Jetpack thought my domain was https://dev.domain.com instead of https://domain.com. I’ve spent quite some time to correct that and Jetpack is now configured with the correct domain, but it DID NOT change the “Invalid Site URL” problem for me.

The whole process included dis- and reconnecting everything as you suggest, without any success.

If I hit “Or, create a new Merchant Center account” I get a prompt “You already have another verified account,?Name, which is connected to this store’s URL,?https://domain.com.” – this make’s it even harder to understand why the URL should be invalid.

What shall I do next? Thanks.

• This reply was modified 1 year, 3 months ago by muckaveli.

@rebelde2 sorry to hear that. How did you log the error? I’d like to log mine as well, maybe it’s a different from yours.

Updated MailPoet to 4.18.0 and the problem remains! ??

I’ve found a solution for the title-tags

Hey Maxime, it seems that whatever other plugin overwrites the settings of sublanguage for the page titles. Your code works, it’s priority just isn’t high enough. I have fixed that by adding the priority “999999” (yes, that’s 6 x 9) to this code. Now it works like a charm!

One can add the code below to the functions.php or use a plugin to stay update-safe.

<?php
function custom_title_tag( $title ) {
   if ( is_front_page() ) {
      $title = '';
   } elseif ( is_singular() ) {
      $title = single_post_title( '', false );
   }
   return $title;
}
add_filter( 'pre_get_document_title', 'custom_title_tag', 999999 );
?> 

• This reply was modified 1 year, 6 months ago by muckaveli.

I’ve found the solution for the slugs of perma pages

The translation – that stems from the translation page title – will be shown inside a certain modal, but not displayed on the front-end unless you’ve manually edited it for once and then hit “update”!

Here is the process

• Chose a page from your back-end pages menu and go to “edit”
• Chose your second language from the top menu
• Make sure the top menu is set to “Settings”
• Go to the menu settings on the right side that says “page” and look for the field title “URL”
• This URL might not show a translated version, however if you CLICK on that URL and a modal will open up…
• Here it will show already translated content in the “Permalink” field, however you must click in the box, make whatever edit (like delete the last character and type it back in), then hit “X” to close the modal
• Now you’ll see the URL updated to your translation. The /sublanguage/ folder is not being displayed, but don’t worry about that, it will be shown in the front-end.
• Now, hit “Update” on the top menu to save your page
• Wait a couple of minutes for your server/cache to do it’s magic, and voilà! The slug is now being properly translated!