commit 9e4b1e691315b5f9f673d1cb301697449f9ab8b0
author Anand Doshi <anand@erpnext.com> Tue Mar 12 10:44:35 2013 +0530
committer Anand Doshi <anand@erpnext.com> Tue Mar 12 10:44:35 2013 +0530
tree d84617c87dfa1aa3adb78fa55558bd240ccdce8c
parent a012fdb54c6ca79f577c4040dc125496795da507

patch fix: published on should be date of creation

patches/march_2013/p03_rename_blog_to_blog_post.py

diff --git a/patches/march_2013/p03_rename_blog_to_blog_post.py b/patches/march_2013/p03_rename_blog_to_blog_post.py
index 7520f9c..69902f34 100644
--- a/patches/march_2013/p03_rename_blog_to_blog_post.py
+++ b/patches/march_2013/p03_rename_blog_to_blog_post.py
@@ -6,4 +6,4 @@
 	webnotes.reload_doc('website', 'doctype', 'blog_post')
 	webnotes.conn.sql('''update tabBlogger set posts=(select count(*) 
 		from `tabBlog Post` where ifnull(blogger,"")=tabBlogger.name)''')
-	webnotes.conn.sql("""update `tabBlog Post` set published_on=creation""")
+	webnotes.conn.sql("""update `tabBlog Post` set published_on=date(creation)""")