2.1.6 Error: Returning autogenerated keys is not supported.

[Migrated From Jforum.net]

Hello all.
I download 2.1.6 and successfully deploy it onto glassfish-b48, with PostgreSQL-JNDI-DataSource .
Installation passed without errors.
But user-registration procedure ends with error:

<!-- BEGIN ERROR STACK TRACE
java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at net.jforum.Command.process(Command.java:116)
	at net.jforum.JForum.service(JForum.java:182)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184)
	at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:216)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:276)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
	at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
	at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:231)
	at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
	at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
	at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
	at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
	at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
	at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
	at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
Caused by: org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:352)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.postgresql.ds.common.PooledConnectionImpl$ConnectionHandler.invoke(PooledConnectionImpl.java:348)
	at $Proxy27.prepareStatement(Unknown Source)
	at com.sun.gjc.spi.ConnectionHolder.prepareStatement(ConnectionHolder.java:428)
	at net.jforum.dao.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java:95)
	at net.jforum.dao.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java:107)
	at net.jforum.dao.generic.GenericUserDAO.addNew(GenericUserDAO.java:243)
	at net.jforum.view.forum.UserAction.insertSave(UserAction.java:232)
	... 36 more

END ERROR STACK TRACE-->

How to fix it?
[originally posted on jforum.net by dm]

[Migrated From Jforum.net]

Open your file WEB-INF/config/jforum-custom.conf and add the following:

database.support.autokeys = false

Then restart your Application server.

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

[Migrated From Jforum.net]

Thank you, Rafael!
This file does not exists, but i create new with one string and redeploy jforum.war.
All it;s ok.
[originally posted on jforum.net by dm]

[Migrated From Jforum.net]

Ok, i can register new accounts and post new messages.
But i can't see this messages!
Forum-index show count of posted messages, but click on forum title showing empty page:(
(In attached file.)
[originally posted on jforum.net by dm]

[Migrated From Jforum.net]

Are you able to see the messages in the tables jforum_topics and jforum_posts?

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

[Migrated From Jforum.net]

Rafael Steil wrote:Are you able to see the messages in the tables jforum_topics and jforum_posts?

Rafael

Yes. Data posts into database.
[originally posted on jforum.net by dm]

[Migrated From Jforum.net]

Have you tried to reinstall JForum and see if the bug appears again? If you did not, could you, please?

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