Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Could not fully process the POS Order: "invalid input syntax for integer

By
Jason Wu
on 7/6/16, 3:29 AM 310 views

2016-06-11 21:27:00,981 3607 ERROR SK openerp.sql_db: bad query: SELECT "stock_picking_type"."write_uid","stock_picking_type"."create_date","stock_picking_type"."color","stock_picking_type"."return_picking_type_id","stock_picking_type"."create_uid","stock_picking_type"."name","stock_picking_type"."default_location_src_id","stock_picking_type"."id","stock_picking_type"."code","stock_picking_type"."warehouse_id","stock_picking_type"."sequence","stock_picking_type"."write_date","stock_picking_type"."default_location_dest_id","stock_picking_type"."active","stock_picking_type"."sequence_id" FROM "stock_picking_type" WHERE "stock_picking_type".id IN (53, 'Etobicoke: Delivery Orders') AND (("stock_picking_type"."warehouse_id" IS NULL OR (FALSE OR ("stock_picking_type"."warehouse_id" in (1,20,21,22,23,24,25,26,27,28,29,31)))) AND ("stock_picking_type"."warehouse_id" = 20)) ORDER BY "stock_picking_type"."sequence" Traceback (most recent call last): File "/opt/odoo/odoo-server/openerpl_db.py", line 234, in execute res = self._obj.execute(query, params) DataError: invalid input syntax for integer: "Etobicoke: Delivery Orders" LINE 2: ... WHERE "stock_picking_type".id IN (53, 'Etobicoke... ^ 2016-06-11 21:27:00,982 3607 ERROR SK openerp.addons.point_of_sale.point_of_sale: Could not fully process the POS Order: "invalid input syntax for integer: "Etobicoke: Delivery Orders" LINE 2: ... WHERE "stock_picking_type".id IN (53, 'Etobicoke... ^ " while evaluating u'action_paid()'

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/6/16, 3:29 AM
Seen: 310 times
Last updated: 7/6/16, 3:42 AM