[Mapbender-users] error in sql statement pgsql_data.sql

[Christoph Baudson]

Thanks Marec, I have removed the lines from the dump.

The new file is in the SVN and will be part of rc2.

https://svn.osgeo.org/mapbender/branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql

--------------

Die korrigierte Datei wurde eingecheckt und wird Teil von rc2 sein.

https://svn.osgeo.org/mapbender/branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql

Christoph

Marec schrieb:
> 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
>
>
>
>
>
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_users


-- 
_______________________________________

W h e r e G r o u p GmbH & Co. KG

Siemensstraße 8
53121 Bonn
Germany

Christoph Baudson
Anwendungsentwickler

Fon: +49 (0)228 / 90 90 38 - 15
Fax: +49 (0)228 / 90 90 38 - 11
christoph.baudson at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
_______________________________________

Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
_______________________________________