Menu
▾
▴
[pilot-db-list] =?iso-8859-1?Q?Re:_[pilot-db-list]_Questions_about_non-working_install_for_Mac_users?=
|
From: =?iso-8859-1?Q?<mar...@la...> - 2003-03-12 14:13:53
|
If you did see it, there is a tool in the libpalm directory of=0D=0Athe p= alm-db-tools source file, dump-pdb. This tool are able to=0D=0Aextract th= e informations of the appInfo block. But i think the=0D=0Abetter is to us= e a hex editor.=0D=0A=0D=0AHave you try to:=0D=0A * load a DB on the emul= ator and open it.( you should be able=0D=0Ato open it).=0D=0A * load the = same file on the Palm.( you should be not able to=0D=0Aopent it).=0D=0A *= delete the DB on the Mac=0D=0A * backup the DB on the Mac.=0D=0A * load = the new file in the emulator and open it.=0D=0A=0D=0AIf you can open the = file at the end, then the modifications do=0D=0Aduring the Hotsync, are r= eversed during the backup, and it's=0D=0Anormal that your "Palm" file is = identic to your "Org" file.=0D=0A=0D=0AI parsed your "Palm" File in your = mail for informations, i=0D=0Afound some trouble can you tell me how did = you do this file.=0D=0AThank you,=0D=0AMarc Chalain.=0D=0A=0D=0A---------= - Debut du message initial -----------=0D=0A=0D=0ADe : pilot-db-list-= ad...@li...=0D=0AA : Scott Wallace <swallace@mynah.e= ecs.umich.edu>=0D=0ACopies : pil...@li...=0D=0ADat= e : Wed, 12 Mar 2003 11:10:12 +0100=0D=0AObjet : Re: [pilot-db-list] Q= uestions about non-working=0D=0Ainstall for Mac users=0D=0A=0D=0A2003-03-= 11 11:40: Scott Wallace <swa...@my...> is=0D=0Abelieved = to have typed:=0D=0A=0D=0A> This is very interesting. Would it be poss= ible to examine=0D=0Athe =0D=0A> AppInfo block when it is on the palm? I= suppose there are=0D=0Atools to do =0D=0A> this...=0D=0A=0D=0AI don't kn= ow. I didn't find a good one but I didn't look that=0D=0Ahard (but=0D=0AI= would like to have one 8-)=0D=0A=0D=0A> Well, the db3 format doesn't use= the standard appinfo structure.=0D=0A> According to the docs I've read, = the appinfo block can contain=0D=0A> whatever user data one might want, b= ut I could imagine that this=0D=0A> isn't actually the case. =0D=0A=0D=0A= There are several application that doesn't use the standard=0D=0Aappinfo = so=0D=0Athe problem must be somewhere else=0D=0A=0D=0A> Have you tried cr= eating a db on the palm, backing up to your=0D=0Amac and =0D=0A> reinstal= ling the db? This shouldn't work. I could try to=0D=0Amake =0D=0A> a m= odification to the file format to make it consistent with=0D=0Anormal =0D= =0A> expectations about the appinfo block and we could see if=0D=0Athat r= esolves =0D=0A> these mac problems. =0D=0A> =0D=0A> What do you think ab= out trying this experiment? =0D=0A=0D=0AI tried this with the version yo= u sent me and it doesn't work.=0D=0A=0D=0AWhat exactly happens during ins= tallation of a database, does=0D=0Athe program=0D=0Ainteracts with the do= wnloaded file in some way during=0D=0Adownload? (if so,=0D=0Acould there = be some little/big endian problem) =0D=0A=0D=0ASome obeservations=0D=0A=0D= =0AItem 1: Corruption occurs going from Mac =3D> Palm=0D=0A=0D=0AItem 2: = Corruption doesn't occur when going Mac =3D> SD Card =3D> Palm=0D=0A=0D=0A= Item 3: I created a database on the Palm, hotsynced, opened my=0D=0Abacku= p=0D=0A folder and tried to install it on my Palm but it=0D=0Afail= ed when=0D=0A I tried to open it.=0D=0A =0D=0A Then = I tried to install it on my SD card and copy it to my=0D=0A Palm, = which worked! So I assume this means that going from=0D=0A Palm to= Mac is OK.=0D=0A =0D=0A And here a few interesting things = happens. Notation:=0D=0AOrg is=0D=0A the file that was created on = the Mac, Palm the one which=0D=0A was installed on the Palm and th= en synced back, SD the one=0D=0A that was installed on the SD, cop= ied to the Palm and=0D=0Asynced=0D=0A back. The example database d= efines two strings and has one=0D=0A record.=0D=0A=0D=0AOrg looks = like this=0D=0A=0D=0A > database name: snutt=0D=0A0x0000 73 6E 75 7= 4 74 00 00 00 01 75 E4 60 00 00 00 00=0D=0A0x0010 00 00 00 00 0E 67 00 00= 00 00 00 00 00 00 00 00=0D=0A > flags:=0D=0A0x0020 00 08=0D=0A = > version:=0D=0A0x0022 00 00=0D=0A > time creation=0D=0A0x0024 3= E 6F 0A 3F=0D=0A > time modification=0D=0A0x0028 3E 6F 0A 57=0D=0A = > time backup=0D=0A0x002C 3E 6F 0A 57=0D=0A > modnum ???=0D=0A= 0x0030 00 00 00 04=0D=0A > appInfo block offset: 0x00000058=0D=0A0x= 0034 00 00 00 58=0D=0A > sortInfo block offset: 0x00000000=0D=0A0x0= 038 00 00 00 00=0D=0A > type: DB00=0D=0A0x003C 44 42 30 30=0D=0A = > creator: DBOS=0D=0A0x0040 44 42 4F 53=0D=0A > unique ID=0D=0A= 0x0044 00 00 00 00=0D=0A > next record ID=0D=0A0x0048 00 00 00 00=0D= =0A > number of records: 1=0D=0A0x004C 00 01 00 00=0D=0A > re= cord 1 entry: offset 0x0080, =0D=0A0x0050 00 80 40 00 20 01 00 00=0D=0A = > AppInfo block: =0D=0A0x0058 00 00 00 02 00 00 00 0A=0D=0A0x0060 48= 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 00 00=0D=0A0x0070 00 00 00 41 00 = 04 00 00 00 00 00 80 00 02 00 00=0D=0A >> Number of Chunk: 2=0D=0A = > 0x0058 00 00 00 02=0D=0A >> Chunk 1 type: 0 =3D> field name=0D=0A= > 0x005C 00 00=0D=0A >> Chunk 1 size: 10=0D=0A > 0x005E 00 0A=0D= =0A >> Chunk 1: 2 strings: =0D=0A > 0x0060 48 65 6A 00 48 65 6C 6C= 6F 00=0D=0A >> Chunk 2 type: 1 =3D> field type=0D=0A > 0x006A 00 = 01=0D=0A >> Chunk 2 size: 4=0D=0A > 0x006C 00 04=0D=0A >> Ch= unk 2: 00 00 =3D> string, 00 00 =3D> string=0D=0A > 0x006E 00 00 00 00=0D= =0A >> Chunk 3 type: 41 =3D> listview=0D=0A > 0x0072 00 41=0D=0A = >> Chunk 3 size: 4 (CORRUPTION the minimum is 4 + 32)=0D=0A > 0x0= 074 00 04=0D=0A >> Chunk 3:=0D=0A > 0x0076 00 00 00 00=0D=0A = >> Chunk 4 type: 80 =3D> find options=0D=0A > 0x007A 00 80=0D=0A = >> Chunk 4 size: 2=0D=0A > 0x007C 00 02=0D=0A >> Chunk 4:=0D=0A >= 0x007E 00 00=0D=0A > record 1=0D=0A0x0080 00 04 00 08 45 74 74 00 = 54 72 65 00 =0D=0A >> offset of the field 1=0D=0A > 0x0080 00 04=0D= =0A >> offset of the field 2=0D=0A > 0x0082 00 08=0D=0A >> f= ield 1: "Ett"=0D=0A > 0x0084 45 74 74 00=0D=0A >> field 1: "Tre"=0D= =0A > 0x0088 54 72 65 00 =0D=0A=0D=0APalm like this=0D=0A0x0000 73 6E 75= 74 74 00 00 00 01 75 E4 60 00 00 00 00=0D=0A0x0010 00 00 00 00 0E 67 00 = 00 00 00 00 00 00 00 00 00=0D=0A0x0020 00 08 00 00 3E 6F 0A 3F 3E 6F 0A 5= 7 3E 6F 0A 57=0D=0A0x0030 00 00 00 04 00 00 00 58 00 00 00 00 44 42 30 30= =0D=0A0x0040 44 42 4F 53 00 00 00 00 00 00 00 00 00 01 00 00=0D=0A0x0050 = 00 80 40 00 20 01 00 00 00 00 00 02 00 00 00 0A=0D=0A0x0060 48 65 6A 00 4= 8 65 6C 6C 6F 00 00 01 00 04 00 00=0D=0A0x0070 00 00 00 41 00 04 00 00 00= 00 00 80 00 02 00 00=0D=0A0x0080 00 04 00 08 45 74 74 00 54 72 65 00 =0D= =0A=0D=0AAnd SD like this=0D=0A0x0000 73 6E 75 74 74 00 00 00 01 82 2B E0= 63 6E 74 6C=0D=0A0x0010 00 00 00 04 00 00 00 00 40 C7 8B 0D D8 E8 64 02=0D= =0A0x0020 00 08 00 00 C2 49 59 BF 3E 6F 0C 92 3E 6F 0C 92=0D=0A0x0030 00 = 00 00 04 00 00 00 58 00 00 00 00 44 42 30 30=0D=0A0x0040 44 42 4F 53 00 0= 0 00 00 00 00 00 00 00 01 00 00=0D=0A0x0050 00 80 40 00 20 01 00 00 00 00= 00 02 00 00 00 0A=0D=0A0x0060 48 65 6A 00 48 65 6C 6C 6F 00 00 01 00 04 = 00 00=0D=0A0x0070 00 00 00 41 00 04 00 00 00 00 00 80 00 02 00 00=0D=0A0x= 0080 00 04 00 08 45 74 74 00 54 72 65 00 =0D=0A=0D=0A=0D=0A Note t= hat the Org and Palm files looks exactly the=0D=0Asame, while=0D=0A = the one who got installed on the SD card is different (the=0D=0A = name is changed after the 0 but that shouldn't=0D=0Amatter). All=0D=0A = three dates fields are changed but the rest is the same.=0D=0A = =0D=0A But in this case it's only thing that has changed, nothi= ng=0D=0A extra is inserted there but it still refuses to do=0D=0Aa= nything.=0D=0A=0D=0AThis would suggest that if the only thing that matter= s is how=0D=0Athe file=0D=0Alooks like, then one problem seems to be rela= ted to either the=0D=0Adates or=0D=0Athe name of the file. But this doesn= 't explain the extra info=0D=0Ain the=0D=0Aappinfo block described below.= =0D=0A=0D=0ADoes Pilot-DB check the creation date against the other two i= n=0D=0Asome way?=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A =0D=0A=0D= =0AHere is a description I sent to another list=0D=0A=0D=0A> I compared t= he faulty database in my backup folder with the=0D=0A> orginal I tried to= install and from what I can understand the=0D=0A> appinfo block seem to = have become corrupted (note I'm looking at=0D=0A> this file on my Mac so = the database have travelled Mac =3D>=0D=0APalm =3D>=0D=0A> Mac, the one w= ho travelled Mac =3D> SD Card =3D> Palm =3D> Mac doesn't=0D=0A> have this= problem).=0D=0A> =0D=0A> There seems be an extra chunk of information (I= think 15F bytes)=0D=0A> at the end of the AppInfo block of the munged fi= le.=0D=0A=0D=0ADo you get any ideas??=0D=0A=0D=0A jem=0D=0A= -- =0D=0AJan Erik Mostr=F6m je...@mo... www.mostrom.pp.se=0D=0A= =0D=0A=0D=0A-------------------------------------------------------=0D=0A= This SF.net email is sponsored by:Crypto Challenge is now open! =0D=0AGet= cracking and register here for some mind boggling fun and =0D=0Athe chan= ce of winning an Apple iPod:=0D=0Ahttp://ads.sourceforge.net/cgi-bin/redi= rect.pl?thaw0031en=0D=0A_______________________________________________=0D= =0APilot-db-list mailing list=0D=0AP...@li...=0D= =0Ahttps://lists.sourceforge.net/lists/listinfo/pilot-db-list=0D=0A=0A=0A= Acc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ; =0A3= 615 LAPOSTENET (0,34=80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A |
