Attachments are corrupted

[roseserveradmin+phpbms@…]

I am able to attach files to sales orders and things, but when I download them, they are corrupted. I've used various types of files (jpg, png, pdf, etc.) and all are corrupted upon downloading. I am using apache, php 5, and mysql 5 on the server.

[ben.willard@…]

I have the same problem, and it looks like the issue is that when the data goes in, it's run through addslashes or mysql_escape or something similar, but it's NOT un-escaped when it comes back out. This should be easy to fix, I'd think.

[ben.willard@…]

added stripslashes function to servefile.php so that the slashes which are added on insert or update are removed upon download

[brieb]

The vast majority of people using phpBMS do not have this problem, and while your patch would fix the problem for you, it would create the problem for most other users. What we need to do is isolate how and why those slashes are not present.

My guess is that there is a MySQL or php/MySQL setting or version which is causing the system to automatically escape slashes on most systems, but not on yours. If we can isolate the cause, we can test for it, and then stripslashes when appropriate.

[ben.willard@…]

Thanks for the amazingly fast response! It seemed like it would be too easy for a simple stripslashes to be the answer, and I'm glad to know that the problem is larger than that.

Thanks again for your time!

[Kaycie]

That?s more than sneisble! That?s a great post!