[GeoNetwork-users] Geonetwork - bad script - create-db-postgis.sql

Hi folks,

I have the same problem like Alain (2011-02-23 16:23) or like Robert (2011-02-25 19:52):
Re: [GeoNetwork-users] gast: database setup: INSERT error

https://sourceforge.net/mailarchive/message.php?msg_id=27106327
https://sourceforge.net/mailarchive/message.php?msg_id=27118789

I proceeded exactly according to the instructions:
http://geonetwork-opensource.org/_static/foss4g2010/FOSS4G_Mastering_Advanced_GeoNetwork.pdf

The problem comes up on page 17 with the following script:
create-db-postgis.sql

Is there a new script that works?
Had anybody the same problem and could resolve it?
Can anybody help me with this problem?

I wish you a nice weekend.

Looking forward to a response from you

Regards Maik

E-Mail: maik.wannink@anonymised.com

Hi Maik

There was a bug in that script that was fixed after the GeoNetwork release.
You can download from
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.6.x/web/src/main/webapp/WEB-INF/classes/setup/sql/create/create-db-postgis.sql

or just replace in your script the actual table Languages definition by
this:

CREATE TABLE Languages
  (
    id varchar(5),
    name varchar(32) not null,
    isocode varchar(3) not null,

    primary key(id)
  );

Regards,
Jose García

On Fri, Mar 4, 2011 at 12:43 PM, Maik Wannink <
maik.wannink@anonymised.com> wrote:

Hi folks,

I have the same problem like Alain (2011-02-23 16:23) or like Robert
(2011-02-25 19:52):
Re: [GeoNetwork-users] gast: database setup: INSERT error

https://sourceforge.net/mailarchive/message.php?msg_id=27106327
https://sourceforge.net/mailarchive/message.php?msg_id=27118789

I proceeded exactly according to the instructions:

http://geonetwork-opensource.org/_static/foss4g2010/FOSS4G_Mastering_Advanced_GeoNetwork.pdf

The problem comes up on page 17 with the following script:
create-db-postgis.sql

Is there a new script that works?
Had anybody the same problem and could resolve it?
Can anybody help me with this problem?

I wish you a nice weekend.

Looking forward to a response from you

Regards Maik

E-Mail: maik.wannink@anonymised.com

------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

Hi

Also seem the field *isocode* ended by error in *settings* table in
that *create-db-postgis.sql
*script. You should remove that column from *settings* table.

Regards,
Jose García

On Fri, Mar 4, 2011 at 1:52 PM, jose garcia <josegar74@anonymised.com> wrote:

Hi Maik

There was a bug in that script that was fixed after the GeoNetwork release.
You can download from
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.6.x/web/src/main/webapp/WEB-INF/classes/setup/sql/create/create-db-postgis.sql

or just replace in your script the actual table Languages definition by
this:

CREATE TABLE Languages
  (
    id varchar(5),
    name varchar(32) not null,
    isocode varchar(3) not null,

    primary key(id)
  );

Regards,
Jose García

On Fri, Mar 4, 2011 at 12:43 PM, Maik Wannink <
maik.wannink@anonymised.com> wrote:

Hi folks,

I have the same problem like Alain (2011-02-23 16:23) or like Robert
(2011-02-25 19:52):
Re: [GeoNetwork-users] gast: database setup: INSERT error

https://sourceforge.net/mailarchive/message.php?msg_id=27106327
https://sourceforge.net/mailarchive/message.php?msg_id=27118789

I proceeded exactly according to the instructions:

http://geonetwork-opensource.org/_static/foss4g2010/FOSS4G_Mastering_Advanced_GeoNetwork.pdf

The problem comes up on page 17 with the following script:
create-db-postgis.sql

Is there a new script that works?
Had anybody the same problem and could resolve it?
Can anybody help me with this problem?

I wish you a nice weekend.

Looking forward to a response from you

Regards Maik

E-Mail: maik.wannink@anonymised.com

------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork