openerp-india team mailing list archive

["Amit Bhavsar \(Open ERP\)" <959137@xxxxxxxxxxxxxxxxxx>]

Hello Dieter,

I have checked your scenario with following configuration,
  • Windows XP
  • Postgres 8.3
  • OpenERP 6.1

But at my end working fine, So I have attached the video.  would you
please check it notify us where you have faced the problem.

Thank you and waiting for your reply!

** Attachment added: "No problem of POS synchronisation"
   https://bugs.launchpad.net/openobject-addons/+bug/959137/+attachment/2988438/+files/pos_Order.avi

** Changed in: openobject-addons
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/959137

Title:
  [6.1] POS synchronisation problem

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  Environment:
  Windows XP, Postgres 8.3, OpenERP 6.1

  I install a new database with demo data.
  I only install the POS module.
  All goes well:
  I can use the POS module, I pay thew via the Cash Journal. I see new POS orders appearing in the backend. No errors in te server log.

  Now I stop the server (OpenERP 6.1 service) and start it again.

  For the sake of doing things clean: I logout and login again

  I reconnect to the POS.
  All goes well, and I can create new POS orders
  However
  These new orders do not get synchronised with the backend. On the top right of my browser the red box stating '1 pending orders' stays there.

  The server log shows following order:

  2012-03-19 10:55:02,108 500 ERROR ? openerp.sql_db: bad query: update "account_bank_statement_line" set "journal_id"=E'Cash Journal - (test)' where id = 8
  Traceback (most recent call last):
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\sql_db.py", line 212, in execute
  DataError: invalid input syntax for integer: "Cash Journal - (test)"

  2012-03-19 10:55:02,108 500 ERROR ? openerp.osv.osv: Uncaught exception
  Traceback (most recent call last):
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\osv.py", line 121, in wrapper
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\osv.py", line 176, in execute
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\osv.py", line 164, in execute_cr
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\openerp\addons\point_of_sale\point_of_sale.py", line 73, in create_from_ui
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\openerp\addons\point_of_sale\point_of_sale.py", line 315, in add_payment
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\orm.py", line 4223, in create
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\osv\orm.py", line 4385, in _store_set_values
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\sql_db.py", line 152, in wrapper
    File "C:\Program Files\OpenERP 6.1-20120224-003324\server\.\openerp\sql_db.py", line 212, in execute
  DataError: invalid input syntax for integer: "Cash Journal - (test)"

  2012-03-19 10:55:02,108 500 ERROR ? openerp.netsvc: invalid input
  syntax for integer: "Cash Journal - (test)"

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/959137/+subscriptions