Can't see any topics

[Migrated From Jforum.net]

I've installed JForum from CVS and I can access the main page with no problems. But wherever I try to access any page that lists topics (forums or recent topics), I get the following exception:

java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at net.jforum.Command.process(Unknown Source)
	at net.jforum.JForum.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NoClassDefFoundError
	at net.jforum.view.forum.common.TopicsCommon.topicsByForum(Unknown Source)
	at net.jforum.view.forum.ForumAction.show(Unknown Source)
	... 21 more

I'm using Java 5 with Tomcat 5.5. Also, I have the lastest JForum realese version (2.0.2) installed in the same environment and it works ok.

May be I forget to do something in the installation?
[originally posted on jforum.net by gangrel-br]

[Migrated From Jforum.net]

I didn't get any exception. But I can't see any category and forums.
Rafael told me to re-save all group permissions.

I don't know how to do this. Since no category and forum is listed in admin panel either.

The version 2.0.2 works fine on my site, too. I use a PostgreSQL database. I guess it must be some permission problem of CVS version.
[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

I too use PostgreSQL.

For re-saving the permissions, click on Groups, then on Permissions and Save for each group. Now you should see the forums and categories. And I think you will end up with the same error as mine above.
[originally posted on jforum.net by gangrel-br]

[Migrated From Jforum.net]

Thank you...I did and I got the same problem with now.

The exception has some information:

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "points"

        at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
        at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
        at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
        at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
        at net.jforum.drivers.generic.KarmaModel.getPostKarma(Unknown Source)
        at net.jforum.drivers.generic.PostModel.makePost(Unknown Source)
        at net.jforum.drivers.postgresql.PostModel.selectAllByTopicByLimit(Unknown Source)
        at net.jforum.view.forum.common.PostCommon.topicPosts(Unknown Source)
        at net.jforum.view.forum.PostAction.list(Unknown Source)
        ... 23 more

maybe you can check the SQL for where "points" show up.
[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

Hum... I'm not sure if it is the same problem, where does this PSQLException came from? My CausedBy is a NoClassDefFoundError, not a PSQLException, unless I'm missing something here ops:
[originally posted on jforum.net by gangrel-br]

[Migrated From Jforum.net]

OK, I fix it up now.
PostgreSQL cannot accept this kind of SQL:

select 1 points ...

it should be written as

select 1 as points

I've told Rafale to change '' group_icon before.
In this question, just find the SQL in generic_query.sql and find points
that need changes.
[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

Maybe you can fix the generic_query.sql first.
After you put back it, you'd better upload postgresql.sql again.
Or some common query will be overriden by generic_query.sql
[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

I'm not sure if I'm understanding what you're saying... ops:

Are you saying that this line:

AttachmentModel.selectExtensions =
SELECT extension_id, extension_group_id, extension, description, upload_icon, allow, '' group_icon
FROM jforum_extensions ORDER BY extension

Should be:

AttachmentModel.selectExtensions =
SELECT extension_id, extension_group_id, extension, description, upload_icon, allow, group_icon
FROM jforum_extensions ORDER BY extension

:?:
[originally posted on jforum.net by gangrel-br]

[Migrated From Jforum.net]

gangrel-br wrote:I'm not sure if I'm understanding what you're saying... ops:

Are you saying that this line:

AttachmentModel.selectExtensions =
SELECT extension_id, extension_group_id, extension, description, upload_icon, allow, '' group_icon
FROM jforum_extensions ORDER BY extension

Should be:

AttachmentModel.selectExtensions =
SELECT extension_id, extension_group_id, extension, description, upload_icon, allow, group_icon
FROM jforum_extensions ORDER BY extension

:?:

NO.
I mean, it should be

AttachmentModel.selectExtensions =
SELECT extension_id, extension_group_id, extension, description, upload_icon, allow, '' as group_icon
FROM jforum_extensions ORDER BY extension

And I mean the following SQL statement related to "points":

KarmaModel.getPostKarma = SELECT SUM(points) / COUNT(post_id) points FROM jforum_karma WHERE post_id = ?

should be

KarmaModel.getPostKarma = SELECT SUM(points) / COUNT(post_id) as points FROM jforum_karma WHERE post_id = ?

and

KarmaModel.getUserKarmaPoints = SELECT SUM(points) points, COUNT(1) votes, from_user_id \
	FROM jforum_karma WHERE post_user_id = ? GROUP BY from_user_id

should be

KarmaModel.getUserKarmaPoints = SELECT SUM(points) as points, COUNT(1) as votes, from_user_id \
	FROM jforum_karma WHERE post_user_id = ? GROUP BY from_user_id

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Well, I missunderstood the alias thing... ops: thanks!

But I keep getting to exact same error I posted in this topic's first message. It appears that I get some other problem that happen before the PSQLException can happen.
[originally posted on jforum.net by gangrel-br]

[Migrated From Jforum.net]

mm...Have you tried restart Tomcat or reload the webapp?
And download the latest CVS also.

I have no problem on CVS now.
My environment is quite similar to you.
Java 5 +Tomcat 5.5.4 + PostgreSQL 7.4

The are some fixes I made for PostgreSQL. If you like, I can share it with you.

[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

andowson wrote:mm...Have you tried restart Tomcat or reload the webapp?
And download the latest CVS also.

Sure. Actually, I've just installed again from scratch, but with the same result. I'll try to use Java 1.4 latter to see if anything changes.

andowson wrote:I have no problem on CVS now.
My environment is quite similar to you.
Java 5 +Tomcat 5.5.4 + PostgreSQL 7.4

The only difference I see here is that I'm using PostgreSQL 8

andowson wrote:The are some fixes I made for PostgreSQL. If you like, I can share it with you.

Are these changes on the SQL scripts? I've made some to the db_struct and the dump scripts. In the db_struct there is a NUMBER where it should be NUMERIC in the jforum_attach_desc table.
[originally posted on jforum.net by gangrel-br]

[Migrated From Jforum.net]

Just to remember you guys that - as you already realized -, the cvs version is not stable for databases other than mysql yet, so errors with sql statements and kinda may happend.

Is the forum working now, after your patches? if so, *pleaase* send them to me

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

na na na... the CVS version is stable for :evil: SQL Server:evil: too.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

I got one problem in the admin panel now.
In the Forum panel, If I tried to move one Forum from an category A to category B. The original code will fail. After the following patching, it works:
net/jforum/view/admin/ForumAction.java

	//  Save information
	public void editSave() throws Exception
	{
		Forum f = new Forum(ForumRepository.getForum(this.request.getIntParameter("forum_id")));

		ForumRepository.removeForum(f);
		
		f.setDescription(this.request.getParameter("description"));
		f.setIdCategories(this.request.getIntParameter("categories_id"));
		f.setName(this.request.getParameter("forum_name"));
			
		DataAccessDriver.getInstance().newForumModel().update(f);		
		
		Category category = ForumRepository.getCategory(f.getCategoryId());
		category.changeForumOrder(f);
		
		ForumRepository.reloadForum(f.getId());		
		
		this.list();
	}

However, when I click on the Forum Index to go back to Forum listing.
I got a error page. I've spent two days on fixing it. But I still can't get any idea. Here is the error message:

MethodgetLastPostInfo on net.jforum.repository.ForumRepository 
The problematic instruction: ---------- 
==> assignment: lpi=fir.getLastPostInfo(forum.id)
 [on line 40, column 41 in default/forum_list.htm] in include moduleAction [on line 74, column 21 in default/forum_base.htm]
 ---------- Java backtrace for programmers: ---------- 
...

Has anyone meet this kind of situation?
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

I'll take a look.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Oh!! I found the problem. There needs to be a addForum().
The correct code fixing as follows:

        public void editSave() throws Exception
        {
                Forum f = new Forum(ForumRepository.getForum(this.request.getIntParameter("forum_id")));

                ForumRepository.removeForum(f);

                f.setDescription(this.request.getParameter("description"));
                f.setIdCategories(this.request.getIntParameter("categories_id"));
                f.setName(this.request.getParameter("forum_name"));

                DataAccessDriver.getInstance().newForumModel().update(f);       

                ForumRepository.addForum(f);

                Category category = ForumRepository.getCategory(f.getCategoryId());
                category.changeForumOrder(f);

                ForumRepository.reloadForum(f.getId());
                this.list();
        }

Now, the forum seems work nice.
[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

Done! I commited it to the CVS, with a few improvements.!

Rafael
[originally posted on jforum.net by Rafael Steil]