Error while creating second doctype for module

Hello everyone,

I am playing with frappe and trying to create some app.

I have created new app, created some modules on it.
Created one doctype fo module and everything was ok. After i tried to create second doctype (it have saved without error messages) for same module. After what when i press icon form desk to what module error apears. Maybe someone know what i am doing wrong?

Traceback (innermost last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 51, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 62, in handle
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 85, in execute_cmd
ret =, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 708, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/”, line 13, in get
data = get_data(module)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/”, line 37, in get_data
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/”, line 186, in set_last_modified
item[“last_modified”] = get_last_modified(item[“name”])
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/”, line 190, in get_last_modified
last_modified = frappe.get_all(doctype, fields=[“max(modified)”], as_list=True, limit_page_length=1)[0][0]
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 856, in get_all
return get_list(doctype, *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 829, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/”, line 49, in execute
return self.build_and_run()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/”, line 61, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug)
File “/home/frappe/frappe-bench/apps/frappe/frappe/”, line 140, in sql
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, “Unknown column ‘modified’ in ‘field list’”)

This is pretty strange.

Did you drop any fields from your database? Did you DocType creation go through alright.

modified is a standard field created by the doctype.

thanks for your replay.
i did not drop any DB table. I have deleted what doctype and created new one, now everything working. So what was the reason for what error i dont understand.