NearbyStores Android Application

1. Installation page seems not working

2. Disable ONLY_FULL_GROUP_BY

3. Maps is not working in play store

4. How to resolve the problem "Error! Network is not available" in android 9 and higher

5. How to resolve error "failed to resolve play-services-auth" and "failed to resolve play-services-ads

Sometimes, after checking all the details needed to install the script on the server, you still get the same error message telling you don't have permissions or that the user not have  full privileges for this database, it might be a missing write permission in the root path of your host server

Here's what you do in Ubuntu

1. Make sure all files are owned by the Apache group and user. In Ubuntu it is the www-data group and user

   chown -R www-data:www-data  /var/www/html

2. Next enabled all members of the www-data group to read and write files

   chmod -R g+rw /var/www/html

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin

• Open phpmyadmin & select localhost
• Click on menu Variables & scroll down for sql mode
• Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.

Please run the app first in real device and if it working then do as follow.

If u have enabled the App Signing Feature in the Developer Console, then it's clearly written in the documentation that the Upload Certificate is only needed by Google for authentication and that upload certificate is removed before installing the application on the user's phone. So, u also need to give the App Signing Certificate SHA under the key which you have enabled for Google Maps API. The App Signing Page is as I have attached the screenshot for your convenience... In the image I have marked which you need to give as additional credentials

It may due to the your website  that's not secure enough , to skip this problem please try this solution :

First open your androidmanifest.xml file and add this line of code inside the application tag

android:networkSecurityConfig="@xml/network_security_config"

like this example : 

<application    
android:name="com.domain.apps.appname.AppController"    
android:allowBackup="true"    
android:icon="@mipmap/ic_launcher"    
android:label="@string/app_name"    
android:theme="@style/AppTheme"    
android:largeHeap="true"    
android:supportsRtl="true"    
android:networkSecurityConfig="@xml/network_security_config"    
tools:replace="android:icon,android:theme">

Then go and create a new file in the XML folder , copy this content into this  file :

<?xml version="1.0" encoding="utf-8"?>
<network-security-config>    
<base-config cleartextTrafficPermitted="true">        
<trust-anchors>            
<certificates src="system" />        
</trust-anchors>    
</base-config>
</network-security-config>

Remove the app from your device and start to runing the app again from your android studio .

Good luck in your business.

Go to your build.gradle file and add this line  : google() before this command line : jcenter() ,  see the attached picture to know where to find this file :

E.g : 

repositories {        
    google()        
    jcenter()    
}