errors in upgrade sql script in trunk

[jeanpommier]

Some lang codes ('sp', 'po') are erroneous in the migrate-default.sql script. Another one is missing/removed. No data is inserted for the new ones (vie, nor, fin) I've fixed the erroneous and missing codes issues but not inserting data, in the attached file.

However, the upgraded database does not work :

ERROR [geonetwork.datamanager] - The metadata document index with id=134 is corrupt/invalid - ignoring it. Error: ERROR: current transaction is aborted, commands ignored until end of transaction block
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at jeeves.resources.dbms.Dbms.selectFull(Dbms.java:210)
	at jeeves.resources.dbms.Dbms.select(Dbms.java:181)
	at org.fao.geonet.kernel.XmlSerializer.internalSelect(XmlSerializer.java:92)
	at org.fao.geonet.kernel.XmlSerializerSvn.internalSelect(XmlSerializerSvn.java:72)
	at org.fao.geonet.kernel.XmlSerializerSvn.selectNoXLinkResolver(XmlSerializerSvn.java:107)
	at org.fao.geonet.kernel.DataManager.indexMetadata(DataManager.java:436)
	at org.fao.geonet.kernel.DataManager.indexMetadataGroup(DataManager.java:419)
	at org.fao.geonet.kernel.DataManager$IndexMetadataTask.run(DataManager.java:367)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
	at java.lang.Thread.run(Thread.java:722)

[ianwallen]

Language code errors and missing lang are fixed in commit 2a6c46c70d6c0981bb4cb78329197f81a1904c99

Still requires the fix for "No data is inserted for the new ones (vie, nor, fin)"

[ianwallen]

Fixed in commit 1d6fb9b4f8469539b5a6159b22b7e5c0a88d9a31 Performed a compare of a 2.6.4 db upgraded to 2.8 to a fresh install of 2.8 and they seem to now be the same.