hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

[made_my_day]

Hi, my errorlog attached...
you have any input for me?

2 imap Folders can't be deletetd or synchronised
not in Outlook, not in hms-admin-console
MY ideas hav' gone out

Greetings

"ERROR" 3764 "2014-07-31 01:02:03.410" "Severity: 2 (High), Code: HM4207, Source: MySQLRecordset::GetInt64Value, Description: An unknown error occurred while reading value from recordset: messageid"
"ERROR" 3764 "2014-07-31 01:02:03.442" "Severity: 3 (Medium), Code: HM5136, Source: TCPConnection::HandleRead, Description: An error occured while parsing data. Data length: 38, Data: jgbo DELETE "INBOX.12_folder1". Remote IP: xxx.xxx.xxx.xxx"
"ERROR" 2160 "2014-07-31 05:16:50.802" "Severity: 2 (High), Code: HM4207, Source: MySQLRecordset::GetInt64Value, Description: An unknown error occurred while reading value from recordset: messageid"
"ERROR" 2160 "2014-07-31 05:16:50.802" "Severity: 3 (Medium), Code: HM5136, Source: TCPConnection::HandleRead, Description: An error occured while parsing data. Data length: 47, Data: vzlx STATUS "INBOX.11_folder2" (UNSEEN). Remote IP: xxx.xxx.xxx.xxx"
"ERROR" 4032 "2014-07-31 09:02:05.020" "Severity: 2 (High), Code: HM4207, Source: MySQLRecordset::GetInt64Value, Description: An unknown error occurred while reading value from recordset: messageid"
"ERROR" 4032 "2014-07-31 09:02:05.020" "Severity: 3 (Medium), Code: HM5136, Source: TCPConnection::HandleRead, Description: An error occured while parsing data. Data length: 38, Data: i06h DELETE "INBOX.12_folder1". Remote IP: xxx.xxx.xxx.xxx"

[mattg]

Is each IMAP folder set as a sub folder of each other??

Check the database...

[^DooM^]

Also while you are in there run a repair on the DB

https://www.hmailserver.com/documentati ... pair_mysql

[made_my_day]

oh, i don't explained Location...

These folders located in "deleted items" and both are subfolders from deleted items...
i can rename and they are still in the "imap Folder query"... but i can't delete them...

everythime outlook want to synchro the Folders it began to hang ...(i've unchecked temporary synchro on deleted items)

how to check database? no expirience with mysql :/

greetings

[^DooM^]

Read the docs i linked above, shows how to access DB

[percepts]

go into hmail admin and go to the account these folders are in. Then in the advanced tab you can edit folders and either delete the ones you want by right clicking on folder in left column or emptying the folder.

[^DooM^]

go into hmail admin and go to the account these folders are in. Then in the advanced tab you can edit folders and either delete the ones you want by right clicking on folder in left column or emptying the folder.

He tried, that, it didn't work :/

2 imap Folders can't be deletetd or synchronised
not in Outlook, not in hms-admin-console

[percepts]

Note to self: Must pay attention

[^DooM^]

Tis cool, I do it all the time

[made_my_day]

Hi & thanks for help...
i did a "REPAIR TABLE hm_imapfolders" query with SQLyog

but i got the message --> The storage engine for the table doesn't Support repair - 55B

any ideas?!

it is
1) Folderid 26 / folderissubscribed = 0
2) Folderid 29 / folderissubscribed = 1

[made_my_day]

edit:

when i go to table hm_messages and set a filter on MessageFolderid=26 (i thin it's the same as hm_imapfolders folderid=26)
then i got a lot of Messages which are not shown in Outlook... maybe that's my Problem?

[mattg]

is folder 26 selected as a subscribed folder in outlook

(If you don't know please post version of Outlook)

[made_my_day]

it is equal
i can subscribe or not subscribe... the "folderissubscribed" item works in SQL... the Folders are shown in Outlook when i subscribe and don't shown when i don't subscribe...

both Folders are unsubscribed now and the folderissubscribed item Shows "0"
i think there is a Problem inside the Folders... can it be?

Outlook 2010 and 2013 - same Problem

[mattg]

so, the issue is that you can't remove these folders, or synchronise them, but you can 'subscribe to them' or 'unsubscribe to them', is that correct?

Does Outlook keep offline copies of these folders?
Outlook is notoriously bad at IMAP, especially Outlook 2013.

Does say, Thunderbird allow you to remove these folders, or to synch them?

[made_my_day]

so, the issue is that you can't remove these folders, or synchronise them, but you can 'subscribe to them' or 'unsubscribe to them', is that correct?

--> YES that is correct

Does Outlook keep offline copies of these folders?
Outlook is notoriously bad at IMAP, especially Outlook 2013.

maybe there offline Folders at some Clients... but it's no Problem, all Mails are saved from this Folders...
if the solution should be a "hard delete" @ database then it must be (but how without crashing DB)

Does say, Thunderbird allow you to remove these folders, or to synch them?

Thunderbird having same Problems such Outlook

[percepts]

can you confirm that the folder names you see in outlook are the same as you see in hmailadmin when you look at the account advanced tab edit folders list.

e.g is the foldername called "Trash" in hmail but deleted "items in outlook" or are they both the same name

OR

is the foldername case identical in both setups

[made_my_day]

the Folder names are identically and i can Change them without probs

[mattg]

Are these public folders?

[made_my_day]

no, the Folders created @ inbox 6 months ago...
everything works fine... but some day Outlook starts to make imap Connections without closing them...
and the users starting to hard kill Outlook... in meaning of that i think there is something corrupt at these 2 Folders...
synchronise @this 2 Folders take a long time and never ends - so we want do delete these folders completly

edit:
i found this one @ error logs
"ERROR" 3808 "2014-07-28 17:32:58.140" "Severity: 2 (High), Code: HM4208, Source: IOCPQueueWorkerTask::DoWork, Description: An unknown error occured while handling asynchronous requests."

[mattg]

Then just kill the database entries for them, and then run Data Directory Synchroniser, to put any mail in them back into the inbox.

Restart your hMailserver after you drop those entries, and DDS may take a LONG TIME depending on number of messages etc

[percepts]

OR

how many emails/data do you have in the account ?

I'm thinking you could create another account with same folder structure, drag and drop the mail from old to new account except the two folders causing the problem.
Then delete the old acount
Then rename the new account to the old account name.

[made_my_day]

Then just kill the database entries for them, and then run Data Directory Synchroniser, to put any mail in them back into the inbox.

Restart your hMailserver after you drop those entries, and DDS may take a LONG TIME depending on number of messages etc

The entries in SQL - tables - hm_imapfolders
--> Folder id 26 & 29?
just "klick" and trash?

[mattg]

That's what I'm thinking.

Backup first just in case, also a good idea to copy your data directory somewhere else as well...