2 Replies Latest reply on Jul 2, 2003 10:54 AM by Viet

    The News module..?

    nogood Newbie

      Howdy.

      Deployed the News module and loaded News' setup.ddl. When calling the News pages I get an error saying:

      javax.ejb.FinderException: Find failed: java.sql.SQLException: Column not found: PN_STATE in statement [SELECT t0_s.pn_sid FROM NUKE_STORIES t0_s WHERE t0_s.pn_state = 0]

      In the setup.dll I used the NUKE_STORIES table looks like:

      CREATE TABLE nuke_stories (
      pn_sid INTEGER NOT NULL IDENTITY,
      pn_catid INTEGER DEFAULT '0' NOT NULL ,
      pn_aid VARCHAR(30) DEFAULT '' NOT NULL ,
      pn_title VARCHAR(255) DEFAULT NULL,
      pn_time DATETIME DEFAULT NULL,
      pn_hometext VARCHAR,
      pn_bodytext VARCHAR DEFAULT '' NOT NULL,
      pn_comments INTEGER DEFAULT '0',
      pn_counter INTEGER DEFAULT NULL,
      pn_topic INTEGER DEFAULT '1',
      pn_informant VARCHAR(20) DEFAULT '' NOT NULL,
      pn_notes VARCHAR DEFAULT '' NOT NULL,
      pn_ihome BIT DEFAULT '0' NOT NULL,
      pn_themeoverride VARCHAR(30) DEFAULT '' NOT NULL,
      pn_language VARCHAR(30) DEFAULT '' NOT NULL,
      pn_withcomm BIT DEFAULT '0' NOT NULL,
      pn_format_type INTEGER DEFAULT '0' NOT NULL
      );

      I.e no PN_STATE column. Anyone any idea?

        • 1. Re: The News module..?
          Ümit VARDAR Newbie

          Hi,

          Change the .../nukes/news/src/resources/hsqldb/setup.ddl file as follows, then recreate the table
          .
          .
          .

          CREATE TABLE nuke_stories (
          pn_sid INTEGER NOT NULL IDENTITY,
          >> pn_state INTEGER DEFAULT '0' NOT NULL,
          pn_catid INTEGER DEFAULT '0' NOT NULL ,
          .
          .
          .
          That will solve the problem. Also the cvs should be updated.

          • 2. Re: The News module..?
            Viet Master

            yes this is a simplification we did in the news module.

            remove the usage of QueuedNews and introduce the field state in Story.

            Thus we use one EJB instead of two.

            The news module has been greatly simplified since it has been commited. The code is more compact.

            There still miss some things but it is now pretty usable. Also we checked in the support for RSS.

            julien