Project

General

Profile

Actions

Bug #17539

closed

OCI_INVALID_HANDLE

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

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2007-08-17
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

When I watch some pages in the frontend I get this error:
Warning: OCI-Lob::save() [function.OCI-Lob-save]: OCI_INVALID_HANDLE in D:\IIS\EMS\typo3\sysext\adodb\adodb\drivers\adodb-oci8.inc.php on line 696

My database is oracle 10g.

I think, it's something like bug nr. 0005535 (it's closed, so I opened a new issue-report.).

(issue imported from #M6164)


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #17266: Web>page and Web>list trigger ORA-01704 errorClosedKarsten Dambekalns2007-04-30

Actions
Actions #1

Updated by Karsten Dambekalns over 16 years ago

So, did you use the latest SVN version?

Actions #2

Updated by Moreno Feltscher over 16 years ago

Where can I get the SVN version?

I think, the error occurs, if I visit a page the first time. So can it be because of the cache-functionality?

Actions #3

Updated by Moreno Feltscher over 16 years ago

Now I also get this error when I insert a new content element:
Warning: ociexecute() [function.ociexecute]: ORA-01704: string literal too long in ...\typo3\sysext\adodb\adodb\drivers\adodb-oci8.inc.php on line 1017

Actions #4

Updated by Moreno Feltscher over 16 years ago

Another error now when I try to index external documents like PDF:
Warning: ociexecute() [function.ociexecute]: ORA-00001: unique constraint (INTRANET.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 (INTRANET.SYS_C0090792) violated

INSERT INTO "index_words" ( "wid", "baseword", "metaphone" ) VALUES ( '88728859', 'schalter', '212743736' )
Actions #5

Updated by Moreno Feltscher over 16 years ago

I tried the SVN-version. I also dropped tt_content and recreated it with the install-tool. Now all VARCHAR2 columns became CLOB, nice done. But if I try to add new content I get this error:
Versuch einen Datensatz auf Seite 'ORA-00932: inconsistent datatypes: expected CLOB got CHAR' (tt_content:NEW475e89a46f341) ohne die nötigen Berechtigungen einzufügen. (Oder die Seite existiert nicht!) (msg#1.1.12)

Actions #6

Updated by Michiel Roos over 14 years ago

I have seen this when using the 'Western European' Oracle Express 10g on a UTF-8 dataset.

Patrick Broens tipped me that character set conversions may be in the way here.

After re-installing the whole system using a 'Universal' Oracle Express 10g database with the same dataset, my problems went away.

Maybe send a reminder to Moreno. If he can still reproduce and gives some 'steps to reproduce', I will help to debug. Otherwise, close the bug.

Actions #7

Updated by Moreno Feltscher over 14 years ago

This bug can be closed. At the end (and with some debugging work) all worked fine.

Thank you for your support!

Actions

Also available in: Atom PDF