[Web-erp-svn] SF.net SVN: web-erp:[7001] trunk/Credit_Invoice.php

[<ex...@us...>]

Revision: 7001
          http://sourceforge.net/p/web-erp/reponame/7001
Author:   exsonqu
Date:     2014-11-22 05:29:23 +0000 (Sat, 22 Nov 2014)
Log Message:
-----------
22/11/14 Exson: Fix the qualitytext does not have default value for strict sql mode in Credit_Invoice.php.

Modified Paths:
--------------
    trunk/Credit_Invoice.php

Modified: trunk/Credit_Invoice.php
===================================================================
--- trunk/Credit_Invoice.php	2014-11-22 02:40:09 UTC (rev 7000)
+++ trunk/Credit_Invoice.php	2014-11-22 05:29:23 UTC (rev 7001)
@@ -942,12 +942,14 @@
 							$SQL = "INSERT INTO stockserialitems (stockid,
 																	loccode,
 																	serialno,
-																	quantity)
+																	quantity,
+																	qualitytext)
 											VALUES
 														('" . $CreditLine->StockID . "',
 														 '" . $_SESSION['CreditItems' . $identifier]->Location . "',
 														 '" . $Item->BundleRef . "',
-														 '". $Item->BundleQty ."')";
+														 '". $Item->BundleQty ."',
+													 	 '')";
 
 							$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock item record could not be updated because');
 							$DbgMsg = _('The following SQL to update the serial stock item record was used');
@@ -1607,4 +1609,4 @@
 echo '</div>';
 echo '</form>';
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>