openerp-india team mailing list archive

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

Hi,

The video is a little confusing for me, since on your end, the POS id
synchronising correctly once the server is stopped. I added a video of
my own below to show you what I mean.

Also, on your end, the web interface keeps on working when you stop the
openerp service. On my end, only POS can work that way, nothing else.

Just for clarity, the error behaviour only appears after I stopped the OpenERP server after initial installation. So say I install OpenERP, I create a new database, then I go to POS, and start selling stuff, the red box in top right showing (x pending orders) is there for 1 second, and dissapears. Then all POS backend entries appear correctly.
Then I stop the openERP server, and then when I go to POS again and start selling stuff, thered box in top right stays there. Once I restart the server again, I get the shown error message in the logs.
It doesn't matter now If I sell stuff with the server running or not, it will never synchronise again

Dieter

** Attachment added: "poserror.avi"
   https://bugs.launchpad.net/openobject-addons/+bug/959137/+attachment/2988924/+files/poserror.avi

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