yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] DiamondJohn:
Thee were no changes to the detach between TeMeFI v1.0.93 and v1.0.94. Further to this fact, TeMeFI does NOT store any of the detach details within its own app data (and hence you can uninstall TeMeFI completely, and the detach will continue to operate). Along these lines, all the detachment details are marked within the google play app/data. So, if you are having any issues with TeMeFI regarding the detach, it will have something to do with the PlayStore and its data. Also,, the name as presented is 100% to do with the way the PlayStore is recording its data (see the suggested Dynamic DB query below). Historically for me, that has only changed when I have messed with the PlayStore (eg uninstall/reinstall an app or clear the data). It is not due to any change in TeMeFI, but a change in your PlayStore data. During testing, sometimes YouTube came with the descriptive name and sometimes it did not. It was the PlayStore data that was flakey.

So, firstly, you say "I get an Error: No such table...", I would be very interested to actually get the full details of what/where and when?

to get the error text, click on the area as shown in the second post [BEST] (https://xdaforums.com/showpost.php?p=76860050&postcount=2), but you can also navigate to "TeMeFI Configuration>TeMeFI Logs>Last TeMeFI Warnings and/or Errors" in the menu, immediately after getting the error {SECOND CHOICE], save off the result and post them here.

NB the above should be enough, but you could also do the logcat steps described at: https://xdaforums.com/showpost.php?p=82591017&postcount=392

Wait a sec, you upgraded from 1.0.79 to 1.0.94? that;s a HUGE jump, and I am not going to go back and test the compatibility between such an ooooold version and the current version, especially since the detach has changed (although if you say V3, then V3 hasn't changed). The simplest thing (at least for me;)) is to run the remove all artifacts, and then re-instate the detachment, after the Playstore has managed to re-attach. Seeing 3 in the list before and two now, makes no logical sense so me, and also implies you will need to re-detach the app. Also, there is a check detachment in the same menu. Run that. It really sounds like something has messed up you google play data.

As for the changes in what appears on the list, yeah, things have changed/corrected, and if its no longer in the list, then it was part of some fix, and the old list should be considered invalid/incorrect (however, you do explicitly say you used v3, so that also does not gel). A longer list does not mean better. Also, if your playstore registrations have changed, then your list would of changed over time. Independently of TeMeFI versions.

You could also post the results of a dynamic query:

Database>Dynamic DB Queries>All Table Data>/data/data>/data/data/com.android.vending/databases/localappstate.db>appstate>10000>package_name>Table: ASC

That is basically what the detachable apps list is created from.

PS: On a side, I personally user Vinyl Music Player.;)
[Android Apps and Games] drewcu:
EXTEND2_DETACH_REMOVE_ONE
ENABLE ATT: One App for re-attachment
Error: no such table: LAS.DiamondJohn_TeMeFI_detach_app

Database>Dynamic DB Queries>All Table Data>/data/data>/data/data/com.android.vending/databases/localappstate.db>appstate>10000>package_name>Table: ASC

Ran the above and end with an HTML file that does not include com.google.android.music, and I swear it was in Detach/Check/Attach before I upgraded versions.

So far Google Play Store has not tried to update Google Play Music and I have it set to update all apps automatically. If I go to refresh any possible updates, Google Play Music does not come up which suggests the Detach is working.

Like I said, I am hesitant to upset the apple cart if the Detach is actually working. If I reset the detach artifacts and Play Store data AND if com.google.android.music doesn't show up as a possible app to Detach, then I am stuck. I will check out Vinyl Music Player, but what I like about GPM is the fact that my albums always show in most recently added to my phone / played to least vs. just alphabetical album order which is useless to me (I never remember what albums are named).
[Android Apps and Games] DiamondJohn:
That is explicitly telling me the detach is broken. Without explicitly checking every individual line (of over 1000 lines) of code, nor having your device in my hand, you are heading for further un-explainanble issuers down the line. For example, off the top of my head, has any app successfully updated?

Don't you hate it when all evidence does not align with what you believe to be true;):laugh:

Also, if you ran Method 1, or some other detach method, the playstore will not appear in the list. Or it could be one of the unexpected/unexplained failures I am speaking of.

I understand the "if it ain't broke, then dont fix it" moto, however, check if any/all app is updating correctly, and if you can successfully install any new app.

It may take some time for the playstore to correct itself (ie re-attach the app), but you are currently running a broken playstore.

If everything works (ie the playstore) as its suppose to, then the app WILL appear in the list.

In Vinyl music, the recently added can be found under Playlists, as a "Last Added" playlist.
[Android Apps and Games] drewcu:
If you are asking if the Play Store (com.android.vending) appears in the /data/data/com.android.vending/databases/localappstate.db, the answer is NO (now at least).

Play Store apps ARE updating properly, but I did notice the Recently updated section cleared out. Also, I don't know if apps are automatically updating normally because I manually updated the only few updates that came about the last couple of days. But they download and install normally, and like I said, Play Music doesn't come up in the Updates Available section even though I am using a 2019 version.

What would you do if you were me? Risk Google Play Music not showing up as a choice to detach after resetting detach artifacts and Play Store data? Or just live with things as-is given Play Music is detached as desired using V3 and the Play Store apps update normally?

I've seen the Last Added playlist in different music apps, but then you end up with a song list in a fixed order as opposed to being able to add albums to queue in whatever order you want.

Thanks!
[Android Apps and Games] DiamondJohn:
Not sure which question provoked this answer? Of course you can not detach the playstore, from the playstore:confused:

It WILL show up in the list, especially via step 1 below, otherwise the playstore is buggy If it were me, I would try the following, in this order, and check after each step (for the missing table error, AND if the data now appears in appstate, and the detach check built into TeMeFI)

1. You said your app is NOT in the data for app state. To fix that, I personally have historically gone to the app in the playstore, clicked the update button and then QUICKLY press the cancel button before it finishes the download and installs.

2. Detach another app. If you need to install a temp app just for this fix/test. By detaching another app, it will attempt to reinstate your missing objects (ie it tries to correct/fix itself on every detach)

3. Detach the temp app. test for fix (shouldn't do it)

4. If any of the above doesn't work, running the remove ALL artifacts and waiting/forcing the re-attach of your detached app, then re-detaching that app.

Beyond the scope of TeMeFI, but Android has a user defined Playlist built into it, that most music player should support (inc Vinyl). From the latest added, you can add an item to your personal playlist. As you can imagine, I use boot scripts to create and maintain my playlist, moving newer files closer to the current playlist (which I keep at 100-300), track & remove already played (I have >3k songs) etc etc etc
[Android Apps and Games] DiamondJohn:
It just occurred to, me, if it is marked as detached via TeMeFI (using method3), then trying to install it will look like an attempt by the playstore to update the app. As such, it will be blocked (I thin the playstore will be killed). You will most likely need to remove that specific app from TeMeFI's detach list, before "faking" an installation.

On a side note, the above behavior is also a way to block someone (say your child) from installing specific apps from the playstore (eg a specific game) on their device.

1. install the app from the playstore

2. Detach the app in TeMeFI using method 3

3. uninstall the app using the uninstall in your settings

If anyone now tries to install the app in the palystore, the playstore will be killed!

Actually, that gives me an idea for another method; but of no use to me. Using a variation of the detach method, I could block any new apps from being installed :cyclops: that would help a parent who wishes to control their child from installing apps from the playstore freely. hmmmm... would that be of any use?
[Android Apps and Games] HippoMan:
I think that would indeed be quite useful.

Also, I'm wondering if there could be a way to proactively block the installation of individual apps without going through the Install-Detach-Uninstall steps that you mention above.

.​
[Android Apps and Games] DiamondJohn:
with the current development, the above steps are the only way I can think of.

Also, to be able to get the app identified (eg com.android.google.youtube) I would need to be able to search the WHOLE of the playstores app data base, and pull a number of their private fields/data on the app, so as to fool the playstore into thinking you got it through the playstore.
[Android Apps and Games] HippoMan:
I see. Well, Install-Detach-Uninstall is still workable.

Thank you.

.​
[Android Apps and Games] drewcu:
Thank you! #1 worked for me: clicked Update in the Play Store for GPM and it then said "Waiting for download" which never actually started but hit Cancel anyway. Then I went to TeMeFI and saw GPM as an option to detach and I reran V3 on it. Things seemed fine except automatic updates in the Play Store still wouldn't occur unless I intervened.

So I reattached GPM to the Play Store, removed all artifacts, and cleared the Play Store's data.

Then I again saw GPM as an option to detach so I again reran V3 and now apps are automatically updating in the Play Store except for GPM.

Thank you so much! Fingers crossed no more issues arise...

Drew
[Android Apps and Games] DiamondJohn:
I haven't actually tested it, but you may not need to actually let the install complete, so the uninstall step would also not be needed. By clicking the install (and then cancel before it finishes download) may be enough for the playstore to register the app internally, thereby enabling a detach of an app that is not installed, which would then block the app from being installed in the future. As I said I haven't tested this theory.

So the steps would be:

1. find the app in the playstore

2. click the install button

3. QUICKLY click the cancel; button before it finishes downloading / installing.

4. Detach the app in TeMeFI.
[Android Apps and Games] HippoMan:
Thank you. I'll test that a little later today or over the weekend, and I'll report my findings.

.​
[Android Apps and Games] DiamondJohn:
Another check (for if it has been "registered") would be to run the above described Dynamic DB Query I detailed on local app state, at .the end of this post: https://xdaforums.com/showpost.php?p=83763687&postcount=630 But if it appears in the list of available apps to detach, that basically runs the test for you already.
[Android Apps and Games] DiamondJohn:
favour?

Could I ask a favour from people running Android 10 ROMs?

Apart from this app, I also build ROM's from source for my device. Currently I am running an Oreo Havoc-OS build, which is getting pretty old:crying:

I am looking to upgrade to Android 10, however, both the ROM that I build and ones built by others for my device, both do not correctly support Album art:mad: They will display media art, but it is not album art, and thereby most people don't realise its not correct (as they see media art and assume its the same thing). The reason I would like to see others results, is to check if its a bug specific to my device (which I am guessing its not), or it is a bug across all devices.

Anyway, it would be good to get the results from other Android 10 devices, from the following type of ROMs, by people who have a number of mp3's or such; and are rooted.

1. Lineage-OS Android 10, or a Lineage-OS based ROM such as crDroid. I have tested two of these for my device, and they both fail.

2. An AOSP or AOSP based ROM, Android 10. eg Pixel Experience.

3. A retail Android 10 stock (but rooted) device (Such as Samsung or Pixel device)

The test to run is the following

Databases>Dynamic DB Queries>All Table Data>/data/data>/data/data/com.andrroid.providers.media/databases/external.db>album_art>10>album_id>ASC

After you click "/data/data" you will be presented with a looooog list, if you log press the "X" button, you can filter the list with "external", and that should limit it to a single line.

Also, if you do not get results with the above, could you also please check your internal dB?

Databases>Dynamic DB Queries>All Table Data>/data/data>/data/data/com.andrroid.providers.media/databases/internal.db>album_art>10>album_id>ASC

I dont actually need the results themselves, its simply to check if there are ANY records returned, so in this instance, simple screen shots would be great, and they dont need to show the whole line. Just if there is ANY. data.

Thanks in advance.
[Android Apps and Games] HippoMan:
One of my devices is a Samsung S5 running Lineage 17.1 (which is Android 10). I tried this on that device, and the album-art queries return no records, neither from the external DB nor the internal DB.

.​
[Android Apps and Games] DiamondJohn:
Yeah, that's not looking good, and would align with my deduction that there is something broken in LOS 17.1. I also tried two album art management apps from the PlayStore, that I have successfully used before, and neither were able to change the album art on android 10. I also tested to see if I insert the missing records manually, but that still did not display the assigned album art and also triggered a major crash in the album art software when changing it to something else. It appeared to be looking for a non-existent field of "orientation" :confused: Currently Its not on the album art, its on "files";

It appears to be a serious bug (especially for people that like/depend on their album art:o) that no-one is talking about.:mad:

I would really be interested to see if the same happens with AOSP and device manufacturers default ROM's.:confused:
[Android Apps and Games] PRDR:
I don't know wether this from my ROM helps you or not (OOS 10.3.6 on a rooted OnePlus 6), but here is the output of those command anyways (first picture external, second one internal).
[Android Apps and Games] bradical711:
Wanted to post my results for you as well. Running Dirty Unicorns 14.7 on my pixel 4 xl. Also despite my results listed above, when I enable "show media art" in the ROM's dirty tweaks section, it correctly displays album artwork like you're seeking. Not the media art. I don't know how that affects anything though but I wanted to edit my post to put that.
[Android Apps and Games] DiamondJohn:
What makes you say it is album art, and not,media art (my naming).?

Is the following Album, Art app able to change the album art?

https://play.google.com/store/apps/details?id=com.citc.aag

Do you have any app that enables you to change/manage the album art? I would like to test it and confirm myself.
[Android Apps and Games] bradical711:
I apologize, I may have misunderstood what I read last night. I said that because interpreted what I read as "album art" and "media art" being two separate things. In my use case of android I have experienced separate phones and android versions using what I would describe as "media art", and the other as "album artwork". So to me, them being two separate things made sense. "Media art" in my experience was just a blurred overall generalized color of the album artwork, and the "album artwork", I would say had the album cover on the lockscreen but blurred out. So two different things in my experience and hence why I said what I did. Hope that clarifies everything a bit. Also no, I don't have any app that enables or manage's that for me. And I can try the app later today and let you know. I'll be kinda busy for most of the day but I'll get back to you when I get a moment so I can try that for you.
[Android Apps and Games] DiamondJohn:
No problems, you dont really have anything to apologise for. For starters, the term/naming of "media art" is kind-of my own term, not some industry accepted term. I call it this, because when I tried to determine where/how android 10 was getting its artwork from, I found that it was storing it on the sdcard, using the system internal "_id" value from the "files" table in the media db database, with no storage of the link/detail. Which really looks like some kind of worst case scenario / fall back system. And if I am right, people much smarter than me haven't noticed it either!:mad:

The blurring thing simply adds confusion to the issue, on my custom android 10 ROM, the blurring can be turned on or off, and there is also an option to display as grey-scale (ie black and white). Although, on at least the early builds, it was flakey.

I see Album Art as an image that is shared between multiple media files (most commonly music), that are on the same album. The Media DB has each file (ie song) as a separate line in the "files" table (sqlite database), so the current system where the _id implies a specific file, means that multiple files on the same album, means that each file could have a different artwork.I found it in "/sdacrd/Music/.thumbnails/", where each song has its own artwork extracted from the MP3, so if there is no embedded art, the song will have no artwork.

To make the matter worse, I have many MP3's with a 1x1 pixel artwork embedded in the file (the default source android 10 is extracting the media art and writing to my sdcard), which then actually causes a crash in my media player. Not just an error, but it actually kills my media player! All my previous versions of android had no problem with these. And the 1x1 artwork can even be opened in image viewers on android 10. So the 1x1 image is clearly valid, but is not being handled by android 10 correctly.

I am interested to see how you go wit\h the app?

Also, is your device an official build of LOS DU? Its hard for me to report this as a bug for the ROM, as I build/run an unofficial; custom ROM based on LOS, and the LOS build I do use/test (built by someone else) is also unofficial:crying:
[Android Apps and Games] BrahmaGandhi:
[MENTION=5417899]DiamondJohn[/MENTION] hi dev, this the first time im using this cool app. anyway i need helps..

1) what should i choose when detach an app from playstore (YT vanced) there options for level (method) 1,2,3. which one should i choose? i really don't know the difference.

2) is there any risk/disadvantage to "set root available on start-up" ?

thanks a lot
[Android Apps and Games] Philnicolls89:
For detaching vanced from playstore, use method 3 as it is the most aggressive option (youtube really doesn't want you to detach its app!). Method 1 & 2 may not work for utube.

A lot of the options/features in TeMeFi won't work without root as it needs superuser access to run the scripts, so the disadvantage of not giving it root would be less functionality of the app. As for the 'risk' of giving it root permanently, I believe you can look at the scripts that TeMeFi runs and evaluate them yourself if you have security or privacy concerns. Its only the GUI that is not 'open source'.
[Android Apps and Games] BrahmaGandhi:
thank you fo the explanation.

ok method 3 is done.

since ive decided to always unlocked bl and rooted, security concern is no longer biggie anymore, but im aware for "privacy". i think its part of consequences. Ok, so far..set root available on startup doesnt affected..safetynet/cts still passed, no apps, module issue whatsoever. thanks again
[Android Apps and Games] DiamondJohn:
As for which to use and what they do, there is a message box that pops up BEFORE you choose. READ IT! I had to physically type it, and obviously it was a waste of time:mad:

As for root on boot, that has been described in the thread, and there is a search function in XDA..

I personally run with the option on to assume root on every boot, as it simply means that it does not do an explicit additional internal check on every single boot. The only risk I can think of is if you loose or remove root for TeMeFI, you will still see the root only menu items, but will fail when you try and run them. I run with that option on. It does NOT give you root, it only assumes you have root (to make startup a little bit quicker) The rooting system (ie Magisk) still checks for actual root, before you run any root method.
[Android Apps and Games] BrahmaGandhi:
ok. i understand now. thanks
[Android Apps and Games] DiamondJohn:
Just for clarity, there is nothing specifically in the scripts that flags a script as being ran as root. Its only what the script does, that made me decide what gets run with root and what does not get run with root. I only really use it to build the menu, and then to run the script with root; which is internal to the app, and not explicitly visible in the final script text.

There are two parts to the allowing root. The actual permission to run as root, would be controlled by your root software (ie Magisk). The allow root on boot menu item in TeMeFI, is simply just used to build the menu. If it is off, TeMeFI still checks if root is allowed (ie Magisk allows it and it is not explicitly turned off in TeMeFI) and then uses that for the rest of the time the app is running. Its as if the setting is on (if it passes the initial root check). Where I am going with all this, is that Safety Net checks should not be affected at all (its 100% internal to TeMeFI), unless having any root apps affect it, or if safety net/cts start taking notice and specifically target the little known app called TeMeFI:rolleyes: or you run a specific script in TeMeFI that breaks it.
[Android Apps and Games] rodken:
During this process, Do I delete or keep the source for bootanimation?
[Android Apps and Games] DiamondJohn:
By one of the explicit options / selections on the method, TeMeFI asks if you want it to delete the source ZIP. i.e. you can delete the source in /sdcard/downloads and can even get TeMeFI to do it for you!

Additionally, the source code (i.e. how and what it is doing) is available, so reading that would also show you that it makes a copy into the Magisk folders, and so the source zip is no longer needed.
[Android Apps and Games] DiamondJohn:
Hate to NAG, but has anyone got a Pixel (or samsung) device running the stock manufacturer Android 10 ROM rooted, would please run the above?:fingers-crossed:
[Android Apps and Games] chooks06:
Sorry if I sound like an idiot, but I am one..

So I have an Umidigi A5 Pro running Pixel Experience ROM on Android 10 and I was trying to figure out how to run the code..Dr Carlsberg helped - though now I realized working split screen in this ROM takes some getting used to..

I don't know what to make of it so I'm just attaching the screenshots for both internal and external (didn't see a looong list, didn't notice any "X" but when drunk probably can't see anything anyway)..

If there's anything else I can help you'll have to wait till I'm sober and understand what's happening (both concurrently).

Sorry I didn't scroll to see if there's anything at the bottom below the text shown after running the code.. I'm assuming that there should be nothing else.

Thank you very much for your contribution on XDA.

Stay safe everyone!