0018530: The image field on product window has an incorrect reference.

diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -130133,8 +130133,8 @@
 <!--800508-->  <HELP><![CDATA[Defines a system image]]></HELP>
 <!--800508-->  <COLUMNNAME><![CDATA[AD_Image_ID]]></COLUMNNAME>
 <!--800508-->  <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
-<!--800508-->  <AD_REFERENCE_ID><![CDATA[32]]></AD_REFERENCE_ID>
-<!--800508-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--800508-->  <AD_REFERENCE_ID><![CDATA[4AA6C3BE9D3B4D84A3B80489505A23E5]]></AD_REFERENCE_ID>
+<!--800508-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--800508-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--800508-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--800508-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
diff --git a/src-db/database/sourcedata/AD_FIELD.xml b/src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml
+++ b/src-db/database/sourcedata/AD_FIELD.xml
@@ -101151,7 +101151,7 @@
 <!--800724-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
 <!--800724-->  <AD_COLUMN_ID><![CDATA[800508]]></AD_COLUMN_ID>
 <!--800724-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--800724-->  <DISPLAYLENGTH><![CDATA[100]]></DISPLAYLENGTH>
+<!--800724-->  <DISPLAYLENGTH><![CDATA[20]]></DISPLAYLENGTH>
 <!--800724-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--800724-->  <SEQNO><![CDATA[390]]></SEQNO>
 <!--800724-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
diff --git a/src-util/modulescript/src/org/openbravo/modulescript/ConvertImages.java b/src-util/modulescript/src/org/openbravo/modulescript/ConvertImages.java
new file mode 100644
--- /dev/null
+++ b/src-util/modulescript/src/org/openbravo/modulescript/ConvertImages.java
@@ -0,0 +1,78 @@
+package org.openbravo.modulescript;
+
+import java.awt.image.BufferedImage;
+import java.io.ByteArrayInputStream;
+import javax.imageio.ImageIO;
+import java.io.File;
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Properties;
+
+import net.sourceforge.jnlp.util.PropertiesFile;
+
+import org.openbravo.modulescript.ModuleScript;
+import org.openbravo.database.ConnectionProvider;
+import java.io.FileInputStream;
+import java.util.Properties;
+
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+
+import javax.imageio.ImageIO;
+
+public class ConvertImages extends ModuleScript {
+
+  @Override
+  public void execute() {
+    try {  
+      String catalinabase=System.getenv("CATALINA_BASE");
+      if(catalinabase==null || catalinabase.equals("")){
+        return;
+      }
+      Properties properties = new Properties();
+      properties.load(new FileInputStream(getPropertiesFile()));
+      File imagesFolder=new File(catalinabase, "/webapps/"+properties.getProperty("context.name")+"/web/images/");
+      if(!imagesFolder.exists() || !imagesFolder.isDirectory()){
+        return;
+      }
+
+      ConnectionProvider cp = getConnectionProvider();
+      String sql="SELECT i.imageurl, i.ad_image_id from ad_image i, m_product p where ";
+      sql+=" i.ad_image_id=p.ad_image_id and binarydata is null order by i.ad_image_id ";
+      ResultSet rs=cp.getPreparedStatement(sql).executeQuery();
+      while(rs.next()){
+        String imageurl=rs.getString(1);
+        String imageid=rs.getString(2);
+        File imageFile=new File(imagesFolder, imageurl);
+        if(imageFile.exists()){
+          FileInputStream is = new FileInputStream(imageFile);
+          long length = imageFile.length();
+          byte[] bytes = new byte[(int)length];
+
+          int offset = 0;
+          int numRead = 0;
+          while (offset < bytes.length
+                 && (numRead=is.read(bytes, offset, bytes.length-offset)) >= 0) {
+              offset += numRead;
+          }
+          is.close();
+          ByteArrayInputStream bis = new ByteArrayInputStream(bytes);
+          BufferedImage rImage = ImageIO.read(bis);
+          String qupdate="UPDATE ad_image set binarydata=?, width=?, height=? where ad_image_id=?";
+          PreparedStatement ps=cp.getPreparedStatement(qupdate);
+          ps.setObject(1, bytes);
+          ps.setLong(2, rImage.getWidth());
+          ps.setLong(3, rImage.getHeight());
+          ps.setString(4, imageid);
+          ps.executeUpdate();
+          cp.releasePreparedStatement(ps);
+        }
+      }
+    } catch (Exception e) {
+      return;
+      //This modulescript can fail in different ways.
+      //However, the build should continue without problems
+    }
+    return;
+  }
+}
\ No newline at end of file