Quote:
Originally Posted by captaingeorges
Downloaded Firefox, installed that plugins, got it to run.
When I input your Phrase:
SELECT ContentID, Title FROM Content WHERE BookID is NULL AND ReadStatus=1;
it return an error message...
Georges
|
The assumption is that the DB is the same in your updated non-wifi (1.8.3) and the wifi - something I cannot validate. It is a very basic SQL statement so if failing then the structure may be different. If your comfortable with SQL table design then try checking out the table structures - firstly is there a [content] table? Does it have the fields used in the query. Just look at the complete table with a SELECT * from Content; or use SQLite Manager to view the structure. After this you will need to ensure that the same values are being used to represent similar conditions (i.e. ReadStatus is set for 1 for I'M Reading). I'll try to get a copy of the latest DB for the original Kobo (I think a clean one is available through one of the sticky threads) and take a look but I cannot really validate any "real life" conditions. Can't say this enough - back up the database first.
Update:
Downloaded the 1.8 database and it seems to be identical. Here is what I would do - connect the Kobo for management and copy the koboreader.sqlite file (the database) locally on your computer for testing. Open up the firefox SQLite Manager and select 'Database - Connect' then connect to the local copy of the db. You should now have (in the left window) the list of 7 tables and other bits and pieces. Select the 'content' table and then you should be able to see the structure in the right window. Select the Execute SQL tab and enter SELECT * from content; and push Run SQL. This should show all the data in the content table.
Keep in ming the menu may be different as you are using a Mac. I'm assuming at this stage you are doing this as a interesting project rather than sorting out your original issue!
Here is screen shot of the I'm Reading section of this new database after I marked a few books
http://picasaweb.google.com/lh/photo...eat=directlink