sms database

--===============0017601070102093798==
Content-Type: multipart/alternative; boundary=20cf307d059eccae8f04c05b876d

--20cf307d059eccae8f04c05b876d
Content-Type: text/plain; charset=ISO-8859-1

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!

--20cf307d059eccae8f04c05b876d
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hello, My BitPim database had become currupted somehow in January of t=
his year, and I only recently discovered this when I tried to retreive an o=
ld text.</div>
<div>=A0</div>
<div>When I downloaded my text&#39;s from my phone, I could see that the te=
xts 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 prob=
lem with my SENT text&#39;s download to the BitPim database.</div>

<div>=A0</div>
<div>I feel that my database had somehow became currupted during one of my =
system restores, and I had not noticed the problem till now.</div>
<div>=A0</div>
<div>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 BitPi=
m folder from the My Documents folder and allowed BitPim to create a new da=
tabase. I then tested it and it downloaded and displayed both incoming and =
out going message.</div>

<div>=A0</div>
<div>It appeared that the problem was with the UID field, as a few of the r=
ecords were NULL, and most the rest were not; most of the sent texts from m=
y phone had not had a UID, but others did, and the ones that did displayed =
in BitPim.</div>

<div>=A0</div>
<div>I converted the database to access, then wrote an ASP script to regene=
rate UID&#39;s. I noticed that only the last 9 digits had changed throughou=
t the database. After generating UID&#39;s, imported the database back into=
 the BitPim database and tried to access the sms&#39;s via BitPim. It did n=
ot work...</div>

<div>=A0</div>
<div>So, this brings me here; could someone explain to me, how the UID&#39;=
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 [ 0=
97 ] digits and the other 6 [=A0097414 ] digits.</div>

<div>=A0</div>
<div>Additionally, for each sms record, I had my script generate a record i=
nto 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.</div>

<div>=A0</div>
<div>Any help would be appreciated. Thanks!</div>
<div>=A0</div>

--20cf307d059eccae8f04c05b876d--


--===============0017601070102093798==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
--===============0017601070102093798==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
BitPim-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bitpim-devel

--===============0017601070102093798==--