Need Custom Search and Export - Problems with CRMUpgrades: SugarSearch

[eagleone]

Hello Everybody,

I have a Problem with CRMUpgrades: SugarSearch.
I have Sugar 4.51g installed, TeamOS 3.3d an Zucker Hierarchie 1.0.

When I tried to use any "Advanced Search" I get no Results. What is wrong ?

I made a copy of the entire Project to another Server and it´s the same.

On both Server I run PHP 4.4 maybe thats the Problem ?

Any Help ist welcome, PLEASE

[paikmoses]

Looks like the something broke while installation. Try with a fresh download of sugar and then go through the installation again.

Hope this helps.

Regards

[andopes]

Hi, eagleone.

If you know how to debug php scripts you can do that:

Open the file include/ListView/ListViewData.php
Look for this line:

 $_SESSION['export_where'] = $ret_array['where'] 
  

And insert this one above:

 echo "$main_query"; 
  

This will show the query for retrieving data from database.

And modify the line bellow:

 $result = $GLOBALS['db']->query($main_query); 
  

to this one:

 $result = $GLOBALS['db']->query($main_query, true); 
  

This will make the execution dies if the database gets some error. It will display the error on screen.

If AdvancedSearchs returns nothing it could be because any dropdown customization where the label '-- None --' has been related the the option '0' besides ''.

Remember to restore the file after debugging.

Cheers

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br