Bug #17613: Oracle-SELECT-Error on table "index_phash" - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #17613

closed

Oracle-SELECT-Error on table "index_phash"

Added by Moreno Feltscher over 16 years ago. Updated over 5 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Dmitry Dulepov

Category:

Indexed Search

Target version:

Start date:

2007-09-18

Due date:

% Done:

Estimated time:

TYPO3 Version:

PHP Version:

Tags:

Complexity:

Is Regression:

Sprint Focus:

Description

On such pages I get an error in the dbal-log:
sqlError ORA-01722: invalid number
SELECT count(*) FROM "index_phash" WHERE "item_type" = 0 GROUP BY "phash_grouping"

The type of the field "item_type" in the database is VARCHAR, so this error is traceable.

Is there a way to do a fix for Oracle-installations?

(issue imported from #M6361)

Actions

Copy link

Updated by Moreno Feltscher over 16 years ago

I think, this happens if the engine has to index a site with some Word (.doc) documents. Whis would mean, that "item_type" 0 represents .doc-documents. Is this possible?

Actions

Copy link