Whenever I try to delete a custom token, the site gets an error and the token is not deleted. I am unable to delete any custom tokens.
Log messages show the following:
-----------------------
Type token_custom
Location /admin/structure/token-custom/manage/post_limit_basic/delete?destination=%2Fadmin%2Fstructure%2Ftoken-custom
Message Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: 'post_limit_basic': DELETE FROM "votingapi_result" WHERE ("entity_type" = :db_condition_placeholder_0) AND ("entity_id" = :db_condition_placeholder_1); Array ( [:db_condition_placeholder_0] => token_custom [:db_condition_placeholder_1] => post_limit_basic ) in Drupal\votingapi\VoteStorage->deleteVotesForDeletedEntity() (line 89 of /var/www/html/website/web/modules/contrib/votingapi/src/VoteStorage.php).
Severity Error
-----------------------
Type php
Location /admin/structure/token-custom/manage/post_limit_basic/delete?destination=%2Fadmin%2Fstructure%2Ftoken-custom
Message Drupal\Core\Entity\EntityStorageException: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: 'post_limit_basic': DELETE FROM "votingapi_result" WHERE ("entity_type" = :db_condition_placeholder_0) AND ("entity_id" = :db_condition_placeholder_1); Array ( [:db_condition_placeholder_0] => token_custom [:db_condition_placeholder_1] => post_limit_basic ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->delete() (line 763 of /var/www/html/website/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
-----------------------
Active
Code
I was able to delete the custom tokens without any error. Can you provide the steps to reproduce the issue.
I had the same problem. I found a solution in the Voting API module https://www.drupal.org/project/votingapi/issues/3505963 🐛 Cannot delete entity with no voting Active .
Unfortunately the patch from that issue failed to apply on my website.