Error when trying to change quantity

ERPNext User Forum
1
Hello,

Whenever I try to change the quantity field for example to 33 in this case (see screenshot) the system constantly puts extra 3 pieces of zeros to the end with the following server error: 

Could you please tell me what is that and how can I fix it?

Thank you,
Tivadar

[Log] Traceback (innermost last): (frappe.min.js, line 339)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/app.py", line 46, in application
    response = frappe.handler.handle()
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
    execute_cmd(cmd)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 84, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 521, in call
    return fn(*args, **newargs)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 112, in apply_pricing_rule
    out.append(get_pricing_rule_for_item(args_copy))
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 137, in get_pricing_rule_for_item
    pricing_rules = get_pricing_rules(args)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 193, in get_pricing_rules
    transaction_type=args.transaction_type, conditions=conditions), args, as_dict=1)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/database.py", line 107, in sql
    self._cursor.execute(query, values)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute
    for key, item in args.iteritems())
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in <genexpr>
    for key, item in args.iteritems())
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 278, in literal
    return self.escape(o, self.encoders)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/converters.py", line 133, in quote_tuple
    return "(%s)" % (','.join(escape_sequence(t, d)))
 TypeError: sequence item 0: expected string, dict found

–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/4856b1e2-b648-4758-b57e-12b60b3a6e3f%40googlegroups.com.

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

2
When was the last time you ran update?


On Tue, Jul 1, 2014 at 7:27 PM, <ti...@gmail.com> wrote:
Hello,

Whenever I try to change the quantity field for example to 33 in this case (see screenshot) the system constantly puts extra 3 pieces of zeros to the end with the following server error:

Could you please tell me what is that and how can I fix it?

Thank you,
Tivadar

[Log] Traceback (innermost last): (frappe.min.js, line 339)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/app.py", line 46, in application
response = frappe.handler.handle()
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
execute_cmd(cmd)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 84, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 521, in call
return fn(*args, **newargs)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 112, in apply_pricing_rule
out.append(get_pricing_rule_for_item(args_copy))
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 137, in get_pricing_rule_for_item
pricing_rules = get_pricing_rules(args)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 193, in get_pricing_rules
transaction_type=args.transaction_type, conditions=conditions), args, as_dict=1)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/database.py", line 107, in sql
self._cursor.execute(query, values)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute
for key, item in args.iteritems())
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in <genexpr>
for key, item in args.iteritems())
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 278, in literal
return self.escape(o, self.encoders)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/converters.py", line 133, in quote_tuple
return "(%s)" % (','.join(escape_sequence(t, d)))
TypeError: sequence item 0: expected string, dict found

–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/4856b1e2-b648-4758-b57e-12b60b3a6e3f%40googlegroups.com.

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

–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF12FtehAnu7qR2MLtkC8khPDaS4zCdMWJSUWMh5r8p8sA%40mail.gmail.com.

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

3
Hello Anand,

Thanks for trying to help. Actually I never ran update yet. I installed ERPNext around 2 or 3 weeks ago. How can I update ERPNext? Could you help me, please?


On Tue, Jul 1, 2014 at 6:55 PM, Anand Doshi <an...@erpnext.com> wrote:
When was the last time you ran update?


On Tue, Jul 1, 2014 at 7:27 PM, <ti...@gmail.com> wrote:
Hello,

Whenever I try to change the quantity field for example to 33 in this case (see screenshot) the system constantly puts extra 3 pieces of zeros to the end with the following server error:

Could you please tell me what is that and how can I fix it?

Thank you,
Tivadar

[Log] Traceback (innermost last): (frappe.min.js, line 339)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/app.py", line 46, in application
response = frappe.handler.handle()
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
execute_cmd(cmd)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 84, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 521, in call
return fn(*args, **newargs)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 112, in apply_pricing_rule
out.append(get_pricing_rule_for_item(args_copy))
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 137, in get_pricing_rule_for_item
pricing_rules = get_pricing_rules(args)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 193, in get_pricing_rules
transaction_type=args.transaction_type, conditions=conditions), args, as_dict=1)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/database.py", line 107, in sql
self._cursor.execute(query, values)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute
for key, item in args.iteritems())
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in <genexpr>
for key, item in args.iteritems())
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 278, in literal
return self.escape(o, self.encoders)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/converters.py", line 133, in quote_tuple
return "(%s)" % (','.join(escape_sequence(t, d)))
TypeError: sequence item 0: expected string, dict found

–

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

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

–

You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF12FtehAnu7qR2MLtkC8khPDaS4zCdMWJSUWMh5r8p8sA%40mail.gmail.com.


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

–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TrGqVjN7yaSy5-p%2Bw7JjP5%2B%2BYpBP%3DGYiWN9twz7sZ-EjA%40mail.gmail.com.

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

4
Follow instructions here to update:

On 01-Jul-2014, at 10:37 pm, Tivadar Orosz <ti...@gmail.com> wrote:

Hello Anand,

Thanks for trying to help. Actually I never ran update yet. I installed ERPNext around 2 or 3 weeks ago. How can I update ERPNext? Could you help me, please?


On Tue, Jul 1, 2014 at 6:55 PM, Anand Doshi <an...@erpnext.com> wrote:
When was the last time you ran update?


On Tue, Jul 1, 2014 at 7:27 PM, <ti...@gmail.com> wrote:
Hello,

Whenever I try to change the quantity field for example to 33 in this case (see screenshot) the system constantly puts extra 3 pieces of zeros to the end with the following server error: 

Could you please tell me what is that and how can I fix it?

Thank you,
Tivadar

[Log] Traceback (innermost last): (frappe.min.js, line 339)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/app.py", line 46, in application
    response = frappe.handler.handle()
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
    execute_cmd(cmd)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 84, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 521, in call
    return fn(*args, **newargs)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 112, in apply_pricing_rule
    out.append(get_pricing_rule_for_item(args_copy))
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 137, in get_pricing_rule_for_item
    pricing_rules = get_pricing_rules(args)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 193, in get_pricing_rules
    transaction_type=args.transaction_type, conditions=conditions), args, as_dict=1)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/database.py", line 107, in sql
    self._cursor.execute(query, values)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute
    for key, item in args.iteritems())
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in <genexpr>
    for key, item in args.iteritems())
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 278, in literal
    return self.escape(o, self.encoders)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/converters.py", line 133, in quote_tuple
    return "(%s)" % (','.join(escape_sequence(t, d)))
 TypeError: sequence item 0: expected string, dict found

–

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

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


–

You received this message because you are subscribed to a topic in the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF12FtehAnu7qR2MLtkC8khPDaS4zCdMWJSUWMh5r8p8sA%40mail.gmail.com.


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


–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TrGqVjN7yaSy5-p%2Bw7JjP5%2B%2BYpBP%3DGYiWN9twz7sZ-EjA%40mail.gmail.com.

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


–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/4FD7F3B6-56B8-4AEC-B7FF-983A23501D8A%40gmail.com.

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

5
Hello Rushabh,

I did update ERPNext but the error is still there. Do you have any idea why is that?

Thanks,
Tivadar


On Wed, Jul 2, 2014 at 6:58 AM, Rushabh Mehta <rm...@gmail.com> wrote:
Follow instructions here to update:

On 01-Jul-2014, at 10:37 pm, Tivadar Orosz <ti...@gmail.com> wrote:

Hello Anand,

Thanks for trying to help. Actually I never ran update yet. I installed ERPNext around 2 or 3 weeks ago. How can I update ERPNext? Could you help me, please?


On Tue, Jul 1, 2014 at 6:55 PM, Anand Doshi <an...@erpnext.com> wrote:
When was the last time you ran update?


On Tue, Jul 1, 2014 at 7:27 PM, <ti...@gmail.com> wrote:
Hello,

Whenever I try to change the quantity field for example to 33 in this case (see screenshot) the system constantly puts extra 3 pieces of zeros to the end with the following server error:

Could you please tell me what is that and how can I fix it?

Thank you,
Tivadar

[Log] Traceback (innermost last): (frappe.min.js, line 339)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/app.py", line 46, in application
response = frappe.handler.handle()
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
execute_cmd(cmd)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 84, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 521, in call
return fn(*args, **newargs)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 112, in apply_pricing_rule
out.append(get_pricing_rule_for_item(args_copy))
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 137, in get_pricing_rule_for_item
pricing_rules = get_pricing_rules(args)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 193, in get_pricing_rules
transaction_type=args.transaction_type, conditions=conditions), args, as_dict=1)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/database.py", line 107, in sql
self._cursor.execute(query, values)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute
for key, item in args.iteritems())
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in <genexpr>
for key, item in args.iteritems())
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 278, in literal
return self.escape(o, self.encoders)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/converters.py", line 133, in quote_tuple
return "(%s)" % (','.join(escape_sequence(t, d)))
TypeError: sequence item 0: expected string, dict found

–

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

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


–

You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF12FtehAnu7qR2MLtkC8khPDaS4zCdMWJSUWMh5r8p8sA%40mail.gmail.com.


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


–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TrGqVjN7yaSy5-p%2Bw7JjP5%2B%2BYpBP%3DGYiWN9twz7sZ-EjA%40mail.gmail.com.

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

–

You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/4FD7F3B6-56B8-4AEC-B7FF-983A23501D8A%40gmail.com.


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

–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TpwEdTFQg-MrPitRgAi0JnYF17CLJHgxeQ_Zu%3Dvz%2BeOzQ%40mail.gmail.com.

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

6
Could be a big, can you raise an issue in GitHub

https://github.com/frappe/erpnext/issues


On 02-Jul-2014, at 11:07 am, Tivadar Orosz <ti...@gmail.com> wrote:

Hello Rushabh,

I did update ERPNext but the error is still there. Do you have any idea why is that?

Thanks,
Tivadar


On Wed, Jul 2, 2014 at 6:58 AM, Rushabh Mehta <rm...@gmail.com> wrote:
Follow instructions here to update:

On 01-Jul-2014, at 10:37 pm, Tivadar Orosz <ti...@gmail.com> wrote:

Hello Anand,

Thanks for trying to help. Actually I never ran update yet. I installed ERPNext around 2 or 3 weeks ago. How can I update ERPNext? Could you help me, please?


On Tue, Jul 1, 2014 at 6:55 PM, Anand Doshi <an...@erpnext.com> wrote:
When was the last time you ran update?


On Tue, Jul 1, 2014 at 7:27 PM, <ti...@gmail.com> wrote:
Hello,

Whenever I try to change the quantity field for example to 33 in this case (see screenshot) the system constantly puts extra 3 pieces of zeros to the end with the following server error: 

Could you please tell me what is that and how can I fix it?

Thank you,
Tivadar

[Log] Traceback (innermost last): (frappe.min.js, line 339)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/app.py", line 46, in application
    response = frappe.handler.handle()
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
    execute_cmd(cmd)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 84, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 521, in call
    return fn(*args, **newargs)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 112, in apply_pricing_rule
    out.append(get_pricing_rule_for_item(args_copy))
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 137, in get_pricing_rule_for_item
    pricing_rules = get_pricing_rules(args)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 193, in get_pricing_rules
    transaction_type=args.transaction_type, conditions=conditions), args, as_dict=1)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/database.py", line 107, in sql
    self._cursor.execute(query, values)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute
    for key, item in args.iteritems())
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in <genexpr>
    for key, item in args.iteritems())
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 278, in literal
    return self.escape(o, self.encoders)
  File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/converters.py", line 133, in quote_tuple
    return "(%s)" % (','.join(escape_sequence(t, d)))
 TypeError: sequence item 0: expected string, dict found

–

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

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


–

You received this message because you are subscribed to a topic in the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF12FtehAnu7qR2MLtkC8khPDaS4zCdMWJSUWMh5r8p8sA%40mail.gmail.com.


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


–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TrGqVjN7yaSy5-p%2Bw7JjP5%2B%2BYpBP%3DGYiWN9twz7sZ-EjA%40mail.gmail.com.

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


–

You received this message because you are subscribed to a topic in the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/4FD7F3B6-56B8-4AEC-B7FF-983A23501D8A%40gmail.com.


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


–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TpwEdTFQg-MrPitRgAi0JnYF17CLJHgxeQ_Zu%3Dvz%2BeOzQ%40mail.gmail.com.

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


–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/94644899-E848-457E-9F95-292C18FD995B%40gmail.com.

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

7
Hello Rushabh,

I opened a ticket in GitHub per your request. It's #1877


On Wed, Jul 2, 2014 at 7:42 AM, Rushabh Mehta <rm...@gmail.com> wrote:
Could be a big, can you raise an issue in GitHub



On 02-Jul-2014, at 11:07 am, Tivadar Orosz <ti...@gmail.com> wrote:

Hello Rushabh,

I did update ERPNext but the error is still there. Do you have any idea why is that?

Thanks,
Tivadar


On Wed, Jul 2, 2014 at 6:58 AM, Rushabh Mehta <rm...@gmail.com> wrote:
Follow instructions here to update:

On 01-Jul-2014, at 10:37 pm, Tivadar Orosz <ti…@gmail.com> wrote:


Hello Anand,

Thanks for trying to help. Actually I never ran update yet. I installed ERPNext around 2 or 3 weeks ago. How can I update ERPNext? Could you help me, please?



On Tue, Jul 1, 2014 at 6:55 PM, Anand Doshi <an...@erpnext.com> wrote:
When was the last time you ran update?


On Tue, Jul 1, 2014 at 7:27 PM, <ti...@gmail.com> wrote:
Hello,

Whenever I try to change the quantity field for example to 33 in this case (see screenshot) the system constantly puts extra 3 pieces of zeros to the end with the following server error:

Could you please tell me what is that and how can I fix it?

Thank you,
Tivadar

[Log] Traceback (innermost last): (frappe.min.js, line 339)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/app.py", line 46, in application
response = frappe.handler.handle()
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle
execute_cmd(cmd)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 84, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 521, in call
return fn(*args, **newargs)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 112, in apply_pricing_rule
out.append(get_pricing_rule_for_item(args_copy))
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 137, in get_pricing_rule_for_item
pricing_rules = get_pricing_rules(args)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/pricing_rule/pricing_rule.py", line 193, in get_pricing_rules
transaction_type=args.transaction_type, conditions=conditions), args, as_dict=1)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/apps/frappe/frappe/database.py", line 107, in sql
self._cursor.execute(query, values)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute
for key, item in args.iteritems())
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in <genexpr>
for key, item in args.iteritems())
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 278, in literal
return self.escape(o, self.encoders)
File "/home/ortiv/public_html/erp/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/converters.py", line 133, in quote_tuple
return "(%s)" % (','.join(escape_sequence(t, d)))
TypeError: sequence item 0: expected string, dict found

–

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

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


–

You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF12FtehAnu7qR2MLtkC8khPDaS4zCdMWJSUWMh5r8p8sA%40mail.gmail.com.


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


–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TrGqVjN7yaSy5-p%2Bw7JjP5%2B%2BYpBP%3DGYiWN9twz7sZ-EjA%40mail.gmail.com.

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


–

You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/4FD7F3B6-56B8-4AEC-B7FF-983A23501D8A%40gmail.com.


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


–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TpwEdTFQg-MrPitRgAi0JnYF17CLJHgxeQ_Zu%3Dvz%2BeOzQ%40mail.gmail.com.

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

–

You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/D4E4-lQVvkE/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/94644899-E848-457E-9F95-292C18FD995B%40gmail.com.


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

–

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJXg0TqNLWOk%3DeQYDJBQuixrbm%2BLMe%2Ba91G_ZGRZ%3DXLg0ShY8g%40mail.gmail.com.

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