MacOS Ventura Support

[coolajami]

Oh boy, it is the time of the year for the annual gathering regarding this thing that Apple decided to change on the new version of the Reminders.app, causing the widget not to work. This time the problem seems to be the due date of the reminders. I'm getting the following error:

[Error] reminders-widget-reminders-coffee: – Error: Parse error near line 5: no such column: TASK.ZDUEDATE
  SELECT strftime('%Y-%m-%dT%H:%M:%S',(978307200 + TASK.ZDUEDATE),'unixepoch') a
                                     error here ---^
{ "tasks": [  ], "lists": [] }
 — client.js:1:903834

As it is accustomed, the usual disclaimers apply, the widget was working fine before updating to Ventura and no other changes occurred apart from the macOS upgrade.

[doitonce]

I get the following message

Parse error near line 5: no such column: TASK.ZDUEDATE SELECT strftime('%Y-%m-%dT%H:%M:%S',(978307200 + TASK.ZDUEDATE),'unixepoch') a error here ---^ { "tasks": [ ], "lists": ["미리 알림","가족"] }

[baracude]

I've fixed it.

In pending.sh file change the following lines

Line 81 : TASK.ZTITLE1 AS title, to TASK.ZTITLE AS title, Line 85 : FROM ZREMCDOBJECT TASK LEFT ... to FROM ZREMCDREMINDER TASK LEFT ...

Now it works.

[doitonce]

Thanks for your help. However, there is an error even after editing.

JSON Parse error: Unexpected token ','

[doitonce]

I just solved it. thank you

[baracude]

Oh! I forgot I’ve changed to ZNAME2 already during Monterey upgrade. Thanks for pointing it out.

[coolajami]

Thank you very much @baracude! Works great!

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.