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

[Migrated From Jforum.net]

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]

Did you run the upgrade script on your database?

[originally posted on jforum.net by GatorBait3]

[Migrated From Jforum.net]

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]

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]