Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi
Odoo website stops working, I am not able to login in odoo.Getting following error on login page
Error to render compiling AST AttributeError: 'website' object has no attribute 'get_pricelist_available' Template: website_sale.pricelist_list Path: /templates/t/t Node: <t t-set="website_sale_pricelists" t-value="website.get_pricelist_available(show_visible=True)"/>
If you can't login anymore, just try to update the website_sale module from the command line.
As Ermin said, this is a view error, not a database problem. Yoau have certainly tried to customize an xml file.
Try to update the website_sale from command line. If you don't know how, please read the docs at \https://www.odoo.com/documentation/11.0/reference/cmdline.html
You will typically stop the server first then, then run it as a user (use the --stop-after-init option).
This is a very common error when you start module customization in Odoo.
[fr] Une des solutions pour les débutants sur odoo et les non-développeur, désinstallé et réinstallé le module concerné pour réinitialiser à l'état d'usine. Cette méthode peut mettre en périlles des données, veuillez donc trouver une solution pour sauvegarder vos données relié à ce module.
Conseil : avant toute modification sur le xml, tester votre modification sur on Odoo de teste pour éviter une erreur fatal.
[en] One of the solutions for beginners on odoo and non-developers, uninstalled and reinstalled the concerned module to reset to the factory state. This method can jeopardize data, so please find a solution to save your data related to this module.
Tip: Before making any changes to the xml, test your Odoo on test to avoid a fatal error.
I have tried above solution several time but not working, I think it is something database crash issue. I don't have latest database backup. Please let me know how can i restore database.
How do you want to restore something you do not have???
Is this your complete traceback concerning your error? If yes, then you do not have a database problem obviously. Just your view is screwed up.
I mean how to repair database in odoo 10
Here is last error log
File "/usr/lib/python2.7/site-packages/odoo/tools/convert.py", line 802, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/lib/python2.7/site-packages/odoo/tools/convert.py", line 710, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_model.py", line 1189, in _update
record.write(values)
File "/usr/lib/python2.7/site-packages/odoo/addons/website_version/models/ir_ui_view.py", line 62, in write
return super(view, self).write(vals)
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_ui_view.py", line 378, in write
return super(View, self).write(self._compute_defaults(vals))
File "/usr/lib/python2.7/site-packages/odoo/models.py", line 3572, in write
self._fields[key].determine_inverse(self)
File "/usr/lib/python2.7/site-packages/odoo/fields.py", line 1000, in determine_inverse
getattr(records, self.inverse)()
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_ui_view.py", line 220, in _inverse_arch
view.write(data)
File "/usr/lib/python2.7/site-packages/odoo/addons/website_version/models/ir_ui_view.py", line 62, in write
return super(view, self).write(vals)
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_ui_view.py", line 378, in write
return super(View, self).write(self._compute_defaults(vals))
File "/usr/lib/python2.7/site-packages/odoo/models.py", line 3564, in write
self._write(old_vals)
File "/usr/lib/python2.7/site-packages/odoo/models.py", line 3715, in _write
self._validate_fields(vals)
File "/usr/lib/python2.7/site-packages/odoo/models.py", line 1083, in _validate_fields
raise ValidationError("%s\n\n%s" % (_("Error while validating constraint"), tools.ustr(e)))
ParseError: "Error while validating constraint
Field `website_description` does not exist
Error context:
View `product.product.sale.order`
[view_id: 650, xml_id: sale.product_form_view_sale_order_button, model: product.product, parent_id: 396]
None" while parsing /usr/lib/python2.7/site-packages/odoo/addons/sale/views/sale_views.xml:584, near
<record model="ir.ui.view" id="product_form_view_sale_order_button">
<field name="name">product.product.sale.order</field>
<field name="model">product.product</field>
<field name="inherit_id" ref="product.product_normal_form_view"/>
<field name="groups_id" eval="[(4, ref('sales_team.group_sale_salesman'))]"/>
<field name="arch" type="xml">
<div name="button_box" position="inside">
<button class="oe_stat_button" name="%(action_product_sale_list)d" type="action" icon="fa-usd">
<field string="Sales" name="sales_count" widget="statinfo"/>
</button>
</div>
</field>
</record>
2018-01-05 08:43:15,553 6840 INFO adams_ecommerce werkzeug: 127.0.0.1 - - [05/Jan/2018 08:43:15] "GET /shop/categories/abrasives-wood-abrasives-flap-discs-surface-conditioning-1236 HTTP/1.1" 500 -
2018-01-05 08:43:15,556 6840 INFO adams_ecommerce odoo.modules.loading: loading 1 modules...
2018-01-05 08:43:15,596 6840 INFO adams_ecommerce odoo.modules.loading: 1 modules loaded in 0.04s, 0 queries
2018-01-05 08:43:15,635 6840 ERROR adams_ecommerce werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/werkzeug/serving.py", line 177, in run_wsgi
execute(self.server.app)
File "/usr/lib/python2.7/site-packages/werkzeug/serving.py", line 165, in execute
application_iter = app(environ, start_response)
File "/usr/lib/python2.7/site-packages/odoo/service/server.py", line 250, in app
return self.app(e, s)
File "/usr/lib/python2.7/site-packages/odoo/service/wsgi_server.py", line 182, in application
return werkzeug.contrib.fixers.ProxyFix(application_unproxied)(environ, start_response)
File "/usr/lib/python2.7/site-packages/werkzeug/contrib/fixers.py", line 144, in __call__
return self.app(environ, start_response)
File "/usr/lib/python2.7/site-packages/odoo/service/wsgi_server.py", line 170, in application_unproxied
result = handler(environ, start_response)
File "/usr/lib/python2.7/site-packages/odoo/http.py", line 1306, in __call__
return self.dispatch(environ, start_response)
File "/usr/lib/python2.7/site-packages/odoo/http.py", line 1280, in __call__
return self.app(environ, start_wrapped)
File "/usr/lib/python2.7/site-packages/werkzeug/wsgi.py", line 579, in __call__
return self.app(environ, start_response)
File "/usr/lib/python2.7/site-packages/odoo/http.py", line 1461, in dispatch
odoo.registry(db).check_signaling()
File "/usr/lib/python2.7/site-packages/odoo/__init__.py", line 52, in registry
return modules.registry.Registry(database_name)
File "/usr/lib/python2.7/site-packages/odoo/modules/registry.py", line 59, in __new__
return cls.new(db_name)
File "/usr/lib/python2.7/site-packages/odoo/modules/registry.py", line 82, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/usr/lib/python2.7/site-packages/odoo/modules/loading.py", line 335, in load_modules
force, status, report, loaded_modules, update_module)
File "/usr/lib/python2.7/site-packages/odoo/modules/loading.py", line 237, 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/site-packages/odoo/modules/loading.py", line 156, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/usr/lib/python2.7/site-packages/odoo/modules/loading.py", line 95, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/usr/lib/python2.7/site-packages/odoo/tools/convert.py", line 848, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/usr/lib/python2.7/site-packages/odoo/tools/convert.py", line 918, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/usr/lib/python2.7/site-packages/odoo/tools/convert.py", line 802, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/lib/python2.7/site-packages/odoo/tools/convert.py", line 710, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_model.py", line 1189, in _update
record.write(values)
File "/usr/lib/python2.7/site-packages/odoo/addons/website_version/models/ir_ui_view.py", line 62, in write
return super(view, self).write(vals)
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_ui_view.py", line 378, in write
return super(View, self).write(self._compute_defaults(vals))
File "/usr/lib/python2.7/site-packages/odoo/models.py", line 3572, in write
self._fields[key].determine_inverse(self)
File "/usr/lib/python2.7/site-packages/odoo/fields.py", line 1000, in determine_inverse
getattr(records, self.inverse)()
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_ui_view.py", line 220, in _inverse_arch
view.write(data)
File "/usr/lib/python2.7/site-packages/odoo/addons/website_version/models/ir_ui_view.py", line 62, in write
return super(view, self).write(vals)
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_ui_view.py", line 378, in write
return super(View, self).write(self._compute_defaults(vals))
File "/usr/lib/python2.7/site-packages/odoo/models.py", line 3564, in write
self._write(old_vals)
File "/usr/lib/python2.7/site-packages/odoo/models.py", line 3715, in _write
self._validate_fields(vals)
File "/usr/lib/python2.7/site-packages/odoo/models.py", line 1083, in _validate_fields
raise ValidationError("%s\n\n%s" % (_("Error while validating constraint"), tools.ustr(e)))
ParseError: "Error while validating constraint
Field `website_description` does not exist
Error context:
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo/service/model.py", line 119, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/odoo/http.py", line 327, in checked_call
result.flatten()
File "/usr/lib/python2.7/site-packages/odoo/http.py", line 1257, in flatten
self.response.append(self.render())
File "/usr/lib/python2.7/site-packages/odoo/http.py", line 1250, in render
return env["ir.ui.view"].render_template(self.template, self.qcontext)
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_ui_view.py", line 1036, in render_template
return self.browse(self.get_view_id(template)).render(values, engine)
File "/usr/lib/python2.7/site-packages/odoo/addons/website/models/ir_ui_view.py", line 110, in render
return super(View, self).render(values, engine=engine)
File "/usr/lib/python2.7/site-packages/odoo/addons/web_editor/models/ir_ui_view.py", line 26, in render
return super(IrUiView, self).render(values=values, engine=engine)
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_ui_view.py", line 1056, in render
return self.env[engine].render(self.id, qcontext)
***********************************************************
View `product.product.sale.order`
[view_id: 650, xml_id: sale.product_form_view_sale_order_button, model: product.product, parent_id: 396]
None" while parsing /usr/lib/python2.7/site-packages/odoo/addons/sale/views/sale_views.xml:584, near
<record model="ir.ui.view" id="product_form_view_sale_order_button">
<field name="name">product.product.sale.order</field>
<field name="model">product.product</field>
<field name="inherit_id" ref="product.product_normal_form_view"/>
<field name="groups_id" eval="[(4, ref('sales_team.group_sale_salesman'))]"/>
<field name="arch" type="xml">
<div name="button_box" position="inside">
<button class="oe_stat_button" name="%(action_product_sale_list)d" type="action" icon="fa-usd">
<field string="Sales" name="sales_count" widget="statinfo"/>
</button>
</div>
</field>
</record>
2018-01-05 08:43:15,718 6840 INFO adams_ecommerce odoo.modules.loading: loading 100 modules...
2018-01-05 08:43:16,097 6840 INFO adams_ecommerce odoo.modules.registry: module sale: creating or updating database tables
2018-01-05 08:43:16,756 6840 INFO adams_ecommerce odoo.addons.auth_crypt.models.res_users: Hashing passwords, may be slow for databases with many users...
2018-01-05 08:43:16,820 6840 INFO adams_ecommerce odoo.modules.loading: loading sale/data/ir_sequence_data.xml
2018-01-05 08:43:16,826 6840 INFO adams_ecommerce odoo.modules.loading: loading sale/data/sale_data.xml
2018-01-05 08:43:16,849 6840 INFO adams_ecommerce odoo.modules.loading: loading sale/data/sale_tour.xml
2018-01-05 08:43:16,869 6840 INFO adams_ecommerce odoo.modules.loading: loading sale/report/sale_report.xml
2018-01-05 08:43:16,913 6840 INFO adams_ecommerce odoo.models.unlink: User #1 deleted ir.values records with IDs: [54]
2018-01-05 08:43:16,920 6840 INFO adams_ecommerce odoo.modules.loading: loading sale/data/mail_template_data.xml
2018-01-05 08:43:16,926 6840 INFO adams_ecommerce odoo.modules.loading: loading sale/report/sale_report_views.xml
2018-01-05 08:43:17,076 6840 INFO adams_ecommerce odoo.modules.loading: loading sale/report/sale_report_templates.xml
2018-01-05 08:43:17,148 6840 INFO adams_ecommerce odoo.modules.loading: loading sale/report/invoice_report_templates.xml
2018-01-05 08:43:17,232 6840 INFO adams_ecommerce odoo.modules.loading: loading sale/security/sale_security.xml
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Try clearing browser cache and restart Odoo service and try login again.
Please use a meaningful title. "500: Internal Server Error" is a meaningless generic error message, so please use the proper error message from the log as a title.
I am not able top update website _sale module via command line
becasue I am getting error this odoo is installed by automated script so there is no odoo scripts available
Of course you can update it, just locate your Odoo home and use the proper command. Depending on your installation script, Odoo home may be at different places. Additionally I recommend you to 1. learn backup, 2. learn read the documentation, 3. use recommended procedures if you are not skilled enough to do otherwise, 4. learn to read your logs.