#34 Click on customer button does nothing (pre)

[Anonymous]

The following exception is raised when the customer
button is clicked upon.

12/02/2005 00:00:44 org.opencrm.MainCTRL logException
SEVERE: Error
java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation 'concat'
at com.mysql.jdbc.MysqlIO.checkErrorPacket
(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand
(MysqlIO.java:1534)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect
(MysqlIO.java:1625)
at com.mysql.jdbc.Connection.execSQL
(Connection.java:2291)
at com.mysql.jdbc.Connection.execSQL
(Connection.java:2226)
at com.mysql.jdbc.Statement.executeQuery
(Statement.java:1159)
at org.opencrm.mysql.executeSQL
(mysql.java:77)
at
org.opencrm.gui.customer.CustomerCTRL.buildHistory
(CustomerCTRL.java:475)
at
org.opencrm.gui.customer.CustomerCTRL.synchronizeMod
elToGui(CustomerCTRL.java:436)
at
org.opencrm.gui.customer.CustomerCTRL.showGUI
(CustomerCTRL.java:108)
at org.opencrm.Global.newCustomer
(Global.java:736)
at
org.opencrm.MainWindow.btnCustomerMousePressed
(MainWindow.java:870)
at
org.opencrm.MainWindow$13.actionPerformed
(MainWindow.java:296)
at
javax.swing.AbstractButton.fireActionPerformed
(AbstractButton.java:1849)
at
javax.swing.AbstractButton$Handler.actionPerformed
(AbstractButton.java:2169)
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.AWTEventMulticaster.mouseReleased
(AWTEventMulticaster.java:231)
at java.awt.Component.processMouseEvent
(Component.java:5488)
at javax.swing.JComponent.processMouseEvent
(JComponent.java:3093)
at java.awt.Component.processEvent
(Component.java:5253)
at java.awt.Container.processEvent
(Container.java:1966)
at java.awt.Component.dispatchEventImpl
(Component.java:3955)
at java.awt.Container.dispatchEventImpl
(Container.java:2024)
at java.awt.Component.dispatchEvent
(Component.java:3803)
at
java.awt.LightweightDispatcher.retargetMouseEvent
(Container.java:4212)
at
java.awt.LightweightDispatcher.processMouseEvent
(Container.java:3892)
at
java.awt.LightweightDispatcher.dispatchEvent
(Container.java:3822)
at java.awt.Container.dispatchEventImpl
(Container.java:2010)
at java.awt.Window.dispatchEventImpl
(Window.java:1766)
at java.awt.Component.dispatchEvent
(Component.java:3803)
at java.awt.EventQueue.dispatchEvent
(EventQueue.java:463)
at
java.awt.EventDispatchThread.pumpOneEventForHierarch
y(EventDispatchThread.java:234)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run
(EventDispatchThread.java:110)

[ErtanO]

Logged In: YES
user_id=692543

Make sure that you have at least mysql 4.1 and that your
database encoding is the same as what you have selected for
OpenCRM (you can find this under settings)