MySQL Error

[Migrated From Jforum.net]

Hi,

I started a new Forum, and i am using the JForum. When I create a category I am getting an error like below

Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('jforum_categories_seq')' at line 1"

Please advice what is the error and how can I solve this.
[originally posted on jforum.net by prasanna_sekhar]

[Migrated From Jforum.net]

You may want to post more specifics ... like what version of JForum, what database & versions, etc.

[originally posted on jforum.net by GatorBait3]

[Migrated From Jforum.net]

I am using JForum 2.1.6, MySQL 4.1.18-standard. Below I am pasting the complete Exception as well.

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.view.admin.AdminCommand.process(AdminCommand.java:63)
at net.jforum.JForum.service(JForum.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:346)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('jforum_categories_seq')' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:129)
at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:112)
at net.jforum.dao.generic.GenericCategoryDAO.addNew(GenericCategoryDAO.java:177)
at net.jforum.view.admin.CategoryAction.insertSave(CategoryAction.java:151)
... 17 more

[originally posted on jforum.net by prasanna_sekhar]