Re: [sqlite] database problem with later Android Studio emulator

[Jim Callahan]

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



Jim Callahan
Orlando, FL






On Thu, Sep 1, 2016 at 3:13 AM, Charles L. Sykes 
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

Re: [sqlite] database problem with later Android Studio emulator

[Clemens Ladisch]

Charles L. Sykes wrote:
> 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.

Such an error is typically caused by using the Android framework
incorrectly.


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] database problem with later Android Studio emulator

[Charles L. Sykes]

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