Hi

This problem is probably a server setup issue but I thought it worth checking if anyone else has come across it.

When we receive attachments with an apostrophe in the name they are stored in cache/upload with the apostrophe and stored in MySQL with the apostrophe in the filename of the notes table.

But the link to the file (include/upload_file.php) shown on the email detail page or the notes list is returned incorrectly. It looks like PHP gets the filename returned with html entities ( & # 0 3 9 ; ) instead of the apostrophe which upload_file then rawurlencodes into something that will not link to the attachment in cache/upload. When the user clicks on the attachment link they get a page can not be displayed error.

I can fix this by decoding the html entities before rawurlencoding them but I still don't know what has caused this.

Any pointers anyone? What MySQL setting am I missing?

Sugar: 4.01
PHP: 4.3.9
MySQL: 4.0.26
O/S: centos 4