View Single Post
  #4 (permalink)  
Old 09-16-2008, 07:53 AM
gjpyne gjpyne is offline
New Member
 
Posts: 3
Default Refine the update to avoid unintended DB changes...

Quote:
Originally Posted by mmorse View Post
That appears to be 2 folders named Warnings.


Post us the output from that - or if you know what you're doing you might proceed to:

5) Change one of the duplicate folder names
update mail_item set name="<new name>", subject="<new name>" where id=<id number>;
...
I would recommend that you
select * mail_item where id=<id number>;
choose the offending mail item... and refine your selection to show only the item you want to change..

I did this by adding the mailbox_id... in my case this resulted in a single row
select * mail_item where id=<id number> and mailbox_id=<mailbox id>;

This resulted in a single row..
Then it was safe to update..

update mail_item set name="new folder name", subject="new folder name" where id=<id number> and mailbox_id=<mailbox id>;
__________________
Jerry
Reply With Quote