Free Attachments for Ticket Notes (Free modification)

[Siora]

Thats great. Your professional documentation and prompt response is amazing. Keep it up and you will have customers lining up.

[Matthew]

Originally Posted by Siora

Thats great. Your professional documentation and prompt response is amazing. Keep it up and you will have customers lining up.

I feel the same way. In addition to the well-done documentation, the code itself is nicely framed in the source files. This makes installation so much easier for people like me who do a lot of modding.

I installed the Attachments mod without a hitch. I imagine this will be quite useful for our divisions who maintain a single point of contact for external clients and would like to keep client company profiles and project outlines in one place.

[Dewak]

Thanks you guys for the good comments! We will keep working hard to innovate on Kayako mods and exceed your expectations!

[Dewak]

Dozens of clients are currently using this awesome modification, if you are interested don't hesitate to contact me anytime.

We are soon releasing new mods for Kayako! I'll keep you updated

[Dewak]

A kind salute to the Kayako community.

I just wanted to let everybody know that now that the latest stable version (3.30.01) was released, our team will update all free and paid modifications. Once all the modifications are tested for the latest version I will post here to keep you updated.

Best Regards

[nolnet]

I'm interested in some of these guys services but my emails have gone unanswered. Are they still doing business?

[Dewak]

Hi nolnet, of course we are still doing business. Unfortunately we haven't received any email from you yet. Please check your email messages and confirm that you are sending the to andres[at]dewak.com

[nolnet]

Excellent glad to hear it!

I sent my email yesterday to info@dewak.com

[nolnet]

All is well, thank you for responding.

[Dewak]

Hello everyone. The Attachments for Ticket Notes modification is now available for Kayako SupportSuite/eSupport ver 3.30.02.

If you are interested in having this modification please send us an email to info[at]dewak.com and specify the version number of your current Kayako installation. Our Marketing and Sales team will send you, free of charge, a zip file with the source code and an installation instructions document.

[jenglish]

Thanks for the easy-to-install mod! It works great for small files, but is there an upper size limit to what can be loaded? Anything over 1 MB (maybe smaller) gives me a SQL error.

Invalid SQL: INSERT INTO `swnotesfiles` (typeid, ticketnoteid, name, content, type, size) VALUES ('128539','999','Rose garden brochure- Rose Festival 06-OK.pub','ÐÏࡱá\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0>\0\0þÿ \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0þÿÿÿ\0\0\0\0\0\0\0\0e\0\0\0›\0\0\0œ\0\0\0�\0\0\0ž\0\0\0Ÿ\0\0\0 \0\0\0¡\0\0\0¢\0\0\0£\0\0\0¤\0\0\0¥\0\0\0¦\0\0\0§\0\0\0¨\0\0\0©\0\0\0ª\0\0\0«\0\0\0¬\0\0\0*\0\0\0®\0\0\0¯\0\0\0°\0\0\0±\0\0\0²\0\0\0× \0\0Ø \0
**LOTS MORE CHARACTERS HERE **
\0\0\0\0\0\0\0\0','application/vnd.ms-publisher','1825280'); (MySQL server has gone away)
Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\kayakotest\includes\functions.php:410) in C:\Inetpub\kayakotest\includes\functions_html.php on line 1373
Invalid SQL: UPDATE LOW_PRIORITY `swstaff` SET `lastactivity` = '1224558433' WHERE `staffid` = '4'; (MySQL server has gone away)Invalid SQL: INSERT INTO `swticketnotes` (`typeid`, `notetype`, `forstaffid`, `bystaffid`, `dateline`, `notes`) VALUES ('128539', '1', '0', '4', '1224558433', 'test'); (MySQL server has gone away)Invalid SQL: UPDATE `swtickets` SET `hasnotes` = '1',`lastactivity` = '1224558433' WHERE `ticketid` = '128539'; (MySQL server has gone away)Invalid SQL: INSERT INTO `swauditlogs` (`ticketid`, `staffid`, `departmentid`, `userid`, `dateline`, `logtype`, `actiontype`, `actionmsg`) VALUES ('128539', '4', '1', '990', '1224558433', '1', '1','Ticket note added by: Jeremy English'); (MySQL server has gone away)Invalid SQL: SELECT * FROM `swalertactions` AS alertactions LEFT JOIN `swalertrules` AS alertrules ON (alertactions.alertruleid = alertrules.alertruleid) WHERE alertactions.actiontype IN ('5'); (MySQL server has gone away)

[Dewak]

Hi Jenglish.

Thanks for your kind comments. The modification has no upload size restriction, this looks like a problem from your MySQL configuration. If you see the log looks like the database server fails "MySQL server has gone away"

I recommend you to check with your MySQL configuration.

[jenglish]

Solved! MySQL max allowed packet value defaults to 1MB.

Just in case anyone else has this problem:

The MySQL server's default max_allowed_packet value is 1MB. You can increase this if the server needs to handle big queries (for example, if you are working with big BLOB columns).

[Dewak]

Thanks for the tip jenglish, to avoid this kind of problem we recommend to store attachments in the Filesystem rather than in the database. (See Admin CP settings)

Best!

[jenglish]

This problem had never occurred before for me because we store our attachments in the file system. Can your modification for attachments on notes perform the same way? It is currently using BLOBS on my system (not desirable).

Thank you for the prompt attention.