Cannot update: "No available releases found"

Question

I cannot update some of the modules and the Drupal core itself from "Available Updates" menu. The error is "No available releases found". However, I can list the updates with drush ups.

Why?

Answer 1

Solution 1: SQL Query

While checking updates Drupal creates some rows inside the key_value table which should be deleted after checking is complete but looks like they doesn't for some reason. So deleting the related rows manually solved my problem:

DELETE FROM key_value WHERE collection = 'update_fetch_task';

Solution 2: hook_update_N()

If it is not possible to execute SQL queries via MySQL CLI on your server, then you might want to create a hook_update_N() in a custom module:

$database = \Drupal::database();
$database
  ->delete('key_value')
  ->condition('collection', 'update_fetch_task')
  ->execute();

Answer 2

drush sql-query "DELETE FROM key_value WHERE collection='update_fetch_task'"

using drush Fixed for me

Answer 3

Use the Devel module, and in /devel/php enter the following code.

$query = \Drupal::database()->delete('key_value');
$query->condition('collection', 'update_fetch_task' , '=');
$query->execute();

Answer 4

According to this post https://www.drupal.org/project/drupal/issues/3120168, if you click on "Check manually", it fixes the problem. I tried it and it worked.

Edit: I used this method on Drupal ^8.8

Answer 5

I couldn't find the key_value table anywhere.

After a lot of research, I stumbled upon this article by Marius Cârneală. https://www.mariusc.name/content/no-available-releases-found-drupal-error-fix

His SQL command worked for me: truncate cache_update

You can run it via this drush command:

drush sqlq "truncate cache_update;"

Answer 6

DELETE FROM key_value WHERE collection = 'update_fetch_task' worked where "update manually", "update cron" and "clear all caches" didn't.