安道生網站技術練功房 - 分享經驗，累積智慧

I install JForums on postgres. I am assuming that the only SQL file JForum uses for all it's queries is generic_queries.sql because the DB which i have consist of schemaname.tablename and because of that i had to change all of my SQL file.

Since this was an issue so inserted everything manually and implemented SSO which is working just fine. There were several bug which i faced on PSQL JForums which i will post in your JIRA site.

I have a question. Everytime i post a message on JForums or create a topic or send a PVT message to a user i get a PSQLException :-

Error: currval of sequence "jforum_privmsgs_seq" is not yet defined in the session.

I saw in postgresql.sql file it has :-

select CURRVAL('jforum_privmsgs_seq')
select CURRVAL('jforum_topics_seq')

Never mind i got it :--)