Quantcast

weberp AuditTrail.php display misleading information

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

weberp AuditTrail.php display misleading information

gsavix


Hi. after make some retrieval for audit on weberp current version, i could find that in some cases when
column contains SET, WHERE, AND, DELETE, FROM these contents is replaced with blanks on AuditTrail functions at  [1] and/or [2].

these fragment of query should explain content of table audittrail columns and contents (json format)

{"transactiondate":"2016-08-30 16:16:04","userid":"gsavix","querystring":"UPDATE stockmaster\n\t\t\t\t\t\tSET longdescription='CAMISETA POLO FEM VERMELHA P',\n\t\t\t\t\t\t\tdescription='CAMISETA POLO FEM VERMELHA P',\n\t\t\t\t\t\t\tdiscontinued='0',\n\t\t\t\t\t\t\tcontrolled='0',\n\t\t\t\t\t\t\tserialised='0',\n\t\t\t\t\t\t\tperishable='0',\n\t\t\t\t\t\t\tcategoryid='PETA',\n\t\t\t\t\t\t\tunits='UN',\n\t\t\t\t\t\t\tmbflag='B',\n\t\t\t\t\t\t\teoq='0',\n\t\t\t\t\t\t\tvolume='0.0000',\n\t\t\t\t\t\t\tgrossweight='0.0000',\n\t\t\t\t\t\t\tnetweight='0.0000',\n\t\t\t\t\t\t\tbarcode='',\n\t\t\t\t\t\t\tdiscountcategory='',\n\t\t\t\t\t\t\ttaxcatid='6',\n\t\t\t\t\t\t\tdecimalplaces='2',\n\t\t\t\t\t\t\tshrinkfactor='0',\n\t\t\t\t\t\t\tpansize='0',\n\t\t\t\t\t\t\tnextserialno='0'\n\t\t\t\t\tWHERE stockid='CPFE0314'"}

AuditTrail.php shows column description like ='CAMIA POLO FEM VERMELHA P' cause 
is
...
function UpdateQueryInfo [1] that replace 

'CAMISETA' by 'CAMIA' 

that is clearly not intended.

Please should I open one ticket or someone could change this.

thanks!










------------------------------------------------------------------------------

_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: weberp AuditTrail.php display misleading information

ExsonQu
Administrator
       yah. It missed this condition.
Loading...