[BitPim-devel] sms database

[JusGreen A. W. <jus...@gm...>]

Hello, My BitPim database had become currupted somehow in January of this
year, and I only recently discovered this when I tried to retreive an old
text.

When I downloaded my text's from my phone, I could see that the texts were
being downloaded as I could read the status bar and it saying that it was
retrieving texts from the OUTBOX of my phone. Yes I only had a problem with
my SENT text's download to the BitPim database.

I feel that my database had somehow became currupted during one of my
system restores, and I had not noticed the problem till now.

After some research, I found out what sort of database BitPim used and
tried to fix the error manually. On, before this, I moved my regular BitPim
folder from the My Documents folder and allowed BitPim to create a new
database. I then tested it and it downloaded and displayed both incoming
and out going message.

It appeared that the problem was with the UID field, as a few of the
records were NULL, and most the rest were not; most of the sent texts from
my phone had not had a UID, but others did, and the ones that did displayed
in BitPim.

I converted the database to access, then wrote an ASP script to regenerate
UID's. I noticed that only the last 9 digits had changed throughout the
database. After generating UID's, imported the database back into the
BitPim database and tried to access the sms's via BitPim. It did not work...

So, this brings me here; could someone explain to me, how the UID's are
generated, so that I could repair my database. My ASP script took the first
# of the UID and hard fixed it for all records [ 1337112 ]; then it
randomly generated two more strings separated by a decimal point; one 3 [
097 ] digits and the other 6 [ 097414 ] digits.

Additionally, for each sms record, I had my script generate a record into
the sms__serials table, although, when the sms__serials table was done
building it only had 1219 records versus the 1269 in sms table; exactly the
same results as when started this show.

Any help would be appreciated. Thanks!