Menu
▾
▴
Re: [WebERP-developers] Problems in Tx rollback at CounterSales.php
|
From: webERP D. <web...@li...> - 2013-05-18 02:21:59
|
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
I can see the db_query() call for inserting the order header did
not have the format:<br>
<br>
DB_query($SQL,$db,$ErrMsg,$DbgMsg,true);<br>
<br>
which it should be to rollback on encountering an error. <br>
<br>
However, this is not on a gl entry which it sounds like your entry
failed on.<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 13:25, webERP Developers wrote:
<blockquote
cite="mid:CAJ...@ma..."
type="cite">Hi Phil:
<div><br>
</div>
<div>All my tables are innodb except those of mrp and the wiki
ones (I think I'm using the default).</div>
<div><br>
</div>
<div>Other scripts that caused errors (as SupplierInvoice,
InternalStockRequestFulfill) seem to do the rollback OK, so I
guess it is something on the CounterSales.php or a DB setting.</div>
<div><br>
</div>
<div>
<div><br>
</div>
<div>Regards,<br>
Ricard</div>
<br>
<br>
<div class="gmail_quote">2013/5/18 webERP Developers <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:web...@li..."
target="_blank">web...@li...</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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 cols="72">Phil
Phil Daintree
Logic Works Ltd - <a moz-do-not-send="true" href="tel:%2B64%20%280%29275%20567890" value="+64275567890" target="_blank">+64 (0)275 567890</a>
<a moz-do-not-send="true" href="http://www.logicworks.co.nz" target="_blank">http://www.logicworks.co.nz</a>
skype:daintree</pre>
<div>
<div class="h5"> <br>
On 18/05/13 11:53, webERP Developers wrote: </div>
</div>
<blockquote type="cite">
<div>
<div class="h5">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></fieldset>
<br>
</div>
</div>
<pre>------------------------------------------------------------------------------
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 moz-do-not-send="true" href="http://p.sf.net/sfu/alienvault_d2d" target="_blank">http://p.sf.net/sfu/alienvault_d2d</a></pre>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Web-erp-developers mailing list
<a moz-do-not-send="true" href="mailto:Web...@li..." target="_blank">Web...@li...</a>
<a moz-do-not-send="true" href="https://lists.sourceforge.net/lists/listinfo/web-erp-developers" target="_blank">https://lists.sourceforge.net/lists/listinfo/web-erp-developers</a>
</pre>
</blockquote>
</div>
<br>
------------------------------------------------------------------------------<br>
AlienVault Unified Security Management (USM) platform
delivers complete<br>
security visibility with the essential security
capabilities. Easily and<br>
efficiently configure, manage, and operate all of your
security controls<br>
from a single console and one unified framework. Download a
free trial.<br>
<a moz-do-not-send="true"
href="http://p.sf.net/sfu/alienvault_d2d" target="_blank">http://p.sf.net/sfu/alienvault_d2d</a><br>
_______________________________________________<br>
Web-erp-developers mailing list<br>
<a moz-do-not-send="true"
href="mailto:Web...@li...">Web...@li...</a><br>
<a moz-do-not-send="true"
href="https://lists.sourceforge.net/lists/listinfo/web-erp-developers"
target="_blank">https://lists.sourceforge.net/lists/listinfo/web-erp-developers</a><br>
<br>
</blockquote>
</div>
<br>
</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>
|
