Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
The sql used in styles_update_7210() fails when using postgresql as the backend. Changing the "HAVING repetitions > 1" to "HAVING count(*) > 1" as below and might work for all backends
$names = db_query("SELECT name, COUNT(*) as repetitions FROM {styles} GROUP BY name HAVING count(*) > 1")->fetchCol();
Comment | File | Size | Author |
---|---|---|---|
#1 | styles-update-7210-with-postgresql-1024926-1.patch | 1.44 KB | aaron |
Comments
Comment #1
aaron CreditAttribution: aaron commentedThis one should work. I don't have pgSQL installed, so can't test it for certain.
Comment #2
aaron CreditAttribution: aaron commentedand committed. please re-open if this still fails for postgresql. thanks!