MDB2 ibase Reverse: strange case problem

Hi,

after switching from DB to MDB2 within DB_DataObject I run into this error:

Fatal error: Cannot use object of type MDB2_Error as array
in /usr/share/php/DB/DataObject/Generator.php on line 262

Digging in the code, I've tracked the error to MDB2/Driver/Reverse/ibase.php:

if (!$index['unique_flag'] && !$index['foreign_key']) {

return $db->raiseError(MDB2_ERROR_NOT_FOUND, null, null,
'it was not specified an existing table constraint',
__FUNCTION__);
}


The error is triggered by $index keys being uppercase while the check
for 'unique_flag' and 'foreign_key' is lower case, there are some instruction
to set $fields keys to lower case but no options to lower case the $index
too.

Is this a bug in ibase.php or something wrong with my setup?


--
Alessandro Pasotti
itOpen - "Open Solutions for the Net Age"
w3: www.itopen.it
Linux User# 167502

Ciao Alessandro,

> after switching from DB to MDB2 within DB_DataObject I run into this error:
>
> Fatal error: Cannot use object of type MDB2_Error as array
> in /usr/share/php/DB/DataObject/Generator.php on line 262
>
> Digging in the code, I've tracked the error to MDB2/Driver/Reverse/ibase.php:
>
> if (!$index['unique_flag'] && !$index['foreign_key']) {
>
> return $db->raiseError(MDB2_ERROR_NOT_FOUND, null, null,
> 'it was not specified an existing table constraint',
> __FUNCTION__);
> }
>
>
> The error is triggered by $index keys being uppercase while the check
> for 'unique_flag' and 'foreign_key' is lower case, there are some instruction
> to set $fields keys to lower case but no options to lower case the $index
> too.

can you try the CVS version?
AFAICS, this issue should not happen in
the latest revision.

--
Lorenzo Alberton
http://pear.php.net/user/quipo
__________________________________________________ _________________
Quipo Free Internet - 2 email, 150 Mb di spazio web e molto di più.
ADSL, Hardware & Software Online Store

Il 16:00, mercoledì 2 maggio 2007, Lorenzo Alberton ha scritto:
> Ciao Alessandro,
>
> > after switching from DB to MDB2 within DB_DataObject I run into this
> > error:
> >
> > Fatal error: Cannot use object of type MDB2_Error as array
> > in /usr/share/php/DB/DataObject/Generator.php on line 262
> >
> > Digging in the code, I've tracked the error to
> > MDB2/Driver/Reverse/ibase.php:
> >
> > if (!$index['unique_flag'] && !$index['foreign_key']) {
> >
> > return $db->raiseError(MDB2_ERROR_NOT_FOUND, null, null,
> > 'it was not specified an existing table constraint',
> > __FUNCTION__);
> > }
> >
> >
> > The error is triggered by $index keys being uppercase while the check
> > for 'unique_flag' and 'foreign_key' is lower case, there are some
> > instruction to set $fields keys to lower case but no options to lower
> > case the $index too.
>
> can you try the CVS version?
> AFAICS, this issue should not happen in
> the latest revision.

Now testing the latest CVS, I have another error (note that everything works
with DB instead of MDB2).

Error message: 'APPALTI_UF_OPER_T_IDX1' is not an existing table constraint

this comes from line 365 in Reverse/ibase.php.

The index APPALTI_UF_OPER_T_IDX1 does not exists.

Any hint on how to debug this?
A dump of $lastrow is:

array(6) {
["field_name"]=>
string(5) "IDSAL"
["unique_flag"]=>
int(0)
["foreign_key"]=>
NULL
["description"]=>
NULL
["constraint_type"]=>
NULL
["field_position"]=>
string(1) "1"
}


--
Alessandro Pasotti
itOpen - "Open Solutions for the Net Age"
w3: www.itopen.it
Linux User# 167502

Alessandro Pasotti wrote:
>> can you try the CVS version?
>> AFAICS, this issue should not happen in
>> the latest revision.
>
> Now testing the latest CVS, I have another error (note that everything works
> with DB instead of MDB2).
>
> Error message: 'APPALTI_UF_OPER_T_IDX1' is not an existing table constraint
>
> this comes from line 365 in Reverse/ibase.php.
> The index APPALTI_UF_OPER_T_IDX1 does not exists.
> Any hint on how to debug this?

if you pass an index name to getTableConstraintDefinition(),
you'll get a "XXX is not an existing table constraint"
error.

Similarly, if you pass a constraint name to getTableIndexDefinition(),
you'll get a "it was not specified an existing table index" error.

getTableConstraintDefinition() will only return
a CONSTRAINT, and getTableIndexDefinition() will
only return an INDEX.

Now, I don't know if that's your case
and if it explains your error.
If not, can you send me the table DDL
and a short reproducing script?

TIA

Cheers,
--
Lorenzo Alberton
http://pear.php.net/user/quipo
__________________________________________________ _________________
Quipo Free Internet - 2 email, 150 Mb di spazio web e molto di più.
ADSL, Hardware & Software Online Store