"Something is wrong" when I try access Calendar

Leonardo_Augusto · January 21, 2019, 10:51am

I created a new user and she can’t access calendar list view, the permissions it’s configured as the another users.

snv · January 21, 2019, 11:04am

Hi, please post the console log.

Leonardo_Augusto · January 21, 2019, 11:12am

jquery.min.js:4 POST http://crm.eranalitica.com.br/ 500 (Internal Server Error)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1546460654.0:1559
frappe.call @ desk.min.js?ver=1546460654.0:1452
_run @ list.min.js?ver=1546460654.0:279
(anonymous) @ list.min.js?ver=1546460654.0:261
setTimeout (async)
run @ list.min.js?ver=1546460654.0:260
run @ list.min.js?ver=1546460654.0:2015
(anonymous) @ desk.min.js?ver=1546460654.0:27
execute_run @ list.min.js?ver=1546460654.0:1933
refresh @ list.min.js?ver=1546460654.0:1928
init @ list.min.js?ver=1546460654.0:1666
Class @ desk.min.js?ver=1546460654.0:37
(anonymous) @ list.min.js?ver=1546460654.0:1557
callback @ desk.min.js?ver=1546460654.0:5488
callback @ desk.min.js?ver=1546460654.0:1448
_ @ desk.min.js?ver=1546460654.0:1472
(anonymous) @ desk.min.js?ver=1546460654.0:1573
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
z @ jquery.min.js:4
(anonymous) @ jquery.min.js:4
load (async)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1546460654.0:1559
frappe.call @ desk.min.js?ver=1546460654.0:1452
with_doctype @ desk.min.js?ver=1546460654.0:5462
make @ list.min.js?ver=1546460654.0:1552
show @ desk.min.js?ver=1546460654.0:9683
show @ list.min.js?ver=1546460654.0:1573
(anonymous) @ desk.min.js?ver=1546460654.0:27
frappe.route @ desk.min.js?ver=1546460654.0:2204
startup @ desk.min.js?ver=1546460654.0:12238
load_startup @ desk.min.js?ver=1546460654.0:12207
init @ desk.min.js?ver=1546460654.0:12203
Class @ desk.min.js?ver=1546460654.0:37
frappe.start_app @ desk.min.js?ver=1546460654.0:12187
(anonymous) @ desk.min.js?ver=1546460654.0:12198
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
ready @ jquery.min.js:2
J @ jquery.min.js:2
desk.min.js?ver=1546460654.0:8012 Uncaught (in promise) DOMException
play_sound @ desk.min.js?ver=1546460654.0:8012
_ @ desk.min.js?ver=1546460654.0:1532
(anonymous) @ desk.min.js?ver=1546460654.0:1599
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
z @ jquery.min.js:4
(anonymous) @ jquery.min.js:4
load (async)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1546460654.0:1559
frappe.call @ desk.min.js?ver=1546460654.0:1452
_run @ list.min.js?ver=1546460654.0:279
(anonymous) @ list.min.js?ver=1546460654.0:261
setTimeout (async)
run @ list.min.js?ver=1546460654.0:260
run @ list.min.js?ver=1546460654.0:2015
(anonymous) @ desk.min.js?ver=1546460654.0:27
execute_run @ list.min.js?ver=1546460654.0:1933
refresh @ list.min.js?ver=1546460654.0:1928
init @ list.min.js?ver=1546460654.0:1666
Class @ desk.min.js?ver=1546460654.0:37
(anonymous) @ list.min.js?ver=1546460654.0:1557
callback @ desk.min.js?ver=1546460654.0:5488
callback @ desk.min.js?ver=1546460654.0:1448
_ @ desk.min.js?ver=1546460654.0:1472
(anonymous) @ desk.min.js?ver=1546460654.0:1573
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
z @ jquery.min.js:4
(anonymous) @ jquery.min.js:4
load (async)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
frappe.request.call @ desk.min.js?ver=1546460654.0:1559
frappe.call @ desk.min.js?ver=1546460654.0:1452
with_doctype @ desk.min.js?ver=1546460654.0:5462
make @ list.min.js?ver=1546460654.0:1552
show @ desk.min.js?ver=1546460654.0:9683
show @ list.min.js?ver=1546460654.0:1573
(anonymous) @ desk.min.js?ver=1546460654.0:27
frappe.route @ desk.min.js?ver=1546460654.0:2204
startup @ desk.min.js?ver=1546460654.0:12238
load_startup @ desk.min.js?ver=1546460654.0:12207
init @ desk.min.js?ver=1546460654.0:12203
Class @ desk.min.js?ver=1546460654.0:37
frappe.start_app @ desk.min.js?ver=1546460654.0:12187
(anonymous) @ desk.min.js?ver=1546460654.0:12198
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
ready @ jquery.min.js:2
J @ jquery.min.js:2

snv · January 21, 2019, 11:14am

Try checking for hints in frappe-bench/logs

Leonardo_Augusto · January 21, 2019, 11:16am

[ERROR] 2019-01-21 11:19:00,930 | /home/ubuntu/frappe-bench/apps/frappe/frappe/app.py:
Site: crm.eranalitica.com.br
Form Dict: {
 "cmd": "frappe.desk.reportview.get",
 "doctype": "Event",
 "fields": "[\"`tabEvent`.`name`\",\"`tabEvent`.`owner`\",\"`tabEvent`.`docstatus`\",\"`tabEvent`.`_user_tags`\",\"`tabEvent`.`_comments`\",\"`tabEvent`.`modified`\",\"`tabEvent`.`modified_by`\",\"`tabEvent`.`_assign`\",\"`tabEvent`.`_liked_by`\",\"`tabEvent`.`_seen`\",\"`tabEvent`.`subject`\",\"`tabEvent`.`event_type`\",\"`tabEvent`.`starts_on`\",\"`tabEvent`.`ends_on`\"]",
 "filters": "[]",
 "order_by": "`tabEvent`.`modified` desc",
 "page_length": "20",
 "start": "0",
 "user_settings": "{\"updated_on\":\"Mon Jan 21 2019 09:19:00 GMT-0200\",\"List\":{\"filters\":[],\"order_by\":\"`tabEvent`.`modified` desc\"},\"last_view\":\"List\"}",
 "with_comment_count": "true"
}
Request Error
Traceback (most recent call last):
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/app.py", line 62, in application
    response = frappe.handler.handle()
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py", line 22, in handle
    data = execute_cmd(cmd)
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/handler.py", line 53, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/__init__.py", line 939, in call
    return fn(*args, **newargs)
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 21, in get
    data = compress(execute(**args), args = args)
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 26, in execute
    return DatabaseQuery(doctype).execute(*args, **kwargs)
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py", line 89, in execute
    result = self.build_and_run()
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py", line 113, in build_and_run
    return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/database.py", line 176, in sql
    self._cursor.execute(query)
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
    result = self._query(query)
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result
    result.read()
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1073, in read
    self._read_result_packet(first_packet)
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1143, in _read_result_packet
    self._read_rowdata_packet()
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1181, in _read_rowdata_packet
    rows.append(self._read_row_from_packet(packet))
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1200, in _read_row_from_packet
    data = converter(data)
  File "/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/data.py", line 63, in get_datetime
    return parser.parse(datetime_str)
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/dateutil/parser/_parser.py", line 1356, in parse
    return DEFAULTPARSER.parse(timestr, **kwargs)
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/dateutil/parser/_parser.py", line 653, in parse
    ret = self._build_naive(res, default)
  File "/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/dateutil/parser/_parser.py", line 1227, in _build_naive
    naive = default.replace(**repl)
ValueError: month must be in 1..12
[ERROR] 2019-01-21 11:19:14,593 | /home/ubuntu/frappe-bench/apps/frappe/frappe/app.py:
Site: crm.eranalitica.com.br
"frappe.log" 428L, 29876C                                                                                                                                                                                                  1,1           Top
[5] 0:vim*                                                                                                                                                                                                 "ip-172-31-83-193" 11:24 21-Jan-19

Leonardo_Augusto · January 21, 2019, 11:17am

Seems like a month out of the range, but I don’t get it how this is happening

snv · January 21, 2019, 11:17am

did you check the DB for inconsistencies?
maybe the date format was changed?

Leonardo_Augusto · January 21, 2019, 11:18am

Huh, maybe thats it, and it’s a private event, so this is why is just happening with this user.
I’ll check and let you know, thank you very much for help!

Leonardo_Augusto · January 22, 2019, 12:40pm

I found the problem, that was a specific event.
Something happened during event creation by a trigger of my custom doctype, the script did not set starts_on attribute, and set ends_on year attribute wrong as you can see(0002):

So I made the update and it’s working as well now: