|
From: <dai...@us...> - 2014-10-27 07:15:47
|
Revision: 6944
http://sourceforge.net/p/web-erp/reponame/6944
Author: daintree
Date: 2014-10-27 07:15:34 +0000 (Mon, 27 Oct 2014)
Log Message:
-----------
removed all $db from DB_error_msg($db) calls
Modified Paths:
--------------
trunk/AgedDebtors.php
trunk/AgedSuppliers.php
trunk/BOMExtendedQty.php
trunk/BOMIndented.php
trunk/BOMIndentedReverse.php
trunk/CustomerReceipt.php
trunk/CustomerTransInquiry.php
trunk/DailySalesInquiry.php
trunk/Dashboard.php
trunk/DebtorsAtPeriodEnd.php
trunk/GLBalanceSheet.php
trunk/GLProfit_Loss.php
trunk/GLTagProfit_Loss.php
trunk/GLTrialBalance.php
trunk/InventoryPlanning.php
trunk/InventoryPlanningPrefSupplier.php
trunk/InventoryQuantities.php
trunk/InventoryValuation.php
trunk/MRPPlannedPurchaseOrders.php
trunk/MRPPlannedWorkOrders.php
trunk/MRPReschedules.php
trunk/MRPShortages.php
trunk/MailInventoryValuation.php
trunk/OutstandingGRNs.php
trunk/PDFCustomerList.php
trunk/PDFLowGP.php
trunk/PDFPriceList.php
trunk/PDFPrintLabel.php
trunk/PDFRemittanceAdvice.php
trunk/PDFSellThroughSupportClaim.php
trunk/PDFStockCheckComparison.php
trunk/PO_Items.php
trunk/Prices_Customer.php
trunk/PurchaseByPrefSupplier.php
trunk/ReorderLevel.php
trunk/SalesByTypePeriodInquiry.php
trunk/SalesCategoryPeriodInquiry.php
trunk/SalesGraph.php
trunk/SalesTopCustomersInquiry.php
trunk/SalesTopItemsInquiry.php
trunk/SelectCompletedOrder.php
trunk/ShipmentCosting.php
trunk/Shipments.php
trunk/Shipt_Select.php
trunk/ShiptsList.php
trunk/StockCheck.php
trunk/StockDispatch.php
trunk/StockUsage.php
trunk/StockUsageGraph.php
trunk/SuppPaymentRun.php
trunk/SuppPriceList.php
trunk/SupplierBalsAtPeriodEnd.php
trunk/SupplierTransInquiry.php
trunk/Tax.php
trunk/UpgradeDatabase.php
trunk/Z_DataExport.php
trunk/api/api_session.inc
trunk/doc/Change.log
trunk/includes/ConnectDB_mysql.inc
trunk/includes/ConnectDB_postgres.inc
trunk/includes/FreightCalculation.inc
trunk/includes/PDFPaymentRun_PymtFooter.php
Modified: trunk/AgedDebtors.php
===================================================================
--- trunk/AgedDebtors.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/AgedDebtors.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -266,7 +266,7 @@
if (DB_error_no() !=0) {
$Title = _('Aged Customer Account Analysis') . ' - ' . _('Problem Report') . '.... ';
include('includes/header.inc');
- prnMsg(_('The customer details could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg(_('The customer details could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -368,7 +368,7 @@
if (DB_error_no() !=0) {
$Title = _('Aged Customer Account Analysis') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg(_('The details of outstanding transactions for customer') . ' - ' . $AgedAnalysis['debtorno'] . ' ' . _('could not be retrieved because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The details of outstanding transactions for customer') . ' - ' . $AgedAnalysis['debtorno'] . ' ' . _('could not be retrieved because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . '<br />' . $sql;
Modified: trunk/AgedSuppliers.php
===================================================================
--- trunk/AgedSuppliers.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/AgedSuppliers.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -107,7 +107,7 @@
if (DB_error_no() !=0) {
$Title = _('Aged Supplier Account Analysis') . ' - ' . _('Problem Report') ;
include('includes/header.inc');
- prnMsg(_('The Supplier details could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg(_('The Supplier details could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -194,7 +194,7 @@
if (DB_error_no() !=0) {
$Title = _('Aged Supplier Account Analysis - Problem Report');
include('includes/header.inc');
- prnMsg(_('The details of outstanding transactions for Supplier') . ' - ' . $AgedAnalysis['supplierid'] . ' ' . _('could not be retrieved because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The details of outstanding transactions for Supplier') . ' - ' . $AgedAnalysis['supplierid'] . ' ' . _('could not be retrieved because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . '<br />' . $sql;
Modified: trunk/BOMExtendedQty.php
===================================================================
--- trunk/BOMExtendedQty.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/BOMExtendedQty.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -153,7 +153,7 @@
if (DB_error_no() !=0) {
$Title = _('Quantity Extended BOM Listing') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The Quantiy Extended BOM Listing could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The Quantiy Extended BOM Listing could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
Modified: trunk/BOMIndented.php
===================================================================
--- trunk/BOMIndented.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/BOMIndented.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -151,7 +151,7 @@
if (DB_error_no() !=0) {
$Title = _('Indented BOM Listing') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The Indented BOM Listing could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The Indented BOM Listing could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
Modified: trunk/BOMIndentedReverse.php
===================================================================
--- trunk/BOMIndentedReverse.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/BOMIndentedReverse.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -139,7 +139,7 @@
if (DB_error_no() !=0) {
$Title = _('Indented BOM Listing') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The Indented BOM Listing could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The Indented BOM Listing could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br />
<a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
Modified: trunk/CustomerReceipt.php
===================================================================
--- trunk/CustomerReceipt.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/CustomerReceipt.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -636,7 +636,7 @@
$CustomerSearchResult = DB_query($SQL,'','',false,false);
if (DB_error_no() !=0) {
- prnMsg(_('The searched customer records requested cannot be retrieved because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The searched customer records requested cannot be retrieved because') . ' - ' . DB_error_msg(),'error');
if ($debug==1){
prnMsg(_('SQL used to retrieve the customer details was') . '<br />' . $sql,'error');
}
Modified: trunk/CustomerTransInquiry.php
===================================================================
--- trunk/CustomerTransInquiry.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/CustomerTransInquiry.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -93,7 +93,7 @@
}
$sql .= " ORDER BY id";
- $ErrMsg = _('The customer transactions for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg($db);
+ $ErrMsg = _('The customer transactions for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg();
$DbgMsg = _('The SQL that failed was');
$TransResult = DB_query($sql,$ErrMsg,$DbgMsg);
Modified: trunk/DailySalesInquiry.php
===================================================================
--- trunk/DailySalesInquiry.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/DailySalesInquiry.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -107,7 +107,7 @@
}
$sql .= " GROUP BY stockmoves.trandate ORDER BY stockmoves.trandate";
-$ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg($db);
+$ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg();
$SalesResult = DB_query($sql,$ErrMsg);
echo '<table class="selection">
Modified: trunk/Dashboard.php
===================================================================
--- trunk/Dashboard.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/Dashboard.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -142,7 +142,7 @@
$CustomerResult = DB_query($SQL,'','',False,False); /*dont trap errors handled below*/
if (DB_error_no() !=0) {
- prnMsg(_('The customer details could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg(_('The customer details could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -253,7 +253,7 @@
$DetailResult = DB_query($sql,'','',False,False);
if (DB_error_no() !=0) {
- prnMsg(_('The details of outstanding transactions for customer') . ' - ' . $AgedAnalysis['debtorno'] . ' ' . _('could not be retrieved because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The details of outstanding transactions for customer') . ' - ' . $AgedAnalysis['debtorno'] . ' ' . _('could not be retrieved because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . '<br />' . $sql;
@@ -419,7 +419,7 @@
$TransResult = DB_query($sql,'','',false,false);
if (DB_error_no() !=0) {
- prnMsg(_('The details of supplier invoices due could not be retrieved because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The details of supplier invoices due could not be retrieved because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . ' ' . $sql;
Modified: trunk/DebtorsAtPeriodEnd.php
===================================================================
--- trunk/DebtorsAtPeriodEnd.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/DebtorsAtPeriodEnd.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -56,7 +56,7 @@
if (DB_error_no() !=0) {
$Title = _('Customer Balances') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg(_('The customer details could not be retrieved by the SQL because') . DB_error_msg($db),'error');
+ prnMsg(_('The customer details could not be retrieved by the SQL because') . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/GLBalanceSheet.php
===================================================================
--- trunk/GLBalanceSheet.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/GLBalanceSheet.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -107,7 +107,7 @@
if (DB_error_no() !=0) {
$Title = _('Balance Sheet') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The accumulated profits brought forward could not be calculated by the SQL because') . ' - ' . DB_error_msg($db) );
+ prnMsg( _('The accumulated profits brought forward could not be calculated by the SQL because') . ' - ' . DB_error_msg() );
echo '<br />
<a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1){
@@ -146,7 +146,7 @@
if (DB_error_no() !=0) {
$Title = _('Balance Sheet') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('No general ledger accounts were returned by the SQL because') . ' - ' . DB_error_msg($db) );
+ prnMsg( _('No general ledger accounts were returned by the SQL because') . ' - ' . DB_error_msg() );
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/GLProfit_Loss.php
===================================================================
--- trunk/GLProfit_Loss.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/GLProfit_Loss.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -184,7 +184,7 @@
if (DB_error_no() != 0) {
$Title = _('Profit and Loss') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('No general ledger accounts were returned by the SQL because') . ' - ' . DB_error_msg($db) );
+ prnMsg( _('No general ledger accounts were returned by the SQL because') . ' - ' . DB_error_msg() );
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug == 1){
echo '<br />' . $SQL;
Modified: trunk/GLTagProfit_Loss.php
===================================================================
--- trunk/GLTagProfit_Loss.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/GLTagProfit_Loss.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -193,7 +193,7 @@
if (DB_error_no() != 0) {
$Title = _('Income and Expenditure') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('No general ledger accounts were returned by the SQL because') . ' - ' . DB_error_msg($db) );
+ prnMsg( _('No general ledger accounts were returned by the SQL because') . ' - ' . DB_error_msg() );
echo '<br />
<a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug == 1){
Modified: trunk/GLTrialBalance.php
===================================================================
--- trunk/GLTrialBalance.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/GLTrialBalance.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -164,7 +164,7 @@
$ViewTopic = 'GeneralLedger';
$BookMark = 'TrialBalance';
include('includes/header.inc');
- prnMsg( _('No general ledger accounts were returned by the SQL because') . ' - ' . DB_error_msg($db) );
+ prnMsg( _('No general ledger accounts were returned by the SQL because') . ' - ' . DB_error_msg() );
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/InventoryPlanning.php
===================================================================
--- trunk/InventoryPlanning.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/InventoryPlanning.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -104,7 +104,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Planning') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg(_('The inventory quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The inventory quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -181,7 +181,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Planning') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The sales quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The sales quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' .$SQL;
@@ -218,7 +218,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Planning') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The sales order demand quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The sales order demand quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -267,7 +267,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Planning') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The sales order demand quantities from parent assemblies could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The sales order demand quantities from parent assemblies could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/InventoryPlanningPrefSupplier.php
===================================================================
--- trunk/InventoryPlanningPrefSupplier.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/InventoryPlanningPrefSupplier.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -182,7 +182,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Planning') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg(_('The inventory quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The inventory quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -240,7 +240,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Planning') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The sales quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The sales quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -267,7 +267,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Planning') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The sales order demand quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The sales order demand quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -300,7 +300,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Planning') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The sales order demand quantities from parent assemblies could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The sales order demand quantities from parent assemblies could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/InventoryQuantities.php
===================================================================
--- trunk/InventoryQuantities.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/InventoryQuantities.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -83,7 +83,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Quantities') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The Inventory Quantity report could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The Inventory Quantity report could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
Modified: trunk/InventoryValuation.php
===================================================================
--- trunk/InventoryValuation.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/InventoryValuation.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -69,7 +69,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Valuation') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The inventory valuation could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The inventory valuation could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/MRPPlannedPurchaseOrders.php
===================================================================
--- trunk/MRPPlannedPurchaseOrders.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/MRPPlannedPurchaseOrders.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -113,7 +113,7 @@
if (DB_error_no() !=0) {
$Title = _('MRP Planned Purchase Orders') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The MRP planned purchase orders could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The MRP planned purchase orders could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
Modified: trunk/MRPPlannedWorkOrders.php
===================================================================
--- trunk/MRPPlannedWorkOrders.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/MRPPlannedWorkOrders.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -105,7 +105,7 @@
if (DB_error_no() !=0) {
$Title = _('MRP Planned Work Orders') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The MRP planned work orders could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The MRP planned work orders could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
Modified: trunk/MRPReschedules.php
===================================================================
--- trunk/MRPReschedules.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/MRPReschedules.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -44,7 +44,7 @@
if (DB_error_no() !=0) {
$Title = _('MRP Reschedules') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The MRP reschedules could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The MRP reschedules could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
Modified: trunk/MRPShortages.php
===================================================================
--- trunk/MRPShortages.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/MRPShortages.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -154,7 +154,7 @@
if (DB_error_no() !=0) {
$Title = _('MRP Shortages and Excesses') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The MRP shortages and excesses could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The MRP shortages and excesses could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br/><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br/>' . $sql;
Modified: trunk/MailInventoryValuation.php
===================================================================
--- trunk/MailInventoryValuation.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/MailInventoryValuation.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -118,7 +118,7 @@
if (DB_error_no() !=0) {
$Title = _('Inventory Valuation') . ' - ' . _('Problem Report');
include('includes/header.inc');
- echo _('The inventory valuation could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db);
+ echo _('The inventory valuation could not be retrieved by the SQL because') . ' - ' . DB_error_msg();
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/OutstandingGRNs.php
===================================================================
--- trunk/OutstandingGRNs.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/OutstandingGRNs.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -45,7 +45,7 @@
if (DB_error_no() !=0) {
$Title = _('Outstanding GRN Valuation') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg(_('The outstanding GRNs valuation details could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The outstanding GRNs valuation details could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
/*
if ($debug==1){
Modified: trunk/PDFCustomerList.php
===================================================================
--- trunk/PDFCustomerList.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/PDFCustomerList.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -231,7 +231,7 @@
if (DB_error_no() !=0) {
$Title = _('Customer List') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The customer List could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db) );
+ prnMsg( _('The customer List could not be retrieved by the SQL because') . ' - ' . DB_error_msg() );
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/PDFLowGP.php
===================================================================
--- trunk/PDFLowGP.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/PDFLowGP.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -55,7 +55,7 @@
if (DB_error_no() !=0) {
include('includes/header.inc');
- prnMsg(_('The low GP items could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The low GP items could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/PDFPriceList.php
===================================================================
--- trunk/PDFPriceList.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/PDFPriceList.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -150,7 +150,7 @@
if (DB_error_no() !=0) {
$Title = _('Price List') . ' - ' . _('Problem Report....');
include('includes/header.inc');
- prnMsg( _('The Price List could not be retrieved by the SQL because'). ' - ' . DB_error_msg($db), 'error');
+ prnMsg( _('The Price List could not be retrieved by the SQL because'). ' - ' . DB_error_msg(), 'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1) {
prnMsg(_('For debugging purposes the SQL used was:') . $SQL,'error');
Modified: trunk/PDFPrintLabel.php
===================================================================
--- trunk/PDFPrintLabel.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/PDFPrintLabel.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -41,7 +41,7 @@
$LabelsResult = DB_query($SQL,'','',false,false);
if (DB_error_no() !=0) {
- prnMsg( _('The Price Labels could not be retrieved by the SQL because'). ' - ' . DB_error_msg($db), 'error');
+ prnMsg( _('The Price Labels could not be retrieved by the SQL because'). ' - ' . DB_error_msg(), 'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1){
prnMsg(_('For debugging purposes the SQL used was:') . $SQL,'error');
Modified: trunk/PDFRemittanceAdvice.php
===================================================================
--- trunk/PDFRemittanceAdvice.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/PDFRemittanceAdvice.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -79,7 +79,7 @@
if (DB_error_no() !=0) {
$Title = _('Remittance Advice Problem Report');
include('includes/header.inc');
- prnMsg(_('The details of the payment to the supplier could not be retrieved because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The details of the payment to the supplier could not be retrieved because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . ' ' . $sql;
Modified: trunk/PDFSellThroughSupportClaim.php
===================================================================
--- trunk/PDFSellThroughSupportClaim.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/PDFSellThroughSupportClaim.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -70,7 +70,7 @@
if (DB_error_no() !=0) {
include('includes/header.inc');
- prnMsg(_('The sell through support items to claim could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The sell through support items to claim could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/PDFStockCheckComparison.php
===================================================================
--- trunk/PDFStockCheckComparison.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/PDFStockCheckComparison.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -33,7 +33,7 @@
$Title = _('Stock Freeze') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
echo '<br />';
- prnMsg( _('The inventory check file could not be retrieved because'). ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The inventory check file could not be retrieved because'). ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
@@ -59,7 +59,7 @@
$Title = _('Stock Count Comparison') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
echo '<br />';
- prnMsg( _('The inventory counts file could not be retrieved because'). ' - ' . DB_error_msg($db). 'error');
+ prnMsg( _('The inventory counts file could not be retrieved because'). ' - ' . DB_error_msg(). 'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
@@ -265,7 +265,7 @@
$Title = _('Inventory Comparison') . ' - ' . _('Problem Report') . '.... ';
include('includes/header.inc');
echo '<br />';
- prnMsg( _('The inventory counts could not be retrieved by the SQL because').' - ' . DB_error_msg($db), 'error');
+ prnMsg( _('The inventory counts could not be retrieved by the SQL because').' - ' . DB_error_msg(), 'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/PO_Items.php
===================================================================
--- trunk/PO_Items.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/PO_Items.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -453,7 +453,7 @@
$GLValidResult = DB_query($sql,$ErrMsg,$DbgMsg,false,false);
if (DB_error_no() !=0) {
$AllowUpdate = false;
- prnMsg( _('The validation process for the GL Code entered could not be executed because') . ' ' . DB_error_msg($db), 'error');
+ prnMsg( _('The validation process for the GL Code entered could not be executed because') . ' ' . DB_error_msg(), 'error');
if ($debug==1){
prnMsg (_('The SQL used to validate the code entered was') . ' ' . $sql,'error');
}
Modified: trunk/Prices_Customer.php
===================================================================
--- trunk/Prices_Customer.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/Prices_Customer.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -153,9 +153,9 @@
$result = DB_query($sql,'','',false,false);
if (DB_error_no()!=0){
If ($msg==_('Price Updated')){
- $msg = _('The price could not be updated because') . ' - ' . DB_error_msg($db);
+ $msg = _('The price could not be updated because') . ' - ' . DB_error_msg();
} else {
- $msg = _('The price could not be added because') . ' - ' . DB_error_msg($db);
+ $msg = _('The price could not be added because') . ' - ' . DB_error_msg();
}
}else {
ReSequenceEffectiveDates ($Item, $SalesType, $CurrCode, $_SESSION['CustomerID'], $db);
Modified: trunk/PurchaseByPrefSupplier.php
===================================================================
--- trunk/PurchaseByPrefSupplier.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/PurchaseByPrefSupplier.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -398,7 +398,7 @@
if (DB_error_no() !=0) {
$Title = _('Supplier Ordering') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg(_('The supplier inventory quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The supplier inventory quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -446,7 +446,7 @@
if (DB_error_no() !=0) {
$Title = _('Preferred supplier purchasing') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The sales quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The sales quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />'. $SQL;
@@ -470,7 +470,7 @@
if (DB_error_no() !=0) {
$Title = _('Preferred supplier purchasing') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The sales order demand quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The sales order demand quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />'.$SQL;
@@ -499,7 +499,7 @@
if (DB_error_no() !=0) {
$Title = _('Preferred supplier purchasing') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The sales order demand quantities from parent assemblies could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The sales order demand quantities from parent assemblies could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />'.$SQL;
@@ -530,7 +530,7 @@
if (DB_error_no() !=0) {
$Title = _('Preferred supplier purchasing') . ' - ' . _('Problem Report') . '....';
include('includes/header.inc');
- prnMsg( _('The purchase order quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg( _('The purchase order quantities could not be retrieved by the SQL because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />'. $SQL;
Modified: trunk/ReorderLevel.php
===================================================================
--- trunk/ReorderLevel.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/ReorderLevel.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -59,7 +59,7 @@
if (DB_error_no() !=0) {
$Title = _('Reorder Level') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The Reorder Level report could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The Reorder Level report could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
Modified: trunk/SalesByTypePeriodInquiry.php
===================================================================
--- trunk/SalesByTypePeriodInquiry.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SalesByTypePeriodInquiry.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -345,7 +345,7 @@
break;
}
- $ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg($db);
+ $ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg();
$SalesResult = DB_query($sql,$ErrMsg);
Modified: trunk/SalesCategoryPeriodInquiry.php
===================================================================
--- trunk/SalesCategoryPeriodInquiry.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SalesCategoryPeriodInquiry.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -155,7 +155,7 @@
GROUP BY stockmaster.categoryid
ORDER BY netsalesvalue DESC";
- $ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg($db);
+ $ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg();
$SalesResult = DB_query($sql,$ErrMsg);
echo '<table cellpadding="2" class="selection">';
Modified: trunk/SalesGraph.php
===================================================================
--- trunk/SalesGraph.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SalesGraph.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -296,7 +296,7 @@
$SalesResult = DB_query($SQL);
if (DB_error_no() !=0) {
- prnMsg(_('The sales graph data for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The sales graph data for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg(),'error');
include('includes/footer.inc');
exit;
}
Modified: trunk/SalesTopCustomersInquiry.php
===================================================================
--- trunk/SalesTopCustomersInquiry.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SalesTopCustomersInquiry.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -204,7 +204,7 @@
}
}
- $ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg($db);
+ $ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg();
$SalesResult = DB_query($sql,$ErrMsg);
Modified: trunk/SalesTopItemsInquiry.php
===================================================================
--- trunk/SalesTopItemsInquiry.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SalesTopItemsInquiry.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -209,7 +209,7 @@
}
}
- $ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg($db);
+ $ErrMsg = _('The sales data could not be retrieved because') . ' - ' . DB_error_msg();
$SalesResult = DB_query($sql,$ErrMsg);
Modified: trunk/SelectCompletedOrder.php
===================================================================
--- trunk/SelectCompletedOrder.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SelectCompletedOrder.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -421,7 +421,7 @@
$SalesOrdersResult = DB_query($SQL);
if (DB_error_no() !=0) {
- prnMsg( _('No orders were returned by the SQL because') . ' ' . DB_error_msg($db), 'info');
+ prnMsg( _('No orders were returned by the SQL because') . ' ' . DB_error_msg(), 'info');
echo '<br /> ' . $SQL;
}
Modified: trunk/ShipmentCosting.php
===================================================================
--- trunk/ShipmentCosting.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/ShipmentCosting.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -429,7 +429,7 @@
'" . _('Shipment of') . ' ' . $myrow['itemcode'] . " " . _('cost was') . ' ' . $StdCostUnit . ' ' . _('changed to') . ' ' . locale_number_format($ItemShipmentCost,$_SESSION['CompanyRecord']['decimalplaces']) . ' x ' . _('QOH of') . ' ' . $QOH . "',
" . -$ValueOfChange . ")";
- $ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The GL credit for the shipment stock cost adjustment posting could not be inserted because'). ' ' . DB_error_msg($db);
+ $ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The GL credit for the shipment stock cost adjustment posting could not be inserted because'). ' ' . DB_error_msg();
$Result = DB_query($SQL, $ErrMsg,'',TRUE);
@@ -448,7 +448,7 @@
'" . _('Shipment of') . ' ' . $myrow['itemcode'] . ' ' . _('cost was') . ' ' . $StdCostUnit . ' ' . _('changed to') . ' ' . locale_number_format($ItemShipmentCost,$_SESSION['CompanyRecord']['decimalplaces']) . ' x ' . _('QOH of') . ' ' . $QOH . "',
" . $ValueOfChange . ")";
- $ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The GL debit for stock cost adjustment posting could not be inserted because') .' '. DB_error_msg($db);
+ $ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The GL debit for stock cost adjustment posting could not be inserted because') .' '. DB_error_msg();
$Result = DB_query($SQL, $ErrMsg,'',TRUE);
@@ -462,7 +462,7 @@
lastcostupdate='" . Date('Y-m-d') . "'
WHERE stockid='" . $myrow['itemcode'] . "'";
- $ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The shipment cost details for the stock item could not be updated because'). ': ' . DB_error_msg($db);
+ $ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The shipment cost details for the stock item could not be updated because'). ': ' . DB_error_msg();
$result = DB_query($sql, $ErrMsg,'',TRUE);
Modified: trunk/Shipments.php
===================================================================
--- trunk/Shipments.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/Shipments.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -99,7 +99,7 @@
INNER JOIN purchorders
ON purchorderdetails.orderno=purchorders.orderno
WHERE purchorderdetails.shiptref='" . $_GET['SelectedShipment'] . "'";
- $ErrMsg = _('The lines on the shipment cannot be retrieved because'). ' - ' . DB_error_msg($db);
+ $ErrMsg = _('The lines on the shipment cannot be retrieved because'). ' - ' . DB_error_msg();
$LineItemsResult = DB_query($LineItemsSQL, $ErrMsg);
if (DB_num_rows($GetShiptHdrResult)==0) {
Modified: trunk/Shipt_Select.php
===================================================================
--- trunk/Shipt_Select.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/Shipt_Select.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -98,7 +98,7 @@
stockmaster.decimalplaces,
stockmaster.units";
- $ErrMsg = _('No Stock Items were returned from the database because'). ' - '. DB_error_msg($db);
+ $ErrMsg = _('No Stock Items were returned from the database because'). ' - '. DB_error_msg();
$StockItemsResult = DB_query($SQL, $ErrMsg);
}
Modified: trunk/ShiptsList.php
===================================================================
--- trunk/ShiptsList.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/ShiptsList.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -22,7 +22,7 @@
eta
FROM shipments
WHERE supplierid='" . $_GET['SupplierID'] . "'";
-$ErrMsg = _('No shipments were returned from the database because'). ' - '. DB_error_msg($db);
+$ErrMsg = _('No shipments were returned from the database because'). ' - '. DB_error_msg();
$ShiptsResult = DB_query($SQL, $ErrMsg);
if (DB_num_rows($ShiptsResult)==0){
Modified: trunk/StockCheck.php
===================================================================
--- trunk/StockCheck.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/StockCheck.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -42,7 +42,7 @@
if (DB_error_no() !=0) {
$Title = _('Stock Count Sheets - Problem Report');
include('includes/header.inc');
- prnMsg(_('The inventory quantities could not be added to the freeze file because') . ' ' . DB_error_msg($db),'error');
+ prnMsg(_('The inventory quantities could not be added to the freeze file because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
@@ -64,7 +64,7 @@
if (DB_error_no() !=0) {
$Title = _('Stock Freeze') . ' - ' . _('Problem Report') . '.... ';
include('includes/header.inc');
- prnMsg(_('The old quantities could not be deleted from the freeze file because') . ' ' . DB_error_msg($db),'error');
+ prnMsg(_('The old quantities could not be deleted from the freeze file because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
@@ -95,7 +95,7 @@
if (DB_error_no() !=0) {
$Title = _('Stock Freeze - Problem Report');
include('includes/header.inc');
- prnMsg(_('The inventory quantities could not be added to the freeze file because') . ' ' . DB_error_msg($db),'error');
+ prnMsg(_('The inventory quantities could not be added to the freeze file because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $sql;
@@ -138,7 +138,7 @@
if (DB_error_no() !=0) {
$Title = _('Stock Sheets') . ' - ' . _('Problem Report') . '.... ';
include('includes/header.inc');
- prnMsg( _('The inventory quantities could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The inventory quantities could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -191,7 +191,7 @@
if (DB_error_no() !=0) {
$Title = _('Stock Check Sheets - Problem Report');
include('includes/header.inc');
- prnMsg( _('The sales order demand quantities could not be retrieved by the SQL because') . ' ' . DB_error_msg($db), 'error');
+ prnMsg( _('The sales order demand quantities could not be retrieved by the SQL because') . ' ' . DB_error_msg(), 'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -219,7 +219,7 @@
$DemandResult = DB_query($sql,'','',false,false);
if (DB_error_no() !=0) {
- prnMsg(_('The demand for this product from') . ' ' . $myrow['loccode'] . ' ' . _('cannot be retrieved because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The demand for this product from') . ' ' . $myrow['loccode'] . ' ' . _('cannot be retrieved because') . ' - ' . DB_error_msg(),'error');
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . ' ' . $sql;
}
Modified: trunk/StockDispatch.php
===================================================================
--- trunk/StockDispatch.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/StockDispatch.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -123,7 +123,7 @@
if (DB_error_no() !=0) {
$Title = _('Stock Dispatch - Problem Report');
include('includes/header.inc');
- prnMsg( _('The Stock Dispatch report could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The Stock Dispatch report could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br />
<a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
Modified: trunk/StockUsage.php
===================================================================
--- trunk/StockUsage.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/StockUsage.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -137,7 +137,7 @@
}
$MovtsResult = DB_query($sql);
if (DB_error_no() !=0) {
- echo _('The stock usage for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg($db);
+ echo _('The stock usage for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg();
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . $sql;
}
Modified: trunk/StockUsageGraph.php
===================================================================
--- trunk/StockUsageGraph.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/StockUsageGraph.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -50,7 +50,7 @@
if (DB_error_no() !=0) {
$Title = _('Stock Usage Graph Problem');
include ('includes/header.inc');
- echo _('The stock usage for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg($db);
+ echo _('The stock usage for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg();
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . $sql;
}
Modified: trunk/SuppPaymentRun.php
===================================================================
--- trunk/SuppPaymentRun.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SuppPaymentRun.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -108,7 +108,7 @@
if (DB_error_no() !=0) {
$Title = _('Payment Run - Problem Report');
include('includes/header.inc');
- prnMsg(_('The details of supplier invoices due could not be retrieved because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('The details of supplier invoices due could not be retrieved because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . ' ' . $sql;
@@ -182,7 +182,7 @@
if (DB_error_no() !=0) {
$Title = _('Payment Processing - Problem Report') . '.... ';
include('includes/header.inc');
- prnMsg(_('None of the payments will be processed since updates to the transaction records for') . ' ' .$SupplierName . ' ' . _('could not be processed because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('None of the payments will be processed since updates to the transaction records for') . ' ' .$SupplierName . ' ' . _('could not be processed because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . _('The SQL that failed was') . $SQL;
@@ -213,7 +213,7 @@
if (DB_error_no() !=0) {
$Title = _('Payment Processing - Problem Report') . '.... ';
include('includes/header.inc');
- prnMsg(_('None of the payments will be processed. Unfortunately, there was a problem committing the changes to the database because') . ' - ' . DB_error_msg($db),'error');
+ prnMsg(_('None of the payments will be processed. Unfortunately, there was a problem committing the changes to the database because') . ' - ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
prnMsg(_('The SQL that failed was') . '<br />' . $SQL,'error');
@@ -314,7 +314,7 @@
$AccountsResults = DB_query($SQL,'','',false,false);
if (DB_error_no() !=0) {
- echo '<br />' . _('The bank accounts could not be retrieved by the SQL because') . ' - ' . DB_error_msg($db);
+ echo '<br />' . _('The bank accounts could not be retrieved by the SQL because') . ' - ' . DB_error_msg();
if ($debug==1){
echo '<br />' . _('The SQL used to retrieve the bank accounts was') . ':<br />' . $SQL;
}
Modified: trunk/SuppPriceList.php
===================================================================
--- trunk/SuppPriceList.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SuppPriceList.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -137,7 +137,7 @@
if (DB_error_no() !=0) {
$Title = _('Price List') . ' - ' . _('Problem Report');
include('includes/header.inc');
- prnMsg( _('The Price List could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg( _('The Price List could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br />
<a href="' .$RootPath .'/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
Modified: trunk/SupplierBalsAtPeriodEnd.php
===================================================================
--- trunk/SupplierBalsAtPeriodEnd.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SupplierBalsAtPeriodEnd.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -50,7 +50,7 @@
if (DB_error_no() !=0) {
$Title = _('Supplier Balances - Problem Report');
include('includes/header.inc');
- prnMsg(_('The Supplier details could not be retrieved by the SQL because') . ' ' . DB_error_msg($db),'error');
+ prnMsg(_('The Supplier details could not be retrieved by the SQL because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if ($debug==1){
echo '<br />' . $SQL;
Modified: trunk/SupplierTransInquiry.php
===================================================================
--- trunk/SupplierTransInquiry.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/SupplierTransInquiry.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -93,7 +93,7 @@
$sql .= " ORDER BY id";
$TransResult = DB_query($sql);
- $ErrMsg = _('The supplier transactions for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg($db);
+ $ErrMsg = _('The supplier transactions for the selected criteria could not be retrieved because') . ' - ' . DB_error_msg();
$DbgMsg = _('The SQL that failed was');
echo '<table class="selection">';
Modified: trunk/Tax.php
===================================================================
--- trunk/Tax.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/Tax.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -53,7 +53,7 @@
if(DB_error_no() !=0) {
$Title = _('Taxation Reporting Error');
include('includes/header.inc');
- prnMsg(_('The accounts receivable transaction details could not be retrieved because') . ' ' . DB_error_msg($db),'error');
+ prnMsg(_('The accounts receivable transaction details could not be retrieved because') . ' ' . DB_error_msg(),'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
if($debug==1) {
echo '<br />' . $SQL;
@@ -167,7 +167,7 @@
if(DB_error_no() !=0) {
$Title = _('Taxation Reporting Error');
include('includes/header.inc');
- echo _('The accounts payable transaction details could not be retrieved because') . ' ' . DB_error_msg($db);
+ echo _('The accounts payable transaction details could not be retrieved because') . ' ' . DB_error_msg();
echo '<br /><a href="' . $RootPath . '/index.php?">' . _('Back to the menu') . '</a>';
if($debug==1) {
echo '<br />' . $SQL;
Modified: trunk/UpgradeDatabase.php
===================================================================
--- trunk/UpgradeDatabase.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/UpgradeDatabase.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -251,7 +251,7 @@
echo '<td style="background-color:yellow">' . _('Note').' - '. _('Entry has already been done') . '</td></tr>';
break;
case 1064:
- echo '<td style="background-color:red">' . _('Note').' - '. _('SQL syntax error. The SQL error message is'). ' ' . DB_error_msg($db) . '</td></tr>';
+ echo '<td style="background-color:red">' . _('Note').' - '. _('SQL syntax error. The SQL error message is'). ' ' . DB_error_msg() . '</td></tr>';
break;
case 1068:
echo '<td style="background-color:yellow">' . _('Note').' - '. _('Primary key already exists') . '</td></tr>';
Modified: trunk/Z_DataExport.php
===================================================================
--- trunk/Z_DataExport.php 2014-10-27 07:06:42 UTC (rev 6943)
+++ trunk/Z_DataExport.php 2014-10-27 07:15:34 UTC (rev 6944)
@@ -68,7 +68,7 @@
if (DB_error_no() !=0) {
$Title = _('Price List Export Problem ....');
include('includes/header.inc');
- prnMsg( _('The Price List could not be retrieved by the SQL because'). ' - ' . DB_error_msg($db), 'error');
+ prnMsg( _('The Price List could not be retrieved by the SQL because'). ' - ' . DB_error_msg(), 'error');
echo '<br /><a href="' .$RootPath .'/index.php?' . SID . '">' . _('Back to the menu'). '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -164,7 +164,7 @@
if (DB_error_no() !=0) {
$Title = _('Customer List Export Problem ....');
include('includes/header.inc');
- prnMsg( _('The Customer List could not be retrieved by the SQL because'). ' - ' . DB_error_msg($db), 'error');
+ prnMsg( _('The Customer List could not be retrieved by the SQL because'). ' - ' . DB_error_msg(), 'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -255,7 +255,7 @@
if (DB_error_no() !=0) {
$Title = _('Salesman List Export Problem ....');
include('includes/header.inc');
- prnMsg( _('The Salesman List could not be retrieved by the SQL because'). ' - ' . DB_error_msg($db), 'error');
+ prnMsg( _('The Salesman List could not be retrieved by the SQL because'). ' - ' . DB_error_msg(), 'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -304,7 +304,7 @@
if (DB_error_no() !=0) {
$Title = _('Security Token List Export Problem ....');
include('includes/header.inc');
- prnMsg( _('The Image List could not be retrieved by the SQL because'). ' - ' . DB_error_msg($db), 'error');
+ prnMsg( _('The Image List could not be retrieved by the SQL because'). ' - ' . DB_error_msg(), 'error');
echo '<br /><a href="' .$RootPath .'/index.php">' . _('Back to the menu'). '</a>';
if ($debug==1){
echo '<br />' . $SQL;
@@ -343,7 +343,7 @@
if (DB_error_no() !=0) {
$Title = _('Security Token List Export Problem ....');
include('includes/header.inc');
- prnMsg( _('The Security Token List could not be retrieve...
[truncated message content] |