[Mapbender-users] error in sql statement pgsql_data.sql
Marec
marec at t-online.de
Thu Apr 17 12:24:31 EDT 2008
Hi list
I noticed another error in the installation of mapbender2.5rc1
if you want to fill your mapbender database with elements by using
"pgsql_data.sql".
You runs through an error
############################
############################
ERROR: duplicate key violates unique constraint "translations_pkey"
#############################
#############################
the reason for this is the new table translations!
In this sql statement the table is filled from line 8205
see here:
##############################
INSERT INTO translations (trs_id, locale, msgid, msgstr) VALUES (1,
'de', 'Pan', 'Ausschnitt verschieben');
INSERT INTO translations (trs_id, locale, msgid, msgstr) VALUES (2,
'de', 'Display complete map', 'gesamte Karte anzeigen');
INSERT INTO translations (trs_id, locale, msgid, msgstr) VALUES (3,
'de', 'Zoom in', 'In die Karte hineinzoomen');
.....
......
##############################
after this inserts, the same will execute from line 23011
##############################
INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Pan',
'Ausschnitt verschieben');
INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Display
complete map', 'gesamte Karte anzeigen');
INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Zoom
in', 'In die Karte hineinzoomen');
INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Zoom
out', 'Aus der Karte herauszoomen');
#############################
If you want to execute your sql correctly just edit this file and delete
the statements from line
8202-8255
and your sql will execute correctly
greetings Marc
More information about the Mapbender_users
mailing list