| Author |
|
Pingu
Newbie
Joined: 17 December 2015
Location: Germany
Online Status: Offline
Posts: 2
|
| Posted: 17 December 2015 at 1:16pm | IP Logged
|
|
|
Dear Ladies and Gentlemen,
thank you for WebMail Lite. I've it up and running using Windows 2008 R2 IIS and PHP 7.0 with MariaDB. Unfortunately it works only with Mailboxes if they don't have too much Folders. Otherwise I get the following error message:
[16:51:19.77][c3d0e16a] DB ERROR < 22001
1406
Data too long for column 'folders_order' at row 1 [22001]
[16:51:19.79][c3d0e16a] Previous Exception: 22001
1406
Data too long for column 'folders_order' at row 1 [22001]
Is there anything I can do to correct this Problem (Change some Memory Settings?) - Or is Webmail not suitable for mailboxes with so many Folders?
With my best regards
Rob
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6038
|
| Posted: 18 December 2015 at 2:06am | IP Logged
|
|
|
Looks like the list of folders was too big to fit in 64K text field, try changing the field type with the following MySQL query:
Code:
| ALTER TABLE `awm_folders_order` CHANGE COLUMN `folders_order` `folders_order` MEDIUMTEXT NULL DEFAULT NULL; |
|
|
Hope this helps!
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
Pingu
Newbie
Joined: 17 December 2015
Location: Germany
Online Status: Offline
Posts: 2
|
| Posted: 21 December 2015 at 10:19am | IP Logged
|
|
|
Thank you for your quick reply and sorry for my slow answer.
After executing your command I can see all folders. But: During loading the folders internet explorer as well as firefox reporting a hangig (stalling) script which keeps the computer busy. If I try to access folders deep in the tree, they are reported as empty folders. Shared folders (which are below #users at our systemstart) are not shown at all.
With my best regards
Rob
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6038
|
| Posted: 21 December 2015 at 12:52pm | IP Logged
|
|
|
Unfortunately, I don't think there's a solution. WebMail would indeed have problem with large number of mail folders (several hundreds and more). We keep on optimizing the behavior related to handling folders, but there's still a limit of number of mail folders WebMail can deal with.
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: Data too long for column
Privacy policy |
Refund policy