Discussion Forums  >  Plugins, Customizing, Source Code

Replies: 5    Views: 842

ridgerock
Veteran developer
Profile
Posts: 183
Reg: May 19, 2011
Louisville
1,830
10/09/13 08:27 AM (12 years ago)

Android-Android SQLite database failed to load from /CachedGeoposition.db error

I'm creating an android app that uses a custom URL that calls a HTML5 GPS function. I want to be able to get the current location when requested from the web page. The web page I set up works for regular browsers just fine. If I use the link to native browser it works perfect. The problem is I want to protect the HTML5 page within the app. So, when I try to access the web page in the custom URL, I keep getting this error: ERROR: SQLite database failed to load from /CachedGeoposition.dbCause - unable to open database fileexternal/webkit/Source/WebCore/platform/sql/SQLiteDatabase.cpp(71) : boolWebCore::SQLiteDatabase::open(const WTF::String&, bool) What I am doing is calling GPS yardage for a Golf APP. Again, the Yardage works great when Launched through a native browser but inside the app the Yardage does not pull up. On a side note I have no problems at all keeping it inside an APPLE app and the GPS functions work great. I have had this problem for a LONG time now and I have never been able to find a solution. Any suggestions would be greatly appreciated.
 
SmugWimp
Smugger than thou...
Profile
Posts: 6316
Reg: Nov 07, 2012
Tamuning, GU
81,410
like
10/09/13 02:21 PM (12 years ago)
Have you tried in other plugins? Possibly the HTMLDoc or the CustomHTML plugin might provide different results? Just asking... Cheers! -- Smug
 
ridgerock
Veteran developer
Profile
Posts: 183
Reg: May 19, 2011
Louisville
1,830
like
10/10/13 06:10 AM (12 years ago)
Hey Smug, Yeah, unfortunately I have with no luck.
 
SmugWimp
Smugger than thou...
Profile
Posts: 6316
Reg: Nov 07, 2012
Tamuning, GU
81,410
like
10/10/13 03:45 PM (12 years ago)
Is the SQLite database on the device? Are you saying that your method works ok on an iPhone, but not on Android? Cheers! -- Smug
 
Patrickmotox
Aspiring developer
Profile
Posts: 89
Reg: Dec 10, 2013
Cameron Park, C...
7,090
like
01/27/14 11:19 AM (11 years ago)
I have the same issue and here is how it is manifesting itself. I am trying to get driving directions from within the HTMLdoc, and I also tried using the CustomHTML plugin as well. They both come back with the error you show above. Now in the same app, I have a pdf plugin displaying a link to a site that contains maps and driving directions. When I click that link in the pdf, it opens androids web browser to the page for driving directions and it populates the start location with "my location" and creates the driving directions. Like what you expect to happen. Within the app, as with the HTMLdoc, or CustomHTML, and as a test I am using the same HTML and java scripts as the link being used by the Android browser, I get the error. The wheel just keeps spinning, "my location" is never assigned and the error below is shown in logcat. The destination lat lon is correct, but the start lat lon never gets set. Is there something in the plugins/app/buzztouch that is changing the path to the db? or permissions to get to the db? or ?????? Inquiring minds want to know. Hee hee. ERROR: 01-26 20:52:53.704: D/WebKit(6097): SQLite database failed to load from /GeolocationPermissions.db 01-26 20:52:53.704: D/WebKit(6097): Cause - unable to open database file 01-26 20:52:53.714: D/WebKit(6097): external/webkit/Source/WebCore/platform/sql/SQLiteDatabase.cpp(71) : bool WebCore::SQLiteDatabase::open(const WTF::String&, bool) 01-26 20:52:53.724: E/SQLiteLog(6097): (14) cannot open file at line 30176 of [00bb9c9ce4] 01-26 20:52:53.724: E/SQLiteLog(6097): (14) os_unix.c:30176: (2) open(/CachedGeoposition.db) - 01-26 20:52:53.724: D/WebKit(6097): ERROR: 01-26 20:52:53.724: D/WebKit(6097): SQLite database failed to load from /CachedGeoposition.db 01-26 20:52:53.724: D/WebKit(6097): Cause - unable to open database file 01-26 20:52:53.724: D/WebKit(6097): external/webkit/Source/WebCore/platform/sql/SQLiteDatabase.cpp(71) : bool WebCore::SQLiteDatabase::open(const WTF::String&, bool) 01-26 20:52:54.325: W/ZZ(6097): BT_screen_customHTML:onPageFinished finished Loading: https://maps.google.com/?q=38.732843+-120.802002
 
Patrickmotox
Aspiring developer
Profile
Posts: 89
Reg: Dec 10, 2013
Cameron Park, C...
7,090
like
01/27/14 04:26 PM (11 years ago)
Using htmlDoc plugin solved it. Now to get it to automatically open htmlviewer without prompting. Yahoo.
 

Login + Screen Name Required to Post

pointerLogin to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.