Re: [GeoNetwork-users] Problem updating System configuration

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Yes..........  the databases was created since the version 2.4.2 or
previous...... I forgot this important information....

Sorry...

In any case, i resolved the problem regenerating all Setting table
with the sql inserts presents in the db-create script..... Geonetwork
works fine know.

Thank you for your help!!!!

2010/10/6 jose garcia <jos...@gm...>:
> Hi Francesco
>
> I think I get the problem. Probably your database was created with GN 2.4.2
> or previous (can you confirm?), then these settings specific from 2.4.3:
>
> INSERT INTO Settings VALUES (200,1,'clickablehyperlinks',NULL);
> INSERT INTO Settings VALUES (201,200,'enable','true');
>
> are not in the database (unless you migrated also the db from 2.4.X to 2.4.3
> using GAST).
>
> That explains also, i think, why the migration process was not executed
> automatically when GN 2.6.0 started the first time.
>
> The migration script doesn't contain these inserts as assumes a database
> created by GN 2.4.3. If you add the previous INSERTS should work ok.
>
> Regards,
> Jose García
>
> On Wed, Oct 6, 2010 at 5:59 PM, Francesco D'Amore <da...@ii...> wrote:
>
>> In the previous mail I don't attached any sql scrpt....sorry....
>>
>> This is the script used in order to migrate from the data model 2.4.3
>> to 2.6.0 in a Postgres database:
>>
>> ALTER TABLE Settings ALTER COLUMN value TYPE text;
>> ALTER TABLE Metadata ADD displayorder int;
>>
>> INSERT INTO Settings VALUES (90,1,'selectionmanager',NULL);
>> INSERT INTO Settings VALUES (91,90,'maxrecords','1000');
>> INSERT INTO Settings VALUES (210,1,'localrating',NULL);
>> INSERT INTO Settings VALUES (211,210,'enable','false');
>> INSERT INTO Settings VALUES (220,1,'downloadservice',NULL);
>> INSERT INTO Settings VALUES (221,220,'leave','false');
>> INSERT INTO Settings VALUES (222,220,'simple','true');
>> INSERT INTO Settings VALUES (223,220,'withdisclaimer','false');
>> INSERT INTO Settings VALUES (230,1,'xlinkResolver',NULL);
>> INSERT INTO Settings VALUES (231,230,'enable','false');
>> INSERT INTO Settings VALUES (600,1,'indexoptimizer',NULL);
>> INSERT INTO Settings VALUES (601,600,'enable','true');
>> INSERT INTO Settings VALUES (602,600,'at',NULL);
>> INSERT INTO Settings VALUES (603,602,'hour','0');
>> INSERT INTO Settings VALUES (604,602,'min','0');
>> INSERT INTO Settings VALUES (605,602,'sec','0');
>> INSERT INTO Settings VALUES (606,600,'interval',NULL);
>> INSERT INTO Settings VALUES (607,606,'day','0');
>> INSERT INTO Settings VALUES (608,606,'hour','24');
>> INSERT INTO Settings VALUES (609,606,'min','0');
>> INSERT INTO Settings VALUES (700,1,'oai',NULL);
>> INSERT INTO Settings VALUES (701,700,'mdmode',1);
>> INSERT INTO Settings VALUES (702,700,'tokentimeout',3600);
>> INSERT INTO Settings VALUES (703,700,'cachesize',60);
>> INSERT INTO Settings VALUES (720,1,'inspire',NULL);
>> INSERT INTO Settings VALUES (721,720,'enable','false');
>>
>> UPDATE Settings SET value='2.6.0' WHERE name='version';
>> UPDATE Settings SET value='0' WHERE name='subVersion';
>>
>>
>> Any error?????
>>
>> 2010/10/6 Francesco D'Amore <da...@ii...>:
>> > Hi All!!!
>> >
>> > In effect, I used the migration script in order to upgrade my old
>> > 2.4.3 data model to 2.6.0.
>> >
>> > I used the migration script attached on this mail. Garcia, there is
>> > some problem in this sql file????
>> >
>> > If yes, where can I download the right version???
>> >
>> > Thank you very much!!!!
>> >
>> > 2010/10/6  <jon...@wa...>:
>> >> It occurs to me that I've suddenly seen this issue posted at least three
>> >> times in the past couple of weeks (one of which was myself). I don't
>> >> recall having seen it before - has something been done in 2.6.0 that
>> would
>> >> cause this "corruption" of the database to happen more regularly? Note
>> >> that mine was for RC2.
>> >>
>> >> Jonathan Moules
>> >> GIS Developer.
>> >> Warwickshire Observatory,
>> >> Warwickshire County Council.
>> >> 01926 412358
>> >>
>> >>
>> >> This transmission is intended for the named addressee(s) only and may
>> contain sensitive or protectively marked material up to RESTRICTED and
>> should be handled accordingly. Unless you are the named addressee (or
>> authorised to receive it for the addressee) you may not copy or use it, or
>> disclose it to anyone else. If you have received this transmission in error
>> please notify the sender immediately. All email traffic sent to or from us,
>>  including without limitation all GCSX traffic, may be subject to recording
>> and/or monitoring in accordance with relevant legislation.
>> >>
>> ------------------------------------------------------------------------------
>> >> Beautiful is writing same markup. Internet Explorer 9 supports
>> >> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
>> >> Spend less time writing and  rewriting code and more time creating great
>> >> experiences on the web. Be a part of the beta today.
>> >> http://p.sf.net/sfu/beautyoftheweb
>> >> _______________________________________________
>> >> GeoNetwork-users mailing list
>> >> Geo...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> >> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>> >>
>> >
>> >
>> >
>> > --
>> > Ing. Francesco D'Amore
>> > blog: www.marinajonica.org
>> > linkedin: http://www.linkedin.com/in/francescodamore
>> > Consiglio Nazionale delle Ricerche - Istituto di Inquinamento Atmosferico
>> (IIA)
>> > Ph. D. Student at University of Calabria - DEIS
>> >
>>
>>
>>
>> --
>> Ing. Francesco D'Amore
>> blog: www.marinajonica.org
>> linkedin: http://www.linkedin.com/in/francescodamore
>> Consiglio Nazionale delle Ricerche - Istituto di Inquinamento Atmosferico
>> (IIA)
>> Ph. D. Student at University of Calabria - DEIS
>>
>>
>> ------------------------------------------------------------------------------
>> Beautiful is writing same markup. Internet Explorer 9 supports
>> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
>> Spend less time writing and  rewriting code and more time creating great
>> experiences on the web. Be a part of the beta today.
>> http://p.sf.net/sfu/beautyoftheweb
>> _______________________________________________
>> GeoNetwork-users mailing list
>> Geo...@li...
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
> ------------------------------------------------------------------------------
> Beautiful is writing same markup. Internet Explorer 9 supports
> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
> Spend less time writing and  rewriting code and more time creating great
> experiences on the web. Be a part of the beta today.
> http://p.sf.net/sfu/beautyoftheweb
> _______________________________________________
> GeoNetwork-users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
>

-- 
Ing. Francesco D'Amore
blog: www.marinajonica.org
linkedin: http://www.linkedin.com/in/francescodamore
Consiglio Nazionale delle Ricerche - Istituto di Inquinamento Atmosferico (IIA)
Ph. D. Student at University of Calabria - DEIS