[TYPO3-core] RFC #6369: Bug: Oracle-error while indexing a page with indexed_search

[Ingmar Schlecht]

The code looks OK, but the indentation is wrong (spaces instead of 
tabs). +1 on reading.

cheers
Ingmar


Moreno Feltscher schrieb:
> This is an SVN patch request.
> 
> Type: Bugfix
> 
> Bugtracker references: http://bugs.typo3.org/view.php?id=6369
> 
> Branches: TYPO3_4-1 & trunk
> 
> Problem: If you try to index a TYPO3-page with indexed_search and you
> use Oracle (with DBAL) as your database an error occurs: Warning:
> ociexecute() [function.ociexecute]: ORA-00001: unique constraint
> (*.SYS_C0090792) violated in
> typo3/sysext/adodb/adodb/drivers/adodb-oci8.inc.php on line 1017
> In the dbal-Log I see this (example):
> sqlError ORA-00001: unique constraint (*.SYS_C0090792) violated
>  INSERT INTO "index_words" ( "wid", "baseword", "metaphone" ) VALUES (
> '88728859', 'schalter', '212743736' )
> This error means there is already one record with this "wid" ("wid" is the key).
> 
> Solution: I added an additional SELECT on class.indexer.php to check
> the key already exists. For more details visit the bugtracker.
> 
> Notes: This is my first patch request and I really don't know whether
> this problem already has been fixed.
> 
> 
> Cheers
> Moreno Feltscher


-- 
Ingmar Schlecht
TYPO3 Association Active Member