Details
-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
4.0.0rc1
-
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
Issue Links
- duplicates
-
EZP-12069 Fatal error when word longer than 150 characters
- Closed