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.
There is nothing abnormal about the taxonomies in either d6 or d7. There are no nested vocabularies.
$drush mi --group=taxonomy
Migration failed with source plugin exception: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column [error]
'drupal6_db.th.parent' which is not in SELECT list; this is incompatible with DISTINCT, in
class="placeholder">/Library/WebServer/Documents/drupal6_site/includes/database/database.inc:2171
Fixed by removing line 31 "->orderBy('th.parent')" in migrate_d2d/d6/taxonomy.inc
protected function query() {
// Note the explode - this supports the (admittedly unusual) case of
// consolidating multiple vocabularies into one.
$query = Database::getConnection('default', $this->sourceConnection)
->select('term_data', 'td')
->fields('td', array('tid', 'name', 'description', 'weight'))
->condition('vid', explode(',', $this->sourceVocabulary), 'IN')
// ->orderBy('th.parent')
->distinct();
// Join to the hierarchy so we can sort on parent, but we'll pull the
// actual parent values in separately in case there are multiples.
$query->leftJoin('term_hierarchy', 'th', 'td.tid=th.tid');
return $query;
}
Comments
Comment #2
jayemel CreditAttribution: jayemel commentedThis is related to MySQL 5.7 and was fixed in 7.42
https://www.drupal.org/node/2545480