Hi,I installed osTicket support recently and I have found this weird problem.I changed the logwatch destination mail to be in the osTicket mail, but it seems that osTicket can not show (or fetch) the whole mail and the half of the email from logwatch@domain is truncated. How can I fix this ?
Out of curiosity how big are these logwatch emails? Can you forward a copy of one of the logwatch emails to jared (the dev here on the forums)? (I'm sure that he will ask for one). I'll bring this thread to the attention of the devs
Hey,Roundcube says that the email is 110kb+. Some are 110 and some 130, but I guess it can be large, because of the settings of logwatch, depending on how much detailed is.
I think that I may have found the problem.In my database the ost_ticket_thread table body column is set to datatype TEXT.If yours is the same then I think that your exceeding the storage capacity of that datatype. I googled "mysql datatype text max length" and according to:http://stackoverflow.com/questions/6766781/maximum-length-for-mysql-type-textandhttp://www.electrictoolbox.com/maximum-length-mysql-text-field-types/The maximum size of the TEXT data type is 64kb. You could try changing the datatype to MEDIUMTEXT. (Please please please back up your database before you do!)
Hi,I have changed the "body" colon to be MEDIUMTEXT. Tomorrow I will update whether this solves the problem.
Excellent, I look forward to your reply. :)
Hi,unfortunately changing type of the data didnt solve the problem.
Is it the same length as you were getting before? (ie are they still truncating in about the same place)This is a new ticket created after you changed the db table column?I've asked the devs to take a look at this thread.
Hi,I will copy and paste 2 of these mails into .txt file and will check the size. I will post the result later today.
Hi, Sorry about the delay. This is the result from copy&paste the text to notepad (maybe there is some difference between the original message and text file) :C:\Users\Dean\Desktop>dir *.txt Volume in drive C has no label. Volume Serial Number is 1C91-D46A Directory of C:\Users\Dean\Desktop10.01.2014 г. 19 58 869 1.txt10.01.2014 г. 19 57 756 2.txt
I guess the problem is somewhere in the datatypes. These 2 text files are from different logwatch reports (first is from 5th jan, second from 9th), but the size is almost equal (visible part of the ticket).
And you are sure that you modified the table and column that I specified?I ask because I tested this. I changed the data type in my own database then I grabbed the contents of a log from my server 198 KB (203,589 bytes) according to Windows and opened a ticket via the web interface and the ticket opened fine. I then sent an email to my ticket system and pasted the 199k of text into the email, and the ticket opened fine (it actually ended up being longer than that since it also put my signature into the ticket when I emailed it).
Hm, it is very strange... now I can see the whole message... But it didn't work in the morning.This issue is now resolved. Thank you.
Very welcome. I'm going to close this thread. Please feel free to post if you run into any more issues.
