#Regression

Thanks, @nsciacca. I am still struggling on D10.5.1 with linkchecker 2.0.2.

Not sure what you meant by "delete the existing Broken Links report view" *after* unstalling the module. Running drush lccl (or the equivalent from the broken links page) works flawlessly on 2.0.0 but throws the errors on 2.0.2. Or did I misunderstand what you meant? Here is what I did this time:

I completely uninstalled 2.0.0 that was working as expected. I cleared all caches, ran cron, newly installed with composer 2.0.2, upgraded the database (here is the update output from drush):

> [notice] Update started: linkchecker_update_8003
> [notice] Update completed: linkchecker_update_8003
> [notice] Update started: linkchecker_update_8004
> [notice] Entities are updating: finished 10 of 32.
> [notice] Entities are updating: finished 20 of 32.
> [notice] Entities are updating: finished 30 of 32.
> [notice] Entities are updating: finished 32 of 32.
> [notice] Update completed: linkchecker_update_8004
> [notice] Update started: linkchecker_update_8005
> [notice] Update completed: linkchecker_update_8005
> [notice] Update started: linkchecker_update_8006
> [notice] Linkchecker links are updating: finished 0 of 0.
> [notice] Update completed: linkchecker_update_8006
> [notice] Update started: linkchecker_update_8007
> [notice] The entity_id field storage definition successfully uninstalled.
> [notice] Update completed: linkchecker_update_8007
> [notice] Batch process has consumed in excess of 60% of available memory. Starting new thread
> [notice] Update started: linkchecker_post_update_remove_orphaned_queue_data
> [notice] Update completed: linkchecker_post_update_remove_orphaned_queue_data
[success] Finished performing updates.

Cleared caches, and then running drush lccl throws again the same database errors as quoted in #12,

drush lccl
> [error] Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_id__target_id' in 'NEW': INSERT INTO "linkchecker_link" ("status", "urlhash", "url",

etc., as above, this time ending with

> In StatementWrapperIterator.php line 113:
>
> SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_id__target_id' in
> 'NEW'
>
> In ProcessBase.php line 155:
> Output is empty.

Could it be that the database upgrade is slightly off for D10.5.* while working well for D11? Or am I overlooking sth. obvious?

I had the same issue and I found it was the View config that was stored in the code that was the problem. The view itself needs to be updated, so if you copy it from the module's config directory, or uninstall the module, delete the existing Broken Links report view, then re-install the module and export the new config you should be good to go.