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:
คำถามนี้ถูกตั้งค่าสถานะ
5
ตอบกลับ
7505
มุมมอง
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!
สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!
สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!
ลงชื่อ| Related Posts | ตอบกลับ | มุมมอง | กิจกรรม | |
|---|---|---|---|---|
|
4
มิ.ย. 24
|
10068 | ||
|
ir.attachment res_*-fields NULL on save
แก้ไขแล้ว
|
|
1
มี.ค. 19
|
8052 | |
|
8
พ.ค. 24
|
51540 | ||
|
2
ก.พ. 21
|
43501 | ||
|
2
ก.ค. 20
|
5513 |
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.