• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

ERROR: Field 'forum_topics' doesn't have a default value

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Tried to create a new forum and got this error. I just upgraded to 2.1.6 yesterday, Im thinking that had something to do with it. Hope you can help,

Thanks

<!-- BEGIN ERROR STACK TRACE <br /> java.lang.reflect.InvocationTargetException <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) <br /> at java.lang.reflect.Method.invoke(Unknown Source) <br /> at net.jforum.Command.process(Command.java:116) <br /> at net.jforum.view.admin.AdminCommand.process(AdminCommand.java:63) <br /> at net.jforum.JForum.service(JForum.java:182) <br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) <br /> at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) <br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) <br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) <br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) <br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) <br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) <br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) <br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868) <br /> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) <br /> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) <br /> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) <br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) <br /> at java.lang.Thread.run(Unknown Source) <br /> Caused by: java.sql.SQLException: Field 'forum_topics' doesn't have a default value <br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) <br /> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) <br /> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) <br /> at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) <br /> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) <br /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166) <br /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082) <br /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067) <br /> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) <br /> at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:118) <br /> at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:112) <br /> at net.jforum.dao.generic.GenericForumDAO.addNew(GenericForumDAO.java:242) <br /> at net.jforum.view.admin.ForumAction.insertSave(ForumAction.java:212) <br /> ... 25 more <br /> <br /> END ERROR STACK TRACE-->
[originally posted on jforum.net by TheOne]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Did you run the upgrade script on your database?

[originally posted on jforum.net by GatorBait3]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
But, where do i get the upgrade script? if i could get the upgrade script it would be of great help.
[originally posted on jforum.net by fairoz]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

fairoz wrote:But, where do i get the upgrade script? if i could get the upgrade script it would be of great help.


Try reading the upgrade instructions found here: http://www.jforum.net/doc/UpgradingFrom2.1.6To2.1.7.

From that page:
"Upgrading the database schema
There are some changes to the database schema - a new colum here, a removed colum there... In order to get the database right, go to the directory upgrade/2.1.7, where you'll find the upgrade script for all supported dataabses - Oracle, MySQL, PostgreSQL and HSLQDB."


[originally posted on jforum.net by GatorBait3]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic