traqbar

Hello,

Thanks for the support. Seems like the issue is resolved. The site was maybe about to have a melt down due to another plugin generating thousands upon thousands of files for a feature. I had already complained about being poor quality as these files are not managed and left to rot. But it was not resolved to date. It has been casuing backup problems as well.

Perhaps a good feature you could add to Wordfence is ensuring that high file counts are mentioned or monitored. As in this case there was no obvious signs of the file count casuing the issue, but there was some strange behaviours starting to build up.

Anyway, I disabled the feature of said plugin, removed the 3 million QR code un-needed files and things seem to be getting back to normal.

Thanks

Hello,

It is part of a multisite environment.

Can I send a link to a private contact? I dont really wish to post such info in public sphere.

Thanks

Hello,

I was runnning diagnostics whilst trying to avoid certain folders being scanned. I dont think I have fixed that yet. It isnt a problem to be running the in depth diagnostics, the issue was that it kept running in the database query when no further scan was being run – and it was maxing out the cpu.

I am not sure if I should make a new ticket here or not but…. I was trying to something like /wp-content/uploads/sites/*/folder/* to prevent each site (multi-site) media directory being scanned for a certain plugin. This plugin produces many many small QR codes which take a very long time for wordfence to scan through and ends up timing out the scan. I dont seem to have got this right yet though as the files still seem to be scanned. Is it possible to do such a wildcard expression?

Do I need to do the full path eg /var/www/ etc etc or can I do from wp-content?

Thanks

Hello,

Yes, I got the jist of the intention for this system. Sadly I learnt about it through working out what had crashed my site. It was installed by another plugin which created the tables. I was cleaning out the database no-longer needed tables, and these tables I assumed to be with a cron check plugin I had used intentionally.

As these tables are not obviously associated to a plugin which is using it through any naming scheme I naturally had no issues with removing such tables. Then random and weird crashes that made no sense. Then researching into the casues of the script in one plugin traced all the way back to here. Hence a lot of time and frustration for something I never asked for to be permanently installed on my site. There is no normal way to remove these tables except manually, but there is the danger, unless you know exactly nothing is using it your site will crash.

Hence I understand what benefit you are trying to achieve, but it is very often not required in most cases, and only really required by people who know what they are doing, by which point they will be looking for some kind of cron management system. Which is why I say this is a backward method of forcing upon people who really do not need it – and not allowing it to be an optional use case by people who know what they are doing.

Hi,

No the main issue is that the whole concept of this library is backward. It should be an optional usage for any website owner and not self installed by any random plugin that uses the library.

Only if this plugin is installed should and other plugin connect with it – on the users optional descision. The majority of wordpress sites are unlikely to require such a managed cronjob system, yet you are introducing an additional level of complexity to a few plugins that might use it. Whilst the rest might not – so not resloving the problem on a site that scales enough to require such level of management.

Your documentation shows that any real need for it requires further plugins to manage different setups. As all said and done, the only plugins that are using it on my site are already overbloated nonsense and I aim to remove them – which at the same time I will remove these tables.

I resolved the issue by going through each of my sites and actvating and deactivating this plugin to ensure the tables are built and my site runs okay again. Until such a time when I will remove all this nonsense.

Thanks

I was getting blocked once I installed a nginx reverse proxy. Adding the below code helped resolve the correct visitor IP to be received and resolving https issues.

if ($_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https') $_SERVER['HTTPS']='on';

if ( isset( $_SERVER['HTTP_X_FORWARDED_FOR'] ) ) { 
    $mte_xffaddrs = explode( ',', $_SERVER['HTTP_X_FORWARDED_FOR'] ); 
    $_SERVER['REMOTE_ADDR'] = $mte_xffaddrs[0]; 
}

When a plugin includes (and loads) its own copy of Action Scheduler, it doesn’t need to ‘worry’ about creating the additional tables required by Action Scheduler: the library handles this itself. Or, that is the intention.

So a plugin will not install the tables by itself? Only if Action Scheduler is installed will the tables be inserted? Or do you mean the library in the plugin will install the tables?

Thanks

Hello,

The tables are already back up as previously explained when I activated per site the plugin. I will be looking into what plugins I need to remove in future so I can remove these tables entirely. I am not happy to add this additional level of complexity without having opted in to it.

Thanks

Hello,

I understand this, but during my testing of deactivating and activating plugins, the tables were not rebuilt – I don’t think so anyway, there was a lot I was trying at the time.

I will have to look further into this when I am ready to remove said plugin.

Be very careful about installing this – it is more of a library for developers than something for a general functional use.

Hello,

Thanks for your reply. I came to understand where the failure was coming from. An additional issue was that as I have multisite the plugin would not rebuild tables per site. So I had to activate the plugin per site to get the tables built.

I found that WP Mail SMTP plugin is hooked and maybe W3 totalcache – not sure if that was just running a cached database query though. So I got my site backup but I don’t want these extra tables hanging around on each of my sites. Is it right that WP Mail SMTP would install these tables without Action Scheduler? As you described this is used more as a library than a top level plugin I get this idea.

I am quite happy with my cronjob setup on my VPS and see no need for additional complications of more tables managing a seperate set of tasks. I would avoid any plugins that would add this additional complexity. I only installed this plugin accidentally whilst I was searching for something to prove all the cron tasks are running correctly. There is a plugin with a similar name which I meant to use.

I intend to remove WP Mail SMTP soon and build my own version as it is a bit of bloatware and I only need a clean SMTP plugin. But I am not ready yet. However, my question is – is there an option which is triggered when WP Mail SMTP sees that action scheduler is installed so it switches to using these tables? Or is it dependent on these tables and will install them itself without action scheduler?

I am presuming that it does not build the tables as hence the collapse of my site when the tables were removed. So somewhere there must be an option setup I presume. I haven’t researched this but I am thinking out aloud.

Thanks

Hello, Still waiting for help about this. I am receiving the error as below.

I do not need this plugin and I just want to remove it from my multisite. But it crashes everything as soon as I try to remove it.

AH01071: Got error ‘PHP message: WordPress database error Table ‘production.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘/var/www/production/shared/wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query; PHP message: WordPress database error Table ‘production.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘/var/www/production/shared/wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query; PHP message: WordPress database error Table ‘production.wp_actionscheduler_actions’ doesn’t exist for query SELECT count(a.action_id) FROM wp_actionscheduler_actions a WHERE 1=1 made by require_once(‘wp-admin/admin.php’), do_action(‘tools_page_action-scheduler’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_AdminView->render_admin_ui, ActionScheduler_Abstract_ListTable->display_page, ActionScheduler_ListTable->prepare_items, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query; PHP message: WordPress database error Table ‘production.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 10 made by require_once(‘wp-admin/admin.php’), do_action(‘tools_page_action-scheduler’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_AdminView->render_admin_ui, ActionScheduler_Abstract_ListTable->display_page, ActionScheduler_ListTable->prepare_items, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query’, referer:

Right, I see, Okay I have to contact them at Automatic for how to get rid of this plugin.

Thanks

Hello,

The Action Scheduler has been removed, but it does not remove its tables on deletion. I removed them manually but then I had these errors happen.

Is this actually Action Scheduler still trying to run even though I have uninstalled it?

Thanks

Okay, thanks for the info. I think that corresponds to my investigations.

Can you let me know how to manually remove the current cache as it does not work when I purge all.

Can you confirm if there is an issue with clearing the database caching?

Thanks.