#011465: Fetching extra authentication data in Database filter with Oracle can trigger a PDO error

Description:

Running the tests with Oracle result in an error:

1) testDatabaseFetchData(ezcAuthenticationDatabaseTest)
PDOException: SQLSTATE[HY000]: General error: 904 OCIStmtExecute: ORA-00904: "COUNTRY": invalid identifier
(/home/as/src/php-5.2dev/ext/pdo_oci/oci_statement.c:142)
/home/as/dev/ezcomponents/trunk/AuthenticationDatabaseTiein/src/filters/database/database_filter.php:263
/home/as/dev/ezcomponents/trunk/Authentication/src/authentication.php:241
/home/as/dev/ezcomponents/trunk/AuthenticationDatabaseTiein/tests/filters/database/database_test.php:222
/home/as/dev/ezcomponents/trunk/UnitTest/src/test/runner.php:209
/home/as/dev/ezcomponents/trunk/UnitTest/src/test/runner.php:20
/home/as/dev/ezcomponents/trunk/UnitTest/src/runtests.php:27

The fix is to quote the identifiers ($this->requestedData) in the DatabaseFilter.


Environment:

Operating System:
PHP Version: (please be specific, like '4.4.3' or '5.1.5')
Database and version:
Browser (and version):


Steps to Reproduce:

Run the tests with Oracle.


- Attachments

No attachments for this issue.


- Comments

Fixed in rev. 6187. It will be available in AuthenticationDatabaseTiein 1.1alpha1.

#253708 by Alexandru Stanoi on September 18th, 2007 [Permanent Link]

- History
Properties
Type Bug
Priority Medium
Component Components » AuthenticationDatabaseTiein
Affects 1.0 - AuthenticationDatabaseTiein 1.0
Fix Versions 1.1alpha1 - AuthenticationDatabaseTiein 1.1alpha1
2007.2alpha1 - eZ components 2007.2alpha1
Reporter Alexandru Stanoi
Responsible Alexandru Stanoi
Status 0 Closed
Resolution Fixed
Created September 18th, 2007
Updated September 18th, 2007
Resolved September 18th, 2007
 
Navigation [Permanent Link]
Previous Issue
Back to Issues List
Next Issue: #015537
  Graph shows to small and truncated rotated axis labels