search

afterlogic / webmail-lite-8

Open-source webmail script for existing IMAP server
https://afterlogic.org/webmail-lite-8
GNU Affero General Public License v3.0
335 stars 72 forks source link

Signature image being cut off at the bottom. #52

Closed xpufx closed 4 years ago

xpufx commented 5 years ago

This is actually two issues in one. When we add a banner image at the bottom of the signature, the gui text edit box initially displays it properly. Howevever when you refresh the browser and come to the signature page again, the banner is not displayed anymore. However it must still be there because the outgoing emails do have the banner. The problem there is the bottom portion of the banner is cut off and missing. When I open the image by itself in a browser it's still cut off so it's not a display issue but the image is actually being served that way. Any ideas? (I upgraded to the latest version to see if it would fix the issue but it didn't).

afterlogic-support commented 5 years ago

Does that happen with an image of any size (meaning bytes, not pixels here)? If you try with an image of 15-20Kb size, for example, do you encounter the same problem?

xpufx commented 5 years ago

Will check and report back. Thanks.

On Wed, Nov 6, 2019 at 2:51 PM AfterLogic Support notifications@github.com wrote:

Does that happen with an image of any size (meaning bytes, not pixels here)? If you try with an image of 15-20Kb size, for example, do you encounter the same problem?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/afterlogic/webmail-lite-8/issues/52?email_source=notifications&email_token=AGDFTCPH2IXXHLMTKW6G2S3QSKVSLA5CNFSM4JJTYLDKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEDGIWYI#issuecomment-550275937, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGDFTCITCRQP75GJ57Y5X7DQSKVSLANCNFSM4JJTYLDA .

xpufx commented 5 years ago

The issue is same regardless of file size as far as we can tell.

afterlogic-support commented 5 years ago

To let us help you on this, please open a ticket in our HelpDesk and provide a test account the issue can be reproduced with (i.e. the signature already contains a problematic image). Thanks.

afterlogic-support commented 4 years ago

No, that doesn't look critical. By the way, it looks like you're running quite an outdated version 8.2.3 released over a year ago. Make sure to switch to the latest version and see if the issue is reproduced there.

xpufx commented 4 years ago

Hi. I actually just deleted my comment before reading yours. I noticed the same thing about the release version. It looks like I wasn't able to complete my last update and the config symlink is still pointing to the old version. I will upgrade to the latest version properly then test again. I am closing this until I do that and have a chance to check. Thanks.

bzenky commented 4 years ago

Hello there, I´m having the first part of the problem explained above, I upload a image in the signature section, at first it works, but when logout and login again, the signature disapears. I have the 8.5.2 version.

afterlogic-support commented 4 years ago

Try clearing browser cache and see if the signature shows correctly after logging into WebMail again.

Does it help?

bzenky commented 4 years ago

No, the problem continues, and in the signature, it disapears.

afterlogic-support commented 4 years ago

Understood, we'll need a test account the issue can be reproduced with, and adminpanel credentials. Please send the details via HelpDesk. Thank you.

afterlogic-support commented 4 years ago

Upon the investigation, developers confirmed that the problem is caused by exceeding 64Kb limit in database text fields. Images in signature are presented in base64 encoding, signature is stored in database, so if the image is too big MySQL cuts it. You can change "value" field type in "au_eav_attributes_text" table from TEXT to LONGTEXT, then the image will be kept in signature:

ALTER TABLE `au_eav_attributes_text` CHANGE `value` `value` MEDIUMTEXT;
xpufx commented 4 years ago

Will this be in the next release?

afterlogic-support commented 4 years ago

Can't tell at the moment, but the developers will consider including such a change in the future releases.

bzenky commented 4 years ago

Upon the investigation, developers confirmed that the problem is caused by exceeding 64Kb limit in database text fields. Images in signature are presented in base64 encoding, signature is stored in database, so if the image is too big MySQL cuts it. You can change "value" field type in "au_eav_attributes_text" table from TEXT to LONGTEXT, then the image will be kept in signature:

ALTER TABLE `au_eav_attributes_text` CHANGE `value` `value` MEDIUMTEXT;

Thanks!