commit 0dc627d9b123e11f26665e03c25707c70a99da4b
author Akhilesh Darjee <akhileshdarjee@gmail.com> Tue Sep 17 13:52:22 2013 +0530
committer Akhilesh Darjee <akhileshdarjee@gmail.com> Tue Sep 17 13:52:22 2013 +0530
tree bc7e63ba7eb96c84f8c86479747f5ed9fd58e729
parent 06713d997ef8664f17f5aa931b74d428e8729af3

[fix] [minor] price list patch fixed

patches/june_2013/p03_buying_selling_for_price_list.py

diff --git a/patches/june_2013/p03_buying_selling_for_price_list.py b/patches/june_2013/p03_buying_selling_for_price_list.py
index 7d222c8..ead97ab 100644
--- a/patches/june_2013/p03_buying_selling_for_price_list.py
+++ b/patches/june_2013/p03_buying_selling_for_price_list.py
@@ -22,6 +22,7 @@
 			webnotes.conn.set_value("Price List", price_list, "buying_or_selling", buying_or_selling)
 	except MySQLdb.OperationalError, e:
 		if e.args[0] == 1054:
-			webnotes.conn.sql("""update `tabItem Price` set buying_or_selling='Selling' """)
+			webnotes.conn.sql("""update `tabPrice List` set buying_or_selling='Selling' 
+				where ifnull(buying_or_selling, '')='' """)
 		else:
 			raise e
\ No newline at end of file