openerp-india team mailing list archive

["Dieter \(Skillteam\)" <959137@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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)"

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
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):
  New

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