# i18n Editor freezes Developer **URL:** \ **Category:** Classic Servoy\ **Created:** [January 12, 2007, 9:39am UTC](https://forum.servoy.com/t/i18n-editor-freezes-developer/6954 "2007-01-12T09:39:40Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Karel\_Broer](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Karel\_Broer](https://forum.servoy.com/u/Karel_Broer)\ **Post date:** [January 12, 2007, 9:39am UTC](https://forum.servoy.com/t/i18n-editor-freezes-developer/6954/1 "2007-01-12T09:39:40Z")
When I search an i18n label in the i18n Editor with the Filter option, the Developer freezes for a while. Also selecting a local text from the valuelist in the i18n Editor seems to freeze the Developer for a while. Servoy Developer Version 3.1-build 404 Java version 1.5.0\_06-64 (Mac OS X) MySQL 5.0.27-standard It seems that something really heavy is done on the database, because during the freeze, MySQL uses 99% from the cpu processor… This is listed in the log: > 2007-01-09 21:39:07,712 ERROR [AWT-EventQueue-0] com.servoy.j2db.util.Debug - Throwable > com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry ‘4264’ for key 1 > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) > at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169) > at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693) > at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404) > at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318) > at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303) > at sun.reflect.GeneratedMethodAccessor239.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source) > at $Proxy1.executeUpdate(Unknown Source) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207) > at com.servoy.j2db.dataprocessing.SQLEngine.performUpdates(Unknown Source) > at com.servoy.j2db.property.h.a(Unknown Source) > at com.servoy.j2db.property.h.new(Unknown Source) > at com.servoy.j2db.property.a$2.stateChanged(Unknown Source) > at javax.swing.JTabbedPane.fireStateChanged(JTabbedPane.java:290) > at javax.swing.JTabbedPane$ModelListener.stateChanged(JTabbedPane.java:222) > at javax.swing.DefaultSingleSelectionModel.fireStateChanged(DefaultSingleSelectionModel.java:116) > at javax.swing.DefaultSingleSelectionModel.setSelectedIndex(DefaultSingleSelectionModel.java:50) > at javax.swing.JTabbedPane.setSelectedIndexImpl(JTabbedPane.java:478) > at javax.swing.JTabbedPane.setSelectedIndex(JTabbedPane.java:464) > at com.servoy.j2db.property.a.a(Unknown Source) > at com.servoy.j2db.property.TextEditor.prepareForVisible(Unknown Source) > at com.servoy.j2db.develop.property.h.actionPerformed(Unknown Source) > at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1882) > at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2202) > at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) > at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) > at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234) > at java.awt.Component.processMouseEvent(Component.java:5554) > at javax.swing.JComponent.processMouseEvent(JComponent.java:3126) > at java.awt.Component.processEvent(Component.java:5319) > at java.awt.Container.processEvent(Container.java:2010) > at java.awt.Component.dispatchEventImpl(Component.java:4021) > at java.awt.Container.dispatchEventImpl(Container.java:2068) > at java.awt.Component.dispatchEvent(Component.java:3869) > at javax.swing.plaf.basic.BasicTableUI$Handler.repostEvent(BasicTableUI.java:900) > at javax.swing.plaf.basic.BasicTableUI$Handler.mouseReleased(BasicTableUI.java:1020) > at javax.swing.plaf.basic.BasicTableUI$MouseInputHandler.mouseReleased(BasicTableUI.java:756) > at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:232) > at java.awt.Component.processMouseEvent(Component.java:5554) > at javax.swing.JComponent.processMouseEvent(JComponent.java:3126) > at java.awt.Component.processEvent(Component.java:5319) > at java.awt.Container.processEvent(Container.java:2010) > at java.awt.Component.dispatchEventImpl(Component.java:4021) > at java.awt.Container.dispatchEventImpl(Container.java:2068) > at java.awt.Component.dispatchEvent(Component.java:3869) > at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4256) > at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3936) > at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3866) > at java.awt.Container.dispatchEventImpl(Container.java:2054) > at java.awt.Window.dispatchEventImpl(Window.java:1774) > at java.awt.Component.dispatchEvent(Component.java:3869) > at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) > at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269) > at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190) > at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184) > at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176) > at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) ---
**Author:** ![Karel\_Broer](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Karel\_Broer](https://forum.servoy.com/u/Karel_Broer)\ **Post date:** [January 12, 2007, 9:44am UTC](https://forum.servoy.com/t/i18n-editor-freezes-developer/6954/2 "2007-01-12T09:44:25Z")
Something is going very wrong here… ![:cry:]( "Crying or Very sad") After a clean install from Servoy 3.1, my i18n labels don’t show anymore… although I have set my i18n solution settings to the right server and messages table. Anybody knows how to solve this issue asap? ---
**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\ **Post date:** [January 12, 2007, 10:02am UTC](https://forum.servoy.com/t/i18n-editor-freezes-developer/6954/3 "2007-01-12T10:02:00Z")
Karel, I don’t see this problem. how did you upgrade? update old repository? or imported your solution into a fresh install? are the messages there in the message table? did you export with i18n data? ---
**Author:** ![Karel\_Broer](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Karel\_Broer](https://forum.servoy.com/u/Karel_Broer)\ **Post date:** [January 12, 2007, 10:17am UTC](https://forum.servoy.com/t/i18n-editor-freezes-developer/6954/4 "2007-01-12T10:17:54Z")
> HJK: > how did you upgrade? Hi Harjo, I installed a clean install of Servoy 3.1 > update old repository or imported your solution into a fresh install? Updated repository from 3.0.1 > are the messages there in the message table? Yes > did you export with i18n data? i18n data is in messages tabel allready, so no export of i18n data would be nessecary, would it? I also don’t see my i18n records in the i18n Editor anymore… ---
**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\ **Post date:** [January 12, 2007, 6:04pm UTC](https://forum.servoy.com/t/i18n-editor-freezes-developer/6954/5 "2007-01-12T18:04:26Z")
and in your solution settings, do you see, there your message db & table? ---
**Author:** ![Karel\_Broer](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Karel\_Broer](https://forum.servoy.com/u/Karel_Broer)\ **Post date:** [April 6, 2007, 1:05pm UTC](https://forum.servoy.com/t/i18n-editor-freezes-developer/6954/6 "2007-04-06T13:05:43Z")
Finally discovered the solution for this issue: The messages table needed to be indexed. After I did that, the i18n Editor appeared at normal speed… ![:roll:]( "Rolling Eyes")