In a Drupal 8 install, I visit /admin/reports/updates, and I receive the following error:

Warning: Invalid argument supplied for foreach() in template_preprocess_update_report() (line 44 of core/modules/update/update.report.inc).

From this page, I have tried to the run the SQL query:

delete * from 'prefix_key_value' where collection = 'update_fetch_task';

but I receive error:

MySQL said: Documentation

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* from 'prefix_key_value' where collection = 'update_fetch_task'' at line 1

Help appreciated.

3 Answers 3


delete * from ... is invalid SQL, you don't need the asterisk.


From this page I tried an SQL query to remove * from 'prefix_key_value' where collection = 'update_fetch_task'; but that failed, so I deleted the update_fetch_task entry manually from the prefix_key_value table.

That resolved the error.


From the same page referenced in the question, you need to have an update.settings.yml file, which can be set at ./admin/reports/updates/settings

Once you have this file, the update report screen at ./admin/reports/updates should work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.