Fwd: AW: AW: [nag] hi .. nag and oracle ?

[Chuck Hagenbuch]

replies to list...

----- Forwarded message from Wolfgang Kanovsky <kaw@rdcs.at> -----
    Date: Wed, 29 May 2002 18:54:00 +0200
    From: Wolfgang Kanovsky <kaw@rdcs.at>
Reply-To: kaw@rdcs.at
 Subject: AW: AW: [nag]  hi .. nag and oracle ?
      To: Chuck Hagenbuch <chuck@horde.org>



-----Ursprüngliche Nachricht-----
Von: Chuck Hagenbuch [mailto:chuck@horde.org]
Gesendet: Mittwoch, 29. Mai 2002 18:28
An: nag@lists.horde.org
Cc: kaw@rdcs.at
Betreff: Re: AW: [nag] hi .. nag and oracle ?


[please keep replies on the list]

Quoting Wolfgang Kanovsky <kaw@rdcs.at>:

> i have changed manny things in php ... because .. oracle always use
> UPPERCASE row-names ...

That isn't a problem; we use PEAR's portability option, which should take
care of this for Oracle.


im sorry to tell you .. it does not ...
my config option ....

$conf['storage']['params']['phptype'] = 'oci8';
 $conf['storage']['params']['hostspec'] = '*****';
 $conf['storage']['params']['username'] = 'horde';
 $conf['storage']['params']['password'] = '*****';
 $conf['storage']['params']['database'] = 'office';
 $conf['storage']['params']['table'] = 'nag_tasks';

then in the sql.php...i have to change Rownames to UPPERCASE !! .. that it
is working

     /* Store the retrieved values in a fresh $tasks list. */
            $this->tasks = array();
            while ($row && !DB::isError($row)) {
                /* Create a new task based on this row's values. */
		    /* changed to Uppercase KAW */
                $task = array();
                $task['task_id'] = $row['TASK_ID'];			
	<<
                $task['name'] = $row['TASK_NAME'];			
	<<  ...
                $task['desc'] = $row['TASK_DESC'];
                $task['category'] = $row['TASK_CATEGORY'];
                $task['due'] = $row['TASK_DUE'];
                $task['priority'] = $row['TASK_PRIORITY'];
                $task['completed'] = $row['TASK_COMPLETED'];
                $task['flags'] = 0;

                /* Add this new task to the $tasks list. */
                $this->tasks[$row['TASK_ID']] = $task;

> the sql file has no oracle syntax .. so i have changed it to .. to
> oracle-syntax

The table creation script? Or the driver? The driver should work fine...

the script looks like ...
Text for task_desc is not a valid ..typ .. so you have to change to
varchar2(2048)...
the default value has to be bevor the not null statment ...

so it looks like ..


create table nag_tasks (
    task_owner      varchar(255) not null,
    task_id         int not null,
    task_name       varchar(64) not null,
    task_desc       varchar2(2048),                         <<<
    task_modified   int not null,
    task_due        int null,
    task_priority   int default 0 not null ,                 <<<
    task_category   int default 0 not null ,                 <<<
    task_completed  smallint default 0 not null ,            <<<
    task_private    smallint default 1 not null ,            <<<
    primary key (task_owner, task_id)
);

> Warning: Undefined offset: 1 in ../testweb/horde/nag/lib/Nag.php on line
> 89
> Nicht zugeordnet

Looks like maybe your prefs.php file is out of date?


shoud i try from cvs ?


greets

Wolfgang

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"What was and what may be, lie, like children whose faces we cannot see, in
the arms of silence. All we ever have is here, now." - Ursula K. Le Guin
----- End forwarded message -----


-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"What was and what may be, lie, like children whose faces we cannot see, in 
the arms of silence. All we ever have is here, now." - Ursula K. Le Guin