Problem with Listing Leads on Multiple Pages

[dkiraly]

I've imported several thousand leads into the database from different sources. Currently setting are to display 25 listings per page. When a user clicks on "Next" , the value ®_no_c= is put into the Account field, and no further records are displayed.

Anyone else seen this?

[dkiraly]

I've noticed this problem occurs specifically when searches are performed using custom fields....

[dkiraly]

In the leads module, does anyone know which file the query string is built?

I have figure out that the error is that an ampersand symbol is being left out as the string is built, which is causing the problem....

Example
The string should look like "leadsource=AMSTAT&reg_no_c=N5433"

but actually looks like "leadsource=AMSTATreg_no_c=N5433"

Notice the & symbol missing between amstat and reg....

[simple]

Hi

what is your SugarCRM version, 4.5.0f?

Does it happen when you use the basic search or the advanced search? Do you use a saved search or did you customize the list view in Studio?

[dkiraly]

Yes, it is 4.5f, I've posted another post on renaming a custom field. I've found that the problem is with one of my custom field names.

the fieldname is reg_no_c, when that is passed on the advanced search page, the broweser takes the ampersand in front of the field name and combines it with the reg, so instead of looking like &reg_no_c=N2134, it looks like previousfieldname=xxxx®_no_c=Nw3434, so I need to change the reg_no_c field name to something else, but am not an expert in sugar or php for that matter, but do have some coding exp, just not sure where to look.

[simple]

Hi

It seems to be a bug in Internet Explorer. Which browser would change &reg to the register symbol in the url? Probably only IE...

I tried the same setup on a OS test installation and with Firefox, no problems. But with Internet Explorer I get the same error.

[dkiraly]

Is there a way to change the field delimeter to something other than an ampersand? I.E. a semicolon or some other character? Not sure if this is a function of PHP or Sugar or both.

[simple]

Not sure if this is a function of PHP or Sugar or both.

It has nothing to do with Sugar. And it's not only the standard delimiter in PHP, for key=value pairs in a GET request.

Changing the delimiter in PHP - if possible, don't think so but I don't know - would not help, because the Sugar code (and alot of other web applications) rely on the ampersand as delimiter.