Email Inbox: Filter deleted missing

Frappe Framework Bug
1

Hi all. I have switch to develop

bench version
erpnext 7.2.18
frappe 7.2.14

After configure Email domain i go to EMail Inbox and…

Filter deleted missing

Server Error: Please check your server logs or contact tech support.

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 56, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 19, in handle
execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 42, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 903, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 16, in get
data = compress(execute(**args), args = args)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/reportview.py”, line 21, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 81, in execute
result = self.build_and_run()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 105, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 148, in sql
self._cursor.execute(query)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, “Unknown column ‘uid’ in ‘field list’”)

this from logs/frappe.log

[ERROR] 2017-02-03 16:36:51,647 | /home/frappe/frappe-bench/apps/frappe/frappe/app.py:
Site: erp-test.texol.it
Form Dict: {
 "cmd": "frappe.desk.reportview.get",
 "doctype": "Communication",
 "fields": "[\"name\",\"sender\",\"sender_full_name\",\"communication_date\",\"recipients\",\"cc\",\"communication_medium\",\"subject\",\"status\",\"reference_doctype\",\"reference_name\",\"timeline_doctype\",\"timeline_name\",\"timeline_label\",\"sent_or_received\",\"uid\",\"message_id\",\"seen\",\"nomatch\",\"has_attachment\"]",
 "filters": "[[\"Communication\",\"communication_type\",\"=\",\"Communication\"],[\"Communication\",\"email_account\",\"in\",\"ERP Texol\"],[\"Communication\",\"sent_or_received\",\"=\",\"Received\"]]",
 "limit_page_length": "20",
 "limit_start": "0",
 "order_by": "communication_date desc",
 "save_list_settings": "false"
}
Request Error
Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 56, in application
    response = frappe.handler.handle()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 19, in handle
    execute_cmd(cmd)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 42, in execute_cmd
    ret = frappe.call(method, **frappe.form_dict)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 903, in call
    return fn(*args, **newargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 16, in get
    data = compress(execute(**args), args = args)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 21, in execute
    return DatabaseQuery(doctype).execute(*args, **kwargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 81, in execute
    result = self.build_and_run()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 105, in build_and_run
    return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 148, in sql
    self._cursor.execute(query)
  File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'uid' in 'field list'")
[ERROR] 2017-02-03 16:36:51,654 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/error.py:
Could not take error snapshot: 'connection'
Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/error.py", line 36, in make_error_snapshot
    snapshot = get_snapshot(exception)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/error.py", line 81, in get_snapshot
    call = inspect.formatargvalues(args, varargs, varkw, locals, formatvalue=lambda value: '={}'.format(pydoc.text.repr(value)))
  File "/usr/lib64/python2.7/inspect.py", line 887, in formatargvalues
    specs.append(strseq(args[i], convert, join))
  File "/usr/lib64/python2.7/inspect.py", line 842, in strseq
    return convert(object)
  File "/usr/lib64/python2.7/inspect.py", line 884, in convert
    return formatarg(name) + formatvalue(locals[name])
KeyError: 'connection'
[DEBUG] 2017-02-03 16:38:17,626 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erp-test.texol.it
Queued events for site erp-test.texol.it

i have try to link imap mail account to Opportunity
if write email…that go in opportunity, but don’t show in Email Inbox
I have create a new and clean account email only for that

Any idea?
TY

2

It seems uid field is missing in Communication DocType, try bench update --patch or add in tabCommunication:

uid varchar(140)

3

I have used bench update --patch for upgrade to develop

i have altered mysql table with

ALTER TABLE `1bdxxxxx`.`tabCommunication` 
ADD COLUMN `uid` VARCHAR(140) NULL AFTER `signature`;

new error
OperationalError: (1054, “Unknown column ‘nomatch’ in ‘field list’”)

ALTER TABLE `1bdxxxxxx`.`tabCommunication` 
ADD COLUMN `nowatch` VARCHAR(140) NULL AFTER `signature`;

new error
OperationalError: (1054, “Unknown column ‘has_attachment’ in ‘field list’”)

ALTER TABLE `1bdxxxxx`.`tabCommunication` 
ADD COLUMN `has_attachment` VARCHAR(140) NULL AFTER `signature`;

at the end only
Filter deleted missing
no error in log

but now mail is show…perfect! TY

4

Hello @sharpec
can you try add more a field deleted as like below.

delete.png1353×679 52.5 KB

hope this fixed your popup error “Invalid Filter”

Thanks.

1 Like
5

Thanks. This gave me the clues how to get this working for me

6

Hi @mainul , i dont found the solution for me. :confused:

Also, this is like a issue in github?

Thanks

7

@federico_calvo
did you see the same error ?

Or something else ?

8

Hi @mainul, not that way, this is error :

error.jpg602×509 74.8 KB

thanks!

9

@federico_calvo,

This issue is already resolved please pull the latest code to frappe and erpnext repo and migrate

Thanks,
Makarand

1 Like