You are here

Sunbird Error!!!

7 posts / 0 new
Last post
Just1Ghost
Just1Ghost's picture
Offline
Last seen: 8 years 3 months ago
Joined: 2009-03-11 12:52
Sunbird Error!!!

Hello, all... I was having difficulties with retrieving my dataset after compressing my apps with AppsCompactor (stay away til they get it right?!?) so I reinstalled the apps (FireFox, Sunbird, et al)...

Well, it WAS looking good for a while there; FireFox Bookmarks, settings, etc. all loaded back in without incident... HOWEVER... I reinstalled Sunbird, ran it, and was faced with this:

0x80004005

[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: file:///E:/PortableApps/SunbirdPortable/App/sunbird/components/calStorag... -> file:///E:/PortableApps/SunbirdPortable/App/sunbird/js/calStorageCalenda... :: addColumn :: line 898" data: no]

Any ideas, anyone?!? I'd REALLY like to get my schedule data back...it's imperative.

Any assistance would be GREATLY appreciated!!!

-G-

John T. Haller
John T. Haller's picture
Online
Last seen: 27 min 10 sec ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
New Install

First, do a fresh install to a new location and ensure it works. You can rename your existing directory to SunbirdPortable2 and install a new one at SunbirdPortable next to it. Then close it.

Once you've confirmed it's a good install, copy (don't move) your Data directory in SunbirdPortable2 to SunbirdPortable. Then try starting the new copy of Sunbird Portable in SunbirdPortable again.

In the future, please read the instructions for tools before using them. The first screen of the AppCompactor says "As with any application modification, it's best to make a backup of the files before compressing." The support section of the AppCompactor homepage also makes this quite clear.

The AppCompactor works very well, but there are some apps that will break when compressing. There's no way around it and no way to fully test for it other than then trying the app to make sure it works. That's why it says to make a backup.

Sometimes, the impossible can become possible, if you're awesome!

Just1Ghost
Just1Ghost's picture
Offline
Last seen: 8 years 3 months ago
Joined: 2009-03-11 12:52
New Installed

John,

I apologize for the dig on AppCompactor, it WAS an idiotic mistake not to back up before trying "something new"...and again for that I'm sorry.

However, I've just implemented your tactics above to no avail...I'm still getting the same error message... I'm at a loss for what to do... Have you anything else in your bag of tricks?

Modestly and Sheepishly,

-G-

John T. Haller
John T. Haller's picture
Online
Last seen: 27 min 10 sec ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
DB Error

The actual calendar database (storage.db) in your profile has an error in it now. I found a few results by searching on your error:
http://www.google.com/search?q=addColumn+%3A%3A+line+898%22+data%3A+no

It looks like you may be able to manually repair it by using SQLite, a database editor. Which may be complicated and may not work. Or possibly you're using a different version of Sunbird than you were before. There's no real easy way to fix it at this point. If you hunt on Google for the issue, you may find some suggestions.

But it may be easier to just rebuild the calendar. If you go that route, you can find some of the data using a tool like SQLite. SQLite database browser may come in handy in either case:
https://sourceforge.net/project/showfiles.php?group_id=87946&package_id=...

I checked and this tool can properly read a storage.db file.

Sometimes, the impossible can become possible, if you're awesome!

Just1Ghost
Just1Ghost's picture
Offline
Last seen: 8 years 3 months ago
Joined: 2009-03-11 12:52
Rebuilding or Restoring...

Hi, John (et al),

Thank you for your help with all this nonsense, I truly do appreciate it.

However (didn't you just KNOW that was coming?), I'm wondering; I do have experience (albeit years ago) with manually working with databases so repairing might still be an option (although...ugh, I'm getting a cramp in my neck already)...but, I'm wondering (again), there are 5 calendars I'd created: default, 2, 3, 4, 5...but there is reference to "cal" (which I'm supposing at this point is "calendar") to cals 0, 1, 2, 3, 4, & 5...ohhhkaaay...

Long story longer, how might one go about "rebuilding" using SQLite??? ...and how might I get "some of the data" using same?!? (I'm picturing having them both open and literally copying and pasting until my mousing arm cramps out...is this accurate? ...and lastly, is there ANY OTHER WAY to retrieve my data?!? Please, please, puh-LEASE let there be another way!!!

Quick (and hopefully easier) question: can someone, John say, tell me the date/time meaning/interpretation of this: 1201559031000000 ??? Thank you.

Be well, all...

-G-

John T. Haller
John T. Haller's picture
Online
Last seen: 27 min 10 sec ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
Don't Know

That's about all I found online, unfortunately. You may want to search and find more of figure out exactly what is wrong in the DB. Or try exporting bits of it and importing into a clean one. But I don't know any more than you do at this point.

Sometimes, the impossible can become possible, if you're awesome!

Just1Ghost
Just1Ghost's picture
Offline
Last seen: 8 years 3 months ago
Joined: 2009-03-11 12:52
Importing/Exporting...

Hmmm...yep, tried exporting each (& every) table out of SQLite as CSVs (is there ANY way to export them in another form, such as ICS, SDB or something, SB doesn't read SQL or JS, etc.?!?), and importing them all separately into SB, but to no avail...nothin'...nada...argh...

Other than the error message(s), how would I figure out what's actually WRONG with the db?!? Nothing's apparent to my eye, but...whadoo -I- know?!? Wink

Lastly, any idea what the string of numbers indicating date/time translates into in Human-speak?!? (ie. 1201559031000000) ???

Thanks again, John...

As "always",

-G-

Log in or register to post comments