會員註冊 / 登入  |  電腦版  |  Jump to bottom of page

JForum中文社群 JForum Chinese Users Community » Postgre CURRVAL issue

發表人: acer123, 九級學員
2009-10-28 10:09:40
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')

發表人: acer123, 九級學員
2009-10-28 11:48:25
Never mind i got it :--)




會員註冊 / 登入  |  電腦版  |  Jump to top of page