OperationalError: (1054, "Unknown column 'image' in 'field list'") in Production Order

1

In production Order, an error occurs when I click save.

Traceback (most recent call last):
File “/home/jync/v8/apps/frappe/frappe/desk/form/save.py”, line 22, in savedocs
doc.save()
File “/home/jync/v8/apps/frappe/frappe/model/document.py”, line 230, in save
return self._save(*args, **kwargs)
File “/home/jync/v8/apps/frappe/frappe/model/document.py”, line 253, in _save
self.insert()
File “/home/jync/v8/apps/frappe/frappe/model/document.py”, line 211, in insert
d.db_insert()
File “/home/jync/v8/apps/frappe/frappe/model/base_document.py”, line 299, in db_insert
), d.values())
File “/home/jync/v8/apps/frappe/frappe/database.py”, line 154, in sql
self._cursor.execute(query, values)
File “/home/jync/v8/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 250, in execute
self.errorhandler(self, exc, value)
File “/home/jync/v8/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 50, in defaulterrorhandler
raise errorvalue
OperationalError: (1054, “Unknown column ‘image’ in ‘field list’”)

2

@jync11,

Seems to work fine, do you have a customization on Production Order form?

4

in my custom script,

frappe.ui.form.on(“Production Order”, “bom_no”, function(frm) {

frappe.model.with_doc(“BOM”, frm.doc.bom_no, function() {

var bom = frappe.model.get_doc(“BOM”, frm.doc.bom_no);
console.log(bom);
console.log(bom.operations);
console.log(bom.items);
console.log(bom.scrap_items);

frm.doc.bom_operations = bom.operations.slice();
frm.doc.bom_items = bom.items.slice();
frm.doc.bom_scrap_items = bom.scrap_items.slice();

console.log(frm.doc.bom_operations)
console.log(frm.doc.bom_items)
console.log(frm.doc.bom_scrap_items)

});

});

frappe.ui.form.on(“Production Order”, “onload”, function(frm) {

frm.set_value(“source_warehouse”, “Stores - ED002”);
frm.set_value(“wip_warehouse”, “Work In Progress - ED002”);
frm.set_value(“fg_warehouse”, “Finished Goods - ED002”);
frm.set_value(“scrap_warehouse”, “Scrap - ED002”);

});

@makarand_b

5

I fixed it, thanks anyway. :slight_smile:

6

jync11,

I am new to ERPNext and have a similar issue. May I ask how you fixed this?