Focus on one problem (Listing targets seems like a simple one) and provide detailed information - versions of OS, database, web server, PHP, SuiteCRM.
It would be interesting to see the contents of suitecrm.log at the time the failed Import; and then at the time of when you click to List Targets and nothing shows. The same goes for php_errors.log.
If the error is recent and you have daily backups you should consider simply restoring.
PHP Warning: mysqli_query(): (HY000/1194): Table ‘prospects’ is marked as crashed and should be repaired in /SuiteCRM/include/database/MysqliManager.php on line 135
Well, there you have it - it seems something went very wrong with your database and SuiteCRM is struggling to work around that.
Try to Google for MySQL solutions to that “crashed table” situation, I’m sure you’ll find them. Then go into the command-line mysql, or into phpMyAdmin and solve it.
Be careful with these database operations, though. Check your backups, make new backups, because if your problem turns out to be more serious you’re going to need them.
Did the repair now there is a new message but the same problem.
[13-May-2017 20:47:01 UTC] PHP Warning: Smarty error: Missing required field:file in /home//public_html/SuiteCRM/include/Smarty/Smarty.class.php on line 1094
[13-May-2017 20:47:01 UTC] PHP Strict Standards: Declaration of MyCallsDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/Calls/Dashlets/MyCallsDashlet/MyCallsDashlet.php on line 47
[13-May-2017 20:47:01 UTC] PHP Strict Standards: Declaration of MyMeetingsDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/Meetings/Dashlets/MyMeetingsDashlet/MyMeetingsDashlet.php on line 209
[13-May-2017 20:47:01 UTC] PHP Strict Standards: Declaration of MyAccountsDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/Accounts/Dashlets/MyAccountsDashlet/MyAccountsDashlet.php on line 101
[13-May-2017 20:47:01 UTC] PHP Strict Standards: Declaration of MyOpportunitiesDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 90
[13-May-2017 20:47:01 UTC] PHP Strict Standards: Declaration of SugarFeedDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 607
The advanced search and the basic search are two independent mechanisms (normally everybody has problems with the advanced search, not the basic search like you…).
The errors you’re getting normally happen to people who have just installed, and they get a broken home screen because of that. I’ve never seen these errors breaking the search, but let’s start by fixing them and see what happens.
When you look at the logs, pay attention to the times there - you have to look for errors that happen exactly at the time of the search. Of course, anty other messages of type “error” or “fatal” can be revealing, also, no matter when they happen.
[14-May-2017 21:18:43 UTC] PHP Warning: Smarty error: Missing required field:file in /home//public_html/SuiteCRM/include/Smarty/Smarty.class.php on line 1094
[14-May-2017 21:18:43 UTC] PHP Strict Standards: Declaration of MyCallsDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/Calls/Dashlets/MyCallsDashlet/MyCallsDashlet.php on line 47
[14-May-2017 21:18:43 UTC] PHP Strict Standards: Declaration of MyMeetingsDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/Meetings/Dashlets/MyMeetingsDashlet/MyMeetingsDashlet.php on line 209
[14-May-2017 21:18:43 UTC] PHP Strict Standards: Declaration of MyAccountsDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/Accounts/Dashlets/MyAccountsDashlet/MyAccountsDashlet.php on line 101
[14-May-2017 21:18:43 UTC] PHP Strict Standards: Declaration of MyOpportunitiesDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php on line 90
[14-May-2017 21:18:43 UTC] PHP Strict Standards: Declaration of SugarFeedDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in /home//public_html/SuiteCRM/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 607
At least, that makes sense - with the change the errors are gone. And those errors happen when you show the Home Screen (showing dashlets), not when you search. That’s why I had told you to check the exact times of the errors. So your reports all along should have been “there is nothing in the logs at the time of the basic search”.
We might need to increase the logging level. Please check this article and have a look at both logs. If you don’t find anything when doing the basic search, try increasing the log level in SuiteCRM to “debug” and repeat the process, then post everything here (not just a part) inside the forum’s “code” tags.