Message Approving Problem

[Migrated From Jforum.net]

hi,

Just wondering if you any of you have the similar problem. I am running JForum on Fedora 3, Tomcat 4.1 and postgressql 7.3.6.

Everything is just work fine, but when i set the forum to be moderated. Any new post will be put on the queue for moderator to approve, however, when i click on the view details of that post. It says "There are no posts to moderate.". But i am pretty sure that there are posts pedning to be moderated. o.O?

other than this problem, it is a great forum tools = ) Thanks for your great work

/Sam

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

It may be a problem with postgresql support in jforum. I'll take a look. If you would like to know when this topic is anwered, please register (is always good to know to who we're talking)

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

[Migrated From Jforum.net]

Hi Rafael,

Sure I have just registered. Maybe you would let me know where i should look into. I know a bit about postgresSQL and java. Hope i can contribute something to this tool =)

/Sam
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Oops. Just forget to login.

Anyway here i am. Sam from Hong Kong ( i hope u know where it is ) ..

/Sam
[originally posted on jforum.net by samleong]

[Migrated From Jforum.net]

Hi Rafael,

I think i have found the problem. In net/jforum/drivers/postgresql/ModerationModel.java

the method of getting the moderated topics is like below:

public List topicsByForum(int forumId, int start, int count) throws Exception
{
return super.topicsByForum(forumId, count, start + count);
}

When i try to dump the sql it says, count = 15 , start + count = 15 and run the SQL into database it returns nothing. I am not sure if thats the problem with the postgreSQL. So i change that line into


public List topicsByForum(int forumId, int start, int count) throws Exception
{
return super.topicsByForum(forumId, count, start);
}

Then it works !!! I am not sure that will have any impact on other programs. Hope that would help.

/Sam
[originally posted on jforum.net by samleong]