Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I have migrated the instance from a MySQL 5.5 DB to Postgres 9.3. When uploading an image with the Drag & Drop Upload interface, the metatag module drops the following error:
PDOException: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block: SELECT language, '' FROM {metatag} WHERE (entity_type = :type) AND (entity_id = :id) AND (revision_id = :revision); Array ( [:type] => file [:id] => 206 [:revision] => 0 ) in metatag_metatags_save() (line 518 of <drupal-instance>/profiles/openoutreach/modules/contrib/metatag/metatag.module)
It does not occur when using the standard file upload process, neither does it occur when using MySQL. I have tried installing the dev version of the module but the error persists.
| Comment | File | Size | Author |
|---|---|---|---|
| #8 | metatag-n2455777-8.patch | 2.47 KB | damienmckenna |
Comments
Comment #1
damienmckennaIf you don't specifically need meta tags on File pages, you might try disabling files on the advanced settings page (admin/config/search/metatags/settings).
What module provides the drag 'n drop UI?
Comment #2
schoash commentedI am getting the same error for the image field type. Also using postgres 9.3
Comment #3
damienmckennaDoes this fix the problem?
Comment #5
damienmckennaCan someone please test the patch above? Thanks.
Comment #6
damienmckennaLets expand this to skip saving meta tags for entities that don't support it.
Comment #8
damienmckennaForgot to load the $entity first. Doh.
Comment #9
damienmckennaCommitted.