Contrib.social

Term Node query Integrity constraint violation

Open on Drupal.org →
Created on 24 July 2018, over 6 years ago
Updated 23 May 2023, over 1 year ago

Problem:
The problem is that there is no alias on the map table.
When you are trying update (add join) to base taxonomy term migration happens:

Migration failed with source plugin exception: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'tid' in on clause is ambiguous: SELECT DISTINCT td.*, map.sourceid1 AS    [error]
migrate_map_sourceid1, map.source_row_status AS migrate_map_source_row_status
FROM
{term_data} td
INNER JOIN {term_node} tn ON td.tid = tn.tid
INNER JOIN {node} n ON tn.nid = n.nid AND tn.vid = n.vid
LEFT OUTER JOIN ifaw_d8.migrate_map_ifaw_term_animal_base map ON tid = map.sourceid1

Solution is to use alias.

🐛 Bug report
Status

Closed: cannot reproduce

Version

11.0 🔥

Component
Migration  →

Last updated about 23 hours ago

Created by

🇧🇾Belarus chilic

Live updates comments and jobs are added and updated live.
  • Needs tests

    The change is currently missing an automated test that fails when run with the original code, and succeeds when the bug has been fixed.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment over 1 year ago →
    🇺🇸United States Kristen Pol Santa Cruz, CA, USA

    As part of the Bug Smash Initiative, we are triaging issues that are marked "Postponed (maintainer needs more info)". This issue was marked "Postponed (maintainer needs more info)" more than two years ago.

    Since there was no additional information provided since it was requested last year, I'm marking the issue "Closed (cannot reproduce)". If anyone can provide the additional required, update the issue summary and set the issue status back to "Active" [or "Needs Work" if it has a patch, etc.].

    Thanks!

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024