Odoo Help

0

Unable to update Point of sale

By
Pascal Tremblay
on 11/5/14, 5:10 AM 1,255 views

I'm unable to update « point of sale » module.

Somebody could help me?

Here is my log file :

2014-11-05 10:07:03,422 28908 INFO la_page_pt openerp.service.server: Initiating shutdown
2014-11-05 10:07:03,423 28908 INFO la_page_pt openerp.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2014-11-05 10:07:05,216 29092 INFO ? openerp: OpenERP version 8.0-8a9027e
2014-11-05 10:07:05,216 29092 INFO ? openerp: addons paths: ['/var/lib/odoo/addons/8.0', u'/usr/lib/python2.7/dist-packages/openerp/addons']
2014-11-05 10:07:05,216 29092 INFO ? openerp: database hostname: localhost
2014-11-05 10:07:05,216 29092 INFO ? openerp: database port: 5432
2014-11-05 10:07:05,216 29092 INFO ? openerp: database user: odoo
2014-11-05 10:07:05,395 29092 INFO ? openerp.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069
2014-11-05 10:07:05,401 29092 INFO la_page_pt openerp.modules.loading: loading 1 modules...
2014-11-05 10:07:05,531 29092 INFO la_page_pt openerp.modules.loading: 1 modules loaded in 0.13s, 0 queries
2014-11-05 10:07:05,554 29092 INFO la_page_pt openerp.modules.loading: loading 77 modules...
2014-11-05 10:07:05,558 29092 INFO la_page_pt passlib.registry: registered crypt handler 'pbkdf2_sha512': <class 'passlib.handlers.pbkdf2.pbkdf2_sha512'>
2014-11-05 10:07:05,558 29092 INFO la_page_pt passlib.registry: registered crypt handler 'md5_crypt': <class 'passlib.handlers.md5_crypt.md5_crypt'>
2014-11-05 10:07:05,626 29092 INFO ? openerp.addons.bus.bus: Bus.loop listen imbus on db postgres
2014-11-05 10:07:05,638 29092 INFO la_page_pt openerp.addons.report.models.report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2014-11-05 10:07:07,816 29092 INFO la_page_pt openerp.modules.loading: 77 modules loaded in 2.26s, 0 queries
2014-11-05 10:07:07,897 29092 INFO la_page_pt openerp.modules.loading: Modules loaded.
2014-11-05 10:07:23,178 29092 INFO ? openerp.http: HTTP Configuring static files
2014-11-05 10:07:23,185 29092 INFO la_page_pt_5 openerp.modules.loading: loading 1 modules...
2014-11-05 10:07:23,323 29092 INFO la_page_pt_5 openerp.modules.loading: 1 modules loaded in 0.14s, 0 queries
2014-11-05 10:07:23,360 29092 INFO la_page_pt_5 openerp.modules.loading: loading 83 modules...
2014-11-05 10:07:25,399 29092 INFO la_page_pt_5 openerp.modules.module: module point_of_sale: creating or updating database tables
2014-11-05 10:07:25,810 29092 INFO la_page_pt_5 openerp.addons.auth_crypt.auth_crypt: Hashing passwords, may be slow for databases with many users...
2014-11-05 10:07:25,888 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/data/report_paperformat.xml
2014-11-05 10:07:25,897 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/security/point_of_sale_security.xml
2014-11-05 10:07:26,202 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/security/ir.model.access.csv
2014-11-05 10:07:26,492 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/wizard/pos_box.xml
2014-11-05 10:07:26,513 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/wizard/pos_confirm.xml
2014-11-05 10:07:26,535 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/wizard/pos_details.xml
2014-11-05 10:07:26,561 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/wizard/pos_discount.xml
2014-11-05 10:07:26,584 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/wizard/pos_open_statement.xml
2014-11-05 10:07:26,616 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/wizard/pos_payment.xml
2014-11-05 10:07:26,642 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/wizard/pos_session_opening.xml
2014-11-05 10:07:26,669 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/views/templates.xml
2014-11-05 10:07:26,687 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/point_of_sale_report.xml
2014-11-05 10:07:26,840 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/point_of_sale_view.xml
2014-11-05 10:07:27,684 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/point_of_sale_sequence.xml
2014-11-05 10:07:27,705 29092 INFO la_page_pt_5 openerp.modules.loading: loading point_of_sale/point_of_sale_data.xml
2014-11-05 10:07:27,745 29092 INFO la_page_pt_5 werkzeug: 192.168.1.25 - - [05/Nov/2014 10:07:27] "GET / HTTP/1.1" 500 -
2014-11-05 10:07:27,757 29092 ERROR la_page_pt_5 werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/service/server.py", line 280, in app
    return self.app(e, s)
  File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 216, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 202, in application_unproxied
    result = handler(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1215, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1189, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 579, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1347, in dispatch
    ir_http = request.registry['ir.http']
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 319, in registry
    return openerp.modules.registry.RegistryManager.get(self.db) if self.db else None
  File "/usr/lib/python2.7/dist-packages/openerp/modules/registry.py", line 293, in get
    update_module)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/registry.py", line 324, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 354, in load_modules
    force, status, report, loaded_modules, update_module)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 263, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 182, in load_module_graph
    _load_data(cr, module_name, idref, mode, kind='data')
  File "/usr/lib/python2.7/dist-packages/openerp/modules/loading.py", line 118, in _load_data
    tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
  File "/usr/lib/python2.7/dist-packages/openerp/tools/convert.py", line 899, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/usr/lib/python2.7/dist-packages/openerp/tools/convert.py", line 985, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/usr/lib/python2.7/dist-packages/openerp/tools/convert.py", line 851, in parse
    self._tags[rec.tag](self.cr, rec, n, mode=mode)
  File "/usr/lib/python2.7/dist-packages/openerp/tools/convert.py", line 765, in _tag_record
    id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_model.py", line 1052, in _update
    res_id = model_obj.create(cr, uid, values, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/point_of_sale/point_of_sale.py", line 209, in create
    return super(pos_config, self).create(cr, uid, values, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 332, in old_api
    result = method(recs, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3951, in create
    record = self.browse(self._create(old_vals))
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 464, in new_api
    result = method(self._model, cr, uid, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4089, in _create
    tuple([u[2] for u in updates if len(u) > 2])
  File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 158, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
ParseError: "null value in column "stock_location_id" violates not-null constraint
DETAIL:  Failing row contains (3, 2014-11-05 10:07:25.882092, 22xxxxxxxxNN, 1, 042*, f, null, null, f, f, null, 2014-11-05 10:07:25.882092, 21xxxxxNNDDD, f, 23xxxxxNNNDD, 258, f, null, f, Main, 64, null, 4, f, 1, active, t, t, 5, f, 041*, *).
" while parsing /usr/lib/python2.7/dist-packages/openerp/addons/point_of_sale/point_of_sale_data.xml:30, near
<record model="pos.config" id="pos_config_main">
            <field name="name">Main</field>
            <field name="picking_type_id" ref="picking_type_posout"/>
        </record>

I have cleaned the table pos_config.

I have exported all my database in a plain file. NO TRACE of the line (3, 2014-11-05 10:07:25.882092, 22xxxxxxxxNN, 1, 042*, f, null, null, f, f, null, 2014-11-05 10:07:25.882092, 21xxxxxNNDDD, f, 23xxxxxNNNDD, 258, f, null, f, Main, 64, null, 4, f, 1, active, t, t, 5, f, 041*, *)

I have also try to delete ALL tables beginning by « pos_* » and ALL sequences beginning by « pos_* ». Still the same error... I don't understand how to reset Point of sale.

0

Pascal Tremblay

--Pascal Tremblay--
1617
| 5 2 7
Alma, Canada
--Pascal Tremblay--


Pascal Tremblay
On 11/5/14, 8:55 PM

to solve this error, I have erased all custom physical locations and warehouses.

Thanks to me. Next error now.

About This Community

This platform 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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 11/5/14, 5:10 AM
Seen: 1255 times
Last updated: 3/16/15, 8:10 AM