Project

General

Profile

Actions

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
Category:
Indexed Search
Target version:
-
Start date:
2007-09-18
Due date:
% Done:

0%

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

Also available in: Atom PDF