• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Message Approving Problem

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!