Databases
StackOverflow2013
Postsdbo
POMalformed SQLite Database Without Exception Being Thrown
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMalformed SQLite Database Without Exception Being Thrown
    primarykey
    data
    text
    <p>I have an SQLite database with records being inserted into it for my Android app.</p> <p>I am inserting the answers to on screen surveys, with one answer saved per row in my table.</p> <p>My surveys have 20 questions, and it inserts the answers correctly to the database for the first survey, but then when I insert the answers for the second survey (programatically the same questions, just done again) it malforms the database, but never throws an exception or anything. I run an integrity check before and after and it always returns true.</p> <p>The unusual thing is that it is only malformed when I try to look at the table on my computer. I tried using the SQLite Database Browser tool, TKSQLite tool, and then opening the DB from the supplied sqlite3.exe, and they all seem to show the DB as malformed. Although the TKSQLite tool notifies me that the table is malformed, I can get the data in other tables. The SQLite Database Browser just shows no data in the table, and sqlite3.exe won't open any tables.</p> <p>The very unusual thing is if I query the table in the app and print the cursor rows out to log cat, or use the data within the app, all the data is there.</p> <p>Has anyone seen only partial malformation without an exception being thrown? I would like my database to be pristine...but if my data is there can I hope that it won't get any more malformed?</p> <p>I worked with SQLite databases for a few projects now doing similar things, and this is the first time I am seeing only partial malformation.</p> <p>If it will help I am using the Acer a501 tablet programming on Honeycomb 3.2</p> <p>Additionally, I am accessing the database using a static singleton, to avoid opening and closing the database too often for each insert, and originally inserted via SQL commands using <code>execSQL()</code>, but have also tried using the SQLiteDatabase method <code>insert()</code> to no avail.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USadamacdo
    1. USadamacdo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMalformed SQLite Database Without Exception Being Thrown
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't see any information we can use to help.
      singulars
      1. POMalformed SQLite Database Without Exception Being Thrown
      1. USDave Newton
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload