[Web-erp-svn] SF.net SVN: web-erp:[6542] trunk/StockTransfers.php

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

Revision: 6542
          http://sourceforge.net/p/web-erp/reponame/6542
Author:   exsonqu
Date:     2014-01-16 06:12:51 +0000 (Thu, 16 Jan 2014)
Log Message:
-----------
16/01/14 Exson: Fixed sql strict mode failure problem in StockTransfers.php by adding a '' to qualitytext fields.

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

Modified: trunk/StockTransfers.php
===================================================================
--- trunk/StockTransfers.php	2014-01-15 06:28:12 UTC (rev 6541)
+++ trunk/StockTransfers.php	2014-01-16 06:12:51 UTC (rev 6542)
@@ -395,12 +395,14 @@
 														loccode,
 														serialno,
 														expirationdate,
-														quantity)
+														quantity,
+														qualitytext)
 						VALUES ('" . $_SESSION['Transfer']->TransferItem[0]->StockID . "',
 								'" . $_SESSION['Transfer']->StockLocationTo . "',
 								'" . $Item->BundleRef . "',
 								'" . FormatDateForSQL($Item->ExpiryDate) . "',
-								'" . $Item->BundleQty . "')";
+								'" . $Item->BundleQty . "',
+								'')";
 
 					$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The serial stock item record could not be added because');
 					$DbgMsg = _('The following SQL to insert the serial stock item record was used:');