1 Reply Latest reply on Jun 10, 2004 1:08 PM by cuoz

    nukes 1.1RC1 mysql error

      I am also testing the RC1 tagged release on mysql.

      I grabbed from CVS today. When I deploy the forums, some rows fail to insert
      ---------------------------------------
      12:40:48,845 INFO [ForumEJB] Executing SQL: INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order,forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read,auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote,auth_pollcreate, auth_attachments) VALUES (0,0,'My forum','This is a sample forum',0,10,0,0,NULL,NULL,false,0,0,1,1,1,1,3,3,3,3,0);
      12:40:48,847 WARN [ForumEJB] Issuing sql INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order,forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read,auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote,auth_pollcreate, auth_attachments) VALUES (0,0,'My forum','This is a sample forum',0,10,0,0,NULL,NULL,false,0,0,1,1,1,1,3,3,3,3,0); failed: java.sql.SQLException: Column not found, message from server: "Unknown column 'false' in 'field list'"
      12:40:48,847 ERROR [EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException: Error while issuing sql in post-table-create; - nested throwable: (java.sql.SQLException: Column not found, message from server: "Unknown column 'false' in 'field list'")

        • 1. Re: nukes 1.1RC1 mysql error

          It looks like one of the post create table SQL commands needs to have single quotes around the 'false' value. I was able to insert the record and touch the nukes-bb.ear file and voila. Forums are up & running.