Global Search - AOD

💬 General Discussion
1

Hello, as I said last week I have since this version problems with global search not AOD, searches only 1 one module (opportunities) and not in the other modules, ans all is enabled.

So I tried AOD. It works for the new inputs. But I need to index the whole DB. Is there a command to do it ?

Thanks in advance.

2

The global search issue is a known bug and has been logged on the SuiteCRM GitHub.

On AOD, it should index your full database. Which records has it not indexed?

Thanks,

Will.

3

Nothing is indexed, except the input created after the activation of AOD.

4

IS your scheduler/cron job up and running? Is the AOD index/optimise AOD scheduler running in Admin -> Scheduler?

5

Indeed, was not created. Just did it. But I also have a cron problem. All is done on the cPanel, with -f, without, etc … but the schedulers never ran …

Not possible do to a manual run to test ?

6

You will need to debug with your host to get your schedulers up and running, as a lot of funtionality(such as Workflow, AOD) needs the scheduler to fully function.

Thanks,

Will.

7

Thanks. I contact Hostmonster now.

8

They don’t help with cron. I use this : php -f /PATH-TO-INSTALLATION/cron.php

9

https://my.hostmonster.com/cgi/help/411

10

I did all they say … but same problem … I use in cron jobs every minutes :

php -f /home2/XXXXXX/public_html/XXXXXX/cron.php

And I even tried the tip from a user on this forum on Bluehost (same group) : php-cli /home2/XXXXXX/public_html/XXXXXX/cron.php

11

And here is the contecnt of my cron.php

<?php if(!defined('sugarEntry'))define('sugarEntry', true); /********************************************************************************* * SugarCRM Community Edition is a customer relationship management program developed by * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. * SuiteCRM is an extension to SugarCRM Community Edition developed by Salesagility Ltd. * Copyright (C) 2011 - 2014 Salesagility Ltd. * * This program is free software; you can redistribute it and/or modify it under * the terms of the GNU Affero General Public License version 3 as published by the * Free Software Foundation with the addition of the following permission added * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS. * * This program is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more * details. * * You should have received a copy of the GNU Affero General Public License along with * this program; if not, see http://www.gnu.org/licenses or write to the Free * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA * 02110-1301 USA. * * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road, * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com. * * The interactive user interfaces in modified source and object code versions * of this program must display Appropriate Legal Notices, as required under * Section 5 of the GNU Affero General Public License version 3. * * In accordance with Section 7(b) of the GNU Affero General Public License version 3, * these Appropriate Legal Notices must retain the display of the "Powered by * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not * reasonably feasible for technical reasons, the Appropriate Legal Notices must * display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM". ********************************************************************************/ //change directories to where this file is located. //this is to make sure it can find dce_config.php chdir(dirname(__FILE__)); require_once('include/entryPoint.php'); // $sapi_type = php_sapi_name(); // if (substr($sapi_type, 0, 3) != 'cli') { // sugar_die("cron.php is CLI only."); // } if(empty($current_language)) { $current_language = $sugar_config['default_language']; } $app_list_strings = return_app_list_strings_language($current_language); $app_strings = return_application_language($current_language); global $current_user; $current_user = new User(); $current_user->getSystemUser(); $GLOBALS['log']->debug('--------------------------------------------> at cron.php <--------------------------------------------'); $cron_driver = !empty($sugar_config['cron_class'])?$sugar_config['cron_class']:'SugarCronJobs'; $GLOBALS['log']->debug("Using $cron_driver as CRON driver"); if(file_exists("custom/include/SugarQueue/$cron_driver.php")) { require_once "custom/include/SugarQueue/$cron_driver.php"; } else { require_once "include/SugarQueue/$cron_driver.php"; } $jobq = new $cron_driver(); $jobq->runCycle(); $exit_on_cleanup = true; sugar_cleanup(false); // some jobs have annoying habit of calling sugar_cleanup(), and it can be called only once // but job results can be written to DB after job is finished, so we have to disconnect here again // just in case we couldn't call cleanup if(class_exists('DBManagerFactory')) { $db = DBManagerFactory::getInstance(); $db->disconnect(); } // If we have a session left over, destroy it if(session_id()) { session_destroy(); } if($exit_on_cleanup) exit($jobq->runOk()?0:1);
12

Your cron job should be OK - it is essentially the same. The only thing is that the user calling it should be the same as the web server, and should have permissions on the installation path.

1 Like
13

Well it is via cPanel, should I specify username and passOrd to be sure ? Is it possible in yhe cron command ?

14

I’m not familiar with cPanel, but my guess is that it runs the cron job as user that you created it in. As long as it is the same user that created the suitecrm environment, it should be ok.

Do the other scheduled jobs run?

15

Yes, I have cron jobs for SQL dumps and it works … and it is also for the Suitecrm install …

16

I also tried with easycron.com, it says success but in the CRM, last success of the tasks : never :frowning:

17

Well, now I have 2 different informations :

In job log, I have the job from today in status “Done’”. But still last successfull run : Never.

Very strange …

18

hi did you manage to solve this?