march.p03 patch fix
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 ce32868..199dad2 100644
--- a/patches/march_2013/p03_rename_blog_to_blog_post.py
+++ b/patches/march_2013/p03_rename_blog_to_blog_post.py
@@ -2,8 +2,8 @@
def execute():
webnotes.reload_doc('website', 'doctype', 'blogger')
- webnotes.conn.sql('''update tabBlogger set posts=(select count(*)
- from tabBlog where ifnull(blogger,"")=tabBlogger.name)''')
webnotes.rename_doc("DocType", "Blog", "Blog Post", force=True)
webnotes.conn.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""")