Skip to Content
Menu
This question has been flagged
5 Replies
4318 Views

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:


Avatar
Discard

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.

Best Answer

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.

Avatar
Discard
Author

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!

Author Best 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!

Avatar
Discard
Related Posts Replies Views Activity
4
Jun 24
6614
1
Mar 19
4645
8
May 24
45610
2
Feb 21
38577
2
Jul 20
2646