I have 16,000 as unread, and do each one individually or in groups of 20 doesn't make sense.
You can do this operation from your DB if you have access to it.
Please do not proceed, if you don't know what you are doing.
UPDATE `emails` SET `status` = 'read' WHERE `status` = 'unread';
This sql will set read for all the mails status which has unread status.
If you want to make this operation for a specific account. You would need to run following sql after changing your mailbox_id;
UPDATE `emails` SET `status` = 'read' WHERE `status` = 'unread' AND `mailbox_id` = '<PUT_HERE_MAILBOX_ID>';
This sql will set to read all emails which has unread status. If you don't know your mailbox_id you can check your;
inbound_email or outbound_email tables. The record ids will be your mailbox_id.
Hope this helps.
Developer Support Engineer
Hi David Karohl
Take the backup of your application database first and also emails table and do a suggested by Tevfik..
or you can create a custom page in sugar there you can write the code for getting all emails which Status = unread and
update those records to reads by using Bean or SQL queries then run this file by opening the path in browser.
If in case anything goes wrong then revert back from your backup database.
Hope it helps you!!
S Ramana Raju
Retrieving data ...