Blobs on disk conversion

[André van Toly]

I've just changed the configuration of a MMBase 1.8.7 installation's MySQL database from 'mysql-latin1' to 'mysql-binaryasfile'. I hit the button 'convert' in the Admin / Tools / Blobs section and it seems that a lot of blobs are moved correctly from the database to disk since I can see directory for images and icaches in the data directory I configured.

But: a lot of images for example are missing. It seems that only the first few thousand have been converted to disk and the rest is lacking.

Besides that I am not longer able to upload any new images. I get: "MMBase - Error 500 Field 'handle' doesn't have a default value" (more stacktrace below).

Anyone have any experience with this?

---Cheers, André

org.mmbase.storage.StorageException:

Field 'handle' doesn't have a default value java.sql.SQLException: Field 'handle' doesn't have a default value at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949) at org.mmbase.storage.implementation.database.DatabaseStorageManager.executeUpdate(DatabaseStorageManager.java:1033) at org.mmbase.storage.implementation.database.DatabaseStorageManager.executeUpdateCheckConnection(DatabaseStorageManager.java:1009) at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:947) at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:911) at org.mmbase.storage.implementation.database.RelationalDatabaseStorageManager.create(RelationalDatabaseStorageManager.java:58) at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:884) at org.mmbase.module.core.MMObjectBuilder.insert(MMObjectBuilder.java:636) at org.mmbase.module.builders.AbstractServletBuilder.insert(AbstractServletBuilder.java:256) at org.mmbase.module.core.MMObjectNode.insert(MMObjectNode.java:282) at org.mmbase.module.core.MMObjectBuilder.safeInsert(MMObjectBuilder.java:1073) at org.mmbase.module.core.MMObjectNode.insert(MMObjectNode.java:299) at org.mmbase.bridge.implementation.BasicNode.commit(BasicNode.java:519) at org.mmbase.bridge.util.NodeWrapper.commit(NodeWrapper.java:79) at org.mmbase.bridge.jsp.taglib.NodeProviderHelper.doAfterBody(NodeProviderHelper.java:194) at org.mmbase.bridge.jsp.taglib.AbstractNodeProviderTag.doAfterBody(AbstractNodeProviderTag.java:95) at org.mmbase.bridge.jsp.taglib.NodeTag.doEndTag(NodeTag.java:244) at org.apache.jsp.mmbase.edit.my_005feditors.new_005fobject_jsp._jspx_meth_mm_005fcreatenode_005f0(new_005fobject_jsp.java:2517) at org.apache.jsp.mmbase.edit.my_005feditors.new_005fobject_jsp._jspx_meth_mm_005fpresent_005f4(new_005fobject_jsp.java:2439) at org.apache.jsp.mmbase.edit.my_005feditors.new_005fobject_jsp._jspService(new_005fobject_jsp.java:457) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at

--
André van Toly
web http://www.toly.nl mobile +31(0)627233562
irc irc://irc.slashnet.org/#mmbase
twitter twitter://twitter.com/#!/elfuego2
----------------------------------------------------------------~~<<>>~~

[André van Toly]

Answering my own question:

mysql> describe install_images;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| number | int(11) | NO | PRI | NULL | |
| otype | int(11) | NO | MUL | NULL | |
| owner | varchar(64) | NO | | NULL | |
| title | varchar(255) | YES | | NULL | |
| description | text | YES | | NULL | |
| handle | mediumblob | YES | | NULL | |

The field handle should be able to contain null values for creation of new images, since the binary contents of the handle field are now saved on disk.

---André

> --
> You received this message because you are subscribed to the Google Groups "mmbase-discuss" group.
> To post to this group, send email to mmbase-...@googlegroups.com.
> To unsubscribe from this group, send email to mmbase-discus...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/mmbase-discuss?hl=en.