moz-profile-calendar:// preparation error

[Anubeon]

Greetings All,

I've been running Thunderbird 3.0 since beta 1 and for some weeks now
have been receiving errors whenever I start Thunderbird. I've tried
uninstalling and re-installing the various calendar related add-ons
including lightning and the google calendars provider, but I still
receive the same damned error.

<quote>
An error was encountered preparing the calendar located at moz-profile-
calendar:// for use. It will not be available.

Error Code: 0x80004005
Description: [Exception... "Component returned failure code:
0x80004005 (NS_ERROR_FAILURE)
[mozIStorageStatement.reset]" nsresult: "0x80004005
(NS_ERROR_FAILURE)" location: "JS frame ::
file:///C:/Users/ch2lah/AppData/Roaming/Thunderbird/Profiles/f669obwn.default/extensions
/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/modules/
calStorageUpgrade.jsm ::
ensureUpdatedTimezones :: line 420" data: no]
</quote>

I'm currently running Thunderbird 3.0 (final), Lightning 1.0b2pre and
Provider for Google Calendar 0.6pre. Has anybody else experienced this
error? Does anybody know how to rectify this issue? I'd appreciate any
assistance rendered.

Regards,

Lee.

P.S. As an aside, are the any plans to include the functionality
offered by the Provider in Lightning; it seems a little odd that it is
maintained as a separate extension.

[Anubeon]

Anybody? No?

I'm reluctant to file a bug proper until I know for sure this isn't an
issue unique to my own set-up, which I think more than likely. If
anybody else is experiences, or has experienced this in the past and/
or is aware of a extant bug I would appreciate your input. I rather
miss my calendar.

Kind Regards,

Lee.

[jamesjpn]

Yes, I have the same problem after running Fedora updates and updating
Sunbird Calenar to version 1.0pre. I miss my calendar too and need it
to remember my friend's birthdays. Need a fix soon!

[J_Wesker]

I am having this issue too with Thunderbird Final 3.0 on Fedora 11
x86_64, after last week update to this release. I was using Lighting
1.0pre but after the upgrade, I lost my calendar and cannot create a
new one, also the add-on Provider for Google Calendar appears as not
compatible with this version of thunderbird. I hope there is a way to
restore my settings and still have the great features of thunderbird
3.0

[Anubeon]

Bump!

Anyone else experience this? or have any idea how to fix this?

Lee.

[courtne...@gmail.com]

I found this solution on redhat's bugzilla and it fixed my problem.

SOLUTION:

There is a schema problem with the lightning database.
Do the following:

-Stop thunderbird

-Go to the calendar-data in your thunderbird profile:

cd .thunderbird/???????.default/calendar-data

-Load up sqlite client on database file:

sqlite3 local.sqlite

-Add a few missing columns to two tables:

sqlite>ALTER TABLE cal_relations ADD recurrence_id INTEGER;
sqlite>ALTER TABLE cal_relations ADD recurrence_id_tz TEXT;

sqlite>ALTER TABLE cal_attachments ADD recurrence_id INTEGER;
sqlite>ALTER TABLE cal_attachments ADD recurrence_id_tz TEXT;

-Leave client

sqlite>.exit

-Rstart thunderbird

[Mark]

Not unique to you. Same problem here. Still searching.

[ruturajv]

Hi,
it doesn't work.. on

thunderbird-3.0-4.fc12.i686 and thunderbird-
lightning-1.0-0.16.20090916hg.fc12 combination

anybody with more tips?

[Peter]

On Dec 28 2009, 4:20 am, "courtney.pla...@gmail.com"

Thanks worked for me :-)

[vballj]

That worked for me too. Thanks so much for this fix. I was getting
extremely frustrated that I couldn't create a local calendar!

[Philipp Kewisch]

See also http://weblogs.mozillazine.org/calendar/2009/11/getting_a_database_error_in_yo.html

Philipp

[Demetri]

Happening to me too. Every time I fire up Thunderbird I get the error
you quote above. Turning off lightning add-on seemed to fix it for
me.