Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Pro
 AfterLogic Forum : AfterLogic WebMail Pro
Subject Topic: Webmail version 3.4 ASP Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 28 September 2007 at 10:51am | IP Logged Quote Aerobee
I have noticed there is a limit in the CC field when i reply to all, if there is more than 5-6 email addresses.

Is it correct that you have put in a limit, like max 255 chars in the CC field and possibly other email address fields?
We have around 35 email addresses setup on our server and we need to be able to send out a message to all employees at the same time.

We run on a windows server 2003 and our server limit on recipients is 100 simultaneously, please advise.

How can we fix this problem asap?
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 28 September 2007 at 11:04am | IP Logged Quote Aerobee
If all i have to do is edit the code, eg a maxlength from 255 to 1000 just point me in the direction of the file :) thanks.. Oh and a line number would be good ;)
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 28 September 2007 at 11:35am | IP Logged Quote Aerobee
Is it correct that it is in the functions_new.inc.asp file on line 71,79,87 and 96 where i have to modify the maxlength="254" to something higher.

Would that solve my problem, or is it deeper than that?

I really need to get that problem solved asap as they are breathing down my neck
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 28 September 2007 at 11:40am | IP Logged Quote Aerobee
Aha, i see the problem. You have put that maxlength in there because you use the field type of VarChar(255) in the database to store the CC, BCC etc addresses.

Hmm, cant i just change those field types to longtext and remove the maxlength parameter in the code?

Allright allright, i'll stop posting replys and will wait for an answer
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: 28 September 2007 at 11:57am | IP Logged Quote Alex
255 chars limitation is for MSAccess/MySQL. If your database is MS SQL Server, you may change the code and modify the SQL tables definitions accordingly.

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: 28 September 2007 at 12:04pm | IP Logged Quote Aerobee
I run on a MySQL database...
What would happen if i modify the code anyway and the SQL tables to longtext?

Is it not possible to be able to send to more that 5-6 email addresses when using a MySQL database - there must be some kind of a workaround
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: 28 September 2007 at 12:48pm | IP Logged Quote Alex
Quote:
I run on a MySQL database...
What would happen if i modify the code anyway and the SQL tables to longtext?

That's not a quick question but I don't think it will still work correctly.
Quote:
there must be some kind of a workaround

Well, as a quick workaround, if you increase the fields length in HTML, I think you will be able to send emails to more recipients but everything in To/CC/BCC after 255 chars will be truncated in database. Thus, the mail will be sent to via SMTP to all recipients but its copy in Sent Items will retain only the first 255 characters.

Regards,
Alex
Back to Top View Alex's Profile Search for other posts by Alex
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 29 September 2007 at 1:32am | IP Logged Quote Andrew
Actually, MySQL before v5.0.3 supports 0...255 varchar, but 0...65535 in 5.0.3 and later versions. So, if you use MySQL 5.0.3+, you can easily increase maximum field length.

With regard to text/longtext type, there are some differences from varchar type which may cause some problems. You can learn about the differences from MySQL 4.1 documentation or MySQL 5 documentation.


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


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 29 September 2007 at 1:41am | IP Logged Quote Aerobee
If i just increase the field length in the code, as i did, the script will not carry all the CC addresses to the field, only the first 255 chars, but i am able to manually add the rest.

So the field length is indeed increased, but when i press reply to all the script will not carry all the addresses to the CC field. Maybe because it gets the addresses from the db where it allready have been truncated by the db to 255 chars?.

What makes me wonder is that i can see all 35 email addresses wich the email was originaly sent to (not through webmail) but it wont carry all those addresses to the CC field on a reply even though i have increased the maxlength of the form.
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 29 September 2007 at 1:44am | IP Logged Quote Aerobee
aha.. that sounds good.. now i just have to find out how to find the version number of my mysql db.
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 29 September 2007 at 1:49am | IP Logged Quote Aerobee
MySQL version 5.0.18
Should work then, right
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 29 September 2007 at 1:51am | IP Logged Quote Aerobee
Client version 5.0.4

Wich one is it guys? lost here

And, wich fields in wich tables should i increase the maxlenngth
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 
Aerobee
Newbie
Newbie


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 29 September 2007 at 1:57am | IP Logged Quote Aerobee
I was able to up the field length to 64000 chars in the str_cc field in the wm_messages table - so it should work, allthough i am using an ext app for managing MySQL called SQLFront, but if that would let me do it, it surely must work yea.

So, can you please assist me in finding all the fields in the db where i have to up the char length, thanks guys
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: 29 September 2007 at 2:20am | IP Logged Quote Andrew
We've sent you the appropriate instructions via e-mail.

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


Joined: 13 August 2007
Location: Denmark
Online Status: Offline
Posts: 28
Posted: 29 September 2007 at 2:25am | IP Logged Quote Aerobee
thanks alot andrew
Back to Top View Aerobee's Profile Search for other posts by Aerobee
 

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