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

Unable to update Point of sale

By
Pascal Tremblay
on 11/5/14, 5:10 AM 1,118 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--
1314
| 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.

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: 11/5/14, 5:10 AM
Seen: 1118 times
Last updated: 3/16/15, 8:10 AM