Help

[illuminati945]

What Do i do?

[davidlday]

Has this worked previously and just now stopped, or is this the first time you've set this up?

Also, can you run a little test for me? Open a terminal, and run the following:

sqlite3 $HOME/Library/Calendars/Calendar\ Cache "SELECT name FROM sqlite_master WHERE name IN ('ZICSELEMENT','ZCALENDARITEM')"

You should get back either 'ZCALENDARITEM' or 'ZICSELEMENT'. If you get the same error, that'll help me know where to start.

[illuminati945]

It has never worked. This is the error: "Error: unable to open database "/Users/levy": unable to open database file" I think it might be because my username has a space in it?

[davidlday]

Good call - I didn't account for the possibility of spaces in $HOME. I'll have a look this evening, but should be an easy fix.

[illuminati945]

Sweet, tell me what you come up with

[davidlday]

I've committed and pushed the fix here. I don't know how long before Ubersicht picks up the change, but you can download reminders.widget.zip from this repo directly and test it out. I'll leave the issue open for now, but if I don't hear back from you by next Monday I'll consider it fixed and close the issue. Best of luck, and thanks for bringing this to my attention!

• D

[illuminati945]

I downloaded it directly from github, and when i put it in my widgets folder nothing shows. It is like it was before i ever put the widget in. well, at least theres no error :)

On Thu, Feb 23, 2017 at 12:25 PM, David L. Day notifications@github.com wrote:

I've committed and pushed the fix here. I don't know how long before Ubersicht picks up the change, but you can download reminders.widget.zip from this repo directly and test it out. I'll leave the issue open for now, but if I don't hear back from you by next Monday I'll consider it fixed and close the issue. Best of luck, and thanks for bringing this to my attention!

• D

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-281860771, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbiHxROlI1e92yHfWgQ-4AFLqoKsaks5rfOAGgaJpZM4MH_Nr .

[davidlday]

Well, shoot. Okay, let me take a look again this weekend and get back to you.

[illuminati945]

Alright mate

On Fri, Feb 24, 2017 at 1:48 PM, David L. Day notifications@github.com wrote:

Well, shoot. Okay, let me take a look again this weekend and get back to you.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-282188961, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbgH75zEOM_blZHUCsDepMnirAKzQks5rfkTzgaJpZM4MH_Nr .

[davidlday]

Not having any luck finding anything obvious this time. Once again, can you run the following in the terminal and let me know the output?

sqlite3 "file:$HOME/Library/Calendars/Calendar Cache?mode=ro" "SELECT name FROM sqlite_master WHERE name IN ('ZICSELEMENT','ZCALENDARITEM')"

D

[illuminati945]

"ZCALENDARITEM"

On Sun, Feb 26, 2017 at 1:36 AM, David L. Day notifications@github.com wrote:

Not having any luck finding anything obvious this time. Once again, can you run the following in the terminal and let me know the output?

sqlite3 "file:$HOME/Library/Calendars/Calendar Cache?mode=ro" "SELECT name FROM sqlite_master WHERE name IN ('ZICSELEMENT','ZCALENDARITEM')"

D

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-282487765, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbl62NicCTWTdbvRajH0JPYqTHkRlks5rgDxSgaJpZM4MH_Nr .

[davidlday]

Okay - Another one for you to run, pls. This should bring back all tasks:

sqlite3 "file:$HOME/Library/Calendars/Calendar Cache?mode=ro" "SELECT zduedate, zpriority, rem.ztitle AS title, cal.ztitle AS list, rem.znotes AS notes FROM zcalendaritem rem LEFT JOIN znode cal ON rem.zcalendar=cal.z_pk WHERE rem.z_ent=6 AND zcompleteddate IS NULL ORDER BY CASE WHEN zduedate IS NULL THEN 1 ELSE 0 END, zduedate, zpriority;"

[illuminati945]

"|0|English Due|School Work|"

On Mon, Feb 27, 2017 at 8:11 AM, David L. Day notifications@github.com wrote:

Okay - Another one for you to run, pls. This should bring back all tasks:

sqlite3 "file:$HOME/Library/Calendars/Calendar Cache?mode=ro" "SELECT zduedate, zpriority, rem.ztitle AS title, cal.ztitle AS list, rem.znotes AS notes FROM zcalendaritem rem LEFT JOIN znode cal ON rem.zcalendar=cal.z_pk WHERE rem.z_ent=6 AND zcompleteddate IS NULL ORDER BY CASE WHEN zduedate IS NULL THEN 1 ELSE 0 END, zduedate, zpriority;"

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-282587881, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbg97vo2Xx5Upskgv9zosrHAB8hcvks5rgeqFgaJpZM4MH_Nr .

[davidlday]

Okay, that's working. One last test, please.

Can you go to the widgets directory in a terminal and execute:

cd "$HOME/Library/Application Support/Übersicht/widgets/reminders.widget" ./pending.sh

You should get the same back as json. If that works, then I'm gonna put this on hold to merge in the PR I have open, as the problem may likely lie in the reminders.coffee script.

[illuminati945]

"

{ "tasks": [ { "dueDate": " ", "priority": "0", "title": "Mrs cook has my USB. Black, 16gb", "list": "To Do/Buy", "notes": " ", "secondsLeft": " " },{ "dueDate": " ", "priority": "0", "title": "English Due", "list": "School Work", "notes": " ", "secondsLeft": " " } ], "lists": ["To Do/Buy","Owe others","Owe me","Family","School Work"] }"

Looks like the commands are working, however its still not displaying anything

On Tue, Feb 28, 2017 at 11:45 AM, David L. Day notifications@github.com wrote:

Okay, that's working. One last test, please.

Can you go to the widgets directory in a terminal and execute:

cd "$HOME/Library/Application Support/Übersicht/widgets/reminders.widget" ./pending.sh

You should get the same back as json. If that works, then I'm gonna put this on hold to merge in the PR I have open, as the problem may likely lie in the reminders.coffee script.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-282905376, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbhugweqUsFfSuEz3M1Sw6ZaO45Fvks5rg24tgaJpZM4MH_Nr .

[davidlday]

Can you open the Ubersicht debug console and tell me if you're seeing this:

TypeError: undefined is not an object (evaluating 'res.txt')

or something similar?

[davidlday]

Okay, I think I have it fixed. Can you try the zip before I push? reminders.widget.zip

[illuminati945]

There is nothing in the console, and it still doesnt show anything

On Thu, Mar 2, 2017 at 11:16 AM, David L. Day notifications@github.com wrote:

Okay, I think I have it fixed. Can you try the zip before I push? reminders.widget.zip https://github.com/davidlday/RemindersWidget/files/812388/reminders.widget.zip

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-283514999, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbr-PVZhl7IbxcTNKdbwXvOWeqk7Iks5rhgpxgaJpZM4MH_Nr .

[davidlday]

I was able to recreate the problem (finally) by redeploying the widget several times with Übersicht still running. I think this relates to Issue 24 of Übersicht, which is still open.

Clear the widget from the cache - the order is important:

1. Shut down Übersicht.
2. Delete reminders.widget from Übersicht's widget directory ($HOME/Library/Application Support/Übersicht/widgets/)
3. Delete Übersicht's cache directory ($HOME/Library/Caches/tracesOf.Uebersicht)
4. Empty trash can.
5. Start Übersicht.
6. Redeploy reminders.widget from the zip above.

Let me know if this works.

[illuminati945]

Still nothing. You reckon it might be a problem with my computer?

On Thu, Mar 2, 2017 at 10:36 PM, David L. Day notifications@github.com wrote:

I was able to recreate the problem (finally) by redeploying the widget several times with Übersicht still running. I think this relates to Issue 24 https://github.com/felixhageloh/uebersicht/issues/24 of Übersicht, which is still open.

Clear the widget from the cache - the order is important:

1. Shut down Übersicht.
2. Delete reminders.widget from Übersicht's widget directory ($HOME/Library/Application Support/Übersicht/widgets/)
3. Delete Übersicht's cache directory ($HOME/Library/Caches/ tracesOf.Uebersicht)
4. Empty trash can.
5. Start Übersicht.
6. Redeploy reminders.widget from the zip above.

Let me know if this works.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-283630476, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbrl2pISu_U7F-asUglRU8Om8s_ijks5rhqmygaJpZM4MH_Nr .

[davidlday]

I have a second person experiencing this problem as well. Let me have them take a run at the fix I offered and see if they have any luck.

I'd hesitate to say there's something wrong with your computer at this point. Do you have other widgets working?

[illuminati945]

All my other widgets are working perfectly

On Fri, Mar 3, 2017 at 10:18 AM, David L. Day notifications@github.com wrote:

I have a second person experiencing this problem as well. Let me have them take a run at the fix I offered and see if they have any luck.

I'd hesitate to say there's something wrong with your computer at this point. Do you have other widgets working?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-283814381, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbrMpHo_4WvXWzyrMnA96vwf4xPDAks5rh046gaJpZM4MH_Nr .

[chrisvanklutter]

Hi there, I was finally able to do as you asked me to and delete caches etc. but it still doesn't appear to be working.

[davidlday]

@illuminati945 and @chrisvanklutter - Thank you both for trying. Let's dig a little deeper. I have a MacBook Air that I haven't installed Ubersicht on yet, so I'm going to try to recreate the problem. Can you both please tell me:

1. OS Version (i.e. I'm at macOS Sierra, Version 10.12.3)
2. Ubersicht Version (Current is 1.0.44)
3. A list of widgets you have installed

I'm going to dig through my system logs on my other machine to see if I can find anything related to when I had this happen there.

Update: My apologies - 1.1 (45) is current for Ubersicht.

D

[chrisvanklutter]

1. macOS Sierra, Version 10.12.3 (16D32)
2. Ubersicht Version, 1.1 (45) (Got updated just after I tried to run your widget)
3. Only the reminder wigdet

[illuminati945]

1. OSX El Capitan, Version 10.11.6
2. Ubersicht Version 1.1 (45)
3. black-bar, SimpleTime, Background, Playbox, reminders (not working), ToDo (My Widget :)

On Sun, Mar 5, 2017 at 3:55 AM, chrisvanklutter notifications@github.com wrote:

1. macOS Sierra, Version 10.12.3 (16D32)
2. Ubersicht Version, 1.1 (45) (Got updated just after I tried to run you widget)
3. Only the reminder wigdet

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-284164427, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbg-oQ9RDduwqeNgUb7ysfDlgMdtBks5riZeXgaJpZM4MH_Nr .

[curdaneta]

1. macOS Sierra, Version 10.12.4 Beta (16E175b)
2. Ubersicht Version 1.1 (45)
3. batteryDetails, public_ip, reminders (not working), simple-clock

[davidlday]

@curdaneta @chrisvanklutter @illuminati945 - I merged in changes from a PR, and made some additional updates to how styling is handled that may fix this issue. I encountered some pretty strange behavior working through this, and externalizing the style sheets seemed to work. Would you each mind testing out the following version before I commit?

reminders.widget.zip

Best, David

[davidlday]

@jordikitto - would you mind testing out the zip file above as well and let me know what you think? I hope you don't mind, I left the original style as the default, but changing it to the sidebar style is a one-liner in the reminders.coffee script.

Thanks! David

[curdaneta]

@davidlday didn't work for me. Followed the previous steps, quit, clear cache. Also nothing to report on the console

[illuminati945]

Worked for me! Thank you!

On Thu, Mar 9, 2017 at 11:14 AM, Ciro Urdaneta notifications@github.com wrote:

@davidlday https://github.com/davidlday didn't work for me. Followed the previous steps, quit, clear cache. Also nothing to report on the console

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/davidlday/RemindersWidget/issues/3#issuecomment-285212882, or mute the thread https://github.com/notifications/unsubscribe-auth/ATLIbp3D1g_OEt_ruj4WJTEfwjbqSYzkks5rj0RpgaJpZM4MH_Nr .

[chrisvanklutter]

Worked for me as well! Thanks for the quick work

[curdaneta]

@davidlday looks like I missed something or maybe is my beta OS. I'll try again and post my details

[davidlday]

@curdaneta - sounds good. let me know if you have any luck.

[curdaneta]

@davidlday Still not working for me. Tried again without succeed. Also tested running only the Reminders Widget. Looks like could be something related to mac OS 10.12.4 Beta (16E183b)

[davidlday]

@curdaneta - Sorry to hear. Perhaps take a look in Console, and search for errors related to Ubersicht and/or sparkle. I'm going to push the latest changes, close this out, but feel free to open a new issue just for you and we can continue working through it.

[jordikitto]

Everything works great for me David, love it. The ease of changing between styles should allow for some other cool custom designs too!

[jordikitto]

I'm interested in your default design, it is 10px from the top and left? So the widget doesn't sit flush against the screen anywhere, just kind of 'hovers' in the left a bit. What made you choose it to be like that? Also are you still using blur, do you have any issues with it?

[curdaneta]

@davidlday in my case the problem is that the widget doesn't load the reminders. It works, If I use the sidebar.css It renders the CSS, I'm able to change the CSS and works fine but it doesn't load any Reminders.app data

[davidlday]

@jordikitto - the choice to hover 10px from top left makes it align with two other widgets, one lower left (quote-of-day kinda thing) and one lower right (a clock). And yes, for now I left blur alone, but I may refine it later. These latest changes focused on getting the style externalized. I plan to refine the style more, and maybe even make it so that the default style really just shows instructions on how to apply one of the styles. Would love to hear more of your thoughts on it.

[davidlday]

@curdaneta - maybe they've updated the reminders database. Can you run the following, pls:

sqlite3 "file:$HOME/Library/Calendars/Calendar Cache?mode=ro" "SELECT name FROM sqlite_master WHERE name IN ('ZICSELEMENT','ZCALENDARITEM')"

[curdaneta]

@davidlday where should I run this command, from a Terminal window in the reminders.coffee?

[davidlday]

@curdaneta - my apologies. Yes, open a Terminal window and run there. Doesn't matter what directory you're in.

[curdaneta]

@davidlday it returns ZCALENDARITEM

[davidlday]

@curdaneta - okay. Another one to try. Same deal, just run in Terminal. Directory doesn't matter:

sqlite3 "file:$HOME/Library/Calendars/Calendar Cache?mode=ro" "SELECT z_ent FROM z_primarykey WHERE z_name = 'Task'"

Let me know the output, then I'll have one more for you to run. And, I hate to ask, but you do have tasks in at least one Reminders list, correct?

[curdaneta]

Hi @davidlday the command returns 6 And yes, there are a couple of task of my reminders list

[davidlday]

Okay - one more to make sure pending.sh is working:

sqlite3 "file:$HOME/Library/Calendars/Calendar Cache?mode=ro" "SELECT zduedate, zpriority AS priority, rem.ztitle AS title, cal.ztitle AS list, rem.znotes AS notes FROM ZCALENDARITEM rem LEFT JOIN znode cal ON rem.zcalendar=cal.z_pk WHERE rem.z_ent=6 AND zcompleteddate IS NULL ORDER BY CASE WHEN zduedate IS NULL THEN 1 ELSE 0 END, zduedate, zpriority;"

Again, run in a Terminal and post results. Also, the screenshot shows you're using a modified css, correct? Can you attach a copy of that as well, pls?

[curdaneta]

Done, please check the images

[davidlday]

@curdaneta Would you mind trying with both the default.css and sidebar.css as well and post screenshots of results. And would you mind attaching the custom CSS as a file (not just a screenshot)? You'll need to zip it up or change the extension to .txt. I adjusted my css to try and match what I see in the screenshot, but not sure I got it entirely.

[curdaneta]

Hi @davidlday I'm pretty sure that the issue isn't the CSS, the Reminder data doesn't load. I tried changing the font size, adding custom classes and it doesn't work. For my is the mac OS 10.12.4 Beta

curdaneta.txt

[jordikitto]

Not that I'm a pro or anything at this. David seems to have a much better idea of how the .sh file works. I see you've got a lot of stuff running? Have you tried running Ubersicht and the Reminders widget only?

It seems to be only on the 10.12.4 beta that people are experiencing this issue. On 10.12.3 and I have no issues, especially with the sidebar on the right. Was it working before 10.12.4?

I'm guessing Apple has changed how they store/handle the Reminders data.