I'm getting this:

PDOException: SELECT base.uid AS uid, base.name AS name, base.pass AS pass, base.mail AS mail, base.theme AS theme, base.signature AS signature, base.signature_format AS signature_format, base.created AS created, base.access AS access, base.login AS login, base.status AS status, base.timezone AS timezone, base.language AS language, base.picture AS picture, base.init AS init, base.data AS data FROM {users} base WHERE (base.uid IN (:db_condition_placeholder_0)) (prepared: SELECT base."UID" AS "UID", base.name AS name, base.pass AS pass, base.mail AS mail, base.theme AS theme, base.signature AS signature, base.signature_format AS signature_format, base.created AS created, base."ACCESS" AS "ACCESS", base.login AS login, base.status AS status, base.timezone AS timezone, base.language AS language, base.picture AS picture, base.init AS init, base.data AS data FROM "USERS" base WHERE (base."UID" IN (:db_condition_placeholder_0)) ) e: SQLSTATE[HY000]: General error: 1722 OCIStmtExecute: ORA-01722: invalid number (/root/PDO_OCI-1.0/oci_statement.c:142) args: Array ( [:db_condition_placeholder_0] => reset ) in DrupalDefaultEntityController->load() (line 196 of /web/includes/entity.inc).

Looks like Drupal trying to insert varchar type placeholder value instead of number...

Comments

amfis’s picture

Some backtrace for error:

db: Array ( [0] => Array ( [file] => /web/includes/database/select.inc [line] => 1284 [function] => query [class] => DatabaseConnection_oracle [type] => -> [args] => Array ( [0] => SELECT base.uid AS uid, base.name AS name, base.pass AS pass, base.mail AS mail, base.theme AS theme, base.signature AS signature, base.signature_format AS signature_format, base.created AS created, base.access AS access, base.login AS login, base.status AS status, base.timezone AS timezone, base.language AS language, base.picture AS picture, base.init AS init, base.data AS data FROM {users} base WHERE (base.uid IN (:db_condition_placeholder_0)) [1] => Array ( [:db_condition_placeholder_0] => reset ) [2] => Array ( [target] => default [return] => 1 ) ) ) 

[1] => Array ( [file] => /web/includes/entity.inc [line] => 196 [function] => execute [class] => SelectQuery [type] => -> [args] => Array ( ) ) 

[2] => Array ( [file] => /web/includes/common.inc [line] => 7474 [function] => load [class] => DrupalDefaultEntityController [type] => -> [args] => Array ( [0] => Array ( [0] => reset ) [1] => Array ( ) ) ) 

[3] => Array ( [file] => /web/modules/user/user.module [line] => 287 [function] => entity_load [args] => Array ( [0] => user [1] => Array ( [0] => reset ) [2] => Array ( ) [3] => ) ) 

[4] => Array ( [file] => /web/modules/user/user.module [line] => 362 [function] => user_load_multiple [args] => Array ( [0] => Array ( [0] => reset ) [1] => Array ( ) [2] => ) ) 

[5] => Array ( [file] => /web/includes/menu.inc [line] => 579 [function] => user_load [args] => Array ( [0] => reset ) ) 

[6] => Array ( [file] => /web/includes/menu.inc [line] => 746 [function] => _menu_load_objects [args] => Array ( [0] => Array ( [path] => user/% [load_functions] => a:1:{i:1;s:9:"user_load";} [to_arg_functions] => [access_callback] => user_view_access [access_arguments] => a:1:{i:0;i:1;} [page_callback] => user_view_page [page_arguments] => a:1:{i:0;i:1;} [delivery_callback] => [fit] => 2 [number_parts] => 2 [context] => 0 [tab_parent] => [tab_root] => user/% [title] => My account [title_callback] => user_page_title [title_arguments] => a:1:{i:0;i:1;} [theme_callback] => [theme_arguments] => a:0:{} [type] => 6 [description] => [position] => [weight] => 0 [include_file] => ) [1] => Array ( [0] => user [1] => reset [2] => 526 [3] => 1324559325 ) ) ) 

[7] => Array ( [file] => /web/includes/menu.inc [line] => 458 [function] => _menu_translate [args] => Array ( [0] => Array ( [path] => user/% [load_functions] => a:1:{i:1;s:9:"user_load";} [to_arg_functions] => [access_callback] => user_view_access [access_arguments] => a:1:{i:0;i:1;} [page_callback] => user_view_page [page_arguments] => a:1:{i:0;i:1;} [delivery_callback] => [fit] => 2 [number_parts] => 2 [context] => 0 [tab_parent] => [tab_root] => user/% [title] => My account [title_callback] => user_page_title [title_arguments] => a:1:{i:0;i:1;} [theme_callback] => [theme_arguments] => a:0:{} [type] => 6 [description] => [position] => [weight] => 0 [include_file] => ) [1] => Array ( [0] => user [1] => reset [2] => 526 [3] => 1324559325 ) ) ) 
amfis’s picture

Title: Error while trying to reset user password! » Error while trying to reset user password using Oracle database driver!
Project: Oracle Driver » Drupal core
Version: 7.x-1.9 » 7.8
Component: Code » user.module
amfis’s picture

Status: Active » Closed (won't fix)
Renee S’s picture

Project: Drupal core » Oracle Driver
Version: 7.8 » 7.x-1.x-dev
Component: user.module » Code

I think this belongs here instead - it might be related to #1633004: DatabaseSchema_oracle::createFieldSql() not compliant with Schema API documentation.; I'm seeing something similar, and I'll try the patches and see if it goes away...

Leaving this as closed, but hopefully better filed :)