[Developers] keys in builder fields

Fri, 17 Nov 2006 00:45:41 -0800 

hi guys.
I just discovered a cool feature on the builder xml: you can say if an index should be made for a field. but it dous not seem to work well (with mysql). The index size is not given? Is there something i do wrong or so? 

this is my field declaration:

<field>
            <gui>
                <guiname xml:lang="nl">naam</guiname>
            </gui>
            <editor>
                <positions>
                    <input>1</input>
                    <list>1</list>
                    <search>1</search>
                </positions>
            </editor>
            <dt:datatype base="line"/>
            <db>
                <name>naam</name>

                <type key="true" notnull="true" size="300" 
state="persistent">STRING</type>

            </db>
        </field>

and the error:




22006-11-15 17:34:52,778 ERROR   mmbase.module.core.MMObjectBuilder - BLOB/TEXT 
column 'naam' used in key specification without a key length in query:ALTER 
TABLE mm_artikel ADD INDEX mm_artikel_main_idx 
(naam)org.mmbase.storage.StorageException: BLOB/TEXT column 'naam' used in key 
specification without a key length in query:ALTER TABLE mm_artikel ADD INDEX 
mm_artikel_main_idx (naam)
        at 
org.mmbase.storage.implementation.database.DatabaseStorageManager.createIndex(DatabaseStorageManager.java:2612)
        at 
org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:2579)
        at 
org.mmbase.storage.implementation.database.DatabaseStorageManager.createTable(DatabaseStorageManager.java:1945)
        at 
org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1846)

        at 
org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:562)
        at org.mmbase.module.core.MMObjectBuilder.init(MMObjectBuilder.java:446)
        at org.mmbase.module.core.MMBase.initBuilder(MMBase.java:991)
        at org.mmbase.module.core.MMBase.initBuilders(MMBase.java:968)
        at org.mmbase.module.core.MMBase.init(MMBase.java:373)
        at org.mmbase.module.Module.startModule(Module.java:125)
        at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:587)
        at org.mmbase.module.RemoteMMCI.getHost(RemoteMMCI.java:92)
        at org.mmbase.module.RemoteMMCI.init(RemoteMMCI.java:61)
        at org.mmbase.module.Module.startModule(Module.java:125)
        at org.mmbase.module.Module.startModules(Module.java:334)
        at org.mmbase.module.Module.getModule(Module.java:385)
        at org.mmbase.module.Module.getModule(Module.java:359)
        at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:583)

        at 
org.mmbase.servlet.MMBaseStartThread.run(MMBaseStartThread.java:40)java.sql.SQLException: 
BLOB/TEXT column 'naam' used in key specification without a key length

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
        at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1074)
        at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1008)

        at 
org.mmbase.module.database.MultiStatement.executeUpdate(MultiStatement.java:57)
        at 
org.mmbase.storage.implementation.database.DatabaseStorageManager.createIndex(DatabaseStorageManager.java:2606)
        at 
org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:2579)
        at 
org.mmbase.storage.implementation.database.DatabaseStorageManager.createTable(DatabaseStorageManager.java:1945)
        at 
org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1846)

        at 
org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:562)
        at org.mmbase.module.core.MMObjectBuilder.init(MMObjectBuilder.java:446)
        at org.mmbase.module.core.MMBase.initBuilder(MMBase.java:991)
        at org.mmbase.module.core.MMBase.initBuilders(MMBase.java:968)
        at org.mmbase.module.core.MMBase.init(MMBase.java:373)
        at org.mmbase.module.Module.startModule(Module.java:125)
        at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:587)
        at org.mmbase.module.RemoteMMCI.getHost(RemoteMMCI.java:92)
        at org.mmbase.module.RemoteMMCI.init(RemoteMMCI.java:61)
        at org.mmbase.module.Module.startModule(Module.java:125)
        at org.mmbase.module.Module.startModules(Module.java:334)
        at org.mmbase.module.Module.getModule(Module.java:385)
        at org.mmbase.module.Module.getModule(Module.java:359)
        at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:583)
        at org.mmbase.servlet.MMBaseStartThread.run(MMBaseStartThread.java:40)

2006-11-15 17:34:52,779 ERROR   mmbase.module.core.MMBase - Removed builder 
artikel from the builderlist, as it cannot be initialized.


regards,


--
Ernst Bunders,
Dynasol
tel 0629 131396
_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers






















					Reply via email to