• After 15+ years, we've made a big change: Android Forums is now Early Bird Club. Learn more here.

Help Moto G5s wont start after battery gone flat

If your Moto G5s goes flat there isn't enough charge to boot phone. The phone will boot then shut down & you cant charge it.

To fix
1 Plug in USB charger
2 Hold Vol- ( lower volume button) & power button for 10 seconds or so
3 Now you should boot into Command prompt recover mode. ( see pic of Android bot with his panel open & text beneath him,
4 Look at text. Look for line that states Battery ok (charging) if this is green then phone is charging.
5 Wait 30 minutes or so, you should by now have at-least 10% charge in phone. ( wont show until you start phone)
6 select with volume control buttons option on right near buttons for power & volume, the option Start.

Now phone should boot.

7 leave on charger until phone charged

sqliteOpenHelper...Unique combination of columns?

Hello.

I'm looking for some direction on creating a table that has uses UNIQUE constraints. When adding new rows to my database, I want to make sure I don't add a duplicate value. However, I need to check that the combination of two columns is unique.

for example the column names are as follows.

Code:
KEY_RECORD     KEY_FILE     KEY_TIME     KEY_TEMP     KEY_CONC

KEY_RECORD will repeat over 7 rows, with a the KEY_FILE iterating 1-7 such as

Code:
KEY_RECORD     KEY_FILE     KEY_TIME     KEY_TEMP     KEY_CONC
0001              1
0001              2
...
0001              7
0002              1
0002              2
....

currently I'm creating my DB using sqliteOpenHelper. I do the following.

Java:
private static final String TABLE_CREATE = "CREATE TABLE " + TABLE_RECORDS + "(" + KEY_ID + " INTEGER PRIMARY KEY," + KEY_RECORD + " TEXT," + KEY_FILE + " TEXT," + KEY_TIME + " TEXT," + KEY_TEMP + " TEXT," + KEY_CONC + " TEXT" + " )";

...

@Override
public void onCreate (SQLiteDatabase db)
{

    db.execSQL(TABLE_CREATE);
    db.close();
}

I know if I add the keyword UNIQUE I can make any of the columns unique.

Java:
private static final String TABLE_CREATE = "CREATE TABLE " + TABLE_RECORDS + "(... + " TEXT UNIQUE," + KEY_FILE + ..." + " )"

But how do I do it so that a combination of the two columns must be unique in order to add.

Message from the developers

Hi,

We created this forum to get unique views from you.
Trick Colors 2 is a casual puzzle game developed by Rodio studios (just two people).
Our friends who have tried out the game really liked it(but....). So can you check the game out and give your thoughts on it ?
We would appreciate it if you can.
Thanks a lot.

Here's the link to the game
https://play.google.com/store/apps/details?id=com.trickcolors2.rodio


Here's the link to the trailer

Attachments

  • Screenshot_20190910-222839.png
    Screenshot_20190910-222839.png
    40.1 KB · Views: 79
  • Screenshot_20190910-222805.png
    Screenshot_20190910-222805.png
    38.2 KB · Views: 76

Jetaudio problem with GPS

Hello,

I have the jetaudio + 9.9.0 for android on my Samsung s8 which give entire satisfaction except 1 thing

I start the music and that's work very fine but when i start a gps program at the same time with sound like ( google map, waze , tom tom , mazda gps car ) i have the sound also but when the message is finished the sound does not come back to the jetaudio player

I cannot have the 2 sound together working ( 1 after the other )

Is this something that we can solve in the settings (so many settings ) ,am i the only one, a known bug ?

Many thanks for your help

Sequence of the program running

I am running a fragment that as you switch to it, it queries a MySQL database and populates a spinner.
On choosing an item in the spinner and then pressing a button, I want it to again query the database and extract info corresponding to the item selected.
However, it seems to complete all the steps in the setOnClickListener method first before it returns the results from the query, whose call is also included in the setOnClickListener method.

Below is my method, as well as the code that does the querying of the database.

This is in the onCreateView method and does the initial retrieving of records to populate the spinner.
Code:
if (getUserVisibleHint()) {
    GetTrainingVideosMySql getTrainingVideosMySql = new GetTrainingVideosMySql();
    getTrainingVideosMySql.execute("");
}

This following code also in the oncreateView method, and is when an item has been selected in the spinner, and now the button has been pressed. The objective is to again query the database, set the class string called fileUrl, and then use this fileUrl in vw.setVideoPath(fileUrl):
Code:
btnFetch.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View view) {
        fileUrl = "";
        GetVideoUrlMySql getVideoUrl = new GetVideoUrlMySql();
        getVideoUrl.execute("");
        vw.setVideoPath(fileUrl);
        vw.start();
    }
});

Below is the method that does the extracting of the information required of the database:
Code:
private class GetVideoUrlMySql extends AsyncTask<String, Void, String> {
    String fileLocation = "";
    @Override
    protected void onPreExecute() {
        super.onPreExecute();
    }

    @Override
    protected String doInBackground(String... params) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection(url, user, pass);

            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("SELECT url FROM training.training_videos WHERE id = 1");
            ResultSetMetaData rsmd = rs.getMetaData();

            while (rs.next()) {
                fileLocation = rs.getString(1).toString() + "\n";
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return fileLocation;
    }

    @Override
    protected void onPostExecute(String result) {
        fileUrl = fileLocation;
    }

The sequence that I would expect the program flow to take when the button is pressed, is first to get the file URL because of the statement getTrainingVideosMySql.execute(""), which sets fileUrl, then use this fileUrl string as the video required.
Instead, it responds to the button click and runs the method setOnClickListener.
It first sets fileUrl to an empty string, then goes to "protected void onPreExecute()" in "private class GetVideoUrlMySql", then sets the video url to this empty string, tries to start the video, then the doInBackground method, then the onPostExecute method.

I need the onPostExecute method to complete and then set this fileUrl to the video needed before trying to start the video.

Sorry if all confusing how I've explained it.

Help Radio Band Changed while trip abroad

Hi,

my girlfriend runs an German Sony Xperia X Compact on Android 8.0.0.

She traveled for three months in the US and now her phone worked well until it suddenly stoped. Now its stuck on "radio band USA" (A guy at a reapair shop found that out with using *#*#4636#*#*) and she can't get back to the German network.

I tried the factory reset already but that didn't solve the problem.

Is there any other way?

I realy appreciate any help.

Cheers,
Julian

outgoing message sound

I have a new MOTOROLA G6 running pie9 software, outgoing message sound is a very low single beep meaning you need to look at screen for message sent. Using default message app, tried whatsapp and no change contacted Motorola support no resolution. Other forums report same issue phone reviews do not mention problem.

robsie:(

Kyocera Dura Force Pro 2 Bugs

So I'm a long time Kyocera Dura Force user. Love the phone but bought a new one in March from Verizon. Initially it was great then came the shove down your throat updates. Now my phone rings twice over itself, volume turns itself down, if I miss a call display shows I missed 2 calls from the same caller at the same time. Got replacement phone that does the same thing. Verizon tier 3 support duplicated the issue on their same phone. I constantly miss calls because volume turns itself down on ringer and text notifications. Verizon says software update issues since their phone did it too. Kyocera says nothing wrong. I sent my phone in with a video showing the problems, but nothing is wrong they say... Anyone elses Dura Force Pro 2 doing this?

[Game][Free] TriPeaks Solitaire Challenge

New vision of solitaire experience. Free and wide-platform tripeaks solitaire arena.

Everyone who likes tri peaks, pyramid, freecell, spider, diamond, klondike, mahjong and other classic free solitaire games will play the global TriPeaks solitaire challenge.

We have collected the best social tripeaks solitaire experience to bring it to you.

TriPeaks Solitaire Challenge is the most powerful global classic solitaire arena. Reach new skills, explore new powerups, collect gold and silver, reach achievements, open new tournaments, and become the TriPeaks Solitaire Champion of the World!!

Features:
- excellent QHD graphics
- thrilling sound effects
- the game is superior balanced and is completely free, but if you wish, you can buy some packs to boost your experience
- all-in-one friends integration: once connected to the Facebook, you will get not only super boost to your max hearts amount, but more friends for the competition
- additionally, every your friend can help you with a hearts every hour 24/7.
- different card types reflect your preferred options

Solitaire Tournaments:
- Classic Tripeaks Solitaire Tournament: challenge The Globe every day! Here you will find solitaire masters of your level.
- World Challenge Tournament: the most extreme tripeaks solitaire arena you had before. New conditions, new competitors, new prizes every day!
- Facebook Tripeaks Tournament: challenge your friends and keep them in touch of your success.

Some tips:
- use bonuses to boost your score. For example, taking the Timer Freeze Powerup before you play, you will get more time to play and more time bonus score in case to clear the all game field. And taking the Joker Card powerup, you get the wildcard that beat any other one.
- some levels are quite complicated, but all of them are real, don't give up!
- make fast combinations, Quick Hand is your friend on the way to high score
- clean up all the cards, every cleaned Tower card will give you 10000 bonus points
- keep the deck as full as possible, every card there is your bonus points, but upgraded Joker powerup will get you ever more bonus score
- play fast, time is your score points too
- play smart, be the Solitaire Champion!

Invite as many friends as you can to get more fun and more challenge.

Thank you for joining us and welcome to our TriPeaks Solitaire Challenge club!

Download from Google Play: TriPeaks Solitaire Challenge


1.jpg
2.jpg
3.jpg
4.jpg

Whatsapp phishing attempt

This morning I've had two texts allegedly from Whatsapp with a code for 2 factor authentication. The first was from a UK mobile (cell) number, and the second had a Whatsapp logo displayed by the text message. Naturally I deleted both of them as I don't use Whatsapp, and it's not installed on my phone.

I also had a voice calll saying '"Your Authorization code is 999999" with no clue what it was referring to. I blocked the number.

As 2FA is coming to UK banks and other online transactions soon, be aware of these ,maybe not so obvious, scam calls and texts.

After flashing twrp recovery phone is stuck at (set warranty bit :recovery)

I tried to root my Samsung galaxy on7 sm-g600fy using Odin
After flashing tar.md5 I tried to boot the phone into twrp recovery mode to flash SuperSU but it is not opening twrp recovery mode instead it is stuck at
(set warranty bit:recovery) .on top of screen
..
(Samsung galaxy on7 ) in middle

(Powered by Android) in the bottom

If someone can help please help me to get root access o my device

Default keyboard Galaxy Tab A

Can't seem to change default keyboards on my Galaxy Tab A. I'm Seeking a keyboard with a DEL key, like Google's or Swiftkey. Can't find a path in SETTINGS to change away from SAMSUNG. Web searching says to go to PHONE SETTINGS which don't apply of course.

I have the Google keyboard app downloaded but don't see a way to implement it.

I'd much appreciate some help here.

Should I repair my smartphone or buy a new one?

I have a Lenovo Vibe K5 Note 32 GB, 3GB RAM bought on Nov 2015 running on Android Marshmallow. I formatted & reset it 9 months ago as the performance was slow. Now I have 2 GB Space left. Still there is occasional lag in using the smartphone. The phones camera lens cover lost its glue & has detached from phone. The volume up key sometimes won't work & needs to be pressed hard. Also there are black spots on pictures taken with camera. Should I repair this smartphone or buy a new one?
Is it worth waiting for Android 10 smartphones?

Accessories Wired earbud sound quality......

Blows compared to bluetooth earbuds. Both are AKG. What gives?

Anyone else notice this? I'm an audiophile thus I take my music quality very seriously. Usually I've found bluetooth buds lack the punch and crispness of high quality playback.

The exact opposite is true with the earbuds that came with the phone and the AKG BT buds I bought. Strange indeed.
.

Link to my local_manifest.xml files for a bunch of custom rom builds from source

For any compilers on google devices that may struggle with local_manifest.xml files for custom rom makers such as Bootleggers, DU etc I have created a repo of my local_manifest files as well as some bash scripts I put together cause im just lazy and would rather not set my build env up cmd by cmd.

git clone https://github.com/Centurion83/local_manifest.xml.git

Live Video to TV

Hi all!

I'm using the default app and device to go from the phone to HDMI. It's all working as expected.... except....

The Android bar is displaying during the video. I've turned it off accidentally once, but every time I start it up it comes back up and I can't figure out what I did. :D

Hopefully someone has run into this before.

Here's an image of the bar I'm talking about

Thanks!

Phil

Attachments

  • PhoneBar2.jpg
    PhoneBar2.jpg
    53.4 KB · Views: 124

Filter

Back
Top Bottom