Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-12180

Errors appear when trying to copy subtree with sensitive menu

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Medium Medium
    • None
    • 4.0.0rc1
    • Database related
    • None

    Description

      When I trying to copy subtree with sensitive menu several errors appear:

      Error: eZOracleDB Dec 05 2007 11:29:54

      Error (12899): ORA-12899: value too large for column
      "VV"."EZSEARCH_WORD"."WORD" (actual: 179, maximum: 150)
      Failed query at offset 118:
      INSERT INTO
      ezsearch_word ( word, object_count )
      VALUES ( 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '1' )

      Start of error:
      'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', '1' )

      Error: eZOracleDB Dec 05 2007 11:29:54
      Error (8002): ORA-08002: sequence S_SEARCH_WORD.CURRVAL is not yet defined in this session
      Failed query at offset 0:
      SELECT s_search_word.currval from DUAL
      Start of error:
      SELECT s_search_word.currval from DUAL

      Error: eZOracleDB Dec 05 2007 11:29:54
      Error (1400): ORA-01400: cannot insert NULL into ("VV"."EZSEARCH_OBJECT_WORD_LINK"."NEXT_WORD_ID")
      Failed query at offset 649:
      INSERT INTO
      ezsearch_object_word_link
      ( word_id,
      contentobject_id,
      frequency,
      placement,
      next_word_id,
      prev_word_id,
      contentclass_id,
      contentclass_attribute_id,
      published,
      section_id,
      identifier,
      integer_value )
      VALUES ( '1661', '225', '0', '2', '', '1660', '16', '186', '1196846993', '1', 'intro', '0' )
      Start of error:
      '', '1660', '16', '186', '1196846993', '1', 'intro', '0' )

      Error: eZOracleDB Dec 05 2007 11:29:54
      Error (1400): ORA-01400: cannot insert NULL into ("VV"."EZSEARCH_OBJECT_WORD_LINK"."WORD_ID")
      Failed query at offset 624:
      INSERT INTO
      ezsearch_object_word_link
      ( word_id,
      contentobject_id,
      frequency,
      placement,
      next_word_id,
      prev_word_id,
      contentclass_id,
      contentclass_attribute_id,
      published,
      section_id,
      identifier,
      integer_value )
      VALUES ( '', '225', '0', '3', '86', '1661', '16', '187', '1196846993', '1', 'body', '0' )
      Start of error:
      '', '225', '0', '3', '86', '1661', '16', '187', '1196846993', '1', 'body', '0' )

      Error: eZOracleDB Dec 05 2007 11:29:54
      Error (1400): ORA-01400: cannot insert NULL into ("VV"."EZSEARCH_OBJECT_WORD_LINK"."PREV_WORD_ID")
      Failed query at offset 653:
      INSERT INTO
      ezsearch_object_word_link
      ( word_id,
      contentobject_id,
      frequency,
      placement,
      next_word_id,
      prev_word_id,
      contentclass_id,
      contentclass_attribute_id,
      published,
      section_id,
      identifier,
      integer_value )
      VALUES ( '86', '225', '0', '4', '86', '', '16', '191', '1196846993', '1', 'publish_date', '0' )
      Start of error:
      '', '16', '191', '1196846993', '1', 'publish_date', '0' )

      Steps to reproduce
      • Create 2 objects (e.g. articles - first and second). In first article field "summary" or "body" should content word consists more then 150 characters.
      • Choose copy subtree in "First" sensitive menu and then select the second created article

      Attachments

        Activity

          People

            unknown unknown
            vv@ez.no vv@ez.no
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: