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

how to configure WH?

By
Qamar Soft
on 11/21/14, 6:14 AM 1,086 views

I create new warehouse with routes buy and Make To order

when I run the schedule I get

 

2014-11-21 11:44:16,970 9745 ERROR test81 openerp.sql_db: Programming error: column purchase_requisition.log does not exist
LINE 1: ...ition."create_uid",purchase_requisition."user_id",purchase_r...
                                                             ^
, in query  SELECT purchase_requisition."origin",purchase_requisition."exclusive",purchase_requisition."create_date",purchase_requisition."date_end",purchase_requisition."write_uid",purchase_requisition."id",purchase_requisition."create_uid",purchase_requisition."user_id",purchase_requisition."log",purchase_requisition."picking_type_id",purchase_requisition."message_last_post",purchase_requisition."company_id",purchase_requisition."state",purchase_requisition."ordering_date",purchase_requisition."account_analytic_id",purchase_requisition."procurement_id",purchase_requisition."description",purchase_requisition."warehouse_id",purchase_requisition."write_date",purchase_requisition."schedule_date",purchase_requisition."date_approve",purchase_requisition."multiple_rfq_per_supplier",purchase_requisition."name" FROM "purchase_requisition"
                    WHERE purchase_requisition.id IN %s AND (TRUE)
                    ORDER BY id
                
2014-11-21 11:44:16,970 9745 ERROR test81 openerp.http: Exception during JSON request handling.
Traceback (most recent call last):
  File "/opt/odoo/odoo-8.0/openerp/http.py", line 499, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/opt/odoo/odoo-8.0/openerp/http.py", line 516, in dispatch
    result = self._call_function(**self.params)
  File "/opt/odoo/odoo-8.0/openerp/http.py", line 282, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/service/model.py", line 113, in wrapper
    return f(dbname, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/http.py", line 279, in checked_call
    return self.endpoint(*a, **kw)
  File "/opt/odoo/odoo-8.0/openerp/http.py", line 732, in __call__
    return self.method(*args, **kw)
  File "/opt/odoo/odoo-8.0/openerp/http.py", line 375, in response_wrap
    response = f(*args, **kw)
  File "/opt/odoo/odoo-8.0/addons/web/controllers/main.py", line 948, in call_button
    action = self._call_kw(model, method, args, {})
  File "/opt/odoo/odoo-8.0/addons/web/controllers/main.py", line 936, in _call_kw
    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/addons/stock/procurement.py", line 210, in run
    res = super(procurement_order, self).run(cr, uid, new_ids, autocommit=autocommit, context=context)
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/addons/procurement/procurement.py", line 207, in run
    res = self._run(cr, uid, procurement, context=context or {})
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/addons/purchase_requisition/purchase_requisition.py", line 410, in _run
    'product_qty': procurement.product_qty
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/addons/mail/mail_thread.py", line 377, in create
    thread_id = super(mail_thread, self).create(cr, uid, values, context=context)
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 332, in old_api
    result = method(recs, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/models.py", line 3972, in create
    record = self.browse(self._create(old_vals))
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 464, in new_api
    result = method(self._model, cr, uid, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/models.py", line 4169, in _create
    self.pool[model_name]._store_set_values(cr, user, ids, fields2, context)
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/models.py", line 4304, in _store_set_values
    result = self._columns[f].get(cr, self, ids, f, SUPERUSER_ID, context=context)
  File "/opt/odoo/odoo-8.0/openerp/osv/fields.py", line 1308, in get
    result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
  File "/opt/odoo/odoo-8.0/openerp/osv/fields.py", line 1379, in _fnct_read
    res[record.id] = value[self.arg[-1]]
  File "/opt/odoo/odoo-8.0/openerp/models.py", line 5443, in __getitem__
    return self._fields[key].__get__(self, type(self))
  File "/opt/odoo/odoo-8.0/openerp/fields.py", line 711, in __get__
    self.determine_value(record)
  File "/opt/odoo/odoo-8.0/openerp/fields.py", line 806, in determine_value
    record._prefetch_field(self)
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/models.py", line 3182, in _prefetch_field
    result = records.read(list(fnames), load='_classic_write')
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/models.py", line 3129, in read
    self._read_from_database(stored)
  File "/opt/odoo/odoo-8.0/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/models.py", line 3239, in _read_from_database
    cr.execute(query, [tuple(sub_ids)] + rule_params)
  File "/opt/odoo/odoo-8.0/openerp/sql_db.py", line 158, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/odoo/odoo-8.0/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column purchase_requisition.log does not exist
LINE 1: ...ition."create_uid",purchase_requisition."user_id",purchase_r...

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/21/14, 6:14 AM
Seen: 1086 times
Last updated: 3/16/15, 8:10 AM