Oracle - invalid column name

[Migrated From Jforum.net]

Hi,

i'm trying to start JForum 2.1.4 using BEA and Oracle9. I took the oracle files (config/database/oracle/*) from cvs - the versions with tag V_2_1_4.

Now i get the following exception when trying to start JForum:

Root cause of ServletException.net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: java.sql.SQLException: ORA-00904: invalid column name

at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:102)
at net.jforum.JForum.init(JForum.java:112)
....

There is no further information in the log file about the invalid column (or table). I already checked the db structure comparing mysql_db_struct.sql and oracle_db_struct.sql. The column names are nearly all the same - differences are considered in the statements in oracle.sql

Has anybody an idea how to solve the problem?

Is there a possibility to get more logging information? I already used 'priority value="debug"' in log4j.xml

Thanks,
Irving

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

ok, problem is solved:

- jforum_categories: column moderated was missing
- jforum_karma: column rate_date was missing

Irving
[originally posted on jforum.net by Anonymous]