Actions
Bug #17613
closed
Oracle-SELECT-Error on table "index_phash"
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)
Updated by Moreno Feltscher about 17 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?
Updated by Moreno Feltscher over 16 years ago
Can please anybody close this as solved in rev. 3247 and 3249.
Thanks
Updated by
Actions