[Bug-gnubg] sqlite sync

2008-01-08 Thread Achim Mueller
Hi folks, I have a question regarding the sqlite database: Is it possible to sync databases on different computers? I used a db on my notebook and wanted to copy it to my pc, but though relational test says that everything is fine, gnubg can't handle the database and mumbles something from

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Jonathan Kinsey
Achim Mueller wrote: Is it possible to sync databases on different computers? I used a db on my notebook and wanted to copy it to my pc, but though relational test says that everything is fine, gnubg can't handle the database and mumbles something from encrypted. ~/.gnubg/gnubgautorc and

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Christian Anthon
Achim Mueller wrote: Hi folks, I have a question regarding the sqlite database: Is it possible to sync databases on different computers? I used a db on my notebook and wanted to copy it to my pc, but though relational test says that everything is fine, gnubg can't handle the database and

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Christian Anthon
Jonathan Kinsey wrote: I'm making some changes to the database, I recently removed some fields from the database, this will unfortunately break everything. I'm currently adding a native sqlite interface (keeping the python ones but moving the code from python to c). Yes the database

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Jonathan Kinsey
Christian Anthon wrote: Jonathan Kinsey wrote: I'm making some changes to the database, I recently removed some fields from the database, this will unfortunately break everything. I'm currently adding a native sqlite interface (keeping the python ones but moving the code from python to

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Achim Mueller
* Christian Anthon [EMAIL PROTECTED] [080108 12:01]: Achim Mueller wrote: Hi folks, I have a question regarding the sqlite database: Is it possible to sync databases on different computers? I used a db on my notebook and wanted to copy it to my pc, but though relational test says

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Achim Mueller
* Christian Anthon [EMAIL PROTECTED] [080108 14:11]: Achim Mueller wrote: (No game) relational test Database table check failed! The table gnubg.match is missing. So I took the windows database, renamed it and gnubg was satisfied. But when I try a sqlite command like sqlite ace.db

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Christian Anthon
Achim Mueller wrote: (No game) relational test Database table check failed! The table gnubg.match is missing. So I took the windows database, renamed it and gnubg was satisfied. But when I try a sqlite command like sqlite ace.db .dump it complains Unable to open database ace.db. file is

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Achim Mueller
* Christian Anthon [EMAIL PROTECTED] [080108 15:13]: gnubg uses sqlite3, while 'sqlite' is sqlite2 on my ubuntu system. Might that be the problem? Bingo! I always assumed that sqlite is only a link to sqlite3 ... this explains a lot ;-). Problem solved. Ciao Achim

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Jonathan Kinsey
I upgraded the python code to use sqlite 3 recently, mainly because python 2.5 comes with sqlite 3 (no need for pysqlite). Jon Christian Anthon wrote: gnubg uses sqlite3, while 'sqlite' is sqlite2 on my ubuntu system. Might that be the problem? Christian. On Jan 8, 2008 2:17 PM, Achim

Re: [Bug-gnubg] sqlite sync

2008-01-08 Thread Christian Anthon
gnubg uses sqlite3, while 'sqlite' is sqlite2 on my ubuntu system. Might that be the problem? Christian. On Jan 8, 2008 2:17 PM, Achim Mueller [EMAIL PROTECTED] wrote: * Christian Anthon [EMAIL PROTECTED] [080108 14:11]: Achim Mueller wrote: (No game) relational test Database table