Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Pro
 AfterLogic Forum : AfterLogic WebMail Pro
Subject Topic: Mail Forwarding Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
musicman
Newbie
Newbie


Joined: 06 March 2006
Location: United States
Online Status: Offline
Posts: 9
Posted: 14 April 2006 at 12:05pm | IP Logged Quote musicman
I have Webmail Pro and I am using it as a web interface to our Windows 2003 POP server. It works fine but we are seeing an issue.

When users try to send mail to a Contact Groups that they have created with more then 12 email adddresses, they receive the following error message:

Error: Negative or void server response
Server Responded: 501 5.5.4 Invalid Address
Back to Top View musicman's Profile Search for other posts by musicman
 
Alex
AfterLogic Support
AfterLogic Support
Avatar

Joined: 19 November 2003
Online Status: Offline
Posts: 2206
Posted: 14 April 2006 at 12:10pm | IP Logged Quote Alex
The entire "To:" string must be no longer than 255 characters. Seems when you put more than 12 address, this limit becomes exceeded and the address string gets truncated.

Regards,
Alex
Back to Top View Alex's Profile Search for other posts by Alex
 
musicman
Newbie
Newbie


Joined: 06 March 2006
Location: United States
Online Status: Offline
Posts: 9
Posted: 14 April 2006 at 12:17pm | IP Logged Quote musicman
Is this a limitation in WEBmail Pro only? Is this going to be addressed in the next release?
Back to Top View musicman's Profile Search for other posts by musicman
 
Alex
AfterLogic Support
AfterLogic Support
Avatar

Joined: 19 November 2003
Online Status: Offline
Posts: 2206
Posted: 14 April 2006 at 12:50pm | IP Logged Quote Alex
Yes, this is WebMail Pro limitation only. It's caused by the fact that MySQL server does not support long strings (larger than 255 characters). Seems this limitation will persist until MySQL starts supporting long strings.

Regards,
Alex
Back to Top View Alex's Profile Search for other posts by Alex
 
tardis2112
Newbie
Newbie
Avatar

Joined: 10 May 2007
Online Status: Offline
Posts: 10
Posted: 10 August 2007 at 8:22am | IP Logged Quote tardis2112
We are using Webmail Pro with MSSQL and not MySQL. Does MSSQL have this limitation? If not, can we modify MailBee to work around this?
Back to Top View tardis2112's Profile Search for other posts by tardis2112
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 11 August 2007 at 1:11am | IP Logged Quote Andrew
MSSQL supports strings length up to 8000 chars. It's possible to modify WebMail Pro source code to increase this limit for MSSQL.

You're free to modify WebMail Pro source code (if you need us to turn you to right direction, please let us know), but if you have a customized version of WebMail Pro, you won't be able to take an advantage of regular updates because they don't contain your custom modifications and applying them will override the modifications.

Best regards,
Andrew
Back to Top View Andrew's Profile Search for other posts by Andrew
 
tardis2112
Newbie
Newbie
Avatar

Joined: 10 May 2007
Online Status: Offline
Posts: 10
Posted: 13 August 2007 at 7:01am | IP Logged Quote tardis2112
That is great news! We have already customized MailBee extensively, so modifying the source is no problem. I could use a clue as to which functions on what pages I should look at to make the change though. Kind of a needle in the haystack. Thanks!
Back to Top View tardis2112's Profile Search for other posts by tardis2112
 
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 13 August 2007 at 10:43am | IP Logged Quote Aerobee
Actually, MySQL does indeed support more than 255 chars, it all depends of the field type.

If you set the field type as a varchar then it will allow a maximum of 255 chars.
But if you change the field type to longtext it will support a lot more

No offense to you Andrew.
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 
Alex
AfterLogic Support
AfterLogic Support
Avatar

Joined: 19 November 2003
Online Status: Offline
Posts: 2206
Posted: 13 August 2007 at 10:53am | IP Logged Quote Alex
We're aware of longtext but it's not a string type. We're using types like longtext for storing bodies but longtext won't work for fields which are used for sorting and for some other actions.

Regards,
Alex
Back to Top View Alex's Profile Search for other posts by Alex
 
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 13 August 2007 at 11:07am | IP Logged Quote Aerobee
Ok, that makes me a bit confused Alex. But firstly, i am not doubting your skills.

I have been using the field type longtext for storing various text strings and have successfully sorted the output. I am aware that longtext is not a string type, but you can still sort the output.

Or maybe i misunderstood you?
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 14 August 2007 at 2:08am | IP Logged Quote Andrew
We don't use longtext in WebMail Pro because it's necessary to keep a compatibility between all supported database engines: MS SQL, MySQL and MS Access.

Also, although MS SQL Server and MySQL provide a lot of useful features, we're not able to use some of them because of MS Access limitations (it's hard to support three versions of the same source code for each database individually).


Anyway, you may resolve the issue described above as follows (assuming you use MS SQL server):

1. Increase the size of the following fields in the database to 8000 chars:
wm_messages.str_to
wm_messages.str_cc
wm_messages.str_bcc

2. Make the following modifications in WebMail Pro source code:

File functions_new.inc.asp, function PrintAddMessageForm(), inputs "toemail", "toCC", "toBCC", replace their maxlength="254" attribute with maxlength="8000"

File functions_new.inc.asp, function MakeUpload():

Code:
toemail = DataEncode(CollElements("toemail"),500)
toCC = DataEncode(CollElements("toCC"),500)
toBCC = DataEncode(CollElements("toBCC"),500)


replace with:

Code:
toemail = DataEncode(CollElements("toemail"),8000)
toCC = DataEncode(CollElements("toCC"),8000)
toBCC = DataEncode(CollElements("toBCC"),8000)




Best regards,
Andrew
Back to Top View Andrew's Profile Search for other posts by Andrew
 
tardis2112
Newbie
Newbie
Avatar

Joined: 10 May 2007
Online Status: Offline
Posts: 10
Posted: 14 August 2007 at 7:51am | IP Logged Quote tardis2112
Awesome! Thanks for the fix Andrew. I have made the changes you indicated. One other thing I found though is that if you save the message as a draft, when you open it back up, it is cutting the addresses off again. Is there somewhere else I should make a change?
Back to Top View tardis2112's Profile Search for other posts by tardis2112
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 15 August 2007 at 2:30am | IP Logged Quote Andrew
The additional changes are:

functions_new.inc.asp file, function SaveMsgToFolderNew():

Code:
.Fields("str_to") = Left(strTo, 255)
.Fields("str_cc") = Left(strCCval, 255)
.Fields("str_bcc") = Left(strBCCval, 255)


replace with:

Code:
.Fields("str_to") = Left(strTo, 8000)
.Fields("str_cc") = Left(strCCval, 8000)
.Fields("str_bcc") = Left(strBCCval, 8000)




Best regards,
Andrew
Back to Top View Andrew's Profile Search for other posts by Andrew
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide