i'm not a sqlite junkie, so i don't know the exact syntax, but ssh in to the box and launch the sqlite interactive console, connect it to the database file created by web2py and see if you can view/update/delete records by writing raw SQL statements. perhaps the errors in the console will be more easier to understand than the web2py wrapped errors.
cfh
