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
Comment #1
manitoba22 CreditAttribution: manitoba22 commentedSeems to be a sequence issue: The procedure tries to insert "red ale" (as first term), before "ale" was created.
Comment #1.0
manitoba22 CreditAttribution: manitoba22 commentedlink formatting
Comment #2
mikeryanThe 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...
Comment #3
pifagor