I get this Exception during install of module translation skills on Postgres (clean install):

PDOException: SQLSTATE[42P07]: Duplicate table: 7 FEHLER: Relation »field_data_tmgmt_translation_skills_tmgmt_translation_skills_la« existiert bereits: CREATE INDEX "field_data_tmgmt_translation_skills_tmgmt_translation_skills_language_to_idx" ON {field_data_tmgmt_translation_skills} ("tmgmt_translation_skills_language_to"); Array ( ) in db_create_table() (line 2688 of W:\workspace\drupal7\includes\database\database.inc).

Translation: existiert bereits == allready exists

It seems that the index names are too long for postgres.
To install the module I disabled '$statements[] = $this->_createIndexSql($name, $key_name, $key); '. (just for testing purpose)

CommentFileSizeAuthor
#6 tmgmt-translation-skills-indexes-2.patch724 bytespropperdx
#4 tmgmt-translation-skills-indexes.patch827 bytespropperdx

Comments

berdir’s picture

berdir
Primary language German
Location Switzerland
commented

You could try to rename the index to remove the language_ prefix and try again. They're not needed anyway.

Still a bit fragile, but could work.

If not, then we have to short the field name.

propperdx’s picture

propperdx commented

I could try, if I would know how... I am really new on module developing on drupal...

berdir’s picture

berdir
Primary language German
Location Switzerland
commented 
    'indexes' => array(
      'language_from' => array('language_from'),
      'language_to' => array('language_to'),
      'language_combination' => array('language_from', 'language_to'),
    ),

Those are the index definitions.

I actually forgot to fix this, we just need the last one. So remove the from and to lines and shorten the last one to just language. That should fix your error.

propperdx’s picture

propperdx commented
StatusFileSize
new tmgmt-translation-skills-indexes.patch827 bytes

Ok that worked.

thank you!

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Active » Needs work

No need to comment it out, just remove that stuff. We can always get the old version back using git if we have to.

And make sure to set an issue to needs review if you upload patch.

propperdx’s picture

propperdx commented
Status: Needs work » Needs review
StatusFileSize
new tmgmt-translation-skills-indexes-2.patch724 bytes
berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Needs review » Fixed

Thanks, commited and pushed!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.