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.
After saving a taxonomy/vocabulary term translation:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '101-0' for key 'PRIMARY': INSERT INTO {taxonomy_term_hierarchy} (tid, parent) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => 101 [:db_insert_placeholder_1] => 0 ) in taxonomy_term_save() (Zeile 601 von /var/www/drupal7/modules/taxonomy/taxonomy.module).
Posted first time in: #1070690: PDOException: SQLSTATE[42S22]: Column not found: [...] 'base.language' [...] !
Comments
Comment #1
Blooniverse CreditAttribution: Blooniverse commented... correcting the project settings!
Comment #2
Taxoman CreditAttribution: Taxoman commentedIs this still a problem after the fixes related to taxonomy in the latest dev version?
Comment #3
Blooniverse CreditAttribution: Blooniverse commented... I am going to check this asap.
Comment #4
Blooniverse CreditAttribution: Blooniverse commented... seems to work fine now in 'Internationalization 7.x1.x-dev (2011-Mar-22)'! Thank you very much.
Nonetheless, there is still an issue (just discovered) related to this module: When I delete all aliases via '/admin/config/search/path/delete_bulk' and bulk update all the aliases straight afterwards, all of the URL aliases of the translated terms disappear from e.g. '/taxonomy/term/foo_number/edit'! But this seems to be more an issue in/of #1073122: Make 'Taxonomy term paths' translatable -- and as such one of Pathauto!
Another error occurs when deleting a taxo term:
I am about to file a separate bug report about this for the Redirect module.
Comment #5
Blooniverse CreditAttribution: Blooniverse commented...
Comment #6
Blooniverse CreditAttribution: Blooniverse commented...
Comment #8
eloiguell CreditAttribution: eloiguell commentedHo he resolt canviant l'auto_increment a la taula taxonomy_term_data . Per algun motiu que desconec hi havia relacions de jerarquia que ja no existeixen amb id superiors a l'autoincrement. això provoca els duplicats. En el meu cas no té res a veure el mòdul Internationalization.
Espero que pugui ser d'ajuda a algú.
I've solved changing auto_increment in the table taxonomy_term_data. For some reason unknown to me there was no hierarchical relations that already exist with id over the AutoIncrement. this causes duplicates. In my case it has nothing to do Internationalization module.
I hope I can be of help to someone.