SQL error in ReverseGRN.php
Hi all:
In version 4.13, when the description of the item includes a ' it is not properly formatted and caused the SQL to fail.
Database Error 1064 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: The purchase GL posting could not be inserted for the reversal of the received item because
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's green cat eye&light green 95cm x 12 @ 589,087', '-7069044')' at line 14
Database SQL Failure : The following SQL to insert the purchase GLTrans record was used
INSERT INTO gltrans (type, typeno, trandate, periodno, account, narrative, amount) VALUES ( 25, '21374', '2016-09-20', '90', '111517000', 'GRN Reversal for PO: 2216 GLITTR - CENE12-King's green cat eye&light green 95cm x 12 @ 589,087', '-7069044')
Database Rollback Due to Error Above : Rolling Back Transaction OK
Regards,
Pak Ricard
|