[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