[-Blue-]

ok, i don't know about you guys but i'm completely sick of having to mark 1 by 1 all the emails to either delete or mark as read, specially when something happens with the phone that i have to start from scratch and download over 1.5k emails on 4 accounts

is there a mod or app out there that will do it? can it be done?

thanks

[jdas]

Shouldn't be too hard...I'll get on it

Ok, this will require an SSH connection:

1) SSH into your device
2) Run the following commands:

sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update messages set flags = flags + 1 where flags&1 = 0;"
sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update mailboxes set unread_count = 0;"

3) Reboot your iPhone

This will mark all messages in the iPhone's mailbox as read.

[-Blue-]

thanks, but how do i run a command?
do i do it from the terminal or from winscp?
thanks again


ok this is what i got.. i did a copy paste from what you wrote..

/$ sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update messages set flags = flags + 1 where flags&1 = 0;"
SQL error: near "Index": syntax error
/$ sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update mailboxes set unread_count = 0;"
SQL error: near "Index": syntax error

not sure what i did wrong.. at least i figured out the commands part lol

[jdas]

Oops...run these instead

sqlite3 "/private/var/mobile/Library/Mail/Envelope Index" "update messages set flags = flags + 1 where flags&1 = 0;"
sqlite3 "/private/var/mobile/Library/Mail/Envelope Index" "update mailboxes set unread_count = 0;"

[-Blue-]

yay it worked.. thanks
now hopefully someone will turn this into a mini app or something

[bhz1]

I loved iDeleteMail on the old 1.1.x firmwares. Wish there was something similar. While its nice to have the command line workaround, having it as an app is better.

[-Blue-]

yeah, a select all or delete all would also be great.. an app that includes or adds to the mail app the options of.. read all, delete all, select all, would be great

[jjhack]

A note on the code above, you don't have to reboot or respring the phone for the counts to reset. Just kill the "MobileMail" app. The app will automatically reload, and when it does the counts will be reset.

killall MobileMail

Just be sure you are not in the middle of composing an important email!

I'm looking for ways to automate this process, it's easy to get it into a script. But getting it to an app/icon is a bit harder.

Thanks jdas for the SQL code!!

[jjhack]

Ok I have the script above made into an application. But there are a couple of caveats.

1. You have to have SSH enabled on your phone. If you disable the SSH service the app will not work.
2. The app will terminate the mail app, so if you are in the middle of composing an email it will be lost.
3. If using exchange, this will not mark the messages read on your exchange server. It will mark the messages read on the phone, but the mark will not sync back to the server.

Download the app here: markall.tar.gz

Just place the tar file in the /Applications folder and extract, then reboot or respring.

When you run the app it will show a black screen then return to the springboard. Wait about 1-2 seconds and the mail unread count will clear.

Hope this app helps, I use it all the time!

[fade]

hmm, the markall.app doesnt work for me, I SSH'd into my phone and tried untarring the file but winscp said it wasnt a valid gzip compression or something. So I untarred the file on my desktop and just copied over the markall.app to my applications folder, then set permissions to 775 and rebooted my iphone. The markall.app appears and it launches but the message count doesnt go down

edit: i made sure ssh was enabled, does this only work on POP3 accounts? because I have IMAP e-mail accounts.

edit 2: i followed this guide (http://www.modmyi.com/forums/native-...inscp-ssh.html) and set permissions back to 755 and clicked on recursive, rebooted and it worked! thanks so much!

[Blowfish64]

I followed the instructions here and it still does not work for me. When I tap the icon, the screen goes blank for a split second and the mail.app terminates, but when I respring or reboot or anything the count has not gone down. Is there any program for this that really works? I'm on 3.0.1 3GS.

[ddonuts4]

Jjhack, for a new member u know a ton. Thanks or the useful tips.

[dontworryaboutit]

Anyone got a different link to the markall.app??.....after extracting the 4kb linked file all I get is a blank folder entitled markall. Any ideas, really sick of seeing a hundreds of "unread emails" that I've already read on my comp.

Thanks

[sxsw]

The markall.app is a great idea. However, having trouble making it work with 3.1.2. The app executes, but doesn't mark mail as read. In fact, it has the opposite effect. If I manually mark a mail as read, then run the markall.app, it actually sets it back to unread. Anyone have any suggestions? Is there something different in 3.1.2 that might cause this?

[kami23]

Hi,

first of all, thanks a lot for this great small app.

But maybe someone can answer me to questions:

1. After kill MobileMail how can i restart it? Because i think the next step is always to click on the button. But it should be automated.

2. Can you tell me a method to delete all mails in MobileMail?

Thanks a lot for the help.

Cu kami23