Have tried to set in USD $ in the currency rate. And get an error in the database.
Its not possible. Is it a bug in the Odoo 17.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Comptabilitat
- Inventari
- PoS
- Project
- MRP
This question has been flagged
Hi,
From the shared message, it seems you have deleted the system generated USD currency and manually created a currency with name USD.
Now when you are trying to upgrade the base module, system trying to create the deleted currency which is USD, in order to solve the error, open the currency menu and search for USD currency and set its external ID as: base.USD
By setting this external id for existing USD, you can solve the issue.
Other option is two delete the current usd currency (not sure if it is used in db or not), if no delete the currency and upgrade base.
Thanks
It should be possible to upload pictures here. And the other hand databases is not working correctly.
Picture create Odoo Error . PLease use copy button to report service. Is quiet stif and database is locked to
I sent it into odoo aswell per e mail. Such is elementary in any erp system.
Copy of rpc Erro
Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/service/model.py", line 133, in retrying result = func() File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1810, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) File "/home/odoo/src/odoo/17.0/odoo/http.py", line 2014, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) File "/home/odoo/src/odoo/17.0/addons/website/models/ir_http.py", line 235, in _dispatch response = super()._dispatch(endpoint) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_http.py", line 221, in _dispatch result = endpoint(**request.params) File "/home/odoo/src/odoo/17.0/odoo/http.py", line 757, in route_wrapper result = endpoint(self, *args, **params_ok) File "/home/odoo/src/odoo/17.0/addons/web/controllers/dataset.py", line 24, in call_kw return self._call_kw(model, method, args, kwargs) File "/home/odoo/src/odoo/17.0/addons/web/controllers/dataset.py", line 20, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/home/odoo/src/odoo/17.0/odoo/api.py", line 468, in call_kw result = _call_kw_multi(method, model, args, kwargs) File "/home/odoo/src/odoo/17.0/odoo/api.py", line 453, in _call_kw_multi result = method(recs, *args, **kwargs) File "/home/odoo/src/odoo/17.0/addons/web/models/models.py", line 73, in web_save self = self.create(vals) File "<decorator-gen-104>", line 2, in create File "/home/odoo/src/odoo/17.0/odoo/api.py", line 414, in _model_create_multi return create(self, [arg]) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/res_currency.py", line 57, in create res = super().create(vals_list) File "<decorator-gen-12>", line 2, in create File "/home/odoo/src/odoo/17.0/odoo/api.py", line 415, in _model_create_multi return create(self, arg) File "/home/odoo/src/odoo/17.0/odoo/models.py", line 4646, in create records = self._create(data_list) File "/home/odoo/src/odoo/17.0/odoo/models.py", line 4834, in _create cr.execute(SQL( File "/home/odoo/src/odoo/17.0/odoo/sql_db.py", line 332, in execute res = self._obj.execute(query, params) psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "res_currency_unique_name" DETAIL: Key (name)=(USD) already exists. During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1783, in _serve_db return service_model.retrying(self._serve_ir_http, self.env) File "/home/odoo/src/odoo/17.0/odoo/service/model.py", line 152, in retrying raise _as_validation_error(env, exc) from exc File "/home/odoo/src/odoo/17.0/odoo/service/model.py", line 111, in _as_validation_error translate_sql_constraint(env.cr, exc.diag.constraint_name, env.context.get('lang', 'en_US')) File "/home/odoo/src/odoo/17.0/odoo/tools/translate.py", line 442, in translate_sql_constraint return cr.fetchone()[0] TypeError: 'NoneType' object is not subscriptable The above server error caused the following client error: RPC_ERROR: Odoo Server Error RPC_ERROR at makeErrorFromResponse (https://green-iceberg-as-team.odoo.com/web/assets/468fcc3/web.assets_web.min.js:2910:163) at XMLHttpRequest.<anonymous> (https://green-iceberg-as-team.odoo.com/web/assets/468fcc3/web.assets_web.min.js:2914:13)
I updated the data base aswell just now. To see if there are something wrong in the old database for Odoo.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrar-se
Please post the error, as it probably contains information readers would find helpful when considering how to help you.