apps-android-commons icon indicating copy to clipboard operation
apps-android-commons copied to clipboard

Error fetching nearby places

Open fgnievinski opened this issue 3 years ago • 17 comments

Summary:

Error fetching nearby places. no such column: location_language (cod...

Steps to reproduce:

Click on the icon for nearby location in the bottom menu. Wait for the GPS location to fix. Click on the button for searching in this area.

System logs:

Add logcat files here (if possible).

Need help? See https://github.com/commons-app/apps-android-commons/wiki/Getting-app-logs-from-Android-Studio

Device and Android version:

Google Pixel 3a Android 12 stock version

Commons app version:

3.1.1~1c9267ca0

Screen-shots:

Screenshot_20211210-211158

Would you like to work on the issue?

I'm not an Android programmer but I can help with testing.

fgnievinski avatar Dec 11 '21 00:12 fgnievinski

Thank you for reporting!

Did you recently switch to a different version of the app manually (for instance by installing an APK)? Or did you just update normally using F-Droid or Play Store?

Also, did you recently change language settings of the OS or app?

Would you mind trying to erase the app's data (in Android settings)? Please let us know whether that fixes the issue or not. Thanks!

nicolas-raoul avatar Dec 14 '21 05:12 nicolas-raoul

yes, I had recently reconfigured Android's preferred language settings.

I only installed from the Google Play store. but I did try uninstalling and reinstalling, which did l didn't help. I also tried the beta version, to no avail.

but now clearing the app's storage solved the issue, thank you for your help.

fgnievinski avatar Dec 14 '21 15:12 fgnievinski

Do you remember what sequence of operations led to the problem?

Or even better, would you know steps to reproduce the error?

That would help us a lot to fix the bug so that it does not happen to other people in the future :-) Thanks a lot!

nicolas-raoul avatar Dec 15 '21 00:12 nicolas-raoul

the sequence of steps would be:

  • install the Commons app
  • open and close the app
  • change Android language
  • open the app again
  • try to access the Nearby menu

fgnievinski avatar Dec 15 '21 13:12 fgnievinski

Strangely I could not reproduce the issue. But please anyone else please try and let us know :-) Thanks Felipe and all!

nicolas-raoul avatar Dec 15 '21 14:12 nicolas-raoul

~~I am also having issues with nearby places and have not made any recent changes I can think of. My issue mentions a column, not languages though - let me know if you would prefer I open a separate issue for this.~~

My own issue (strike-through text above) was resolved by clearing cache and storage.

mds08011 avatar Dec 23 '21 04:12 mds08011

@mds08011 If I understand correctly you have not modified any Commons app setting recently, and have not recently installed the app via APK? Would you mind posting a logcat that includes the stacktrace?

nicolas-raoul avatar Dec 23 '21 08:12 nicolas-raoul

~~Correct, I installed from the Google Play Store at least a few months ago and do not recall changing any settings.~~

~~I can try to get those longs but it may be a while.~~

Resolved by clearing cache and storage

mds08011 avatar Dec 23 '21 20:12 mds08011

Actually, please disregard my previous comments. My own issue with Nearby was easily resolved after clearing the app cache and storage.

mds08011 avatar Dec 23 '21 22:12 mds08011

this issue is already solved by pull request #4742 , Please close this issue.

Rishavgupta12345 avatar Jan 26 '22 13:01 Rishavgupta12345

@Rishavgupta12345 Not sure what you are talking about, #4742 is an issue, with no associated PR. Let's keep this open and close if nobody experiences the same during the next beta.

nicolas-raoul avatar Jan 27 '22 10:01 nicolas-raoul

@Rishavgupta12345 Not sure what you are talking about, #4742 is an issue, with no associated PR. Let's keep this open and close if nobody experiences the same during the next beta.

YES I mentioned the pull request wrong but actually, this issue is not reproducible

Rishavgupta12345 avatar Jan 27 '22 14:01 Rishavgupta12345

Also having this issue. No changes to my phone or the app. Just opened the app for the first time in several months and nearby feature is no longer working.

I'm not an app developer, but it looks like some kind of database error.

Device and Android version: Samsung Galaxy A51 Android version 12

App version: 3.1.1~1c9267ca0

Screenshot_20220525-152052_Commons

Light-jetPilot avatar May 25 '22 19:05 Light-jetPilot

@Light-jetPilot Could you please try to uninstall then reinstall the app?

nicolas-raoul avatar May 26 '22 02:05 nicolas-raoul

@Light-jetPilot Could you please try to uninstall then reinstall the app?

Uninstalled, restarted, and reinstalled. Same issue. Also am having issue #4742

Edit: forgot to mention I'm using only Google Play for this install

Light-jetPilot avatar May 26 '22 02:05 Light-jetPilot

Uninstalled, restarted, and reinstalled. Same issue. Also am having issue #4742

@Light-jetPilot have you tried going to Settings>Apps>Commons>Storage & Cache and then clearing both the storage and cache memory? That resolved both issues in my case.

mds08011 avatar May 26 '22 02:05 mds08011

This does fix the issue. Odd that a clean install wouldn't, but I'm guessing that local database wasn't removed in the uninstall, so it still contained the deprecated column. Thanks for your help

Light-jetPilot avatar May 26 '22 02:05 Light-jetPilot