I've upgraded to the current ezComponets. PersistentObject is at 1.6.
I have some problems writing data back to the database. In some cases I
get the following a stack trace, as that appended to the end of the
mail. Oracle is complaining that for a given value for a numeric field
is not numeric or a string not parseable as a string.
If I echo the query, as it in persistent_session.php:689, it is
UPDATE "REQUISITION_ITEM" SET "RQI_QTY" = :ezcValue1, "ORP_ID" =
:ezcValue2, "ORS_ID" = :ezcValue3 WHERE
"RQI_ID" = :ezcValue4
and the content of ezcQuery::boundValues is
(
[:ezcValue1] => 3
[:ezcValue2] => 25
[:ezcValue3] => 20
[:ezcValue4] => 41
)
The database table is
CREATE TABLE "PLANTMAP"."REQUISITION_ITEM"
( "RQI_ID" NUMBER(*,0) NOT NULL ENABLE,
"RQI_QTY" NUMBER NOT NULL ENABLE,
"ORP_ID" NUMBER DEFAULT 40,
"ORS_ID" NUMBER DEFAULT 20 NOT NULL ENABLE,
....
)
As said before, for some of the load saves on other objects everything
works fine.
Can anybody give me some hint how diagnose the problem and fix it?
Thanks,
Peter
Stack Trace:
Jul 15 20:07:28 [Error] [default] [default] exception
'ezcPersistentQueryExcepti
on' with message 'A query failed internally in Persistent Object:
SQLSTATE[HY000
]: General error: 1722 OCIStmtExecute: ORA-01722: invalid number
(/root/PDO_OCI-1.0/oci_statement.c:142) Query: 'UPDATE
"REQUISITION_ITEM&q
uot; SET "RQI_QTY" = :ezcValue1, "ORP_ID" =
:ezcValue2, &quo
t;ORS_ID" = :ezcValue3 WHERE "RQI_ID" = :ezcValue4'' in
/usr/shar
e/pear/ezc/PersistentObject/persistent_session.php:712
Stack trace:
#0 /usr/share/pear/ezc/PersistentObject/handlers/save_handler.php(378):
ezcPersi
stentSession->performQuery(Object(ezcQueryUpdate), true)
#1 /usr/share/pear/ezc/PersistentObject/handlers/save_handler.php(107):
ezcPersi
stentSaveHandler->updateInternal(Object(R3PmRequisitionItem), false)
#2 /usr/share/pear/ezc/PersistentObject/persistent_session.php(409):
ezcPersiste
ntSaveHandler->saveOrUpdate(Object(R3PmRequisitionItem))
#3 /data/sites/R3-PlantMap/sito/lib/r3_base.php(1440):
ezcPersistentSession->sav
eOrUpdate(Object(R3PmRequisitionItem))
#4 /data/sites/R3-PlantMap/sito/lib/r3_base.php(1538):
R3BaseController->handleS
tandardAct(Array, '41', Array)
#5 /data/sites/R3-PlantMap/sito/web/admin/edit.php(55):
R3BaseController->handle
Req(Array)
#6 /data/sites/R3-PlantMap/sito/web/admin/edit.php(201):
submitForm('requisition
_ite...', Array)
#7 {main}
--
Dott. Peter Hopfgartner
R3 GIS Srl - GmbH
Via Johann Kravogl-Str. 2
I-39012 Meran/Merano (BZ)
Email: [email protected]
Tel. : +39 0473 494949
Fax : +39 0473 069902
www : http://www.r3-gis.com
--
Components mailing list
[email protected]
http://lists.ez.no/mailman/listinfo/components
