Error migrating image gallery

[Marco Ferretti, geändert vor 12 Jahren.]

I am trying to migrate the image gallery from DatabaseHook ( Liferay 5.2.3 default ) to FileSystemHook (Liferay 6.0.6 default ) using Liferay 6.0.6's control panel ... but I get an exception :

14:37:51,591 DEBUG [MaintenanceUtil:64] Please set image.hook.impl in your portal-ext.properties to use com.liferay.portal.image.FileSystemHook
14:37:51,660 FATAL [ConvertProcessMessageListener:35] Unable to process message {destinationName=liferay/convert_process, responseDestinationName=null, responseId=null, payload=com.liferay.portal.convert.ConvertImageGallery, values=null}
com.liferay.portal.convert.ConvertException: org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """"
  Position: 26
	at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:53)
	at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:47)
	at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:32)
	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
	at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:56)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """"
  Position: 26
	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:353)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:299)
	at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:224)
	at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:224)
	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:231)
	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:198)
	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:185)
	at com.liferay.portal.convert.ConvertImageGallery.doConvert(ConvertImageGallery.java:102)
	at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44)
	... 7 more

Here's the PostgreSQL log :

ERROR:  zero-length delimited identifier at or near """" at character 26
STATEMENT:  update Image set text_ = ""

I believe it should be

update Image set text_ = ''

Any hint as of where I could find the piece of code and eventually change it ?


TIA

Marco

[Marco Ferretti, geändert vor 12 Jahren.]

Looks like it was fixed in LF 6.1 ( http://issues.liferay.com/browse/LPS-12110 )

Where do I find more infos about that correction so that I can try to fix my instance (6.0.6 ) ?



TIA


Marco

[Darko Joseph Hojnik, geändert vor 12 Jahren.]

It's not fixed. Still here with 6.1.1

cheers Darko

[Hitoshi Ozawa, geändert vor 12 Jahren.]

If images aren't used in the pages, it's probably easier to just use WebDAV to download and upload images again.

[Marco Ferretti, geändert vor 11 Jahren.]

I thought about that but ... that wouldn't be the most common case .