my dog learned polymorphism*
The moose likes JForum and the fly likes Create a new index from scratch with date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Create a new index from scratch with date" Watch "Create a new index from scratch with date" New topic

Create a new index from scratch with date

Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424

I tried to reindex everything using the recreate index from scratch and using the by date option and I keep getting this error on my console:

Exception in thread "Thread-19" net.jforum.exceptions.DatabaseException: java.sql.SQLException: ORA-00933: SQL com
mand not properly ended

at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(
at net.jforum.dao.generic.GenericLuceneDAO.getPostIdByDate(
at net.jforum.dao.generic.GenericLuceneDAO.firstPostIdByDate(
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

... 18 more

Does anyone knows how to fix this?
[originally posted on by nadjim]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
For oracle you need to modify Oracle.sql adding this code in the SearchModel section:

in the default sql file that query is for MySQL.

[originally posted on by radar]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
nadjim wrote:Hi,

I tried to reindex everything

Just upgraded from 2.1.6 to 2.1.8, and forum search works only for newly-created topics.

Does anyone know how to make jForum search in older topics too?


upd: figured out, it's under "Lucene index" in admin panel.
[originally posted on by n0mer]
jQuery in Action, 2nd edition
subject: Create a new index from scratch with date
Similar Threads
Weblogic 8.1 SP5 server got shutdown due to Connection leak and java.lang.OutofMemory
Hibernate Criterion query: org.hibernate.exception.SQLGrammarException: could not execute query
hibernate exception SQLGrammarException could not fetch initial value for increment
localized message is ORA-00942: table or view does not exist
DB error in servlet while inserting data