Stuck at X URLs in the work queue

I’m having the same problem.

1917 URLs in the work queue
Detected 1917 unique URLs in 2222 links.

Never gets past this point and isn’t finding the broken links (which I know there are many).

I reinstalled the plugin and clicked the nuclear option. It found all the links then stalled at the work queue.

This is a dev site so no public access.

Same here

Have you enabled the log? Perhaps there is some hint in the log file of what’s going on?

Sue and co: if you are using the default wp-cron on a dev site with no traffic this could explain the problem. You need to trigger wp-cron regularly.

I have ~500 URLs in the work queue. Last time my URLs were checked was 2015.05.12. according to the plugin. I went ahead and enabled logging, to see if anything is happening. Will get back with the results.
This is a live site so it gets some traffic every now and then.

Thanks for the advice.

2015?! OK, you have a problem ??

In your shoes I would:
– delete the plugin (not only desactivate, really delete)
– check that the 4 tables this plugin installs are gone (wp_blc_instances, blc_links, blc_synch and blc_filters. If not delete these tables thru phpmyadmin.
– re-install a fresh version

Wait.
Before doing this check in advanced settings the 3 variables: execution time, server limit, resource usage limit.

Execution time: move to 60 seconds
Server charge: leave empty (for our test)
Resource usage: increase this

Activate the log.
Then check your log that it runs.

It could be that the plugin never runs because your server is too weak for your settings.

Thanks. The site does get pinged at least several times per week if not more so I don’t think that’s the problem. I changed the plugin settings as you suggested but it is stuck at 1917 again. I’ll check the log files. If there is nothing there I’ll do the clean reinstall and let you know if that fixes the problem.

I installed and started running the plugin this morning. All was well, but now I am getting a similar behavior than yours. Let me be precise as perhaps we don’t have the exact same problem:

– in the dashboard the queue does not move
– I have log enabled, and I see that the plugin is executing regularly: it’s even writing to the database
– I checked the blc_links table and an hour or 2 ago it started writing incomplete lines in the table: only link_id and url are filled. All other variables, including last_check, last_check_attenpt, final_url… are empty.
There are thousands of such lines. This is a problem.
– the log also shows the UPDATE sql query. I’m investigating into this query as clearly it’s not writing correctly the the table.

Yes: the UPDATE query is adding \ before each field and just before the closing apostrophe of each field. This is breaking the update.

So the plugin is running, but the blc_links table does not get updated.

I’ll see if I can find what’s causing this. Ideally at this point the plugin developer would step up ??

EDIT: it seems it’s the debug that’s add_slashing, not the actual query.

I’ve checked the UPDATE function in links.php and cannot see anything wrong despite the fact that it obvisouly is not updating the wp_blc_links table.

Here’s what’s happening: the plugin keeps scanning the same 30 or so links continually, but does not write in the database that it has scanned those links. That’s why at each cycle, when it checks the database for the next links to be scanned, that it scans the same ones again, and again, and again…

I have used the nuclear reset (which completely drops the blc_links table and rescans the site) with debug log turned on from the start. This way I will be able to see what happens once blc_links is no longer updated.

But given the size of my site this could take half a day before we get there.

OK,
Same problem again: this time after only 500 out of 7000 links it stopped: the process is still running and recording in the log (apparently successfully, ie, lines are updated) but nothing gets updated in wp_blc_links.

This is a major bug in an otherwise excellent plugin. Unfortunately it renders the plugin useless until the developer is able to fix it. Despite my best efforts I have not found the reason why the UPDATE no longer works after a while.

I had given this plugin a 5 star rating, but will be degrading this until this is fixed. I sincerely wish good luck to the developers (it’s strong programming so it should be quite easy for them)

Of course it’s 2016, my bad ?? So it’s more than a month now. This was probably the last time I was trying to fix it. Or it was an older version of WP back then when plugin worked fine. Who knows now.

But we are probably knocking on locked doors over here. Original author stopped maintaining this plugin months ago. At least that’s what looks like.
We could try and report the issue over here: https://github.com/ManageWP/broken-link-checker