[Web-erp-svn] SF.net SVN: web-erp:[7035] trunk

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

Revision: 7035
          http://sourceforge.net/p/web-erp/reponame/7035
Author:   exsonqu
Date:     2014-12-20 06:55:12 +0000 (Sat, 20 Dec 2014)
Log Message:
-----------
20/12/14 Exson: Make COGSGLPostings.php, SalesGLPostings.php SQL strict mode compatible.

Modified Paths:
--------------
    trunk/COGSGLPostings.php
    trunk/SalesGLPostings.php

Modified: trunk/COGSGLPostings.php
===================================================================
--- trunk/COGSGLPostings.php	2014-12-20 06:30:24 UTC (rev 7034)
+++ trunk/COGSGLPostings.php	2014-12-20 06:55:12 UTC (rev 7035)
@@ -144,11 +144,14 @@
 			$sql = "INSERT INTO accountgroups (	groupname,
 												sectioninaccounts,
 												pandl,
-												sequenceintb )
+												sequenceintb,
+												accountgroups
+										       			)
 										VALUES ('Sales',
 												'1',
 												'1',
-												'10')";
+												'10',
+												' ')";
 
 			$result = DB_query($sql);
 		}

Modified: trunk/SalesGLPostings.php
===================================================================
--- trunk/SalesGLPostings.php	2014-12-20 06:30:24 UTC (rev 7034)
+++ trunk/SalesGLPostings.php	2014-12-20 06:55:12 UTC (rev 7035)
@@ -167,12 +167,14 @@
 					groupname,
 					sectioninaccounts,
 					pandl,
-					sequenceintb
+					sequenceintb,
+					parentgroupname
 				) VALUES (
 					'Sales',
 					1,
 					1,
-					10)";
+					10,
+					' ')";
 
 			$result = DB_query($SQL);
 		}
@@ -431,4 +433,4 @@
 
 
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>