[WebERP-developers] Problems in Tx rollback at CounterSales.php

[webERP D. <web...@li...>]

Hi all:

Due to a wrong change in GL account code to varchar(20) (now fixed and
committed) I was facing some errors at CounterSales.php

Big problem was, it is not performing the rollback properly.

At some point the script tried to update a GL account that did not exist,
and wisely the system stopped and showed a database error 1452: cannot add
or update a child row....

So, the script is supposed to rollback until the DB_tx_Begin, but it did
not and DB was left inconsistent.

Checked and added more error reporting and rollback seems succesful but it
is not.

As example, the INSERT into salesorders and INTO salesorderdetails are left
at the DB, even if some INSERT at gltrans failed.

Could not fix it yet. Anyone faced the same problem?


Regards,
Ricard