Re: [Q] SQLITE version...SOLVED

On the iPaq, libsqlite0 failed to upgrade on upgrading sqlite ipkg. It
couldn't overwrite /usr/lib/libsqlite.so.0. I took care of this.

Version 2.7.2 running on both laptop and iPaq. I've xfered contacts
from laptop to iPaq based on evo2gpe.py. I've got some category name
issues, possibly, but now I can touch the data.

Many thanks for your patience and support!

Ted

Joseph J. McCarthy wrote:
> This is very odd since I have never had a problem with the upgrade. it
> sounds like you might have gotten caught in a weird "no mans land" where
> you were using both 2.7.x and 2.4.10 and now it is slightly hosed.
>
> If you use "less" to look at the file do you see:
>
> ** This file contains an SQLite 2.1 database **
>
> at the top?
>
> BTW, I am building a 2.7.4 and will upload it sometime today, just in
> case.
>
> Joe
>
> On Fri, 2003-01-10 at 08:56, Theodore E Poe Jr. wrote:
>
>>I went to the sqlite website, downloaded and compiled 2.7.2 on my
>>laptop. I then did the same test and have the same problem. Running my
>>laptop's 2.7.2 sqlite on the iPaq's contacts file (using the iPaq's
>>2.7.2 sqlite) without modifying any data and .quitting causes a binary
>>file difference on my RH7.2 system. Sending that touched contacts file
>>back to the iPaq causes the same "Unsupported file format" error.
>>
>>?
>>
>>Ted
>>
>>
>>Joseph J. McCarthy wrote:
>>
>>>Thats odd. I am in the same situation (2.7.4 on desktop, 2.7.2 on Ipaq)
>>>and they exchange fine between the two.....?
>>>
>>>I guess I can build a new ipk of 2.7.4, but it might not be today....do
>>>you have access to the development cluster? It isnt too hard to build it
>>>yourself (I just dont know that I will have time today).
>>>
>>>Joe
>>>
>>>On Fri, 2003-01-10 at 08:30, Theodore E Poe Jr. wrote:
>>>
>>>
>>>>Thanks. Unfortunately, sqlite must store its version number within the
>>>>database file upon touching it. I scp'ed contacts generated on the iPaq
>>>>using your 2.7.2, browsed the data with my 2.7.4 version without
>>>>modifying the data, then scp'ed the file back to the iPaq. The binary
>>>>files differ and gpe-contacts rejected it with "Unsupported file format."
>>>>
>>>>Just to make sure, I scp'ed a good contacts file from the iPaq back and
>>>>forth without touching it with sqlite and it worked fine.
>>>>
>>>>Do you know where to get the 2.7.2 source that I could compile for my
>>>>laptop and hopefully resolve this?
>>>>
>>>>Ted
>>>>
>>>>Joseph J. McCarthy wrote:
>>>>
>>>>
>>>>>I am uploading a new one now......
>>>>>
>>>>>check in unstable in 10 minutes :)
>>>>>
>>>>>joe
>>>>>
>>>>>
>>>>>On Thu, 2003-01-09 at 15:39, Theodore E Poe Jr. wrote:
>>>>>
>>>>>
>>>>>
>>>>>>Currently, the sqlite ipkg is version 2.4. Can GPE move up to version
>>>>>>2.7 so that it can be more current? I have the 2.7.4 rpm on my laptop
>>>>>>and would like to use evo2gpe.py to load all of my Contacts onto my
>>>>>>iPaq. (Or else, is the 2.4 source code available to compile that on my
>>>>>>laptop, instead?)
>>>>>>
>>>>>>Thanks.
>>>>>>
>>>>>>Ted
>>>>>>
>>>>>>_______________________________________________
>>>>>>GPE mailing list
>>>>>>GPE@handhelds.org
>>>>>>http://handhelds.org/mailman/listinfo/gpe
>>>>>
>>
>>_______________________________________________
>>GPE mailing list
>>GPE@handhelds.org
>>http://handhelds.org/mailman/listinfo/gpe
>
Received on Fri Jan 10 17:44:07 2003