Page 1 of 1

hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-11 13:35
by 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"

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-11 15:51
by mattg
Is each IMAP folder set as a sub folder of each other??

Check the database...

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-11 16:31
by ^DooM^
Also while you are in there run a repair on the DB

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

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-11 16:35
by 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

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-11 16:37
by ^DooM^
Read the docs i linked above, shows how to access DB

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-11 18:10
by 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.

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 00:14
by ^DooM^
percepts wrote: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 :/
made_my_day wrote:2 imap Folders can't be deletetd or synchronised
not in Outlook, not in hms-admin-console

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 00:18
by percepts
Note to self: Must pay attention :oops:

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 00:24
by ^DooM^
Tis cool, I do it all the time :D

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 11:34
by 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

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 12:13
by 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?

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 12:38
by mattg
is folder 26 selected as a subscribed folder in outlook

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

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 13:13
by 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

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 13:33
by 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?

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 14:00
by made_my_day
mattg wrote: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
mattg wrote: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)
mattg wrote:Does say, Thunderbird allow you to remove these folders, or to synch them?
Thunderbird having same Problems such Outlook :(

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 14:33
by 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

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 14:57
by made_my_day
the Folder names are identically and i can Change them without probs

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 16:06
by mattg
Are these public folders?

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 17:07
by 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."

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 17:24
by 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

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 17:24
by 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.

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 17:30
by made_my_day
mattg wrote: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?

Re: hmailserver 5.4.2-B1964, MYSQL Error Logs HM4207, HM5136

Posted: 2014-08-12 17:31
by 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...