Advanced Search Bug in 4.5.1h and Internet Explorer.

[spectheintro]

I first noticed this behavior in Sugar 4.5.1f, but it's become much more prevalent (to the point of being nearly unusable) with 4.5.1h.

Essentially, Advanced Searching does not work. When I enter any criteria under Advanced Search in Internet Explorer, and then click "Search," the screen goes directly to "Internet Explorer cannot display the page." I don't have any issues with Firefox performing the same search, but IE goes absolutely haywire.

Now, if I click "reload" after it goes to the error page, it actually displays the search query results. But, I can't navigate to the next page of results: it goes right back to the error page. I have not made any modifications to SearchForm.html outside of cosmetic changes via Studio. I did make the following change to SearchForm.php in the include directory:

$where .= $db_field . " like '".$like_char.$field_value.$like_char."'";

I did this so that my users could search more easily. This had never impacted searching before, but now it is impossible to execute successful advanced searches in IE. Basic searches work just fine.

Please help me solve this issue; this is a real dealbreaker in its current state.

[spectheintro]

I did a bit of research on this and it turns out my particular issue has to do with the character limit for URLs in Internet Explorer. Because I have so many custom fields to search by, it's resulting in a URL that is longer than IE's limit of 2,048 characters. (I'm at 2174 right now.) I'm going to see if there's a way to up the max limit; if not, I'm going to have to remove some fields.

[spectheintro]

The main issue here is that I was very descriptive when naming my custom fields in MySQL, so I routinely have fields whose names are 20 characters. I have around 50+ custom fields that I need to be able to search by, but it looks like whenever an advanced search is executed the status of *every* custom field is included in the URL. Is there any way to fix this so that searching does not crash IE? I would really prefer not to remove searchable fields, or (even worse) rename all of my fields in the database. (That would be truly awful.)

[spectheintro]

Could a mod please move this thread to "Help," since it's not really an upgrade problem? Thanks.

[susiewilliams]

Hi there,

I moved your thread, per your request. Unfortunately, I don't have an answer to your questions, but hopefully someone else does.