New record

Hello All,
   I have added some custom field in Customer doctype and some custom triggers.
1) When i open existing customer it displays all customer data without any error.
2) When i click on new customer it displays following error on javascript console.

   Traceback (innermost last): File "../lib/webnotes/handler.py", line 156, in handle execute_cmd(cmd) File "../lib/webnotes/handler.py", line 191, in execute_cmd ret = call(method, webnotes.form_dict) File "../lib/webnotes/handler.py", line 208, in call return fn(**newargs) File "../lib/webnotes/client.py", line 42, in get_value return webnotes.conn.get_value(doctype, json.loads(filters), fieldname, as_dict=as_dict, debug=debug) File "../lib/webnotes/db.py", line 294, in get_value ret = self.get_values(doctype, filters, fieldname, ignore, as_dict, debug) File "../lib/webnotes/db.py", line 311, in get_values raise e ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1")

What should i do?
Thank you all,

Regards,
Gangadhar kadam



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

    For more options, visit https://groups.google.com/groups/opt_out.
Hi Gangadhar,

We don't have your context. You need to provide us with the details of the custom field.

-Anand.

On 21-Aug-2013, at 4:33 PM, gangadhar kadam <em...@gmail.com> wrote:

Hello All,
   I have added some custom field in Customer doctype and some custom triggers.
1) When i open existing customer it displays all customer data without any error.
2) When i click on new customer it displays following error on javascript console.

   Traceback (innermost last): File "../lib/webnotes/handler.py", line 156, in handle execute_cmd(cmd) File "../lib/webnotes/handler.py", line 191, in execute_cmd ret = call(method, webnotes.form_dict) File "../lib/webnotes/handler.py", line 208, in call return fn(**newargs) File "../lib/webnotes/client.py", line 42, in get_value return webnotes.conn.get_value(doctype, json.loads(filters), fieldname, as_dict=as_dict, debug=debug) File "../lib/webnotes/db.py", line 294, in get_value ret = self.get_values(doctype, filters, fieldname, ignore, as_dict, debug) File "../lib/webnotes/db.py", line 311, in get_values raise e ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1")

What should i do?
Thank you all,

Regards,
Gangadhar kadam



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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