Thunderbird/Lightning non-recurring events not syncing

Anmeldedatum: 31.01.2012 Beiträge: 23

Just to share with you and the author as I believe I may have solved this.

I got the same issue as this thread:
http://www.fjsoft.at/forum/viewtopic.php?t=12449&postdays=0&postorder=asc&start=15

Thunderbird 9.0.1, Lightning 1.1.1, MPE 1.8.2, MPE Add-On 2.0.9, HTC Sensation XE, Windows 7.

The sync failed to transfer non-recurring events, the first pass would copy from the phone to Lightning, the next would erase them from the phone.

The error console in Thunderbird showed the similar error containing:
Error selecting non recurring events by range!
TypeError: item.startDate is null
DB Error: unknown error

The solution to the previous thread was to locate an entry in the Lightning database with a start date of zero and delete it.

This is what I did.

Lightning calendar store file is found in:
C:\Users\<username>\AppData\Roaming\Thunderbird\Profiles\<profile>\calendar-data\local.sqlite.

Made a backup of this file.

Downloaded the sqlite command tool from:
http://www.sqlite.org/sqlite.html

Transferred the sqlite3.exe to the calendar directory, opened a command window in the directory (in admin mode), and run the tool using:
sqlite3.exe local.sqlite

Located the zero start date entries using:
select id from cal_events where event_start=0;

I had six entries, I deleted them one by one using the id until it worked, using:
delete from cal_events where id='<id>';

I assume all of them could have been removed, using:
delete from cal_events where event_start=0;

This seemed to resolve the problem.

I did lots of other stuff, I wiped the calendar database on the phone, I tried using BirdieSync but this wasn't as good as MPE and created another calendar for me that couldn't be opened by Jorte, it doesn't have the restricted sync dates that MPE has either.

I have no idea where the zero start dates came from, I transferred the calendar to Lightning originally from a Palm Desktop, this worked ok for the first week, so I can only assume MPE created them.

If the author/moderator needs any more info, please say so.

Verfasst am: So Feb 05, 2012 21:26

Its strange. Do you know which events had startdate null ? Is it possible to locate them based on subject ?

Informationen zum Datenschutz auf dieser Website