def validate(self):
if self.from_time > self.to_time:
frappe.throw(_("Start Date cannot be after End Date"))
existing_records=frappe.db.sql(""" select name from `tabMeeting Schedule` where from_time>='{0}' and
to_time<='{1}' """.format(self.from_date,self.from_date), as_list=True)
if existing_records:
frappe.msgprint("Sorry! please try again meeting exist already on this date ")
else:
frappe.msgprint("Congratulation! Schedule Success!")
def validate(self):
if self.from_time > self.to_time:
frappe.throw(_("Start Date cannot be after End Date"))
existing_records=frappe.db.sql(""" select name from `tabMeeting Schedule` where from_time>='{0}' and
to_time<='{1}' """.format(self.from_time,self.from_time), as_list=True)
if existing_records:
frappe.msgprint("Sorry! please try again meeting exist already on this date ")
else:
frappe.msgprint("Congratulation! Schedule Success!")
if you got same error, please update your code as following (testing purpose) whether it still has error
def validate(self):
if self.from_time > self.to_time:
frappe.throw(_("Start Date cannot be after End Date"))
existing_records = {}
if existing_records:
frappe.msgprint("Sorry! please try again meeting exist already on this date ")
else:
frappe.msgprint("Congratulation! Schedule Success!")
Traceback (most recent call last):
File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 62, in application
response = frappe.handler.handle()
File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 22, in handle
data = execute_cmd(cmd)
File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 53, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 939, in call
return fn(*args, **newargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/load.py", line 71, in getdoctype
docs = get_meta_bundle(doctype)
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/load.py", line 81, in get_meta_bundle
bundle = [frappe.desk.form.meta.get_meta(doctype)]
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/meta.py", line 24, in get_meta
meta = FormMeta(doctype)
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/meta.py", line 34, in __init__
self.load_assets()
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/meta.py", line 44, in load_assets
self.load_templates()
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/meta.py", line 159, in load_templates
module = load_doctype_module(self.name)
File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/utils.py", line 185, in load_doctype_module
doctype_python_modules[key] = frappe.get_module(module_name)
File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 704, in get_module
return importlib.import_module(modulename)
File "/usr/lib/python2.7/importlib/__init__.py", line 37, in import_module
__import__(name)
File "/home/frappe/frappe-bench/apps/meeting/meeting/meeting/doctype/meeting/meeting.py", line 22
existing_records = {}
^
SyntaxError: invalid syntax