listview is empty

[lobby]

Hello,
I have imported a lot of data to the acounts and contacts modules. But the listview is empty, but the entries are in the database. If I check the data in detailview, I can see it.
The searchfilters are empty, too. Does anybody know this problem?

[sugarcane]

Hello,

what version of Sugar are you using? For 5.1, click the clear button and then click the Search button and see if anything comes up.

You might also want to check in Admin-->System Settings and check to setting for the 'Listview Items per Page'. This determines how many records are to be displayed on each listview page.

[andopes]

Hi lobby

If you click on Clear at the Search Form does the ListView return all the entries?
If you search for another field does the ListView returns correctly?

If yes for both then you can edit the file include/ListView/ListViewData.php and add the line:

 echo "<PRE>$main_query"; 
  

Just after the line:

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
  

Then go to Accounts ListView and try to do a Search.
If the ListView return no data, just a query string, copy it and paste to the phpMyAdmin and execute it there.
Probably it will return an error, it will guide you to solve the error.

Let us know the query string and the error.

Cheers