No such field, how can i avoid such issue?

(1054, "Unknown column 'tabMaintenance Schedule.sales_order_no' in 'field list'")

Traceback (innermost last):
File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application
response = frappe.handler.handle()
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
execute_cmd(cmd)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 526, in call
return fn(*args, **newargs)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/search.py", line 13, in search_link
search_widget(doctype, txt, query, searchfield=searchfield, page_len=page_len, filters=filters)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/search.py", line 85, in search_widget
as_list=True)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/reportview.py", line 20, in execute
order_by, limit_start, limit_page_length, as_list, with_childnames, debug)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 47, in execute
return self.build_and_run()
File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 59, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
self._cursor.execute(query)
File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'tabMaintenance Schedule.sales_order_no' in 'field list'")



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/3405c01f-afae-4f64-87e6-55b097b5a77f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
Remove sales_order_no from “Search Field” options via Setup -> Customize Form -> Maintenance Schedule.


On Aug 27, 2014, at 3:43 PM, Y Y <ya...@gmail.com> wrote:

(1054, "Unknown column 'tabMaintenance Schedule.sales_order_no' in 'field list'")

Traceback (innermost last):
File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application
response = frappe.handler.handle()
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
execute_cmd(cmd)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 526, in call
return fn(*args, **newargs)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/search.py", line 13, in search_link
search_widget(doctype, txt, query, searchfield=searchfield, page_len=page_len, filters=filters)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/search.py", line 85, in search_widget
as_list=True)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/reportview.py", line 20, in execute
order_by, limit_start, limit_page_length, as_list, with_childnames, debug)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 47, in execute
return self.build_and_run()
File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 59, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
self._cursor.execute(query)
File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'tabMaintenance Schedule.sales_order_no' in 'field list'")



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/3405c01f-afae-4f64-87e6-55b097b5a77f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/03F0616B-9B66-47DC-A402-4891591B1965%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.
This is exists in demo.frappecould.com

Repeat steps:
login -> Support -> Maintenance Visit -> New -> 3 button at top of the form click "From Maintenance schedule", -> input text to search, error shows.

Please advise how to fix, i can send push request.

Thanks,
Yang

在 2014年8月27日星期三UTC+8下午6时22分16秒,Nabin Hait写道:
Remove sales_order_no from “Search Field” options via Setup -> Customize Form -> Maintenance Schedule.


On Aug 27, 2014, at 3:43 PM, Y Y <ya...@gmail.com> wrote:

(1054, "Unknown column 'tabMaintenance Schedule.sales_order_no' in 'field list'")

Traceback (innermost last):
File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application
response = frappe.handler.handle()
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
execute_cmd(cmd)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 526, in call
return fn(*args, **newargs)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/search.py", line 13, in search_link
search_widget(doctype, txt, query, searchfield=searchfield, page_len=page_len, filters=filters)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/search.py", line 85, in search_widget
as_list=True)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/reportview.py", line 20, in execute
order_by, limit_start, limit_page_length, as_list, with_childnames, debug)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 47, in execute
return self.build_and_run()
File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 59, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
self._cursor.execute(query)
File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'tabMaintenance Schedule.sales_order_no' in 'field list'")



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/3405c01f-afae-4f64-87e6-55b097b5a77f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/18c20304-4852-46f4-a22c-3a49520998d9%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
We can replicate the issue, will fix and push by the end of the day.

On Aug 28, 2014, at 6:17 AM, Y Y <ya...@gmail.com> wrote:

This is exists in demo.frappecould.com

Repeat steps:
login -> Support -> Maintenance Visit -> New -> 3 button at top of the form click "From Maintenance schedule", -> input text to search, error shows.

Please advise how to fix, i can send push request.

Thanks,
Yang

在 2014年8月27日星期三UTC+8下午6时22分16秒,Nabin Hait写道:
Remove sales_order_no from “Search Field” options via Setup -> Customize Form -> Maintenance Schedule.


On Aug 27, 2014, at 3:43 PM, Y Y <ya...@gmail.com> wrote:

(1054, "Unknown column 'tabMaintenance Schedule.sales_order_no' in 'field list'")

Traceback (innermost last):
File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application
response = frappe.handler.handle()
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
execute_cmd(cmd)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 526, in call
return fn(*args, **newargs)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/search.py", line 13, in search_link
search_widget(doctype, txt, query, searchfield=searchfield, page_len=page_len, filters=filters)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/search.py", line 85, in search_widget
as_list=True)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/reportview.py", line 20, in execute
order_by, limit_start, limit_page_length, as_list, with_childnames, debug)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 47, in execute
return self.build_and_run()
File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_query.py", line 59, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug)
File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
self._cursor.execute(query)
File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'tabMaintenance Schedule.sales_order_no' in 'field list'")



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/3405c01f-afae-4f64-87e6-55b097b5a77f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/18c20304-4852-46f4-a22c-3a49520998d9%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/F522E052-2C30-4B0E-A921-19D44CC751E3%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.