• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Can't see any topics

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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:



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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you...I did and I got the same problem with now.

The exception has some information:

maybe you can check the SQL for where "points" show up.
[originally posted on jforum.net by andowson]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
OK, I fix it up now.
PostgreSQL cannot accept this kind of SQL:

it should be written as

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm not sure if I'm understanding what you're saying... ops:

Are you saying that this line:


Should be:


:?:
[originally posted on jforum.net by gangrel-br]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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

Are you saying that this line:


Should be:


:?:


NO.
I mean, it should be


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

should be

and

should be


[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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

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:

Has anyone meet this kind of situation?
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'll take a look.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oh!! I found the problem. There needs to be a addForum().
The correct code fixing as follows:

Now, the forum seems work nice.
[originally posted on jforum.net by andowson]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Done! I commited it to the CVS, with a few improvements.!

Rafael
[originally posted on jforum.net by Rafael Steil]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic