Use Basic Search is Blank but advanced is ok

Use Basic Search is Blank but advanced is ok
importing targets gives an error
viewing targets is blank
viewing targets under Target List is fine

everything has been working fie for month then yesterday it stopped working after an upload of targets.

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.

rebuilding the database fixed the all the target issues the only one left is the blank search.

Is the search blank for all kinds of searches, or just for Target searches?

Do you have anything in the logs when searching?

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

HI. That’s a known issue with some versions of PHP (did you happen to upgrade PHP recently?).

https://github.com/salesagility/SuiteCRM/issues/942

While it’s not fixed, you can tweak the code to make it run. Go into each of the files with the error and find a line that looks like this:

function process($lvsParams = array()) {

and change it into this

function process($lvsParams = array(), $id=NULL) {

these changes won’t be upgrade-safe, meaning when you do an upgrade there is a small chance that you might have to reapply them.

than you i will fix that.

Also the advanced search works fine only the basic is the problem. Could it be one of the .php files?

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.

Nothing changed

[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

That’s VERY strange. Can you please post the full contents of one of those files after your change? For example, the Accounts dashlet file.

Use the “code” tags available from the toolbar in these forums when replying, and put your code inside that.

all the errors are gone but the Basic search does not work.

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.

Smarty error: Missing required field:file in /home//public_html/SuiteCRM/include/Smarty/Smarty.class.php on line 1094

Let’s start over. You might be getting this: https://github.com/salesagility/SuiteCRM/issues/2194

Please, what are your versions of OS, database, web server, PHP, and SuiteCRM?

And do you have any custom modules created by you?

CENTOS 7.3 x86_64

we are trying to get basic search to work

Well, good luck, then. Go and get it to work.

Do your diagnosis your way, since you’re clearly not interested in doing it my way… sorry to bother you with my questions.

each of the log files are 30 mb can i just delete them or how do you empty them