#5 Occasional SQL syntax error when posting a reply

[Numiton]

The error is not visible to the user.

The stack trace indicates that this happens when word_id_sql is empty in
functions_search.remove_search_post:394

Stack trace:
WARN com.numiton.db.DBUtils.executeQuery(DBUtils.java:358) Error with query:
SELECT word_id
FROM phpbb_search_wordmatch
WHERE word_id IN ()
GROUP BY word_id
HAVING COUNT(word_id) = 1
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your
SQL syntax; check the manual that corresp
onds to your MySQL server version for the right syntax to use near ')
GROUP BY word_id
HAVING COUNT(word_id) = 1' at line 3
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3172)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1197)
at com.numiton.db.DBUtils.executeQuery(DBUtils.java:348)
at com.numiton.db.MySQL.mysql_query(MySQL.java:156)
at example.db.sql_dbMysql4.sql_query(sql_dbMysql4.java:135)
at example.db.sql_dbMysql4.sql_query(sql_dbMysql4.java:108)
at
example.includes.functions_search.remove_search_post(functions_search.java:394)
at example.includes.functions_post.submit_post(functions_post.java:267)
at example.posting.generateContent(posting.java:762)
at example.NumitonServlet.doPost(NumitonServlet.java:78)

[Numiton]

Logged In: YES
user_id=1969110
Originator: YES

This looks like a bug brought from phpBB itself by the migration process.

[Numiton]

Logged In: YES
user_id=1969110
Originator: YES

If this wasn't a problem in phpBB, we won't deal with it for now.