This forum is a read-only archive of the Gammon Software forum (2000–2026). No new posts can be made. Search the archive.

SQL in global

Posted by Cruelcore on Wed 07 Aug 2013 08:36 PM — 2 posts, 13,236 views.

Cruelcore #0
Whenever I try to load paralellRPI (and only paralellrpi) I get this message:

SQL error on statement:
"SELECT value FROM worlds WHERE name = ':Top Height'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = ':Top Height'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi World Position:wp.showCmd'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi World Position:wp.ptMinPosition.x'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi World Position:wp.ptMinPosition.y'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi World Position:wp.ptMaxPosition.x'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi World Position:wp.ptMaxPosition.y'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi World Position:wp.left'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi World Position:wp.right'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi World Position:wp.top'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi:Top Height'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi:Bottom Height'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = ':Top Height'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = ':Top Height'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi:Top Height'"
database disk image is malformed
SQL error on statement:
"SELECT value FROM worlds WHERE name = 'parallelrpi:Top Height'"


Can't extend the bottom bar to see what I'm typing. If I try to extend it, that pops up and it goes back to being near invisible again.
Nick Gammon Australia Forum Administrator #1 

 database disk image is malformed


Something is wrong with the database. You need to do some sort of cleanup on it.

Google for that message. For example:

http://techblog.dorogin.com/2011/05/sqliteexception-database-disk-image-is.html

I suggest you look at that (and similar) pages. Try dumping the database back to "flat" SQL and then reloading it.

See here for backing up and restoring:

http://www.gammon.com.au/forum/?id=9262&reply=7#reply7