Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
None
-
None
Description
Hi
When accessing "/oauthadmin/list" you get this error:
An unexpected error has occurred. Please contact the webmaster. A query failed internally in Persistent Object: SQLSTATE[HY000]: General error: 942 OCIStmtExecute: ORA-00942: tabellen eller utsnittet finnes ikke (/usr/src/php-5.2.17/ext/pdo_oci/oci_statement.c:146) Query: 'SELECT "ezprest_clients"."id", "ezprest_clients"."name", "ezprest_clients"."description", "ezprest_clients"."client_id", "ezprest_clients"."client_secret", "ezprest_clients"."endpoint_uri", "ezprest_clients"."owner_id", "ezprest_clients"."created", "ezprest_clients"."updated", "ezprest_clients"."version" FROM "ezprest_clients" WHERE "ezprest_clients"."version" = 0 ORDER BY "ezprest_clients"."name"' in /data1/www/apache2php52/ezporacle/.run/lib/ezc/PersistentObject/src/persistent_session.php on line 799
With the following patch, it helps but you then get problem with a sequence
--- lib/ezc/Database/src/handlers/oracle.php.old 2010-01-08 16:27:00.000000000 +0100 +++ lib/ezc/Database/src/handlers/oracle.php 2011-03-28 14:33:28.000000000 +0200 @@ -151,5 +151,11 @@ $str = str_replace( "'", "''", $str ); return "'$str'"; } + + protected $identifierQuoteChars = array( + "start" => '', + "end" => '', + ); + } ?>
The error is then:
An unexpected error has occurred. Please contact the webmaster. A query failed internally in Persistent Object: SQLSTATE[HY000]: General error: 2289 OCIStmtExecute: ORA-02289: sekvensen finnes ikke (/usr/src/php-5.2.17/ext/pdo_oci/oci_statement.c:146) Query: 'INSERT INTO ezprest_clients ( name, description, client_id, client_secret, endpoint_uri, owner_id, created, updated, version, id ) VALUES ( :ezcValue1, :ezcValue2, :ezcValue3, :ezcValue4, :ezcValue5, :ezcValue6, :ezcValue7, :ezcValue8, :ezcValue9, ezprest_clients_s.nextval )' in /data1/www/apache2php52/ezporacle/.run/lib/ezc/PersistentObject/src/persistent_session.php on line 799