[Nook Color Android Development] Anemailname:
To block OTA updates, I used SQLite Editor with the instructions below from "Mark"

I can't find this post anywhere and have no idea where I got it, if you are Mark..THANK YOU! and post a link to the original so we can find you! <G>:D

Worked perfectly for me. I've attached the text file so you can save it instead of trying to read the forum, it takes a bit but not as much time as you'd think.

The $3 is well worth it!

:::This is a one-time thing, and doesn't require revising it as new updates come out, as some other methods do (e.g., pushing modified build.props files down). Those are completely free, but a fair bit more complicated, and have to be redone every time a new update is released by B&N.

1) Go to Extras, open the Android Market, tap on the magnifying glass, and search for SQLite Editor. It will cost you <$3.

You don't need the companion product, Root Explorer, at all, that others have mentioned, so you can save some $$$ if you want (4 bucks, I think). It's actually quicker not to even use Root Explorer.

2) Buy and install SQLite. If you're running auto-nootered, you'll need to shut your Nook off and restart it afterwards. That's because the Extras screen info is cached, and not updated dynamically, so you'll never see any newly loaded Apps until you reboot.

3) After powering back up, go to Extras and click on SQLite. It will scan your entire Nook and find every SQL database file there. Even the hidden ones. It only takes ~10 seconds.

4) Scroll down to DeviceManagerService, and tap on it. Then tap on devicemanager.db.

5) Tap on the "registry" entry. It's easier now if you rotate to landscape, so you can see more of the fields in each entry.

6) All the entries in this table start with "com.bn.device....". Look for the one that's labeled '...fota.mode" at the end.

7) In the far right Value column, you'll see "Auto". Tap on that to select it. Then go down to the Status Bar at the bottom, and tap the Menu button (3 horizontal lines), and pick Edit Field.

8) You'll then see a black screen with one entry, the field editing form. You should see the field name of "value" there, and its contents will be "auto". If it turned out that your selection picked some other field (they are pretty small!), don't panic! :smileywink: Just go back and retry until you get the right one.

9) Tap on "auto" and the keyboard will come up. Backspace to delete the current contents, and enter "manual" in its place. Then tap Done. Then tap Save. Until you tap Save, you've changed nothing, so poking about is fairly safe. You may see a message about granting super-user permissions, which is normal.

10) You can now exit out of SQLite if you like (it's not necessary), but you're not quite done yet, so don't enable WiFi immediately. To make sure that the system is using the settings you just modified, you need to force it to reload and "see" them. So just power you Nook off and back on. After it reboots, it will use your new settings from then on. That's it.

Walla! You're all set. Auto-updates will no longer be pushed down to your Nook. However, updates you manually sideload wll still work. If you decide at some point you'd like auto-updating to work again, just go back in and re-enable it by changing "manual" to "auto".

~~

While the length and detail of the instructions above may make this look like it's more complicated than it really is, I'd rather err of the side of accuracy than leave something "obvious" out. It really doesn't take more than 2 minutes to do, and most could probably figure it out on their own, if they really needed to. The one thing they might overlook is the need to reboot afterwards, which isn't necessarily obvious.

- Mark