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

[Moreno Feltscher]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0006369.diff
Type: application/octet-stream
Size: 1325 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20080115/61f7ae20/attachment.obj