This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
reference:reset_message_folder_counts [2014/11/19 12:54] – paul | reference:reset_message_folder_counts [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 12: | Line 12: | ||
Then, type | Then, type | ||
- | with ff as (select folderid, | + | with ff as (select folderid, |
sum(case when newflag then 1 else 0 end) as newcnt, | sum(case when newflag then 1 else 0 end) as newcnt, | ||
- | | + | |
- | sum(case when hold then 1 else 0 end) as holdcnt from | + | sum(case when hold then 1 else 0 end) as holdcnt from messages.folders left join |
- | messages.foldermessages inner join messages.msgdata using(msgdataid) where deletedtime is null group by folderid) | + | |
- | update messages.folders f set msgcount=ff.cnt, | + | |
- | | + | update messages.folders f set msgcount=ff.cnt, |
+ | | ||
| | ||
(Copy and paste if possible!) | (Copy and paste if possible!) | ||
+ | |||
+ | N.B. VPOP3 **does** need to be stopped while you do this |