yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] patrickdrd:
I've noticed temefi messes up appstate table (in localappstate.db google play store's database) and

more specifically the auto_update column (resets it to "1" for all apps),

in such a way that titanium backup cannot even modify it anymore...

why is that? please fix and leave that column alone because I think it's very important, for me at least,

I noticed for example my google play services (which I hadn't been updating for a while) were updated,

which is definitely undesired result..

I had to open the file with a sqlite editor in order to get the column values back to "2",

which is "never auto update" app,

I'm restoring from my last two backups to see if I can restore my google play services version back
[Android Apps and Games] DiamondJohn:
That's NOT TeMeFI !

If you are seeing that, then something else is doing it. Funny thing, TeMeFI actually SETS IT TO 2, so what you are saying makes even less sense. If you detach an app, that is one of the tests it has to pass for a pass mark. ie That its 2 If TeMeFI was failing (which it is not :p), it would of been setting all apps to 2 if anything, not 1. Something else is your issue, not TeMeFI.

When I change that field, I am also changing a number of other fields, so they would also be borked, if I had damaged that one for "all apps"; thats how SQL works. Actually, check that you do not have other apps detached (or if you had them detached, then detaching resets). It will make the change for all apps that are detached. It will change it the first time you detach. By reattaching it (by removing the detach) the play store will probably reset it to the default value you are seeing, which is probably not 2, its not TeMeFI.

Use the "List All..." to see what is currently detached, and what you have previously detached is on you. The more I think of it, the more I suspect your "all apps" is due to either you detaching and reattaching or doing an apps store "clear data". Its also working perfectly on two of my devices. Mine are ALL 1 except for the specific ones I have detached.

Also, I know some apps like YouTube do auto update, even when the option is turned off. And hence this feature!
[Android Apps and Games] patrickdrd:
actually the detached apps are set to "2" but the rest are forced to "1",

and titanium backup failed to reset it to "1" again
[Android Apps and Games] DiamondJohn:
Thats what I am telling you. TeMeFI will force all detached apps to 2, except for method 1 where there will be no record, or soon after you reattach where again there will be no record. At which point the playstore will recreate the record with the auto-update turned on. Thats NOT TeMeFI.

The rest of the apps are not touched by TeMeFI, but by your PlayStore. This field is set within the PlayStore (ie no need to be using an sql editor)

Thats how the playstore works.
[Android Apps and Games] DiamondJohn:
No, TeMeFI is NOT forcing them to 1. The Playstore will default it to 1 if it needs to reinsert it (ie a re-attach)

If you are talking about detached apps, then yes, what TeMeFI does is not only stop the playstore from re-attaching apps back to the playstore, but it will stop ANYTHING trying to reattach apps.

Thats the whole point of detaching apps. Setting the value to anything other than two, is asking the playstore to auto-update the app. You seem to be asking TeMeFI to detach the app, then asking TiTB to attach the app; and TeMeFI is winning :victory:

I say :p to TiTB, you've met your match:D
[Android Apps and Games] DiamondJohn:
New Build!

New Version v1.0.84

Download: SEE OP!

Notable changes:

New Items. within the menu at "TeMeFI Configuration>Latest Added Menu Items"

Updated Items. within the menu at "TeMeFI Configuration>Latest Updated Menu Items"

Enjoy and stay safe.
[Android Apps and Games] patrickdrd:
you didn't understand I think,

I talked about two things (that both happened since started using temefi, I don't "blame" your app,

just trying to find out what's wrong):

1) all my apps, besides the ones that I had detached with temefi were set to "1" (auto update),

I don't know what caused it, but something should have, because I didn't

from time to time I'm checking this setting from inside titanium backup and "market auto updates" setting and

I press "deselect all" to reset all to "2", this time

2) it wasn't possible, trying to change "1" to "2" from titanium backup resulted in an error,

again, I don't know if temefi has to do with those issues,

it could be due to new play store versions?
[Android Apps and Games] DiamondJohn:
Re-read your original post, you explicitly ask me to stop updating the field.

That is most likely the default for the Playstore.

I am not supporting TiTB, and do not even use it myself, however, when you select ALL apps, you should NOT select apps that have been detached within TeMeFI. The changes TeMeFI makes to the playstore stops ANY apps from doing what it sees as underhanded attempts to re-attach an app. And as such, if you try and change the auto-update field, it will rule that as dangerous and reject it. However, from memory, if it is trying to simply set it to turn auto updates off (ie 2), it should not be a problem, but it may actually use a process where it sets it to auto update before resetting it to manual update. I dont know, but if it is trying something that could re-attach an app, the changes TeMeFI enacts will block it. TiTB is a black box; just like the playstore. But there is actually a log of what it does do, accessible from within TeMeFI, but this is amongst the 650-+ other methods. You will also note that the playstore does not list the detached apps, as installed apps, yet TiTB does. That sounds like a bug in TiTB not mirroring the playstore.:confused:

Since the detached apps are not visible on the playstore, you cant break it, but you can set each app to turn off auto updates.
[Android Apps and Games] DiamondJohn:
Regarding this new item. To use it you will of course need Magisk, and wont be able to access it unless you do anyway.

Simply place your selected and supported "bootanimation.zip" onto your internal SDCard at /sdcard/Download/bootanimation.zip and then run the method. And then reboot and see your new boot animation in action. As it uses Magisk and systemless implementation, the change is non-destructive and can be simply reverted using the above menu item, which will now include a revert option. Also note, I tried this a few years ago on an older Magisk, and it would play the default boot animation for a few seconds before it switched over to the new boot animation.

There are hundreds of boot animations available. Just for demo purposes, I have attached the one I have used for the past 5+ years. I think its an old nexus prime source

A rotated video.

https://www.youtube.com/watch?v=vRax3Z2Dwsg

NB: to use it properly/full screen, you may need to change the dimensions stored in the file "desc.txt" file within the zip to match your screen size. Mine is 1080 x 1920
[Android Apps and Games] Lither:
I have followed the instructions in this post using TeMeFI app but when I open the Youtube app, I still get the same update screen.
[Android Apps and Games] DiamondJohn:
Firstly, if any of the checks are not a PASS, then, the whole detach has not passed. You have check 3,0 as UNKNOWN, which is a FAIL. Passing Check 3.0 is very critical.

Run the detach again, reboot, and run the check again.

Secondly, screenshots are NOT the way to report issues. Save off the file (pencil icon on the far right of the fly out menu) and attach the saved off file. NOT a screen shot. In the saved off file, I have hidden extra details that helps me decipher what the issue is. Especially since the first one has been cut-off. NB: You can also zoom in or out using a pinch move on the screen.

If you are still getting the issue (ie UNKNOWN for check 3.0), do the steps as set out in the previous post:

https://xdaforums.com/showpost.php?p=82610735&postcount=398
[Android Apps and Games] DiamondJohn:
pulled from another thread

hmmm... Although my phone is rooted, I turn root off in Magisk for TeMeFI, and also only run the un-rooted shell method, which explicitly does not request a root shell, and it runs as expected for me.

Did the menu item, show up? ie Logcat>Logcats>Logcat-Default (No Root) there is also an "old Toybox" version, which may explain why it did not work. ie you have an old toybox implementation, and I added that method around 2019-08-28 and thereby released whenever was the next release.

Did it return an error? or just an empty screen?

If an error occurred but no display of such, you can also check for errors by long pressing the bottom area

Is any other non-root user having issues?
[Android Apps and Games] DiamondJohn:
New Build!

New Version v1.0.85

Download: SEE OP!

Notable changes:

New Items. within the menu at "TeMeFI Configuration>Latest Added Menu Items"

Updated Items. within the menu at "TeMeFI Configuration>Latest Updated Menu Items"

Enjoy and stay safe.
[Android Apps and Games] lenwar:
Hi,

I'm trying to detach youtube from Play store, but TeMeFI throws back an error:

(yes, destinamtion, not destination :) )

It does the same for all three 'DETACH: Select Package then Protection Level v3' options

I use version 1.0.85 on LineageOS 17.1 (unofficial) on a OnePlus 5t (in case that's relevant). I have the current Magisk installed (20.4) including SQLite for ARM aarch64 devices.
[Android Apps and Games] DiamondJohn:
Ah yes, that old spelling mistake. My position is that its there to uniquely identify where the error occurred...

Actually, you found a bigger issue than you realise.

I found out that the spelling mistake was actually in the new systemize script, but at some point, I accidentally overwrote the detach script with the systemize script :o:o:o oops...sorry.

I have made a new build correcting both issues, and its in the OP, just putting together a matching release post.

And no need to worry, because the setup of the two scripts are different, the crash would of stopped any damage.:good: Luckily I do checks for valid selections before running stuff. Remember, I build these for my phone, so don't want to stuff my own one up!:mad:

Again sorry.:crying:
[Android Apps and Games] DiamondJohn:
New Build!

New Version v1.0.86

Download: SEE OP!

Notable changes:

Updated Items. within the menu at "TeMeFI Configuration>Latest Updated Menu Items"

New Items. within the menu at "TeMeFI Configuration>Latest Added Menu Items"

Enjoy and stay safe.
[Android Apps and Games] patrickdrd:
are you sure you uploaded properly?

because I only get a text file
[Android Apps and Games] DiamondJohn:
DOH!
[Android Apps and Games] DiamondJohn:
ummm.. Would you believe I was simply checking if anyone is using the MD5?

Correct file uploaded and OP updated.
[Android Apps and Games] lenwar:
It works!!

Heys,

Thanks for the quick fix! :)

It works now. Now just hoping that it will remain out of the Play Store for good
[Android Apps and Games] DiamondJohn:
Have you run the check?
[Android Apps and Games] lenwar:
Yup. Everything checks out. Everything is peachy! :)
[Android Apps and Games] DiamondJohn:
I brought this over from a PM, after cleansing any possibly private info just in case the response ends up being helpful to someone else in the future.

Alright, there are a couple of other things going on with your results, that are not directly related to your detach issue, but do indicate something is not totally OK with what you sent me, so sorry if I jump around a little in my response.

So lets first address the fact your check 3 fails. I have looked into the files you sent me, and it appears to me you have multiple accounts/playstore accounts on your phone? It appears to be saying that you have 3 registrations for youtube, and 3 of them have been detached. What is confusing is that you don't have 3 matching results for check number 4.0, or two of them have not been detached.

Do you have multiple accounts?

EDIT: Actually, I just rechecked you favourite output, and that shows that you only have a single account:confused: maybe you have had multiple in the past or something. Either way, something is screwy in your data as your ownership (which crashes) is showing 3 registration for youtube in the check.I will put together a script to run in terminal editor or such, to better understand what is going on with your playstore registrations.

Now, I AM NOT SUGGESTING THE FOLLOWING because it would bug me if someone asked me to do the same, and it will also wipe the opportunity to investigate further what is happening on your phone. However, it does appear something is not good (or at least in an unexpected state) with your playstore data, so if you prefer another path, wiping your playstore data may correct it when it recreates itself. You will need to give the playstore some time to re-establish itself to a state where you will be able to detach, but it could be an option for you; but I would prefer to understand what is actually going on and by wiping your data the opportunity will be gone..

I have more to go on your issues, but I need to head off right now, so I will address the other issues a little later today, but the above info would be helpful as a starting point.

PPS: since you are getting the crash n running the ownership fav, another step which may avert the issue until we get a better understanding is, if you go into your Ssettings then Apps and open the settings for the playstore, and press Force stop, then try running the favourite that is crashing, that may possibly avert the crash. Just a thought to try. And if it does work, send me a pm to the uploaded file as you did for appstate
[Android Apps and Games] DiamondJohn:
[MENTION=4663690]Lither[/MENTION]

Run the following from a terminal window or from ADB. zip up the file /sdcard/temefi_ownership_data.html and place it on https://fileboin.net and PM me the link (dont attach it to this thread)

su;
sSQLEXEC="/data/user/0/diamondjohndroid.utility.temefi/cache/sqlite3";
chmod 775 $sSQLEXEC;
sDB_FILE="/data/data/com.android.vending/databases/library.db";
echo "<html><body><table border=1>" > /sdcard/temefi_ownership_data.html;
$sSQLEXEC -header -html "$sDB_FILE" "SELECT * FROM ownership;" >> /sdcard/temefi_ownership_data.html 2>&1;
echo "</table></body></html>" >> /sdcard/temefi_ownership_data.html;

Hopefully the above will either return the data which crashes when you try in TeMeFI, or it will give the error that is causing TeMeFI to crash

Also, to get a logcat as to why TeMeFI crashes, see the post

https://xdaforums.com/showpost.php?p=82591017&postcount=392

and where it says "# *** START TEMEFI and wait for the crash ****" in your case you will run the favourite that triggers the crash. ZIP up the log and place it on https://filebin.net and PM me the link (dont attach it to this thread)
[Android Apps and Games] Lither:
I have 3 accounts on the phone, one is for Play Store, one is for Youtube and the other one is a email account.

I will use this option as a last resort if nothing works.

I have force stopped the Play Store and ran the ownership data file but same again it crashes.

I have ran the command above using ADB and it returned the data from the ownership data file and got a logcat but this time it didn't crash (force stopped) but just returned to the home screen.
[Android Apps and Games] DiamondJohn:
In your data, all 3 are registered for having youtube., and hence, the check is returning that its state is unknown, as it sees three youtubes as being detached;its only expecting 1 and takes 0 as a FAIL. I tested and designed it for a single account. However, the three all seem to be detached correctly.

Do NOT use it for this issue, it will not help once you re-establish your three accounts. I thought it may of been an issue since your appstate had 1 record to the 3 records in ownership. NB: appstate does have an account assigned to it also.

It appears your device ran out of memory. Although it does not look like a lot of data, your phone crashed because it ran out of memory The row count may be small, but some of the fields are binary data and they have to be converted to be visually represented. That fav I posted returns ALL rows and ALL columns.

Running a shell is a lot lighter on resources than when running in a GUI / application.

From memory, your issue was with the warning on starting youtube that a newer version was available, and not that youtube was being update.

I don't get that, and that's what brought you here.

The one unusual / surprising thing is that you have a record in ownership for each account, but your appstate only has the one record. *maybe* that's the difference :confused: (remember playstore is a blackbox) that keeps the message away for me. ie I have a 1-1 map between ownership and appstate.

I will be interested to see the effects on if YouTube gets updated in the background.:fingers-crossed:
[Android Apps and Games] patrickdrd:
[MENTION=5417899]DiamondJohn[/MENTION] could you add an option to set all auto-update entries in localappstate.db in vending data/data folder to "1"?
[Android Apps and Games] Lither:
Does the Play Store check for app updates on the main account or on all 3 accounts?

I will be clean flashing a new ROM sometime this week and will try it again, should I just add the Play Store account and then run the detach or add all 3 accounts and then detach?

The phone has 6GB RAM and no other apps were running in the background.

Yes, everytime I open the Youtube app, I get an update popup and I just press not now to ignore it and it goes into the app but a few days ago, the not now option isn't there anymore.

Also, I tried the non-root version but it still comes up with the update popup with no other option than to update.
[Android Apps and Games] DiamondJohn:
You tell me?

Read above!

I dont think it would make a notable difference in regard to order. I personally think its a hole in Googles design/implementation, as the appstate data has an "account" field, but it does NOT store the account that relates specifically to youtube.

But what happens internally with the implementation through java is out of my hands; remember, some of the fields are complex "goobley-gook":silly:. I created the fav to return ALL records. We are really only interested in youtube right now, so you could create a fav using the dynamic database query functionality, but limited to only youtube; thats thefeature I used to created the fav you are using, but without any filtering.

I *think* that is a combination of googles implementation of YouTube and their multiple accounts.

Whoaaaa! that should not happen to non-root! if you are talking about Vanced, then you definitely need to report that as a BUG! on the Vance thread.
[Android Apps and Games] DiamondJohn:
Yeah, I could, but I could also pop by your place and do your laundry!:p

You can create a script, and add it to the dynamic run script functionality. You could use the source from the dynamic query select functionality to get you started. By the sounds, you personally would want to automate/create/use it as a boot script, and not have to run it manually.
[Android Apps and Games] DiamondJohn:
Taken from a PM.

"Safest" depends on what you are trying to protect and against what?

And by "packages" you really mean "methods" as it detaches "packages" from PlayStore using 1 of 3 methods.

Method 3 is what I use. You can read above for a better understanding of the differences and then decide for yourself which is suitable in your case.
[Android Apps and Games] DiamondJohn:
Updated the OP with the current menu and structure.

Its basically a new method in the next version.

I tried to include a copy of it here, and it was a post that was too long to be accepted by XDA as a single post :cyclops:
[Android Apps and Games] Oswald Boelcke:
Unless you know, the limit for a post is 30,000 characters but including BB code.

Please advise if you want this post to be removed from your thread.
[Android Apps and Games] DiamondJohn:
Thanks, but no need, I was attempting to post it in that last post, just to save people time from having to go to the first post; which most probably wouldn't. It would of been a duplication of whats in the OP now anyway.

PS to all: you can do a text search in the OP menu tree, for a specific item, to work out where to find it in the menu. Although the built in search function will also find it, it still takes the extra step of previewing the function to get the menu location, in case you want to remember how to get to it normally for next time.

PPS: The (*) at the end of the menu item shows that this is a menu with a dynamically built list of children, which could be multiple levels deep, with each being 1-100+ long.
[Android Apps and Games] patrickdrd:
ok but the reason I asked you is that saving localappstate.db database edits after temefi's modification of the localappstate.db file is impossible,

I've tried everything on android (I was doing that previously with titanium backup, it doesn't work anymore),

moreover I tried with mixplorer, sqllite master and my android tools, all of them succeed in modifying the record,

but all of them fail in saving the database localappstate.db!

the only working solution I've found is to send the localappstate.db file to a computer,

edit it with SQLiteDatabaseBrowser program and then upload to my mobile and overwrite it
[Android Apps and Games] DiamondJohn:
Read below, its very possible. There is a world of difference between what you (or I) dont know how to do, and what is "impossible". As soon as you believe its impossible, you will naturally stop looking for a solution (since there is none), but once you see the solution below, you just may have a face-palm moment.

[IMG="shoulder shrug"]https://github.githubassets.com/images/icons/emoji/unicode/1f937-2642.png[/IMG]

The issue is beyond the scope of TeMeFI. Its a database / SQL understanding issue, and TeMeFI is not a training tool for 1 of the over 600 methods available.

You don't "save a database".You modify &/or delete one or more records in a table (or more), then you COMMIT your change (which some devs may show as a "save" button in their apps, but its a generalisation for the user).

Now, if you go and try to modify or delete the YouTube records, then it will fail, that's what the protection is all about, and that it works so well is a testament to the technique.:good:

The solution is very simple. Just DONT TOUCH THE YOUTUBE RECORD!

So, all you need to do is add a where clause. I am guessing you are trying to set auto_update = 2, but the principal is easily translated for other requirements.

UPDATE appstate SET auto_update=2 [B][COLOR="DarkGreen"]WHERE package_name != 'com.google.android.youtube' [/COLOR][/B]AND auto_update != 2

[IMG="face_palm"]https://github.githubassets.com/images/icons/emoji/unicode/1f926-2642.png[/IMG]

Another option is to switch to Method 2, where it does not raise an error, but also is thus not as strong at detaching. You could also flip back to Method 3 after doing a normal update. Going method 1 is not so easy to flip back to method 2 or 3.

So, when is it good for you, for me to come round for your laundry?:rolleyes:
[Android Apps and Games] patrickdrd:
ok, I know how to write a sql command to do what I want since I'm a database developer myself,

the problem is that no app I tried is able to save/commit,

mixplorer said that it blocked update with error 1811,

can I run the sql within temefi?

edit: ok, it supposedly succeeds with the where clause,

but next time I open it,

the record I want to modify still has "1",

so it wasn't updated :(

edit2: ok, I've finally managed to do it with an app called sqlite editor,

I never thought it would be so difficult:(