Wild guess: Could there possibly be a difference in where the different implementations of Android look for SQLite files? If you are using a default directory and the default directory is different on different machines; then Android might not be looking in the correct directory to find your files; resulting in a "file not found" error. Also consider file permission issues.
You might find these StackOverflow discussions useful: December 15, 2010 http://stackoverflow.com/questions/4452538/location-of-sqlite-database-on-the-device March 10, 2013 http://stackoverflow.com/questions/15326455/what-is-the-default-database-location-of-an-android-app-for-an-unrooted-device September 9, 2013 http://stackoverflow.com/questions/18905804/where-is-my-sqlite-database-stored-in-android <http://stackoverflow.com/questions/18905804/where-is-my-sqlite-database-stored-in-android> Jim Callahan Orlando, FL On Thu, Sep 1, 2016 at 3:13 AM, Charles L. Sykes <char...@sykesclan.com> wrote: > Dear SQLite Experts: > > > > I recently made the move from Windows 7 to Windows 10, and from Eclipse to > Android Studio. > > > > I have a set of Oscar quiz apps with a SQLite database, which ran fine when > I converted them over, testing under the Nexus Emulator (API 19). When I > later obtained a Samsung Galaxy S7 and copied the apk over to the physical > device, I got the "Unfortunately, APP NAME has stopped". I forgot about it > (since it was running under the Nexus emulator), until I uploaded them to > Amazon for sale, and they failed on all devices except an older one, > possibly the Nexus. > > > > I installed a Galaxy emulator and figured out how to get a detailed debug > log, and now I am perplexed in getting a "table not found" error. > > > > I know this doesn't occur with the Nexus emulator because I put in Toast > statements to display table counts as part of my standard debugging when a > new version of the database is loaded. > > > > In testing, I'm only switching between the two emulators. There are no code > changes. > > > > (Since the app only does queries, and no updates, the table is initially > created outside and pushed onto the phone. Basically I use SQL Workbench to > load the table from text files. I didn't see a reason to have hundreds of > INSERT statements in the code for a one-time use. The canned database is > then used in both the Android and iPhone versions [never got the Windows > version to work].) > > > > I originally created the apps a couple of years ago (version 3.??). Do I > need to possibly download a later version of SQLite and recreate the > database with it? > > > > Thank you for any insight you can offer, > > > > cls > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
