chrisdperry91

Yes, tried wp-cli the site never crashes and server never shows a dangerous load, while monitoring with phpMyadmin it always loses database connection around 15 minutes into the “altering tables” process.

With the update I was able to access the command, thanks!

However I still loose connection to server after about 1000 seconds during ALTER TABLE ADD PRIMARY KEY. My wp_postmeta table is 1.3GB and about 8M rows. I’ve tried indexing the SQL commands one by one via phpmyadmin as well and it will alwayse fail on that step.

Any ideas or workarounds for such a large table? Maybe a time limit constraint in my SQL settings?

Thanks for your continued help, I really want to take advantage of this plugin for my massive amount of woocommerce postmeta.

I have updated all product and they are at the very least in the default “Uncategorized” category. Still getting the error. Every few minutes it will log the same error about 10 times or so in a couple seconds. There is also this new one. Related I’m assuming but different form the other.

PHP Notice: Undefined index: loop in /home/mcpirdmy/public_html/wp-content/plugins/duracelltomi-google-tag-manager/integration/woocommerce.php on line 969

Is there something I could try to reset within the plugin now that I have added the products back into a category?

Hello, yes all plugins are up to date.

I’m currently trying to debug another issue between WooCommerce & WPML, in doing so I deleted thousands of product categories that were mistakingly imported. Thousands of products were left without a category which I then had to go and add back to the uncategorized category. Not sure if that’s relevant to this issue but figured I would put it out there since that line of code references product category.

Rebooted the server, logged back in and I have a success message “high performance keys added to 1 table” no error messages, and all tables have the options to revert. Looks like it was able to finish this time.

Turns out it actually did 504 again while altering postmeta. The table is 2.4GB Would I be able to just run the commands individually to re-key wp_postmeta from phpmyadmin?

https://ibb.co/P6hp3kN
https://ibb.co/Z146jND

What my plugin page looks like currently.

The server hung and had to reboot during the first run. Last week I was doing some major site and server maintenance to address some issues I had been constantly having with the site, timeouts, 500 errors etc… Looking much better now so I’m confident I could make whatever changes issue free.

The second run completed just fine (i think) I got a success message along the lines of “high performance keys were added”. So I’m wondering if the error message I’m seeing is left over from the first attempt when the server went down midway.

The site runs fine now, much better than it used to in-fact, so If there is still an unresolved issue from the re-key I am not seeing any effect of it, however I would like to confirm the process went smoothly (the second time at least). Is there I way I can check my database to see if it everything is where it needs to be? Should I restore to default and try again? Wait for a plugin update?

Thanks for all your help!

• This reply was modified 3 years, 7 months ago by chrisdperry91.

So I ran the installation again. This time it only took about a minute, no site crash, and I get the success message along the lines of “High-performance keys added to 5 tables.”

The page is still showing the same error as before below in red, wondering if the wp_postmeta key was successfully updated this time and the error is from the first attempt? Or if there is still an issue. Is there a way for me to check? Thanks.

If I were to force the woocommerce event to fire with a default variation selected , would that in-turn allow the re-marketing tag to fire properly?

This should be normal since ecomm_ parameters have been replaced with the new parameter structure.

Ok so it should be safe to ignore the old ecomm_ parameters in the Audience Manager > Audience Sources > Google Ads Tag section of Google Ads? I have minimal hits on the other parameters “event, google_business_vertical, id, value.” I do have healthy activity on the GA4 tag in the same location. Does it essentially serve the same purpose?

You have variable products but attribute selection is handled by a 3rd party plugin that does not fire a necessary browser event that normally WooCommerce fires if all attributes have been selected and a variation has been found in the product database.

This makes sense. Is the default behavior then to not fire upon reaching a product page and instead only fire when an action is taken on selecting attributes? For variable products at least?

Since only one of my variations for each product actually acts as a product (the others are services and aren’t an actual product sale.) I would love to find a workaround that links the product ID in merchant center with a specific variation ID in woocommerce. I tried setting my feed up to use the product parent SKU for all variations in an attempt to match them up but It won’t let me process the feed file in this way.

Sure thing.

Debug Session

Make sure the [your-email] field in your form is actually an “email*” field, not just a text field.

This little mistake is where I was hung up.