After applying patch #2120973-1: beer example not working with postgres: cross table join, users can be imported, but the 'red ale' example term fails. Messages are:

Undefined offset: 0 File /opt/devcms/sites/all/modules/migrate/plugins/destinations/term.inc, line 202(file: /opt/devcms/sites/all/modules/migrate/plugins/destinations/term.inc, line 202)
red ale Error SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "parent" violates not-null constraint: INSERT INTO taxonomy_term_hierarchy (tid, parent) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( ) (/opt/devcms/modules/taxonomy/taxonomy.module:679)

Comments

manitoba22’s picture

Seems to be a sequence issue: The procedure tries to insert "red ale" (as first term), before "ale" was created.

manitoba22’s picture

Issue summary:View changes

link formatting

mikeryan’s picture

Issue summary:View changes
Status:Active» Postponed (maintainer needs more info)

The query on the migrate_example_beer_topic table is ordered by style_parent - on MySQL, NULLs come first when sorting, does PostgreSQL put them last? Yes, apparently it does by default. Not sure what a portable solution would be here...