powered by Jive Software

Openfire gets error unknown column 'email' in 'where clause'

Dear all,

I configure database integration with external database. It works well, I can use spark to log in with username & password of external database. But when I search to add friends, there is no any records appearing. I only can add friends by correctly inserting their exact username.

I check the error log, and I found the error "unknown column ‘email’ in ‘where clause’. I paste here the log error message:

2013.04.17 13:56:05 org.jivesoftware.openfire.user.JDBCUserProvider -** Unknown column ‘email’ in ‘where clause’**

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column ‘email’ in ‘where clause’

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)

I can search username via Openfire Admin page.

Are there someone who encounter with this problem? Please advise me this case.