When importing the fr.po file to French language (using a Postgresql database) i get a lot of errors, the translation works finally but some parts aren't translated:

warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key violates unique constraint "locales_target_lid_key" in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: INSERT INTO locales_target (lid, locale) VALUES (867,'fr') in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key violates unique constraint "locales_target_lid_key" in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: INSERT INTO locales_target (lid, locale) VALUES (1014,'fr') in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' includes/common.inc:225 modules/aggregator.module:144 ;160, modules/blogapi.module:156 ;218 modules/book.module:688, modules/comment.module:140 ;544;647 modules/legacy.module:45 ;51;57' WHERE source = 'view' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' includes/locale.inc:43 modules/block.module:186 modules/comment.module:318, modules/drupal.module:46 modules/filter.module:424 modules/queue.module:28' WHERE source = 'Enabled' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' includes/locale.inc:43 ;1046 modules/aggregator.module:705 ;716, modules/block.module:190 modules/book.module:712 ;760, modules/comment.module:1016 ;1154;1208 modules/filter.module:281' WHERE source = 'Operations' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' includes/locale.inc:58 ;1055 modules/block.module:197, modules/book.module:688 modules/comment.module:684 ;1033, modules/locale.module:87 modules/menu.module:379 ;435' WHERE source = 'delete' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' includes/locale.inc:62 modules/filter.module:436 ;505, modules/locale.module:264 modules/system.module:510 ;534;552;578;588;713' WHERE source = 'Save configuration' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' includes/locale.inc:1055 modules/aggregator.module:708 ;719, modules/book.module:688 modules/comment.module:685 ;690;1032;1157;1211' WHERE source = 'edit' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' includes/locale.inc:1092 modules/locale.module:441 modules/node.module:1108, modules/search.module:83 ;668 modules/user.module:1682' WHERE source = 'Search' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' includes/theme.inc:915 modules/filter.module:404 modules/forum.module:139, modules/locale.module:328 modules/node.module:796 ;1613' WHERE source = 'Cancel' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' modules/aggregator.module:121 modules/block.module:60, modules/comment.module:98 modules/filter.module:227, modules/forum.module:421 modules/locale.module:66 modules/menu.module:36' WHERE source = 'list' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' modules/aggregator.module:149 ;165 modules/block.module:212, modules/comment.module:100 modules/filter.module:233 ;296, modules/forum.module:430 modules/node.module:664 ;978' WHERE source = 'configure' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' modules/aggregator.module:599 ;632;705;716 modules/book.module:712 ;760, modules/filter.module:100 modules/menu.module:272 modules/node.module:929' WHERE source = 'Title' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' modules/aggregator.module:600 modules/filter.module:424, modules/forum.module:151 ;173 modules/menu.module:281, modules/system.module:469 modules/taxonomy.module:102 ;192' WHERE source = 'Description' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

user error:
query: UPDATE locales_source SET location = ' modules/aggregator.module:601 ;649;728;781;811 modules/comment.module:918, ;947 modules/forum.module:96 ;157;179 modules/menu.module:140 ;235;307' WHERE source = 'Submit' in /home/httpd/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /home/httpd/html/drupal/includes/database.pgsql.inc on line 45.

Comments

igrcic’s picture

igrcic CreditAttribution: igrcic commented

I am getting same errors! I guess its because of not so good PostgreSQL support in drupal :(

igrcic’s picture

igrcic CreditAttribution: igrcic commented

I edited locale_target table and remove unique constraint on lid column. For now, everything is working

alkahan’s picture

alkahan CreditAttribution: alkahan commented
ggamba’s picture

ggamba CreditAttribution: ggamba commented

Hello,

I'm getting the very same error with 4.6.2! Is editing locale_target table a safe way to solve the problem?

best wishes
Gabriele