#Public and SQL cash

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
mns17
Normal user
Normal user
Posts: 124
Joined: 2008-06-18 11:13

#Public and SQL cash

Post by mns17 » 2011-11-09 11:00

Hi, All

HM 5.3.X - 5.4.LastBuild

Sometimes in #Public.<SubFolder> i get count of message in MS Outlook (2007 or 2010) or RounCube web-mail <> count of message in SQL

Code: Select all

"IMAPD"	8796	357	"2011-11-09 15:29:04.790"	"192.168.1.111"	"RECEIVED: xbe9 SELECT "#Public.Info""
"IMAPD"	8796	357	"2011-11-09 15:29:04.803"	"192.168.1.111"	"SENT: * 4608 EXISTS[nl]* 0 RECENT[nl]* FLAGS (\Deleted \Seen \Draft \Answered \Flagged)[nl]* OK [UIDVALIDITY 1320787159][nl]* OK [UIDNEXT 4640][nl]* OK [PERMANENTFLAGS (\Deleted \Seen \Draft \Answered \Flagged)][nl]xbe9 OK [READ-WRITE] SELECT completed"
"IMAPD"	10124	357	"2011-11-09 15:29:04.809"	"192.168.1.111"	"RECEIVED: wck8 FETCH 4608 (UID)"
"IMAPD"	10124	357	"2011-11-09 15:29:04.809"	"192.168.1.111"	"SENT: * 4608 FETCH (UID 121384)"
"IMAPD"	10124	357	"2011-11-09 15:29:04.809"	"192.168.1.111"	"SENT: wck8 OK FETCH completed"
Count = 4608

BUT

Code: Select all

SELECT  *
  FROM [hmail].[dbo].[hm_messages]
  Where messagefolderid = 4736
Count = 4716

If i restart HM-service, then count of message in MS Outlook (2007 or 2010) or RounCube web-mail = count of message in SQL
BUT then again count of message in MS Outlook (2007 or 2010) or RounCube web-mail <> count of message in SQL

Type BD = MS SQL 2008 R2

Can HM to have the SQL cash?

Post Reply