linux4me2
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] WordPress database error Commands out of syncHi @ihereira,
Clearing the cache was one of the first things I tried, but it didn’t work.
The other things I’ve tried that made no difference are:
- Checking/optimizing the wp_options table (the one in the error) with phpMyAdmin to make sure there were no problems with it (there weren’t)
- compared the Jetpack autoloader code from WooCommerce 6.5.1 and 7.6.0; there’s no difference, though I don’t believe the error occurred in v. 6.5.1
Yesterday evening, I contacted my web host to ask them to take a look at the MariaDB and syslogs, which I don’t have access to, in order to see if there are any issues occurring at the times corresponding to the errors in the list that I sent them.
My web host said there was nothing, but did recommend that I enable WP_DEBUG to see if there was any more information about the error.
I did enable WP_DEBUG, but there was no additional information abou tthe error.
This morning, I disabled both WP Super Cache and Autoptimize, but the errors continue, so that I guess that rules out a caching issue.
The interesting thing is that while WP_DEBUG is still listing the errors in /wp-content/debug.log, if I SSH into the server, switch to the public_html folder–the folder where the production site is–and run this:
find -type f -name "error_log" -printI don’t get any results, so I don’t know what folder the errors are coming from.
Forum: Plugins
In reply to: [WooCommerce] WordPress database error Commands out of syncWordfence Login Security wasn’t the problem. The errors are still occurring; it just took a while to see them again.
Forum: Plugins
In reply to: [WooCommerce] WordPress database error Commands out of syncI think I may have found a solution.
When I searched the Internet for more information on this error before posting here, I found several mentions of WordPress database errors “command out of sync” with Wordfence on Litespeed servers.
The site is not running Wordfence, but it is using Wordfence Login Security. That’s one plugin I can temporarily deactivate on the production site, so I disabled it and I haven’t gotten any of the errors in the past ~one hour.
Based on the logs I have, the longest it has gone before without the error recurring was 56 minutes, and usually it recurred every two minutes or so, so I am cautiously optimistic. I will post back with results.
Forum: Plugins
In reply to: [WooCommerce] WordPress database error Commands out of syncHi @ihereira,
I would be glad to try that, but I don’t see how it can work because the current theme and all plugins will be active for all other users, and the database error will still be triggered by them, showing up in the error_log file and leading me to believe that the problem continues even though I would not be triggering it.
Since I have not discovered a way to trigger the error through some behavior of my own, I don’t have a way to test even with the Check Conflicts plugin.
Based on the code, can you tell me how I can trigger the error manually?
By the way, can you answer this question:
Why is WooCommerce 7.6.0 repeatedly calling a shutdown handler for a plugin I don’t even have installed, anyway?
Forum: Plugins
In reply to: [WooCommerce] WordPress database error Commands out of syncNo luck with 512 MB for the WP Memory Limit:
WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROMwp_optionsmade by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Autoloader\jpa10d711ec5dd1299c49f4fb90df5a407\Shutdown_Handler->__invoke, Automattic\Jetpack\Autoloader\jpa10d711ec5dd1299c49f4fb90df5a407\Plugins_Handler->cache_plugins, set_transient, update_optionThere are no error logs in WooCommerce > System Status > Logs after these errors in error_log.
Why is WooCommerce 7.6.0 repeatedly calling a shutdown handler for a plugin I don’t even have installed, anyway?
Forum: Plugins
In reply to: [WooCommerce] WordPress database error Commands out of syncHi @ihereira
Thanks for the reply.
I have increased (doubled) the WP Memory Limit to 512 MB:
### WordPress Environment ### WordPress address (URL): https://thedomain.com Site address (URL): https://thedomain.com WC Version: 7.6.0 REST API Version: ✔ 7.6.0 WC Blocks Version: ✔ 9.8.4 Action Scheduler Version: ✔ 3.5.4 Log Directory Writable: ✔ WP Version: 6.2 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: –and cleared the error_log to see if that resolves the error.
I will give it a little time and post back with the results.
I know you said to wait until the error recurred with the increased memory, but I took a look in WooCommerce > System Status > Logs because I couldn’t recall seeing anything about the error there, and there isn’t. The only error log in there is test-log.log, and it’s empty.
Forum: Plugins
In reply to: [Menu In Post] Placeholder doesn’t remain inplaceHi @faunlf
Haven’t heard back from you, so I’m going to mark this as resolved.
Forum: Plugins
In reply to: [Menu In Post] Placeholder doesn’t remain inplaceI have another idea for you. I’ve done some more testing, upgraded my test site to WP 6.2, and tested some more, but I can’t reproduce your problem. I’m going under the assumption that something–Elementor, or a theme/plugin that also affects menus that you’re using–is causing a conflict with Menu In Post, or causing the problem on its own.
If you’re willing to do a quick test, we can see if disabling the code in Menu In Post that adds the
selected="selected"attribute to the drop-down options for the current post/page gets it working for you.Use your favorite plain-text editor to edit /wp-content/plugins/menu-in-post/menu-in-post.php, and on line 157, change this:
$attributes .= ' selected="selected"';to this:
//$attributes .= ' selected="selected"';The two forward slashes at the beginning of the line turns the line into a comment so PHP will ignore it instead of executing the code, preventing Menu In Post from adding the “selected” attribute.
Purge your cache if you’re using one, clear your browser cache, and visit your page again to see if it’s fixed.
Take a look and see if all those
selected="selected"still show up in your HTML.Forum: Plugins
In reply to: [Menu In Post] Placeholder doesn’t remain inplaceFirst, confirm that your shortcode looks something like the following:
[menu_in_post_menu menu=3 style="dropdown" placeholder_text="Choose a topic..."]Where the “menu=” number is the ID of your chosen menu as created by the Menu In Post Tools, and the placeholder_text is in double quotes.
The other thing I notice is that there is a recurring error in the HTML for the menu on your page. Every item has the “selected” attribute set to “selected.” None should be selected, allowing the placeholder to be the visible option. Since they’re all selected, it’s not surprising that you’re getting some weird, random results.
Here’s the relevant HTML from your page showing all the options are selected:
<option value="#">Choose a topic</option> <option value="https://test.mggno.com/resources-2/#agcenter" selected="selected">AgCenter Publications</option> <option value="https://test.mggno.com/resources-2/#Dan-Gill" selected="selected">Dan Gill</option> <option value="https://test.mggno.com/resources-2/#facebook" selected="selected">Facebook Pages to Follow</option> <option value="https://test.mggno.com/resources-2/#GNO-Gardening" selected="selected">GNO Gardening</option> <option value="https://test.mggno.com/resources-2/#Google-Search-Tips" selected="selected">Google Search Tips</option> <option value="https://test.mggno.com/resources-2/#master-gardener-favorites" selected="selected">Master Gardener Favorites</option> <option value="https://test.mggno.com/resources-2/#plant-societies" selected="selected">Plant Societies</option> <option value="https://test.mggno.com/resources-2/#inspiration" selected="selected">Sites for Inspiration</option> <option value="https://test.mggno.com/resources-2/#superplants" selected="selected">Superplants</option> <option value="https://test.mggno.com/resources-2/#youtube" selected="selected">YouTube Channels</option>I see that you’re using Elementor, which may be causing a conflict with the Menu In Post plugin, or some other plugin you’re running that handles menus could be the culprit.
It also looks like you have the menu in a widget instead of in a post. If you’ve got it in a widget, I’d probably try moving it to the post and see if it fixes the problem before I did anything with Elementor.
Since I’m guessing you want to keep Elementor even if it is causing the conflict, you could try the WordPress Menu Block instead of Menu In Post to see if it plays more nicely with Elementor than Menu In Post.
Let me know what you figure out.
Thanks for the information, @muffinpeace.
I guess I wasn’t clear enough. What I was really asking was why the plugin needs to communicate with an external server to do the optimizations it does. I believe I found my answer in the Jetpack privacy policy, if that’s applicable to Jetpack Boost.
Forum: Plugins
In reply to: [WooCommerce] Automatically Empty Trash Orders?Thanks for the quick response @xue28.
That is helpful information. I don’t delete orders often enough to make it worth an extra plugin. For now, I will be fine with the Empty Trash button.
Forum: Plugins
In reply to: [Wordfence Login Security] Is WooCommerce Guest Checkout Protected?Hi @wfphil
Thanks for letting me know.
If you’re looking for a way to improve the plugin, adding support for WooCommerce guest checkout would be a great improvement. Card-testing attacks are a real problem for WooCommerce, and difficult to block without hurting the checkout experience for real customers.
Forum: Plugins
In reply to: [Menu In Post] Menu In Post plugin obsoleted by Gutenberg navigation block ?That would be good. I wouldn’t mind being off the hook for maintaining this plugin.
Forum: Plugins
In reply to: [Woo Manage Fraud Orders] Can’t easily remove user from blacklistI realize this is a bit of an old post, but I have been taking a look at this plugin and noticed it as it addresses an important detail.
In reviewing the developer’s info here, in the section “Remove the customer details from blacklisting,” it looks like an easier way to remove a customer from the blacklist, especially for @emmaee’s more-complex email case, would be to do so via the order itself, though I’m not sure that will purge the customer’s related entries from the logs if the log purge is required to allow the customer to order once more.
Wordfence Login Security is a subset of Wordfence which allows those who only want to add login security without the additional features and overhead of the full Wordfence plugin to do so.
The Wordfence plugin offers many more features than just login security, including a firewall and malware scanning just to name two.