Benvenuto!
Questo è il forum ufficiale dell'Associazione Odoo Italia. Dopo esserti registrato potrai partecipare ponendo domande o rispondendo a quelle esistenti. Non scordarti di compilare il tuo profilo e consultare le linee guida prima di iniziare a scrivere.
[CE 12] - Aggiornamento moduli OCA Italia: Errore interno
Buongiorno a tutti,
stamattina ho fatto l'update dei moduli OCA Italy, ma appena ho riavviato il servizio odoo ho un errore interno.
Sul log ho i seguenti errori:
2021-06-07 08:57:17,632 11972 WARNING Hinge16_ERP odoo.models: The model project.issue.wizard has no _description
2021-06-07 08:57:17,789 11972 WARNING Hinge16_ERP odoo.models: The model multi.employee.wiz has no _description
2021-06-07 08:57:17,789 11972 WARNING Hinge16_ERP odoo.models: The model multi.payslip has no _description
2021-06-07 08:57:17,790 11972 WARNING Hinge16_ERP odoo.models: The model multi.payslip.wizard has no _description
2021-06-07 08:57:18,140 11972 WARNING Hinge16_ERP odoo.models: The model crm.task.wizard has no _description
2021-06-07 08:57:18,230 11972 WARNING Hinge16_ERP odoo.models: The model sale.promotion has no _description
2021-06-07 08:57:18,230 11972 WARNING Hinge16_ERP odoo.models: The model sale.promotion.rule has no _description
2021-06-07 08:57:18,230 11972 WARNING Hinge16_ERP odoo.models: The model sale.promotion.rule.line has no _description
2021-06-07 08:57:18,534 11972 WARNING Hinge16_ERP odoo.api: Deprecated method account_analytic_default._recurring_create_invoice in module odoo.addons.Installments_Contract.models.account_analytic_analysis
2021-06-07 08:57:18,534 11972 WARNING Hinge16_ERP odoo.api: Deprecated method SaleOrder.action_button_confirm in module odoo.addons.Installments_Contract.models.sale_order
2021-06-07 08:57:19,580 11972 WARNING Hinge16_ERP odoo.fields: Field crm.claim.date: parameter 'select' is no longer supported; use 'index' instead.
2021-06-07 08:57:19,580 11972 WARNING Hinge16_ERP odoo.fields: Field crm.claim.team_id: parameter 'select' is no longer supported; use 'index' instead.
2021-06-07 08:57:20,149 11972 ERROR Hinge16_ERP odoo.sql_db: bad query: SELECT "res_partner"."id" as "id","res_partner"."signup_token" as "signup_token",COALESCE("res_partner__website_short_description"."value", "res_partner"."website_short_description") as "website_short_description","res_partner"."ddt_invoicing_group" as "ddt_invoicing_group","res_partner"."is_pa" as "is_pa","res_partner"."signup_type" as "signup_type","res_partner"."employee" as "employee","res_partner"."ddt_code_group" as "ddt_code_group","res_partner"."payment_note" as "payment_note","res_partner"."eori_code" as "eori_code","res_partner"."picking_warn_msg" as "picking_warn_msg","res_partner"."payment_next_action" as "payment_next_action","res_partner"."pec_mail" as "pec_mail","res_partner"."license_number" as "license_number","res_partner"."payment_next_action_date" as "payment_next_action_date","res_partner"."additional_info" as "additional_info","res_partner"."pa_partner_code" as "pa_partner_code",COALESCE("res_partner__website_meta_description"."value", "res_partner"."website_meta_description") as "website_meta_description","res_partner"."manual_followup" as "manual_followup","res_partner"."register" as "register","res_partner"."type" as "type","res_partner"."register_code" as "register_code","res_partner"."is_published" as "is_published","res_partner"."picking_warn" as "picking_warn","res_partner"."codice_destinatario" as "codice_destinatario","res_partner"."rea_capital" as "rea_capital",COALESCE("res_partner__website_meta_title"."value", "res_partner"."website_meta_title") as "website_meta_title","res_partner"."pec_destinatario" as "pec_destinatario",COALESCE("res_partner__website_meta_keywords"."value", "res_partner"."website_meta_keywords") as "website_meta_keywords","res_partner"."riba_policy_expenses" as "riba_policy_expenses","res_partner"."date" as "date","res_partner"."website_meta_og_img" as "website_meta_og_img","res_partner"."e_invoice_detail_level" as "e_invoice_detail_level","res_partner"."comment" as "comment","res_partner"."debit_limit" as "debit_limit","res_partner"."purchase_warn_msg" as "purchase_warn_msg","res_partner"."credit_limit" as "credit_limit","res_partner"."message_bounce" as "message_bounce","res_partner"."active" as "active","res_partner"."signup_expiration" as "signup_expiration","res_partner"."sale_warn_msg" as "sale_warn_msg","res_partner"."display_name" as "display_name","res_partner"."invoice_warn" as "invoice_warn","res_partner"."customer" as "customer","res_partner"."rea_code" as "rea_code","res_partner"."supplier" as "supplier","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."ddt_show_price" as "ddt_show_price","res_partner"."ref" as "ref","res_partner"."rea_member_type" as "rea_member_type","res_partner"."is_company" as "is_company","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."ddt_invoice_exclude" as "ddt_invoice_exclude","res_partner"."lang" as "lang","res_partner"."rea_liquidation_state" as "rea_liquidation_state","res_partner"."color" as "color","res_partner"."email_bounced" as "email_bounced","res_partner"."register_regdate" as "register_regdate","res_partner"."tz" as "tz","res_partner"."purchase_warn" as "purchase_warn","res_partner"."partner_share" as "partner_share","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."electronic_invoice_subjected" as "electronic_invoice_subjected","res_partner"."sanitized_vat" as "sanitized_vat","res_partner"."electronic_invoice_obliged_subject" as "electronic_invoice_obliged_subject","res_partner"."website" as "website","res_partner"."fiscalcode" as "fiscalcode","res_partner"."partner_gid" as "partner_gid","res_partner"."barcode" as "barcode","res_partner"."sale_warn" as "sale_warn","res_partner"."electronic_invoice_no_contact_update" as "electronic_invoice_no_contact_update","res_partner"."function" as "function","res_partner"."industry_id" as "industry_id","res_partner"."nuts4_id" as "nuts4_id","res_partner"."payment_responsible_id" as "payment_responsible_id","res_partner"."electronic_invoice_use_this_address" as "electronic_invoice_use_this_address","res_partner"."default_transport_reason_id" as "default_transport_reason_id","res_partner"."max_invoice_in_xml" as "max_invoice_in_xml","res_partner"."street" as "street","res_partner"."company_id" as "company_id","res_partner"."payment_next_action_type" as "payment_next_action_type","res_partner"."default_transport_method_id" as "default_transport_method_id","res_partner"."group_riba" as "group_riba","res_partner"."street2" as "street2","res_partner"."e_invoice_default_product_id" as "e_invoice_default_product_id","res_partner"."riba_exclude_expenses" as "riba_exclude_expenses","res_partner"."zip" as "zip","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."create_uid" as "create_uid","res_partner"."e_invoice_price_decimal_digits" as "e_invoice_price_decimal_digits","res_partner"."city" as "city","res_partner"."rea_office" as "rea_office","res_partner"."write_uid" as "write_uid","res_partner"."e_invoice_quantity_decimal_digits" as "e_invoice_quantity_decimal_digits","res_partner"."email" as "email","res_partner"."e_invoice_discount_decimal_digits" as "e_invoice_discount_decimal_digits","res_partner"."website_id" as "website_id","res_partner"."phone" as "phone","res_partner"."create_date" as "create_date","res_partner"."mobile" as "mobile","res_partner"."write_date" as "write_date","res_partner"."out_fiscal_document_type" as "out_fiscal_document_type","res_partner"."message_main_attachment_id" as "message_main_attachment_id","res_partner"."in_fiscal_document_type" as "in_fiscal_document_type","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."company_name" as "company_name","res_partner"."carriage_condition_id" as "carriage_condition_id","res_partner"."ipa_code" as "ipa_code","res_partner"."title" as "title","res_partner"."goods_description_id" as "goods_description_id","res_partner"."vat" as "vat","res_partner"."parent_id" as "parent_id","res_partner"."transportation_reason_id" as "transportation_reason_id","res_partner"."zip_id" as "zip_id","res_partner"."transportation_method_id" as "transportation_method_id","res_partner"."user_id" as "user_id","res_partner"."city_id" as "city_id","res_partner"."team_id" as "team_id","res_partner"."register_province" as "register_province","res_partner"."nuts1_id" as "nuts1_id","res_partner"."register_fiscalpos" as "register_fiscalpos","res_partner"."firstname" as "firstname","res_partner"."state_id" as "state_id","res_partner"."nuts2_id" as "nuts2_id","res_partner"."default_transport_condition_id" as "default_transport_condition_id","res_partner"."lastname" as "lastname","res_partner"."country_id" as "country_id","res_partner"."nuts3_id" as "nuts3_id","res_partner"."credit_policy_id" as "credit_policy_id","res_partner"."name" as "name","res_partner"."default_goods_appearance_id" as "default_goods_appearance_id" FROM "res_partner" LEFT JOIN
(SELECT res_id, value FROM "ir_translation"
WHERE type='model' AND name='res.partner,website_short_description' AND lang='it_IT' AND value!='')
as "res_partner__website_short_description" ON ("res_partner"."id" = "res_partner__website_short_description"."res_id") LEFT JOIN
(SELECT res_id, value FROM "ir_translation"
WHERE type='model' AND name='res.partner,website_meta_description' AND lang='it_IT' AND value!='')
as "res_partner__website_meta_description" ON ("res_partner"."id" = "res_partner__website_meta_description"."res_id") LEFT JOIN
(SELECT res_id, value FROM "ir_translation"
WHERE type='model' AND name='res.partner,website_meta_title' AND lang='it_IT' AND value!='')
as "res_partner__website_meta_title" ON ("res_partner"."id" = "res_partner__website_meta_title"."res_id") LEFT JOIN
(SELECT res_id, value FROM "ir_translation"
WHERE type='model' AND name='res.partner,website_meta_keywords' AND lang='it_IT' AND value!='')
as "res_partner__website_meta_keywords" ON ("res_partner"."id" = "res_partner__website_meta_keywords"."res_id") WHERE "res_partner".id IN (2)
ERROR: ERRORE: la colonna res_partner.riba_policy_expenses non esiste
LINE 1: ...ebsite_meta_keywords") as "website_meta_keywords","res_partn...
^
2021-06-07 08:57:20,170 11972 ERROR Hinge16_ERP odoo.sql_db: bad query: SELECT "website"."id" as "id","website"."auto_redirect_lang" as "auto_redirect_lang","website"."company_name" as "company_name","website"."social_linkedin" as "social_linkedin","website"."homepage_id" as "homepage_id","website"."company_website" as "company_website","website"."social_youtube" as "social_youtube","website"."cdn_activated" as "cdn_activated","website"."theme_id" as "theme_id","website"."social_googleplus" as "social_googleplus","website"."cdn_filters" as "cdn_filters","website"."crm_default_team_id" as "crm_default_team_id","website"."social_instagram" as "social_instagram","website"."crm_default_user_id" as "crm_default_user_id","website"."google_analytics_key" as "google_analytics_key","website"."specific_user_account" as "specific_user_account","website"."create_uid" as "create_uid","website"."name" as "name","website"."google_management_client_id" as "google_management_client_id","website"."domain" as "domain","website"."write_uid" as "write_uid","website"."company_id" as "company_id","website"."google_management_client_secret" as "google_management_client_secret","website"."website_form_enable_metadata" as "website_form_enable_metadata","website"."default_lang_code" as "default_lang_code","website"."default_lang_id" as "default_lang_id","website"."google_maps_api_key" as "google_maps_api_key","website"."social_twitter" as "social_twitter","website"."user_id" as "user_id","website"."cdn_url" as "cdn_url","website"."create_date" as "create_date","website"."social_facebook" as "social_facebook","website"."auth_signup_uninvited" as "auth_signup_uninvited","website"."write_date" as "write_date","website"."social_github" as "social_github" FROM "website" WHERE "website".id IN (1)
ERROR: ERRORE: la transazione corrente è interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione
2021-06-07 08:57:20,174 11972 ERROR Hinge16_ERP odoo.sql_db: bad query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END)
FROM ir_model_access a
JOIN ir_model m ON (m.id = a.model_id)
JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)
WHERE m.model = 'ir.ui.view'
AND gu.uid = 4
AND a.active IS TRUE
ERROR: ERRORE: la transazione corrente è interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione
2021-06-07 08:57:20,350 11972 ERROR Hinge16_ERP werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1049, in get
value = self._data[key][field][record._ids[0]]
KeyError: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1065, in __get__
value = record.env.cache.get(record, self)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1051, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('website(1,).auth_signup_uninvited', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\website\models\ir_http.py", line 198, in _handle_exception
response = super(Http, cls)._handle_exception(exception)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\utm\models\ir_http.py", line 31, in _handle_exception
response = super(IrHttp, cls)._handle_exception(exc)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_http.py", line 182, in _handle_exception
return request._handle_exception(exception)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 776, in _handle_exception
return super(HttpRequest, self)._handle_exception(exception)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 314, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\pycompat.py", line 87, in reraise
raise value
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_http.py", line 208, in _dispatch
result = request.dispatch()
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 835, in dispatch
r = self._call_function(**self.params)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 346, in _call_function
return checked_call(self.db, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\service\model.py", line 98, in wrapper
return f(dbname, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 339, in checked_call
result = self.endpoint(*a, **kw)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 941, in __call__
return self.method(*args, **kw)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 519, in response_wrap
response = f(*args, **kw)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\website\controllers\main.py", line 96, in web_login
response = super(Website, self).web_login(redirect=redirect, *args, **kw)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 519, in response_wrap
response = f(*args, **kw)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\auth_oauth\controllers\main.py", line 94, in web_login
response = super(OAuthLogin, self).web_login(*args, **kw)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 519, in response_wrap
response = f(*args, **kw)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\auth_signup\controllers\main.py", line 22, in web_login
response.qcontext.update(self.get_auth_signup_config())
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\auth_signup\controllers\main.py", line 98, in get_auth_signup_config
'signup_enabled': request.env['res.users']._get_signup_invitation_scope() == 'b2c',
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\website\models\res_users.py", line 48, in _get_signup_invitation_scope
return current_website.auth_signup_uninvited or super(ResUsers, self)._get_signup_invitation_scope()
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1069, in __get__
self.determine_value(record)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1172, in determine_value
record._prefetch_field(self)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2880, in _prefetch_field
result = records.read([f.name for f in fs], load='_classic_write')
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2818, in read
self._read_from_database(stored, inherited)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2945, in _read_from_database
cr.execute(query_str, params)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.errors.InFailedSqlTransaction: ERRORE: la transazione corrente è interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 88, in lookup
r = d[key]
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\func.py", line 69, in wrapper
return func(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\lru.py", line 44, in __getitem__
a = self.d[obj].me
KeyError: ('ir.model.access', <function IrModelAccess.check at 0x06320078>, 4, 'ir.ui.view', 'write', False, ('it_IT',))
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 88, in lookup
r = d[key]
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\func.py", line 69, in wrapper
return func(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\lru.py", line 44, in __getitem__
a = self.d[obj].me
KeyError: ('ir.model.access', <function IrModelAccess.check at 0x03D04DB0>, 4, 'ir.ui.view', 'write', False, ('it_IT',))
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\python\lib\site-packages\werkzeug\serving.py", line 304, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\Odoo 12.0\python\lib\site-packages\werkzeug\serving.py", line 292, in execute
application_iter = app(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\service\server.py", line 434, in app
return self.app(e, s)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\service\wsgi_server.py", line 142, in application
return application_unproxied(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\service\wsgi_server.py", line 117, in application_unproxied
result = odoo.http.root(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 1320, in __call__
return self.dispatch(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 1293, in __call__
return self.app(environ, start_wrapped)
File "C:\Program Files (x86)\Odoo 12.0\python\lib\site-packages\werkzeug\middleware\shared_data.py", line 220, in __call__
return self.app(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 1488, in dispatch
result = ir_http._dispatch()
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\auth_signup\models\ir_http.py", line 19, in _dispatch
return super(Http, cls)._dispatch()
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web_editor\models\ir_http.py", line 22, in _dispatch
return super(IrHttp, cls)._dispatch()
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\http_routing\models\ir_http.py", line 403, in _dispatch
result = super(IrHttp, cls)._dispatch()
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\utm\models\ir_http.py", line 26, in _dispatch
response = super(IrHttp, cls)._dispatch()
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_http.py", line 212, in _dispatch
return cls._handle_exception(e)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\website\models\ir_http.py", line 241, in _handle_exception
if request.website.is_publisher() and isinstance(exception, werkzeug.exceptions.NotFound):
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\website\models\website.py", line 586, in is_publisher
return self.env['ir.model.access'].check('ir.ui.view', 'write', False)
File "<decorator-gen-178>", line 2, in check
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 93, in lookup
value = d[key] = self.method(*args, **kwargs)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\muk_security\models\ir_model_access.py", line 42, in check
return super(IrModelAccess, self).check(model, mode=mode, raise_exception=raise_exception)
File "<decorator-gen-23>", line 2, in check
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 93, in lookup
value = d[key] = self.method(*args, **kwargs)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_model.py", line 1269, in check
(model, self._uid,))
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.errors.InFailedSqlTransaction: ERRORE: la transazione corrente è interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione 95 0.049 4.111
2021-06-07 08:58:03,395 11972 ERROR Hinge16_ERP odoo.sql_db: bad query: SELECT "res_partner"."id" as "id","res_partner"."signup_token" as "signup_token","res_partner"."website_short_description" as "website_short_description","res_partner"."ddt_invoicing_group" as "ddt_invoicing_group","res_partner"."is_pa" as "is_pa","res_partner"."signup_type" as "signup_type","res_partner"."employee" as "employee","res_partner"."ddt_code_group" as "ddt_code_group","res_partner"."payment_note" as "payment_note","res_partner"."eori_code" as "eori_code","res_partner"."picking_warn_msg" as "picking_warn_msg","res_partner"."payment_next_action" as "payment_next_action","res_partner"."pec_mail" as "pec_mail","res_partner"."license_number" as "license_number","res_partner"."payment_next_action_date" as "payment_next_action_date","res_partner"."additional_info" as "additional_info","res_partner"."pa_partner_code" as "pa_partner_code","res_partner"."website_meta_description" as "website_meta_description","res_partner"."manual_followup" as "manual_followup","res_partner"."register" as "register","res_partner"."type" as "type","res_partner"."register_code" as "register_code","res_partner"."is_published" as "is_published","res_partner"."picking_warn" as "picking_warn","res_partner"."codice_destinatario" as "codice_destinatario","res_partner"."rea_capital" as "rea_capital","res_partner"."website_meta_title" as "website_meta_title","res_partner"."pec_destinatario" as "pec_destinatario","res_partner"."website_meta_keywords" as "website_meta_keywords","res_partner"."riba_policy_expenses" as "riba_policy_expenses","res_partner"."date" as "date","res_partner"."website_meta_og_img" as "website_meta_og_img","res_partner"."e_invoice_detail_level" as "e_invoice_detail_level","res_partner"."comment" as "comment","res_partner"."debit_limit" as "debit_limit","res_partner"."purchase_warn_msg" as "purchase_warn_msg","res_partner"."credit_limit" as "credit_limit","res_partner"."message_bounce" as "message_bounce","res_partner"."active" as "active","res_partner"."signup_expiration" as "signup_expiration","res_partner"."sale_warn_msg" as "sale_warn_msg","res_partner"."display_name" as "display_name","res_partner"."invoice_warn" as "invoice_warn","res_partner"."customer" as "customer","res_partner"."rea_code" as "rea_code","res_partner"."supplier" as "supplier","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."ddt_show_price" as "ddt_show_price","res_partner"."ref" as "ref","res_partner"."rea_member_type" as "rea_member_type","res_partner"."is_company" as "is_company","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."ddt_invoice_exclude" as "ddt_invoice_exclude","res_partner"."lang" as "lang","res_partner"."rea_liquidation_state" as "rea_liquidation_state","res_partner"."color" as "color","res_partner"."email_bounced" as "email_bounced","res_partner"."register_regdate" as "register_regdate","res_partner"."tz" as "tz","res_partner"."purchase_warn" as "purchase_warn","res_partner"."partner_share" as "partner_share","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."electronic_invoice_subjected" as "electronic_invoice_subjected","res_partner"."sanitized_vat" as "sanitized_vat","res_partner"."electronic_invoice_obliged_subject" as "electronic_invoice_obliged_subject","res_partner"."website" as "website","res_partner"."fiscalcode" as "fiscalcode","res_partner"."partner_gid" as "partner_gid","res_partner"."barcode" as "barcode","res_partner"."sale_warn" as "sale_warn","res_partner"."electronic_invoice_no_contact_update" as "electronic_invoice_no_contact_update","res_partner"."function" as "function","res_partner"."industry_id" as "industry_id","res_partner"."nuts4_id" as "nuts4_id","res_partner"."payment_responsible_id" as "payment_responsible_id","res_partner"."electronic_invoice_use_this_address" as "electronic_invoice_use_this_address","res_partner"."default_transport_reason_id" as "default_transport_reason_id","res_partner"."max_invoice_in_xml" as "max_invoice_in_xml","res_partner"."street" as "street","res_partner"."company_id" as "company_id","res_partner"."payment_next_action_type" as "payment_next_action_type","res_partner"."default_transport_method_id" as "default_transport_method_id","res_partner"."group_riba" as "group_riba","res_partner"."street2" as "street2","res_partner"."e_invoice_default_product_id" as "e_invoice_default_product_id","res_partner"."riba_exclude_expenses" as "riba_exclude_expenses","res_partner"."zip" as "zip","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."create_uid" as "create_uid","res_partner"."e_invoice_price_decimal_digits" as "e_invoice_price_decimal_digits","res_partner"."city" as "city","res_partner"."rea_office" as "rea_office","res_partner"."write_uid" as "write_uid","res_partner"."e_invoice_quantity_decimal_digits" as "e_invoice_quantity_decimal_digits","res_partner"."email" as "email","res_partner"."e_invoice_discount_decimal_digits" as "e_invoice_discount_decimal_digits","res_partner"."website_id" as "website_id","res_partner"."phone" as "phone","res_partner"."create_date" as "create_date","res_partner"."mobile" as "mobile","res_partner"."write_date" as "write_date","res_partner"."out_fiscal_document_type" as "out_fiscal_document_type","res_partner"."message_main_attachment_id" as "message_main_attachment_id","res_partner"."in_fiscal_document_type" as "in_fiscal_document_type","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."company_name" as "company_name","res_partner"."carriage_condition_id" as "carriage_condition_id","res_partner"."ipa_code" as "ipa_code","res_partner"."title" as "title","res_partner"."goods_description_id" as "goods_description_id","res_partner"."vat" as "vat","res_partner"."parent_id" as "parent_id","res_partner"."transportation_reason_id" as "transportation_reason_id","res_partner"."zip_id" as "zip_id","res_partner"."transportation_method_id" as "transportation_method_id","res_partner"."user_id" as "user_id","res_partner"."city_id" as "city_id","res_partner"."team_id" as "team_id","res_partner"."register_province" as "register_province","res_partner"."nuts1_id" as "nuts1_id","res_partner"."register_fiscalpos" as "register_fiscalpos","res_partner"."firstname" as "firstname","res_partner"."state_id" as "state_id","res_partner"."nuts2_id" as "nuts2_id","res_partner"."default_transport_condition_id" as "default_transport_condition_id","res_partner"."lastname" as "lastname","res_partner"."country_id" as "country_id","res_partner"."nuts3_id" as "nuts3_id","res_partner"."credit_policy_id" as "credit_policy_id","res_partner"."name" as "name","res_partner"."default_goods_appearance_id" as "default_goods_appearance_id" FROM "res_partner" WHERE "res_partner".id IN (2)
ERROR: ERRORE: la colonna res_partner.riba_policy_expenses non esiste
LINE 1: ...website_meta_keywords" as "website_meta_keywords","res_partn...
^
2021-06-07 08:58:03,395 11972 ERROR Hinge16_ERP odoo.addons.base.models.ir_cron: Unexpected exception while processing cron job {'id': 13, 'ir_actions_server_id': 352, 'cron_name': 'Post process payment transactions', 'user_id': 1, 'active': True, 'interval_number': 10, 'interval_type': 'minutes', 'numbercall': -1, 'doall': False, 'nextcall': datetime.datetime(2021, 6, 7, 8, 50), 'priority': 5, 'create_uid': 1, 'create_date': datetime.datetime(2020, 4, 9, 9, 15, 23, 651698), 'write_uid': 2, 'write_date': datetime.datetime(2020, 4, 15, 20, 18, 29, 602720)}
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1049, in get
value = self._data[key][field][record._ids[0]]
KeyError: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1065, in __get__
value = record.env.cache.get(record, self)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1051, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('res.users[1].tz', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1049, in get
value = self._data[key][field][record._ids[0]]
KeyError: 2
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1065, in __get__
value = record.env.cache.get(record, self)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1051, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('res.partner(2,).tz', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_cron.py", line 230, in _process_jobs
registry[cls._name]._process_job(job_cr, job, lock_cr)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_cron.py", line 136, in _process_job
now = fields.Datetime.context_timestamp(cron, datetime.now())
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1769, in context_timestamp
tz_name = record._context.get('tz') or record.env.user.tz
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1069, in __get__
self.determine_value(record)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1182, in determine_value
self.compute_value(recs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1136, in compute_value
self._compute_value(records)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1129, in _compute_value
self.compute(records)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 649, in _compute_related
record[self.name] = value[self.related_field.name]
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 5167, in __getitem__
return self._fields[key].__get__(self, type(self))
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1069, in __get__
self.determine_value(record)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1172, in determine_value
record._prefetch_field(self)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2880, in _prefetch_field
result = records.read([f.name for f in fs], load='_classic_write')
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2818, in read
self._read_from_database(stored, inherited)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2945, in _read_from_database
cr.execute(query_str, params)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedColumn: ERRORE: la colonna res_partner.riba_policy_expenses non esiste
LINE 1: ...website_meta_keywords" as "website_meta_keywords","res_partn...
^
2021-06-07 08:58:03,395 11972 ERROR Hinge16_ERP odoo.sql_db: bad query: SELECT "res_partner"."id" as "id","res_partner"."signup_token" as "signup_token","res_partner"."website_short_description" as "website_short_description","res_partner"."ddt_invoicing_group" as "ddt_invoicing_group","res_partner"."is_pa" as "is_pa","res_partner"."signup_type" as "signup_type","res_partner"."employee" as "employee","res_partner"."ddt_code_group" as "ddt_code_group","res_partner"."payment_note" as "payment_note","res_partner"."eori_code" as "eori_code","res_partner"."picking_warn_msg" as "picking_warn_msg","res_partner"."payment_next_action" as "payment_next_action","res_partner"."pec_mail" as "pec_mail","res_partner"."license_number" as "license_number","res_partner"."payment_next_action_date" as "payment_next_action_date","res_partner"."additional_info" as "additional_info","res_partner"."pa_partner_code" as "pa_partner_code","res_partner"."website_meta_description" as "website_meta_description","res_partner"."manual_followup" as "manual_followup","res_partner"."register" as "register","res_partner"."type" as "type","res_partner"."register_code" as "register_code","res_partner"."is_published" as "is_published","res_partner"."picking_warn" as "picking_warn","res_partner"."codice_destinatario" as "codice_destinatario","res_partner"."rea_capital" as "rea_capital","res_partner"."website_meta_title" as "website_meta_title","res_partner"."pec_destinatario" as "pec_destinatario","res_partner"."website_meta_keywords" as "website_meta_keywords","res_partner"."riba_policy_expenses" as "riba_policy_expenses","res_partner"."date" as "date","res_partner"."website_meta_og_img" as "website_meta_og_img","res_partner"."e_invoice_detail_level" as "e_invoice_detail_level","res_partner"."comment" as "comment","res_partner"."debit_limit" as "debit_limit","res_partner"."purchase_warn_msg" as "purchase_warn_msg","res_partner"."credit_limit" as "credit_limit","res_partner"."message_bounce" as "message_bounce","res_partner"."active" as "active","res_partner"."signup_expiration" as "signup_expiration","res_partner"."sale_warn_msg" as "sale_warn_msg","res_partner"."display_name" as "display_name","res_partner"."invoice_warn" as "invoice_warn","res_partner"."customer" as "customer","res_partner"."rea_code" as "rea_code","res_partner"."supplier" as "supplier","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."ddt_show_price" as "ddt_show_price","res_partner"."ref" as "ref","res_partner"."rea_member_type" as "rea_member_type","res_partner"."is_company" as "is_company","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."ddt_invoice_exclude" as "ddt_invoice_exclude","res_partner"."lang" as "lang","res_partner"."rea_liquidation_state" as "rea_liquidation_state","res_partner"."color" as "color","res_partner"."email_bounced" as "email_bounced","res_partner"."register_regdate" as "register_regdate","res_partner"."tz" as "tz","res_partner"."purchase_warn" as "purchase_warn","res_partner"."partner_share" as "partner_share","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."electronic_invoice_subjected" as "electronic_invoice_subjected","res_partner"."sanitized_vat" as "sanitized_vat","res_partner"."electronic_invoice_obliged_subject" as "electronic_invoice_obliged_subject","res_partner"."website" as "website","res_partner"."fiscalcode" as "fiscalcode","res_partner"."partner_gid" as "partner_gid","res_partner"."barcode" as "barcode","res_partner"."sale_warn" as "sale_warn","res_partner"."electronic_invoice_no_contact_update" as "electronic_invoice_no_contact_update","res_partner"."function" as "function","res_partner"."industry_id" as "industry_id","res_partner"."nuts4_id" as "nuts4_id","res_partner"."payment_responsible_id" as "payment_responsible_id","res_partner"."electronic_invoice_use_this_address" as "electronic_invoice_use_this_address","res_partner"."default_transport_reason_id" as "default_transport_reason_id","res_partner"."max_invoice_in_xml" as "max_invoice_in_xml","res_partner"."street" as "street","res_partner"."company_id" as "company_id","res_partner"."payment_next_action_type" as "payment_next_action_type","res_partner"."default_transport_method_id" as "default_transport_method_id","res_partner"."group_riba" as "group_riba","res_partner"."street2" as "street2","res_partner"."e_invoice_default_product_id" as "e_invoice_default_product_id","res_partner"."riba_exclude_expenses" as "riba_exclude_expenses","res_partner"."zip" as "zip","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."create_uid" as "create_uid","res_partner"."e_invoice_price_decimal_digits" as "e_invoice_price_decimal_digits","res_partner"."city" as "city","res_partner"."rea_office" as "rea_office","res_partner"."write_uid" as "write_uid","res_partner"."e_invoice_quantity_decimal_digits" as "e_invoice_quantity_decimal_digits","res_partner"."email" as "email","res_partner"."e_invoice_discount_decimal_digits" as "e_invoice_discount_decimal_digits","res_partner"."website_id" as "website_id","res_partner"."phone" as "phone","res_partner"."create_date" as "create_date","res_partner"."mobile" as "mobile","res_partner"."write_date" as "write_date","res_partner"."out_fiscal_document_type" as "out_fiscal_document_type","res_partner"."message_main_attachment_id" as "message_main_attachment_id","res_partner"."in_fiscal_document_type" as "in_fiscal_document_type","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."company_name" as "company_name","res_partner"."carriage_condition_id" as "carriage_condition_id","res_partner"."ipa_code" as "ipa_code","res_partner"."title" as "title","res_partner"."goods_description_id" as "goods_description_id","res_partner"."vat" as "vat","res_partner"."parent_id" as "parent_id","res_partner"."transportation_reason_id" as "transportation_reason_id","res_partner"."zip_id" as "zip_id","res_partner"."transportation_method_id" as "transportation_method_id","res_partner"."user_id" as "user_id","res_partner"."city_id" as "city_id","res_partner"."team_id" as "team_id","res_partner"."register_province" as "register_province","res_partner"."nuts1_id" as "nuts1_id","res_partner"."register_fiscalpos" as "register_fiscalpos","res_partner"."firstname" as "firstname","res_partner"."state_id" as "state_id","res_partner"."nuts2_id" as "nuts2_id","res_partner"."default_transport_condition_id" as "default_transport_condition_id","res_partner"."lastname" as "lastname","res_partner"."country_id" as "country_id","res_partner"."nuts3_id" as "nuts3_id","res_partner"."credit_policy_id" as "credit_policy_id","res_partner"."name" as "name","res_partner"."default_goods_appearance_id" as "default_goods_appearance_id" FROM "res_partner" WHERE "res_partner".id IN (2)
ERROR: ERRORE: la colonna res_partner.riba_policy_expenses non esiste
LINE 1: ...website_meta_keywords" as "website_meta_keywords","res_partn...
^
2021-06-07 08:58:03,411 11972 ERROR Hinge16_ERP odoo.addons.base.models.ir_cron: Unexpected exception while processing cron job {'id': 5, 'ir_actions_server_id': 122, 'cron_name': 'Mail: Fetchmail Service', 'user_id': 1, 'active': True, 'interval_number': 5, 'interval_type': 'minutes', 'numbercall': -1, 'doall': False, 'nextcall': datetime.datetime(2021, 6, 7, 8, 50), 'priority': 5, 'create_uid': 1, 'create_date': datetime.datetime(2020, 4, 9, 9, 13, 33, 503992), 'write_uid': 2, 'write_date': datetime.datetime(2020, 4, 15, 20, 19, 52, 330044)}
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1049, in get
value = self._data[key][field][record._ids[0]]
KeyError: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1065, in __get__
value = record.env.cache.get(record, self)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1051, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('res.users[1].tz', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1049, in get
value = self._data[key][field][record._ids[0]]
KeyError: 2
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1065, in __get__
value = record.env.cache.get(record, self)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 1051, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('res.partner(2,).tz', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_cron.py", line 230, in _process_jobs
registry[cls._name]._process_job(job_cr, job, lock_cr)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_cron.py", line 136, in _process_job
now = fields.Datetime.context_timestamp(cron, datetime.now())
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1769, in context_timestamp
tz_name = record._context.get('tz') or record.env.user.tz
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1069, in __get__
self.determine_value(record)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1182, in determine_value
self.compute_value(recs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1136, in compute_value
self._compute_value(records)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1129, in _compute_value
self.compute(records)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 649, in _compute_related
record[self.name] = value[self.related_field.name]
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 5167, in __getitem__
return self._fields[key].__get__(self, type(self))
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1069, in __get__
self.determine_value(record)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 1172, in determine_value
record._prefetch_field(self)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2880, in _prefetch_field
result = records.read([f.name for f in fs], load='_classic_write')
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2818, in read
self._read_from_database(stored, inherited)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2945, in _read_from_database
cr.execute(query_str, params)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedColumn: ERRORE: la colonna res_partner.riba_policy_expenses non esiste
LINE 1: ...website_meta_keywords" as "website_meta_keywords","res_partn...
^
Ditemi che non devo buttare tutto, è l'ambiente di produzione, per fortuna il mio quindi con i clienti non ho grattacapi.
Scaricare il codice aggiornato non è sufficiente.
Ogni qual volta aggiorni il codice sorgente, devi lanciare la procedura di aggiornamento del db:
odoo -c /etc/odoo/odoo.conf -d nome_database -u moduli_da_aggiornare --stop-after-init
[moduli da aggiornare] puoi sostituirlo con all
il comando odoo può variare siccome dipende dalla metodologia di installazione scelta, così come il percorso del file di configurazione.
Per lanciare questo comando devi teoricamente prima spegnere il servizio odoo
Ciao Simone,
quando si aggiornano i moduli va sempre lanciato Odoo con '-d nomedatabase -u all' (oppure con il modulo specifico aggiornato se lo sai), altrimenti è possibile che si blocchi, non essendo creati eventuali nuovi campi del database, aggiornare le viste, ecc.
Se l'hai fatto, è da approfondire.
Se il backup l'hai creato in modalità ZIP dovresti avere il filestore incluse.
Puoi comunque spostare il filestore manualmente, esiste proprio una cartella chiamata "filestore"
Buonasera a tutti, ho fatto le operazioni suggerite, e confermo che l'istanza di Odoo è ripartita. Ma ho un grosso problema con il FileStore, non mi ha rigenerato i file e sembrano essere corrotti e non so se devo effettuare altri comandi.
In particolare, se mi loggo andando sull'url /web mi ritrovo una pagina bianca, non la blank page come segnalata sui vari siti, proprio pagina bianca, come se non riesce a caricare i file. Ho fatto una prova quindi a creare un nuovo database e con il nuovo database mi loggo tranquillamente ed ho la visibilità del sito.
Ora però ho il terribile sospetto che i dati dal database reale non posso portarli nel nuovo, giusto? Come posso fare a travasarli?
Grazie,
Simone
Resta informato
Informazioni sulla comunità
Strumenti di richiesta
Statistiche
Richiesta del: 07/06/21, 09:05 |
Vista: 1132 volte |
Ultimo aggiornamento: 09/06/21, 11:42 |