almendron
Forum Replies Created
-
De nada.
Por lo que veo, la cuestión de las categorías sigue pendiente de resolver. Acabo de volver a comprobar y al marcar la categoría con Id=2, me coge tres más cuyo ID también comienza por 2. Me lo hace tanto en local como en servidor.
Acabo de probar la nueva versión del plugin y me da error crítico al actualizar.
No me sale en el log dicho error, pero así aparecen muchísimas líneas con un PHP Warning (Undefined variable $block_editor). Es como si hubiera entrado en bucle y al final provocara el error crítico.
Es que no afecta a todas las categorías. A mi solo me pasa cuando selecciono una de ellas. Prueba con la que tenga de ID 1 o 2.
Forum: Plugins
In reply to: [Jetpack - WP Security, Backup, Speed, & Growth] Connection lostThis morning it has been detected that the hosting was receiving an attack with many requests from different countries. To avoid overloading the machine, they have configured the varnish anti-attack filter and this has caused the connection with wordpress.com to be lost.
Forum: Plugins
In reply to: [Broken Link Checker] Unnecessary database queries?Check. Modifying the ‘wp_options’ table also works.
Forum: Plugins
In reply to: [Broken Link Checker] Unnecessary database queries?The tests were carried out on a local server. When I read your last message, I had already made the changes to the plugin. As the result was positive, I will not modify the table ‘wp_options’.
Actions performed:
Add index to the table.
ALTER TABLE {prefix}_blc_instances ADD INDEX lpc (link_id, parser_type, container_type);Apply the suggested changes to the code
$broken_links = 0; #$blc_link_query->get_filter_links( 'broken', array( 'count_only' => true ) );I take note of the last option proposed (modify “wsblc_options”). I will give it a try.
Thank you very much for your support.Forum: Plugins
In reply to: [Broken Link Checker] Unnecessary database queries?The solution you propose does not work.
- The value of ‘show_link_count_bubble’ changed to ‘false’.
- I access the section ‘Media’, ‘Plugins’, etc. and the following query is executed in each of them:
Plugin: broken-link-checker
blcLinkQuery->get_links()
wp-content/plugins/broken-link-checker/legacy/includes/link-query.php:580blcLinkQuery->get_filter_links()
wp-content/plugins/broken-link-checker/legacy/includes/link-query.php:682wsBrokenLinkChecker->admin_menu()
wp-content/plugins/broken-link-checker/legacy/core/core.php:414do_action('admin_menu')
wp-includes/plugin.php:517SELECT COUNT(*)
FROM (
SELECT 0
FROM wp_blc_links AS links JOIN wp_blc_instances AS instances
ON links.link_id = instances.link_id
WHERE ( instances.parser_type IN ('link', 'image', 'youtube-iframe', 'metadata', 'url_field', 'acf') )
AND ( instances.container_type IN ('comment', 'post', 'page', 'dummy') )
AND ( ( broken = 1 ) )
AND ( (dismissed = 0) )
GROUP BY links.link_id) AS fooThis query should only be executed when accessing your plugin section and not in any other WordPress admin section.
Forum: Plugins
In reply to: [Broken Link Checker] Unnecessary database queries?You have updated the plugin, but the issue raised in this query has not been resolved.
Problem solved. Thank you very much.
I have found the solution: right click on the WAMP icon, go to “Tools” and click on “Revert default DBMS MySQL <-> MariaDB”.
MariaDB is set as default engine, the port numbers change automatically and the services are restarted.
Best regards
Forum: Plugins
In reply to: [Broken Link Checker] Unnecessary database queries?Thank you very much. I hope that the update will arrive as soon as possible.
Forum: Plugins
In reply to: [Broken Link Checker] Unnecessary database queries?Another example. Sequence:
- Login (…wp-login.php)
- ../wp-admin: 4.3 seconds plugin query
- ../wp-admin/plugins.php: 2.6353 seconds query plugin
Forum: Plugins
In reply to: [XML Sitemap Generator for Google] API 403Resolved with the latest update. Thanks
Forum: Plugins
In reply to: [Broken Link Checker] Unnecessary database queries?Screenshot: https://www.almendron.com/compartir/broken/query.png (note: the execution time varies).
The main problem is not the time, but why it is executed in the scope of the administration.
Example: Why is this query executed when I access the list of posts or categories?
This database query on very large sites with many posts and links causes a large RAM consumption.
https://www.almendron.com/tribuna/
xx_blc_instances: 358000 files
xx_blc_links: 289000 files
xx_blc_sych: 218000 files
xx_post: 145000 filesForum: Plugins
In reply to: [XML Sitemap Generator for Google] PHP Deprecated: strpos()Thank you very much. Best regards
