I have created a three language site, all seems to be working fine except when I wish to create a multi-lingual menu.

I first create the menu in english. Then I edit it and change it to Japanese, after which I change the Title to ブログ.

As soon as I submit, I get the following errors:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "localizertranslation_tid_seq" does not exist in /data/www/takemusukai.org/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT nextval('localizertranslation_tid_seq') in /data/www/takemusukai.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key violates unique constraint "localizertranslation_pkey" in /data/www/takemusukai.org/includes/database.pgsql.inc on line 125.
* user warning: query: INSERT INTO localizertranslation (tid, object_name, object_key, object_field, locale, translation) VALUES ('0', 'menu_item', '86', 'title', 'ja', 'ブログ') in /data/www/takemusukai.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "localizertranslation_tid_seq" does not exist in /data/www/takemusukai.org/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT nextval('localizertranslation_tid_seq') in /data/www/takemusukai.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key violates unique constraint "localizertranslation_pkey" in /data/www/takemusukai.org/includes/database.pgsql.inc on line 125.
* user warning: query: INSERT INTO localizertranslation (tid, object_name, object_key, object_field, locale, translation) VALUES ('0', 'menu_item', '86', 'description', 'ja', '') in /data/www/takemusukai.org/includes/database.pgsql.inc on line 144.

These errors seem to be consistent if I use Japanese or portugese and change the title.

I have installed and re-installed the module to make sure that I have done everything correctly.

Can send more logs or info as required.

Thanks

CommentFileSizeAuthor
#5 psql_sequence-5--1-10.patch446 bytesdeining
#2 error_1.txt8.57 KBdarianj

Comments

darianj’s picture

darianj commented

I have noticed this behavior in several places where localization is enabled.

I recently upgraded to the devel version of the localizer and that made no difference.

Thanks.

darianj’s picture

darianj commented
StatusFileSize
new error_1.txt8.57 KB

Ok, to do some more deubgging, I dropped the database and user, deleted entire drupal directory and re-installed:

Once drupal was up and running, put it into maintenance mode, untar localizer into sites/all/modules, untar flags into localizer, untar localizer-sites int sites all, as per instructions. (all latest download files today). Edited sites/default/settings.php (all as per instructions on web)

Next, enabled localizer and all modules, so far so good.
Then go to any maintenance menu, eg: user management>user settings
select english (it is the only one there currently) and click 'change', then press 'save configuration' and all the errors appear. (file enclosed)

Cant see what I am doing wrong here.. it is a clean install. Perhaps it is an issue with relation creation in postgres?

Any ideas appreciated.

Roberto Gerola’s picture

Roberto Gerola commented

> Perhaps it is an issue with relation creation in postgres?
Yes, of course.

I hadn't enough time to make extensive tests with postgres.

Create on your db a sequence with this name : localizertranslation_tid_seq

I leave this bug open so it will remind me to fix it.

Thanks.

rkofler’s picture

rkofler commented
Assigned: Unassigned » rkofler

thx, is was the missing sequence:

--> start psql and paste this sql in:

-- Sequence: localizertranslation_tid_seq
-- DROP SEQUENCE localizertranslation_tid_seq;
CREATE SEQUENCE localizertranslation_tid_seq
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 100000000
  START 1
  CACHE 1;

here some keyword for google (was not easy to find this link)
"drupal cannot change language menues"

deining’s picture

deining commented
Version: 5.x-1.9 » 5.x-1.x-dev
StatusFileSize
new psql_sequence-5--1-10.patch446 bytes

The attached fix cures that problem.