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

[<te...@us...>]

Revision: 6960
          http://sourceforge.net/p/web-erp/reponame/6960
Author:   tehonu
Date:     2014-11-05 07:05:45 +0000 (Wed, 05 Nov 2014)
Log Message:
-----------
Fixed bugs in previous commit

Modified Paths:
--------------
    trunk/PDFPriceList.php
    trunk/sql/mysql/upgrade4.11-4.12.sql

Modified: trunk/PDFPriceList.php
===================================================================
--- trunk/PDFPriceList.php	2014-11-05 05:10:23 UTC (rev 6959)
+++ trunk/PDFPriceList.php	2014-11-05 07:05:45 UTC (rev 6960)
@@ -147,10 +147,10 @@
 	}
 	$PricesResult = DB_query($SQL,'','',false,false);
 
-	if (DB_error_no($db) !=0) {
+	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/sql/mysql/upgrade4.11-4.12.sql
===================================================================
--- trunk/sql/mysql/upgrade4.11-4.12.sql	2014-11-05 05:10:23 UTC (rev 6959)
+++ trunk/sql/mysql/upgrade4.11-4.12.sql	2014-11-05 07:05:45 UTC (rev 6960)
@@ -1,5 +1,7 @@
 INSERT INTO `config` VALUES ('InvoiceQuantityDefault','1');
 
+ALTER TABLE `stockcategory` ADD INDEX `CategoryDescription` (`categorydescription`);
+
 UPDATE config SET confvalue='4.12' WHERE confname='VersionNumber';