[sqlite] Problem : SQLite Database error
Heya guys, iv got a database which was made my a program called BluePhoneElite, its a Mac OS X piece of software which pairs with a mobile phone over bluetooth to allow messages and calls to be managed from the computer... awesome piece of software untill it breaks. Somehow the database has become corrupted, but my experience with programming and SQL is kinda limited, so turn to you guys... There are two databases, one for messages (text's) and the other for calls ! both are .sqlite extensions (e.g messages.sqlite & calls.sqlite) Iv managed to open them in SQLite Expert Personal 1.7.31 and look within the data, this is where it gets annoying, everything seems to look okay to me the data is perfectly readable (aka, no random symbols or things which look out of place)... But, when i ask SQLite Personal to check the integreity of the databases i get this; Messages.sqlite *** in database main *** On tree page 7686 cell 67: invalid page number 7692 On tree page 7686 cell 67: Child page depth differs On tree page 7686 cell 68: invalid page number 7693 On tree page 7686 cell 69: invalid page number 7694 On tree page 7686 cell 70: invalid page number 7701 On tree page 7686 cell 71: invalid page number 7702 On tree page 7686 cell 72: invalid page number 7695 On tree page 7686 cell 73: invalid page number 7697 On tree page 7686 cell 74: invalid page number 7700 On tree page 7686 cell 75: invalid page number 7696 On tree page 7686 cell 76: invalid page number 7698 On page 7686 at right child: invalid page number 7699 Calls.sqlite *** in database main *** On page 273 at right child: invalid page number 361 Suffice to say these messages dont mean much to me, anyone else have any ideas ? Also, when i scroll through the data, i keep getting alert messages popping up saying "The database disk image is malformed" and the details of this error just says Exception message: The database disk image is malformed Exception class: ESQLiteException Date/Time: 2008-10-11 23:02:35.734 Im kinda desperate to get these databases back into a working state, can anyone help ? Regards Aaron ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Problem : SQLite Database error
Heya guys, iv got a database which was made my a program called BluePhoneElite, its a Mac OS X piece of software which pairs with a mobile phone over bluetooth to allow messages and calls to be managed from the computer... awesome piece of software untill it breaks. Somehow the database has become corrupted, but my experience with programming and SQL is kinda limited, so turn to you guys... There are two databases, one for messages (text's) and the other for calls ! both are .sqlite extensions (e.g messages.sqlite & calls.sqlite) Iv managed to open them in SQLite Expert Personal 1.7.31 and look within the data, this is where it gets annoying, everything seems to look okay to me the data is perfectly readable (aka, no random symbols or things which look out of place)... But, when i ask SQLite Personal to check the integreity of the databases i get this; Messages.sqlite *** in database main *** On tree page 7686 cell 67: invalid page number 7692 On tree page 7686 cell 67: Child page depth differs On tree page 7686 cell 68: invalid page number 7693 On tree page 7686 cell 69: invalid page number 7694 On tree page 7686 cell 70: invalid page number 7701 On tree page 7686 cell 71: invalid page number 7702 On tree page 7686 cell 72: invalid page number 7695 On tree page 7686 cell 73: invalid page number 7697 On tree page 7686 cell 74: invalid page number 7700 On tree page 7686 cell 75: invalid page number 7696 On tree page 7686 cell 76: invalid page number 7698 On page 7686 at right child: invalid page number 7699 Calls.sqlite *** in database main *** On page 273 at right child: invalid page number 361 Suffice to say these messages dont mean much to me, anyone else have any ideas ? Also, when i scroll through the data, i keep getting alert messages popping up saying "The database disk image is malformed" and the details of this error just says Exception message: The database disk image is malformed Exception class: ESQLiteException Date/Time: 2008-10-11 23:02:35.734 Im kinda desperate to get these databases back into a working state, can anyone help ? Regards Aaron ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 shared object question.
ok I got it figured out. I had to compile sqlite3>> ./configure --disable-tcl On 3/4/07, aaron smith <[EMAIL PROTECTED]> wrote: Ultimately what I am trying to do is install the ruby wiki, Instiki. In doing some research I found that rubys sqlite-lib wasn't compatible with sqlite3. So i removed sqlite3 to get sqlite2. Later to find out that, oh. sqlite3-ruby library is the one I needed to use. So now I have to figure out how to get sqlite3 back on. So far I have been compiling everything myself from source, ruby,lighttpd,apache, etc.. Except sqlite. I was confused about this .so. As on sqlites site there is a previous version binary of 2.8.xx. Which was a binary that executed as expected. Is the solution just to recompile sqlite3 source myself? Any idea where I can find out information about RPM for centOS? thanks On 3/3/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: > > On 3/4/07, aaron smith <[EMAIL PROTECTED]> wrote: > > I'm somewhatenew to the linux world. I'm running a dedicated CenteOS > box. > > I'm trying to get sqlite3 installed. I've downloaded this binary > > http://www.sqlite.org/sqlite-3.3.13.so.gz. gunzip it. I see an > > sql.x.x.x.sofile. What do I do with that? if I try to execute it I get > > s segmentation > > fault. > > A .so file is similar to a windows DLL, so you can't execute it, only > use it from your programs. > What you need is either the sqlite binary or the sqlite source and > compile it yourself. > > What you are trying to do? Your distribution should already have some > pre-made package you can download to install it. If I'm not mistaken > CentOS uses RPM as it's package manager, and if I remember correctly, > yast uses SQLite internally, so maybe it is already installed? > > > Regards, > ~Nuno Lucas > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > >
Re: [sqlite] sqlite3 shared object question.
Ultimately what I am trying to do is install the ruby wiki, Instiki. In doing some research I found that rubys sqlite-lib wasn't compatible with sqlite3. So i removed sqlite3 to get sqlite2. Later to find out that, oh. sqlite3-ruby library is the one I needed to use. So now I have to figure out how to get sqlite3 back on. So far I have been compiling everything myself from source, ruby,lighttpd,apache, etc.. Except sqlite. I was confused about this .so. As on sqlites site there is a previous version binary of 2.8.xx. Which was a binary that executed as expected. Is the solution just to recompile sqlite3 source myself? Any idea where I can find out information about RPM for centOS? thanks On 3/3/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: On 3/4/07, aaron smith <[EMAIL PROTECTED]> wrote: > I'm somewhatenew to the linux world. I'm running a dedicated CenteOS box. > I'm trying to get sqlite3 installed. I've downloaded this binary > http://www.sqlite.org/sqlite-3.3.13.so.gz. gunzip it. I see an > sql.x.x.x.sofile. What do I do with that? if I try to execute it I get > s segmentation > fault. A .so file is similar to a windows DLL, so you can't execute it, only use it from your programs. What you need is either the sqlite binary or the sqlite source and compile it yourself. What you are trying to do? Your distribution should already have some pre-made package you can download to install it. If I'm not mistaken CentOS uses RPM as it's package manager, and if I remember correctly, yast uses SQLite internally, so maybe it is already installed? Regards, ~Nuno Lucas - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] sqlite3 shared object question.
I'm somewhatenew to the linux world. I'm running a dedicated CenteOS box. I'm trying to get sqlite3 installed. I've downloaded this binary http://www.sqlite.org/sqlite-3.3.13.so.gz. gunzip it. I see an sql.x.x.x.sofile. What do I do with that? if I try to execute it I get s segmentation fault. thanks.