Regression: After updating to 2.0.2, broken links report doesn't work

I had to remove all link entities and reanalyze content for links. Then it works.

Similar issues. I quickly realized no content edits would save on site, producing a parent_entity_type_id not found error. I manually enabled dynamic entity reference after seeing it in missing modules report.
composer require 'drupal/dynamic_entity_reference:^3.2'

But the error remains for core broken links reports:

Drupal\Component\Plugin\Exception\PluginNotFoundException: The "" entity type does not exist. in Drupal\Core\Entity\EntityTypeManager->getDefinition() (line 142 of core/lib/Drupal/Core/Entity/EntityTypeManager.php).

@jlancaster, yes that's exactly what I had happen. Same errors. To fix it, delete all links and reanalyze content for links. I also upgraded to 2.1.x and removed dynamic_entity_reference

Ahh, you had me curious and confused because I had no idea what "delete all links and reanalyze content" meant (shows how often I use linkchecker). If anyone else sees this, I found what is being referenced at /admin/config/content/linkchecker in the "Maintenance" section the button says "Clear link data and analyze content for links." Once I ran this everything is good... minus waiting for content to reanalyze. That said, the missing dependency for DER is concerning and I'd like to manually not have to include it.

Yeah, 2.1.x doesn't use DER anymore, so I figured it was a good time to upgrade.

Confirming the instructions in #5 from @jlancaster cleared the problem up for me. Thank you!

Added workaround info to IS

"Clear link data and analyze content for links" did not work for me. The view report is still throwing the same error. I don't see any obvious problems in the views configuration.

The dynamic_entity_reference module is still enabled on my site. It is used by other modules, so it is not something I can remove.

Did you try uninstalling and reinstalling the Linkchecker module?

I really really wanted to avoid reinstalling the Linkchecker module -- having to set up all the fields again would be a super pain. (I guess I'd be able to reinstall field configs, but that would still be a bunch of time)

Beyond having to delete all the old checked links, the view needed some updates as well. What I ended up doing was exporting the view from one my one simple site (where I did end up uninstalling and installing), and then (making sure I had the UUID correct) importing it into the other site.

The same bug bit me on D10.5.1 when upgrading 2.0.0 to 2.0.2
After reading this thread, downgrading, upgrading and updating the db, clearing caches I did not to go to the report but called "Clear link data and analyze content for links". Maybe this error message provides some more information?

Ein AJAX-HTTP-Fehler ist aufgetreten.
HTTP-Rückgabe-Code: 500
Im Folgenden finden Sie Debugging-Informationen.
Pfad: /batch?id=211&op=do_nojs&op=do
Statustext: error
[message "unexpected error ..." in German]
Drupal\Core\Entity\EntityStorageException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_id__target_id' in 'NEW': INSERT INTO "linkchecker_link" ("status", "urlhash", "url", "method", "code", "error", "fail_count", "last_check", "entity_field", "entity_langcode", "uuid", "parent_entity_type_id", "parent_entity_id") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12); Array
(
[:db_insert_placeholder_0] => 1
[:db_insert_placeholder_1] => 9tazkp-ufKs0nSgxt3CsIxKNiazvXgYeERn5eLZN_Xw
[:db_insert_placeholder_2] => https://mysite.tld/somepage-with-an-outdated-link-in-it
[:db_insert_placeholder_3] => HEAD
[:db_insert_placeholder_4] =>
[:db_insert_placeholder_5] =>
[:db_insert_placeholder_6] => 0
[:db_insert_placeholder_7] =>
[:db_insert_placeholder_8] => body
[:db_insert_placeholder_9] => und
[:db_insert_placeholder_10] => f8c0d5e4-0ac7-44c2-bf98-1097fd3b96e7
[:db_insert_placeholder_11] => node
[:db_insert_placeholder_12] => 3
)
in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 817 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php). Drupal\Core\Database\StatementWrapperIterator->execute(Array, Array) (Line: 44)
Drupal\mysql\Driver\Database\mysql\Insert->execute() (Line: 948)
Drupal\Core\Entity\Sql\SqlContentEntityStorage->doSaveFieldItems(Object) (Line: 718)
Drupal\Core\Entity\ContentEntityStorageBase->doSave(NULL, Object) (Line: 486)
Drupal\Core\Entity\EntityStorageBase->save(Object) (Line: 806)
Drupal\Core\Entity\Sql\SqlContentEntityStorage->save(Object) (Line: 354)
Drupal\Core\Entity\EntityBase->save() (Line: 383)
Drupal\linkchecker\LinkExtractorService->saveLink(Object) (Line: 356)
Drupal\linkchecker\LinkExtractorService->saveLinkMultiple(Array) (Line: 142)
Drupal\linkchecker\LinkExtractorBatch->processEntities(50) (Line: 224)
Drupal\linkchecker\LinkExtractorBatch->batchProcessEntities(50, Array) (Line: 297)
_batch_process() (Line: 139)
_batch_do() (Line: 95)
_batch_page(Object) (Line: 52)
Drupal\system\Controller\BatchController->batchPage(Object)
call_user_func_array(Array, Array) (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 637)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 121)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext(Array, Array) (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 181)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 76)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 53)
Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 28)
Drupal\Core\StackMiddleware\ContentLength->handle(Object, 1, 1) (Line: 32)
Drupal\big_pipe\StackMiddleware\ContentLength->handle(Object, 1, 1) (Line: 116)
Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 90)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 50)
Drupal\ban\BanMiddleware->handle(Object, 1, 1) (Line: 263)
Drupal\shield\ShieldMiddleware->bypass(Object, 1, 1) (Line: 219)
Drupal\shield\ShieldMiddleware->handle(Object, 1, 1) (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 36)
Drupal\Core\StackMiddleware\AjaxPageState->handle(Object, 1, 1) (Line: 51)
Drupal\Core\StackMiddleware\StackedHttpKernel->handle(Object, 1, 1) (Line: 741)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)

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.

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?

Ran into the same issue on Drupal 10.4. Following the suggestions in #5 fixed it for me. It would've been nice if the module itself fixed the issue.

Thanks, j_s. You are on Drupal 10.4 but I am on 10.5.1, which may make a difference or not. In any event, I can no longer even clear and re-analyze anything because when I do so I get the error that a database column cannot be found, and removing linkchecker as well as dynamic_entity_reference and then installing linkchecker 2.0.2, applying of course all the database upgrades for 2.0.2 simply does not help. I have tried several times meanwhile to upgrade copies of my functioning live site with 2.0.0 (with a deprecation notice, see at the bottom), removing DER, adding it in again, to no avail. Having beforehand cleared the site of the 2.0.0 module gives me an empty 2.0.2 linkchecker report to begin with, and trying to create a report through the maintenance functions results invariably in this error message:

Drupal\Core\Entity\EntityStorageException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_id__target_id' in 'NEW': INSERT INTO "linkchecker_link" ("status", "urlhash", "url", [... etc., longer quote above]

Should I take this to a separate bug report as the solution from #5 does not work and it seems database related?

For completeness' sake, here is also the deprecation notice from 2.0.0 which is still functional in the identical production environment. I get it when opening the configuration page, plus a few more when changing and saving the configuration. Maybe this sheds some light on what may be the problem with 2.0.2:

Deprecated function: Creation of dynamic property Drupal\linkchecker\Form\LinkCheckerAdminSettingsForm::$moduleHandler is deprecated in Drupal\linkchecker\Form\LinkCheckerAdminSettingsForm->__construct() (line 96 of modules/contrib/linkchecker/src/Form/LinkCheckerAdminSettingsForm.php).

Drupal\linkchecker\Form\LinkCheckerAdminSettingsForm->__construct() (Line: 104)
Drupal\linkchecker\Form\LinkCheckerAdminSettingsForm::create() (Line: 41)
Drupal\Core\DependencyInjection\ClassResolver->getInstanceFromDefinition() (Line: 48)
Drupal\Core\Controller\HtmlFormController->getFormObject() (Line: 58)
Drupal\Core\Controller\FormController->getContentResult()
call_user_func_array() (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 637)
Drupal\Core\Render\Renderer->executeInRenderContext() (Line: 121)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext() (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 181)
Symfony\Component\HttpKernel\HttpKernel->handleRaw() (Line: 76)
Symfony\Component\HttpKernel\HttpKernel->handle() (Line: 53)
Drupal\Core\StackMiddleware\Session->handle() (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle() (Line: 28)
Drupal\Core\StackMiddleware\ContentLength->handle() (Line: 32)
Drupal\big_pipe\StackMiddleware\ContentLength->handle() (Line: 116)
Drupal\page_cache\StackMiddleware\PageCache->pass() (Line: 90)
Drupal\page_cache\StackMiddleware\PageCache->handle() (Line: 50)
Drupal\ban\BanMiddleware->handle() (Line: 263)
Drupal\shield\ShieldMiddleware->bypass() (Line: 130)
Drupal\shield\ShieldMiddleware->handle() (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle() (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle() (Line: 36)
Drupal\Core\StackMiddleware\AjaxPageState->handle() (Line: 51)
Drupal\Core\StackMiddleware\StackedHttpKernel->handle() (Line: 741)
Drupal\Core\DrupalKernel->handle() (Line: 19)

Marking this as a duplicate of the documentation issue.

🐛 Removing DER as a dependency breaks websites Active

Hmm, ok sorry I mis-read the issue title, this isn't a duplicate.

@joseph.olstad - Thanks for trying to help. As the error changed with new 7 August DER 4.0-dev update I created https://www.drupal.org/project/dynamic_entity_reference/issues/3540397 🐛 Non-existent service "views.field_data_provider" on D10.5.1 Active - Meanwhile it seems to me the issue could be a DER problem limited to D10.5 and perhaps dot versions not much earlier, especially in the light of https://www.drupal.org/project/dynamic_entity_reference/issues/3056416 🐛 SQLSTATE[42S22]: Column not found: 1054 Unknown column *_target_id_int in on clause Fixed .

Update: On D10.5.2 I when clearing links and screening for broken links through the maintenance funktion in the get the messages

Links were successfully checked.
Links were not extracted.

Maybe this points in a helpful direction.