Menu
▾
▴
Re: [WebERP-developers] Problems in Tx rollback at CounterSales.php
|
From: webERP D. <web...@li...> - 2013-05-18 00:40:34
|
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Sounds silly - but I have come accross some installations using
myisam tables not innodb - I suspect this is not the issue but just
in case - can you please confirm.<br>
<br>
Thanks <br>
<pre class="moz-signature" cols="72">Phil
Phil Daintree
Logic Works Ltd - +64 (0)275 567890
<a class="moz-txt-link-freetext" href="http://www.logicworks.co.nz">http://www.logicworks.co.nz</a>
skype:daintree</pre>
<br>
On 18/05/13 11:53, webERP Developers wrote:
<blockquote
cite="mid:CAJ...@ma..."
type="cite">Hi all:
<div><br>
</div>
<div>Due to a wrong change in GL account code to varchar(20) (now
fixed and committed) I was facing some errors at
CounterSales.php</div>
<div><br>
</div>
<div>Big problem was, it is not performing the rollback properly.</div>
<div><br>
</div>
<div>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.... </div>
<div><br>
</div>
<div>
So, the script is supposed to rollback until the DB_tx_Begin,
but it did not and DB was left inconsistent.</div>
<div><br>
</div>
<div>Checked and added more error reporting and rollback seems
succesful but it is not.</div>
<div>
<br>
</div>
<div>As example, the INSERT into salesorders and INTO
salesorderdetails are left at the DB, even if some INSERT at
gltrans failed.</div>
<div><br>
</div>
<div>Could not fix it yet. Anyone faced the same problem?</div>
<div><br>
</div>
<div><br clear="all">
<div>Regards,<br>
Ricard</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
<a class="moz-txt-link-freetext" href="http://p.sf.net/sfu/alienvault_d2d">http://p.sf.net/sfu/alienvault_d2d</a></pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Web-erp-developers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Web...@li...">Web...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/web-erp-developers">https://lists.sourceforge.net/lists/listinfo/web-erp-developers</a>
</pre>
</blockquote>
</body>
</html>
|
