Saturday, July 14, 2012

[SOLVED] Unfortunately, Clock has stopped

When I upgraded my xperia ray from CM7 to CM9(FXP128), I was greeted by the message 'Unfortunately, Clock has stopped' whenever the phone started and anytime I touched the Clock widget. Apart from being annoying it meant I couldn't set my alarms so this became a priority one issue :-)

I opened the Terminal Emulator and typed:

$ su 
# logcat

Then I held 'Volume down' (a.k.a. Ctrl) and 'c' to stop the output. I scrolled a bit up in the output and found a line that said:

E/SQLiteOpenHelper( 5231): Couldn't open alarms.db for writing (will try read-only): E/SQLiteOpenHelper( 5231): android.database.sqlite.SQLiteException: Can't downgrade database from version 7 to 5

OK, so this is where it's breaking. I wasn't really interested in finding out what should the proper combination of ownership/permissions for the file as I didn't really trust it would end just here, downgrading database version offers a range of situations that can go wrong. And since I don't really care for my past alarm clock times, I got rid of the old database:

# cd /data/data/com.android.deskclock/databases 
# mv alarms.db alarms.db.bak 

Problem solved.
Posted by Unknown at 11:50 AM
Labels: , ,

51 comments:

  1. UnknownJuly 29, 2012 at 10:18 AM

    amazing. nice work...

    ReplyDelete
  2. mrspiker10October 9, 2012 at 10:21 AM

    y my lg optimus 2x, always prompt this " Unfortunately, clock has stopped "...I already Use what you are showing above? I am using NOvaHD cm9

    ReplyDelete
  3. UnknownOctober 26, 2012 at 3:27 PM

    Wow thank you so much! You just made my day.

    ReplyDelete
  4. WHNovember 2, 2012 at 1:19 AM

    Thank you WOW it worked. Had exact same problem. Will use logcat more often for sure!

    ReplyDelete
  5. UnknownNovember 12, 2012 at 1:31 PM

    Thx my friend~ it worked~
    I　once had the same problem on my AOKP hd2~

    ReplyDelete
  6. RandyDecember 5, 2012 at 7:57 AM

    Just took a Nexus 10 with Jelly Bean on it getting the same error after about a day. I tried this and it didn't work. Wouldn't even recognize such and logcat. Am I messing up syntax in terminal emulator? H-e-l-p!

    ReplyDelete
  7. NorseOctopusDecember 22, 2012 at 4:58 PM

    Awesome! Easiest fix yet for my Samsung Galaxy S2 running Cyanogenmod 10.

    ReplyDelete
  8. DarkWolffeDecember 24, 2012 at 7:51 AM

    Wow. A little peeved it was something so simple. CM10.1 Nightly on a Captivate.

    ReplyDelete
  9. AnonymousJanuary 22, 2013 at 11:38 AM

    This worked for me (Xperia Arc S - CM9.1)
    It had never occurred to me to look at the log files; despite my being an embedded systems developer. I mustn't be very good :)

    ReplyDelete
    Replies
    1. AdminMay 14, 2014 at 7:25 PM

      hi i am using the same phone as you..but cant fix this problem, do you mind telling me how to fix it, step by step? Thank you :)

      Delete
  10. UnknownJanuary 23, 2013 at 8:11 AM

    Great work. Renamed the alarm.db file and it did the trick
    Deleted the old .bak file now.I had this issue on my Samsung Galaxy S2 after upgrading from Slim Bean 3.x to the latest version (at the time of this post) 4.2.1 RC1, I gather because the ROM changed the type of clock but used the same database. All good now, thanks.

    ReplyDelete
    Replies
    1. UnknownSeptember 2, 2013 at 3:17 PM

      This comment has been removed by the author.

      Delete
    2. UnknownMay 31, 2014 at 7:42 PM

      Yes, I renamed the alarm.db file and it worked for me. The terminal emulator commands did not work for me.

      Delete
  11. moayedFebruary 11, 2013 at 8:41 AM

    Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

    ReplyDelete
  12. ZoeyMarch 23, 2013 at 2:36 PM

    To clear the database and any data cached already, you can also find the Clock app in your app drawer, press and hold, then drag it up to the App Info icon. From here if you choose to Clear Data it will get rid of the ill-permissioned database and allow the app to create a new one with the appropriate permissions.

    ReplyDelete
  13. computersbeyond2April 18, 2013 at 2:23 PM

    Thumbs up Zoey!!!!!!

    ReplyDelete
  14. UnknownApril 23, 2013 at 4:40 AM

    Thanks Zoey!! That worked.

    ReplyDelete
  15. gr8mattApril 30, 2013 at 3:58 AM

    I have fought that problem for over a year and finally got annoyed enough to search for a fix. Thanks so much for posting!

    ReplyDelete
  16. UnknownApril 30, 2013 at 9:49 PM

    Hey Thanks, that did the trick.

    ReplyDelete
  17. UnknownJune 12, 2013 at 10:59 AM

    What if it says the database not found?

    ReplyDelete
  18. BaconeaterJanuary 18, 2014 at 9:07 PM

    Thanks, this has been bugging me for weeks.

    ReplyDelete
  19. BresslauFebruary 9, 2014 at 7:17 PM

    Thanks, worked for me too! On kitkat, even.

    ReplyDelete
  20. SaviourFebruary 25, 2014 at 3:48 AM

    Thanks, worked on Slim Kat wondrously...

    ReplyDelete
  21. HaMarch 18, 2014 at 7:27 PM

    unfortunately emain has stopped how to fix this

    ReplyDelete
  22. WellWellMarch 22, 2014 at 12:09 PM

    Great Wrok Man, Smooth and simple.

    ReplyDelete
  23. pojokkecilMay 4, 2014 at 2:40 PM

    thanks, currently I upgrade my galaxy wonder cm10 to cm11. and the problem solved

    ReplyDelete
  24. PimfeMay 29, 2014 at 2:36 PM

    Thank you for your help :) It works for me with my slimkat rom

    ReplyDelete
  25. UnknownJune 1, 2014 at 5:43 AM

    My clock stopped working and I cannot set the alarms. This method worked once for me, but the problem returned, and I could not fix it anymore. Nevertheless, there is something strange I saw. I deleted the caches, the data, do junk cleansing on the my phone, disabled the phone and re-enabled it. After these steps, I saw that the most current alarm settings disappeared, and the alarm settings of some time ago returned. I suspect there are hidden backup/cache/whatever files that the clock is clinging to, that prevents the clock from going back to normal, that I need to delete. Can anybody help?

    ReplyDelete
  26. gpa recordsJune 18, 2014 at 4:29 AM

    Tried but 'permission denied on alarms.db', so I went to app settings and cleared data/cache and tried again. This time 'no such file alarms.db', but everytime i try to modify an alarm its the same error message galaxy gt1900). Thanks anyway

    ReplyDelete
  27. WebsterDecember 1, 2014 at 5:54 PM

    Thanks it works on Android L on Xperia SP

    ReplyDelete
  28. UnknownDecember 22, 2014 at 9:14 AM

    thanks! worked on CM11

    ReplyDelete
  29. Alexander GiegSeptember 8, 2015 at 5:15 AM

    Thank you very much! It worked flawlessly here!

    ReplyDelete
  30. scratOctober 18, 2015 at 2:25 AM

    Thanks, your tip worked for me too (galaxy s4 mini, CM12 lollipop 5.1.1).

    ReplyDelete
  31. HillriderNovember 2, 2015 at 4:37 PM

    This comment has been removed by the author.

    ReplyDelete
  32. HillriderNovember 2, 2015 at 4:46 PM

    Hi All, I had this issue , was trying out one rom after the other as none of the suggestions including deleting the clock db worked for me.After lot of digging , at last the issue in my case turned out to be a corrupt system & internal memory partitions.Once they were fixed the issue did not reappear on the next rom installed.

    Please note that this is an one off case and please try the solution at your own risk and only after understanding thoroughly about what is suggested as a possibility. I'm not responsible for bricked devices.

    ReplyDelete
  33. UnknownNovember 10, 2015 at 12:38 AM

    I upgraded to cm12.1 this week and everything worked perfectly except for this. LG G2 LS980 (Spint) - this fix worked! Thanks so much!

    ReplyDelete
  34. TomDecember 8, 2015 at 8:33 AM

    Worked like a charm. I often forget that Android has a Linux underpinning.

    ReplyDelete
  35. MátéJanuary 5, 2016 at 3:06 PM

    Thanks m8!! It worked :D

    ReplyDelete
  36. mkFebruary 18, 2016 at 9:10 AM

    Worked 4 me on cm 12.1! Thank u!

    ReplyDelete
  37. Satsang PariwarMay 27, 2016 at 2:29 PM

    I could not find alarm.db at all... One plus one - Cyanogenmod 13... upgraded recently and getting the message "unfortunately clock stopped working" once I click on the clock widget.... has the file structure or .db name different here

    ReplyDelete
  38. Satsang PariwarMay 27, 2016 at 2:32 PM

    I could not find alarm.db at all... One plus one - Cyanogenmod 13... upgraded recently and getting the message "unfortunately clock stopped working" once I click on the clock widget.... has the file structure or .db name different here

    ReplyDelete
  39. UnknownJune 26, 2016 at 2:45 PM

    i opend the terminal imulator and typed thw command it replys that file not found ?
    plz hlp ?

    ReplyDelete
  40. UnknownJune 26, 2016 at 2:49 PM

    i opend the terminal imulator and typed thw command it replys that file not found ?
    plz hlp ?

    ReplyDelete
  41. UnknownJune 26, 2016 at 2:55 PM

    i opend the terminal imulator and typed thw command it replys that file not found ?
    plz hlp ?

    ReplyDelete
  42. UnknownSeptember 29, 2016 at 7:16 AM

    Thank you!
    Although I didn't have those entries in muy $logcat, I did change alarma.db and TVE message is gone.
    I'm on cm11, Samsung Galaxy Tan 2.

    ReplyDelete
  43. ErkinOctober 12, 2016 at 5:09 PM

    This comment has been removed by the author.

    ReplyDelete
  44. ErkinOctober 12, 2016 at 5:11 PM

    Thanks, realy work on cm13 google's clock app.

    ReplyDelete
  45. grantiagoOctober 13, 2016 at 7:38 PM

    Bravo! Im running MM with a geris s5 duos rom from xda-developers. This fixed my problem as well. Though my file structure was a bit different. Thanks. Now for the folder mount error. ;-)

    ReplyDelete
  46. UnknownDecember 12, 2016 at 1:51 PM

    Worked like a charm, thanks so much.

    ReplyDelete
  47. UnknownDecember 30, 2016 at 8:45 PM

    Thanks for letting me know that such a thing exists.

    I have the same problem with Clock after I installed cm13 custom ROM on Lenovo A7000. Your instructions helped me fix the problem.

    Thanks.

    ReplyDelete
  48. Sydney House LevellingNovember 17, 2020 at 7:18 AM

    Sydney House Levelling service is a helping hand for people who so ever request for service related to house Levelling. This service provider has proclaimed its position as the most reliable and user-friendly service that fast as well as highly efficient in their service. The technician associated with the service provider guarantees the highest range of workmanship for the construction industry to underlying the site-specific problem such as cheap underpinning.

    ReplyDelete

Subscribe to: Post Comments (Atom)