olliejones / index-wp-users-for-speed Goto Github PK

fabwintle (@fabwintle) reports:
Hi, I have just set up this plugin today and I’m getting the below error when the cron runs.

Uncaught Error: Call to a member function doTaskStep() on bool in /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-content/plugins/index-wp-users-for-speed/includes/tasks/task.php:19
Stack trace:
#0 /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-includes/class-wp-hook.php(307): IndexWpUsersForSpeed\index_wp_users_for_speed_do_task()
#1 /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters()
#2 /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-includes/plugin.php(524): WP_Hook->do_action()
#3 /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-cron.php(138): do_action_ref_array()
#4 {main}
thrown
– Error Level: E_ERROR
– Request: /wp-cron.php?doing_wp_cron=1665379880.7570960521697998046875
– Referrer: https://www.tourismtribe.com/wp-cron.php?doing_wp_cron=1665379880.7570960521697998046875
– File: /wp-content/plugins/index-wp-users-for-speed/includes/tasks/task.php
– Line: 19

Hi Ollie, i´m trying to use this on a Learndash (WP plugin) website with more than 350k users, yeah, a lot.

The main issue is with the admin page, not the users one, so when i try to edit a course it still make this query:

SELECT w337p_users.ID,w337p_users.user_login,w337p_users.display_name FROM w337p_users INNER JOIN w337p_usermeta ON ( w337p_users.ID = w337p_usermeta.user_id ) WHERE 1=1 AND ( ( ( ( w337p_usermeta.meta_key = 'w337p_capabilities' AND w337p_usermeta.meta_value LIKE '%\"edit\\_courses\"%' ) OR ( w337p_usermeta.meta_key = 'w337p_capabilities' AND w337p_usermeta.meta_value LIKE '%\"administrator\"%' ) OR ( w337p_usermeta.meta_key = 'w337p_capabilities' AND w337p_usermeta.meta_value LIKE '%\"editor\"%' ) ) ) ) ORDER BY display_name ASC

with all the likes. I have installed the plugin, i don´t know if the problem is the use of a particular tag for the tables (w377p) or if it´s a problem with Learndash but as far as i understand this query has to be more direct without the LIKEs.

What do you think?

I haven't quite tracked down when this function is called, but had it triggered a few times.

PHP Warning: The magic method IndexWpUsersForSpeed\Indexer::__wakeup() must have public visibility
wp-content/plugins/index-wp-users-for-speed/includes/indexer.php:405

https://make.wordpress.org/core/2023/10/16/introducing-admin-notice-functions-in-wordpress-6-4/

Hi @OllieJones, we are using the plugin for quite some time but then we upgraded the version to 1.1.5.
We have less than 100 Authors but the Author dropdown on the post and page has gone missing even though I set the settings to the max 100 value.

but I checked on the inspector tools the select tag is there, it is overridden by the input tag.

What do you think? Thanks!

To get things to work with MariaDB 10.9, it's necessary to eliminate ORDER BY ID from queries with LIMITs, or semijoined -- IN (SELECT()) -- optimization falls over.

The 'role__not_in' and 'role__in' search terms are expected to be arrays, lists of roles.

At least one plugin presents a string in that term. So we must detect that case and convert it to a one-element array.

Reported by https://wordpress.org/support/users/enthousiastwpuser/

Message: Uncaught TypeError: array_merge(): Argument #2 must be of type array, string given in /var/www/website(dot)com/htdocs/wp-content/plugins/index-wp-users-for-speed/admin/user-handler.php:678

The Approximate User count on the dashboard page is not very accurate.
https://wordpress.org/support/topic/approximate-number-of-users-not-correct-even-after-optimize-database/

And it fails on wordpress 5.8.3.
https://wordpress.org/support/topic/undefined-array-key-wp_the_query/

Here's one: https://wordpress.org/support/topic/report-php-8-1-deprecate-message-2/

From fabwintle (@fabwintle)
https://wordpress.org/support/topic/cron-task-invocation-error-from-fabwintle/

Hi, I have just set up this plugin today and I’m getting the below error when the cron runs.

Uncaught Error: Call to a member function doTaskStep() on bool in /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-content/plugins/index-wp-users-for-speed/includes/tasks/task.php:19
Stack trace:
#0 /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-includes/class-wp-hook.php(307): IndexWpUsersForSpeed\index_wp_users_for_speed_do_task()
#1 /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters()
#2 /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-includes/plugin.php(524): WP_Hook->do_action()
#3 /home/508763.cloudwaysapps.com/tmsajmvuew/public_html/wp-cron.php(138): do_action_ref_array()
#4 {main}
thrown

• Error Level: E_ERROR
• Request: /wp-cron.php?doing_wp_cron=1665379880.7570960521697998046875
• Referrer: https://www.tourismtribe.com/wp-cron.php?doing_wp_cron=1665379880.7570960521697998046875
• File: /wp-content/plugins/index-wp-users-for-speed/includes/tasks/task.php
• Line: 19

Firstly, thanks for creating this plugin!

I am seeing the following line in PHP logs when the reindexing is scheduled to run overnight:

index_wp_users_for_speed_task: task expired, so cannot run: -reindex_1

One thing to note is that WP Cron is disabled via DISABLE_WP_CRON, replaced by a system cronjob every 10 minutes.

Let me know if there is anything else I can do to help check further.

Plugin version: 1.1.5
WP version: 6.3.1
PHP: 7.4.33
MySQL:10.3.39-MariaDB-log-cll-lve

radamesbispo (@radamesbispo) reports:
here

I just want to inform that i have a marketplace using a plugin woocommerce wcfm, but when i activate your plugin Index WP Users For Speed all store vendors disappear from database, so I had to disable the plugin.

Hey guys, our site has a few hundred thousand users and this plugin has been a big help. However, we are no longer able to delete users - when we go to the Users section of wp-admin, and click "Delete" for a user, the next page where you're given the option to reassign posts made by the user doesn't load (specifically, it stops at the dropdown that would list choices of users to reassign to).

The error given is:

PHP Fatal error:  Uncaught TypeError: in_array(): Argument #2 ($haystack) must be of type array, string given in wp-content/plugins/index-wp-users-for-speed/admin/user-handler.php:219
Stack trace:
#0 wp-content/plugins/index-wp-users-for-speed/admin/user-handler.php(219): in_array()
#1 wp-content/plugins/index-wp-users-for-speed/admin/user-handler.php(192): IndexWpUsersForSpeed\UserHandler->filtered_query_args()
#2 wordpress/wp-includes/class-wp-hook.php(307): IndexWpUsersForSpeed\UserHandler->filter__wp_dropdown_users_args()
#3 wordpress/wp-includes/plugin.php(191): WP_Hook->apply_filters()
#4 wordpress/wp-includes/user.php(1637): apply_filters()
#5 wordpress/wp-admin/users.php(371): wp_dropdown_users()
#6 {main}
  thrown in wp-content/plugins/index-wp-users-for-speed/admin/user-handler.php on line 219

when using version 1.0.2 of this plugin and 6.0.2 of WordPress.

I'll start trying to track down the issue and submit a PR if I can figure it out, but figured that I would submit the issue in the meantime to see if there is something we are missing or have set wrong. Thanks for your great plugins, perfect for large sites like ours!