0 Replies Latest reply on May 24, 2005 3:26 PM by amcouto

    Problem accessing to topic forums

    amcouto Newbie

      Hello I have a problem. I can create a forum and a category, but the problem is when i go into the forum to put some post it gives me an error!
      And the error is:

      2005-05-24 20:20:16,406 INFO [STDOUT] Caused by: net.sf.hibernate.JDBCException: Could not execute query
      2005-05-24 20:20:16,406 INFO [STDOUT] at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1612)
      2005-05-24 20:20:16,406 INFO [STDOUT] at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27)
      2005-05-24 20:20:16,406 INFO [STDOUT] at org.jboss.portlet.forums.impl.ForumsModuleImpl.findTopics(ForumsModuleImpl.java:306)
      2005-05-24 20:20:16,406 INFO [STDOUT] ... 89 more
      2005-05-24 20:20:16,406 INFO [STDOUT] Caused by: java.sql.SQLException: 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 '10 topicimpl0_.jbp_id as x0_0_ from jbp_forums_topics topicimpl0_ where (topicim' at line 1
      2005-05-24 20:20:16,406 INFO [STDOUT] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
      2005-05-24 20:20:16,406 INFO [STDOUT] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
      2005-05-24 20:20:16,406 INFO [STDOUT] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
      2005-05-24 20:20:16,406 INFO [STDOUT] at com.mysql.jdbc.Connection.execSQL(Connection.java:2385)

      and ...

      2005-05-24 20:20:16,406 ERROR [org.jboss.portal.core.servlet.CoreServlet] Error
      at org.jboss.portlet.forums.ForumsPortlet.fillShowForumContext(ForumsPortlet.java:2235)
      at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:330)
      at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:217)
      at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:204)
      at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:347)

      Can anybody help me????