commit acfab66239681e7adcc53d46cb7e1ac8c6d02527
author Rushabh Mehta <rmehta@gmail.com> Thu Mar 28 16:47:47 2013 +0530
committer Rushabh Mehta <rmehta@gmail.com> Thu Mar 28 16:47:47 2013 +0530
tree 4c7c0a385dc678522609ea24b37564fd1c52027a
parent 2fe802c81e40060a8efc429b91015cbf1d63bfa5

[patch] [fix] substr starts with 1

patches/march_2013/p11_update_attach_files.py

diff --git a/patches/march_2013/p11_update_attach_files.py b/patches/march_2013/p11_update_attach_files.py
index 769463a..ef39ce8 100644
--- a/patches/march_2013/p11_update_attach_files.py
+++ b/patches/march_2013/p11_update_attach_files.py
@@ -11,6 +11,6 @@
 		else:
 			webnotes.conn.sql("""update `tab%(parent)s`
 				set %(fieldname)s = 
-					if(substr(%(fieldname)s,0,4)='http' or substr(%(fieldname)s, 0, 5)='files',
+					if(substr(%(fieldname)s,1,4)='http' or substr(%(fieldname)s,1,5)='files',
 					 	%(fieldname)s, 
 						concat('files/', %(fieldname)s))""" % f)
\ No newline at end of file