After upgrading simple sitemap, the module breaks

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2: SELECT base_table.revision_id AS revision_id, base_table.id AS id
FROM
{block_content} base_table
INNER JOIN {block_content_field_data} block_content_field_data ON block_content_field_data.id = base_table.id
WHERE (block_content_field_data.type = :db_condition_placeholder_0) AND (); Array
(
[:db_condition_placeholder_0] => basic
)
in Drupal\micro_simple_sitemap\Plugin\simple_sitemap\UrlGenerator\MicroSiteEntityUrlGenerator->getDataSets() (line 155 of modules/contrib/micro_simple_sitemap/src/Plugin/simple_sitemap/UrlGenerator/MicroSiteEntityUrlGenerator.php). Drupal\Core\Database\Statement->execute(Array, Array) (Line: 631)

Comments

flocondetoile created an issue. See original summary.

  • flocondetoile committed 8669b5a on 8.x-3.x
    Issue #3063100 by flocondetoile: Compatible with simple sitemap 8.x-3.2
    
flocondetoile’s picture

Status: Active » Fixed

This fix the SQL error about block_content. Needs more investigations.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.