Can someone explain what is wrong? I get this when I try to delete a record from the model 'Order' in a custom module. I can delete records from every other model without any problems.
This is the error:
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
5
Replies
4129
Views
Are you sure about the table name "order" ..if yes then its a syntax issue from you code you are not providing proper input.
Or try it from backend i.e from postgres query.. by connecting to the database, If it worked apply same logic in code.
I had to know that naming a module 'order' would bring complications. I copied all my code and changed the module name to something else and everything works now. Thank you for your answer!
I had to know that naming a model'order' would bring complications. I copied all my code and changed the model name to something else and everything works now. Thank you guys for your answer!
share your code
What exactly did you code in your custom module though? The query that you see in the traceback says "DELETE FROM order" but it should be "DELETE FROM sale.order". If you're writing a custom SQL query to delete records I should also say that it is a bad idea. The ORM has delete features by default so there should be a good reason for altering it.