aspose file tools*
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

Win a copy of Java 8 in Action this week in the Java 8 forum!
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]
I agree. Here's the link:
subject: Create a new index from scratch with date
Similar Threads
localized message is ORA-00942: table or view does not exist
Hibernate Criterion query: org.hibernate.exception.SQLGrammarException: could not execute query
hibernate exception SQLGrammarException could not fetch initial value for increment
Weblogic 8.1 SP5 server got shutdown due to Connection leak and java.lang.OutofMemory
DB error in servlet while inserting data