Hi,
I have finished importing my contacts, accounts, and creating the links among them. But all my happiness and satisfaction blow away when I realised that when I do a search through the box on the top right, it shows no result.
Only if I search for the details of a couple of contacts I manually input to do some prior testing appear.
Any way to fix this?
The Global Search (on the top-right input box) is indexed, meaning it only works after the Indexer went through the records.
You need to check if your Scheduler jobs are running correctly, and specifically two called “Perform Lucene index” and “Optimize AOD index”.
Then let a few hours go by, sometimes indexing can be delayed.
Finally, if the jobs are working, and you still get no results, then you might want to consider forcing a reindexing:
Thanks for your reply, it has been very useful.
I have rest both processes as per described in the article in your link.
I have also activated the cron job, I found out I forgot to configure it after the installation.
Through the Admin panel, I go to Schedulers and bot process appear now as running. But they must me stuck, as they have been like this for hours and no progress.
Shall I restart them again?
If you have a lot of data, it is normal for the process to take several hours. You can check what is going on with the command I give at the end of my article:
watch du -h modules/AOD_Index/Index/Index
That way you can tell if there is an index built, and if it’s still “moving”, if files are getting created and deleted as it happens during indexing.
You can restart indexing with the instruction given, if you feel it’s necessary.
If the indexing refuses to work correctly, I would check permissions issues. If the process can’t write to the directory, it can’t index.
Also, it’s always useful to check your logs for any errors.
I am afraid that my server does not recognise the command “watch”
-bash: watch: command not found
Besides, I have currently uploaded less than 200 items, so it shouldn’t take so long
Try installing it with
sudo apt-get install procps
Sorry, but I am afraid I also get the same error message of (sudo:) Command Not Found :pinch:
Well maybe we should start at the beginning:
What is your flavour and version of Linux?
is it your own server or is it shared hosting? Do you have super user access? If it’s not “sudo”, it’s “su”.
I don’t know. Where can I check it?
Shared hosting
I think so. But I usually configure my webs through cPanel and FTP
su: command not found
FYI: I didn’t touch the files’ ownership, and the site was working perfectly for 2 weeks
If it’s shared hosting, then you surely don’t have sudo access. So let’s forget about “watch”.
If you simply repeat the command
du -h modules/AOD_Index/Index/Indexevery few seconds, you get a view of how much data is in there, and whether it’s evolving.
If it’s stopped, and search doesn’t work, you might need to reindex. But please solve the permissions problems first, otherwise things will just break again.
Hi,
I have waited some weeks to see if the scheduled task were running, but the search is still not working.
1-Through FTP, I deleted the Index folder: mv modules/AOD_Index/Index/Index modules/AOD_Index/Index/Index
2- Through PHPMyAdmin, I deleted SQL tables aod_index and aod_indexevent
3- Through SuiteCRM Admin Panel, I checked that “Optimise AOD Index” and “Perform Lucene Index” are running correctly, or at least now it generates reports. (This is the only improvement but with no impact on the overall).
The files I deleted under points 1 and 2 have not been generated again, and now there is no file there. So I am not sure point 3 is actually working successfully.
Any advice would be highly welcome. It is crucial to me to solve this issue.
Thanks
The command you show in 1. does not delete anything, it just tries to move a directory into the same place. I will assume you just made a mistake now typing the command, and that you did it correctly and in fact deleted the directory, because you say later “no file is there”.
Let me just check: when you go in Admin / Scheduler, and then click on the Optimize job, and in the Lucene job, what do they say in “last run successfully” field?
Can you find ANY job in that list that has a “last run successfully” today, for example?
Based on this collected information, you can conclude one of these:
if no jobs are running, you need to focus on your cron configuration, getting them all to run
If some jobs are running, then cron is working properly; but then when these two jobs needed for the Index run, they must be getting problems. Search both your logsyour logs for clues.
I did it through FTP. I first renamed, and later deleted the whole folder. Shall I create the folder again?
The cron work is working, but you are right, I confused the log with the Las Succesfull Run field. Neither has been succesfully ran.
I have review the log, and it shows the following message many times
Sat Jan 20 16:00:03 2018 [39661][1][FATAL] Job b1376544-3b66-b897-72cc-5a63bb9d46f8 (Optimise AOD Index) failed in CRON run
Sat Jan 20 16:00:03 2018 [39661][1][FATAL] Retrieving record by id aod_index:1 found Query Failed: SELECT aod_index.* FROM aod_index WHERE aod_index.id = '1' AND aod_index.deleted=0 LIMIT 0,1: MySQL error 1146: Table 'crmdatabase.aod_index' doesn't exist
Sat Jan 20 16:30:01 2018 [40413][1][FATAL] Retrieving record by id aod_index:1 found Query Failed: SELECT aod_index.* FROM aod_index WHERE aod_index.id = '1' AND aod_index.deleted=0 LIMIT 0,1: MySQL error 1146: Table 'crmdatabase.aod_index' doesn't existSat Jan 20 17:00:03 2018 [42236][1][FATAL] Job c733c564-7cad-d1db-eddf-5a63c9a5228c (Perform Lucene Index) failed in CRON run
Sat Jan 20 17:00:03 2018 [42236][1][FATAL] Retrieving record by id aod_index:1 found Query Failed: SELECT aod_index.* FROM aod_index WHERE aod_index.id = '1' AND aod_index.deleted=0 LIMIT 0,1: MySQL error 1146: Table 'crmdatabase.aod_index' doesn't exist
Sat Jan 20 17:30:01 2018 [13619][1][FATAL] Retrieving record by id aod_index:1 found Query Failed: SELECT aod_index.* FROM aod_index WHERE aod_index.id = '1' AND aod_index.deleted=0 LIMIT 0,1: MySQL error 1146: Table 'crmdatabase.aod_index' doesn't existI have deleted the aod_index and aod_indexevent tables in the database, following the tutorial. How do I recover them?
I am convinced that deleting those tables would simply get them recreated automatically, but I might b wrong. So I’m attaching SQL scripts that you can feed into phpMyAdim to recreate them. These come from a version 7.9.x
-- phpMyAdmin SQL Dump
-- version 4.6.6deb1+deb.cihar.com~xenial.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jan 21, 2018 at 06:28 PM
-- Server version: 5.7.20-0ubuntu0.16.04.1
-- PHP Version: 7.0.22-0ubuntu0.16.04.1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `suitecrm`
--
-- --------------------------------------------------------
--
-- Table structure for table `aod_index`
--
CREATE TABLE `aod_index` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text,
`deleted` tinyint(1) DEFAULT '0',
`assigned_user_id` char(36) DEFAULT NULL,
`last_optimised` datetime DEFAULT NULL,
`location` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `aod_index`
--
ALTER TABLE `aod_index`
ADD PRIMARY KEY (`id`);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-- phpMyAdmin SQL Dump
-- version 4.6.6deb1+deb.cihar.com~xenial.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jan 21, 2018 at 06:28 PM
-- Server version: 5.7.20-0ubuntu0.16.04.1
-- PHP Version: 7.0.22-0ubuntu0.16.04.1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `suitecrm`
--
-- --------------------------------------------------------
--
-- Table structure for table `aod_indexevent`
--
CREATE TABLE `aod_indexevent` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text,
`deleted` tinyint(1) DEFAULT '0',
`assigned_user_id` char(36) DEFAULT NULL,
`error` varchar(255) DEFAULT NULL,
`success` tinyint(1) DEFAULT '0',
`record_id` char(36) DEFAULT NULL,
`record_module` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `aod_indexevent`
--
ALTER TABLE `aod_indexevent`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_record_module` (`record_module`),
ADD KEY `idx_record_id` (`record_id`);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
If that isn’t enough to make it work, try creating an empty directory called
modules/AOD_Index/Index
if it isn’t there already. Then wait a few minutes and check if it has new files in it. If not, then create an empty directory called
modules/AOD_Index/Index/Index
If that doesn’t work, please open a Linux shell (like SSH) and tell me the results from these commands given from your SuiteCRM root directory:
ls -al modules/AOD_Index/Index
ls -al modules/AOD_Index/Index/Index
ls -al
This will allow me to check more details about your permissions settihngs.
In the database, it created a row with name “index” under the aod_index table. aod_indexevent table remains empty.
In the server, it created the file “read.lock.file” under the folder /modules/AOD_Index/Index/Index, but 0 Kbs
In the Admin Panel, neither scheduler has run successfully.
These are the details that you requested:
user1596@uk13 [~/public_html/webdomain.com/crm]# ls -al modules/AOD_Index/Index
total 12
drwxrwxr-x 3 user1596 user1596 4096 Jan 21 16:47 ./
drwxrwxr-x 8 user1596 user1596 4096 Oct 24 15:56 ../
drwxr-xr-x 2 user1596 user1596 4096 Jan 21 16:49 Index/user1596@uk13 [~/public_html/webdomain.com/crm]# ls -al modules/AOD_Index/Index/ Index
total 8
drwxr-xr-x 2 user1596 user1596 4096 Jan 21 16:49 ./
drwxrwxr-x 3 user1596 user1596 4096 Jan 21 16:47 ../
-rw-rw-rw- 1 user1596 user1596 0 Jan 21 17:30 read.lock.fileuser1596@uk13 [~/public_html/webdomain.com/crm]# ls -al
total 17728
drwxr-xr-x 21 user1596 user1596 4096 Jan 21 00:00 ./
drwxr-x--- 20 user1596 nobody 4096 Dec 28 10:10 ../
drwxr-xr-x 2 user1596 user1596 4096 Oct 10 11:32 .github/
-rw-r--r-- 1 user1596 user1596 1376 Oct 10 13:57 .htaccess
-rwxr-xr-x 1 user1596 user1596 3094 Oct 29 17:46 CODE_OF_CONDUCT.md*
-rwxr-xr-x 1 user1596 user1596 2811 Oct 10 11:32 HandleAjaxCall.php*
-rwxr-xr-x 1 user1596 user1596 34539 Oct 10 11:32 LICENSE.txt*
drwxr-xr-x 3 user1596 user1596 4096 Oct 10 11:50 ModuleInstall/
-rwxr-xr-x 1 user1596 user1596 3737 Oct 29 17:46 README.md*
-rwxr-xr-x 1 user1596 user1596 5327 Oct 10 11:32 SugarSecurity.php*
-rwxr-xr-x 1 user1596 user1596 5843 Oct 10 11:32 TreeData.php*
drwxr-xr-x 2 user1596 user1596 4096 Oct 10 12:16 XTemplate/
drwxr-xr-x 8 user1596 user1596 4096 Oct 10 12:16 Zend/
drwxrwxr-x 15 user1596 user1596 4096 Jan 14 18:21 cache/
-rwxr-xr-x 1 user1596 user1596 3590 Oct 10 11:32 campaign_tracker.php*
-rwxr-xr-x 1 user1596 user1596 462 Oct 10 11:32 composer.json*
-rwxr-xr-x 1 user1596 user1596 17908 Oct 10 11:32 composer.lock*
-rwxr-xr-x 1 user1596 user1596 10381 Oct 30 17:43 config.php*
-rwxrwxr-x 1 user1596 user1596 586 Jan 9 18:58 config_override.php*
-rwxr-xr-x 1 user1596 user1596 5052 Oct 10 11:32 cron.php*
-rwxr-xr-x 1 user1596 user1596 2446 Oct 10 11:32 crossdomain.xml*
drwxrwxr-x 9 user1596 user1596 4096 Oct 29 17:46 custom/
drwxrwxr-x 3 user1596 user1596 4096 Oct 10 11:32 data/
-rwxr-xr-x 1 user1596 user1596 2388 Oct 10 11:32 dictionary.php*
-rwxr-xr-x 1 user1596 user1596 12541 Oct 29 17:46 download.php*
-rwxr-xr-x 1 user1596 user1596 2392 Oct 10 11:32 emailmandelivery.php*
-rwxr-xr-x 1 user1596 user1596 4912 Oct 10 11:32 export.php*
-rwxr-xr-x 1 user1596 user1596 967627 Oct 10 11:32 files.md5*
-rwxr-xr-x 1 user1596 user1596 2367 Oct 29 17:46 ical_server.php*
drwxr-xr-x 58 user1596 user1596 4096 Oct 10 11:34 include/
-rwxr-xr-x 1 user1596 user1596 2374 Oct 10 11:32 index.php*
drwxr-xr-x 6 user1596 user1596 4096 Oct 30 17:43 install/
-rwxr-xr-x 1 user1596 user1596 17930 Oct 10 13:57 install.log*
-rwxr-xr-x 1 user1596 user1596 31896 Oct 29 17:46 install.php*
-rwxr-xr-x 1 user1596 user1596 2275 Oct 29 17:46 json_server.php*
drwxr-xr-x 3 user1596 user1596 4096 Oct 10 11:46 jssource/
-rwxr-xr-x 1 user1596 user1596 2313 Oct 10 11:32 log_file_restricted.html*
-rwxr-xr-x 1 user1596 user1596 2376 Oct 10 11:32 maintenance.php*
-rwxr-xr-x 1 user1596 user1596 889 Oct 10 14:18 manifest.php*
drwxr-xr-x 2 user1596 user1596 4096 Oct 10 11:50 metadata/
drwxrwxr-x 113 user1596 user1596 4096 Oct 10 14:18 modules/
-rwxr-xr-x 1 user1596 user1596 2890 Oct 10 11:32 pdf.php*
-rw-r--r-- 1 user1596 user1596 420815 Jan 21 17:30 php_errorlog
-rwxr-xr-x 1 user1596 user1596 304 Oct 29 17:45 php_version.php*
drwxr-xr-x 2 user1596 user1596 4096 Oct 29 17:45 public/
-rwxr-xr-x 1 user1596 user1596 73 Oct 10 11:32 robots.txt*
-rwxr-xr-x 1 user1596 user1596 3588 Oct 10 11:32 run_job.php*
drwxr-xr-x 12 user1596 user1596 4096 Oct 10 12:03 service/
drwxr-xr-x 2 user1596 user1596 4096 Oct 10 12:03 soap/
-rwxr-xr-x 1 user1596 user1596 4091 Oct 10 11:32 soap.php*
-rwxr-xr-x 1 user1596 user1596 154 Oct 29 17:45 sugar_version.json*
-rwxr-xr-x 1 user1596 user1596 2296 Oct 29 17:46 sugar_version.php*
-rwxr-xr-x 1 user1596 user1596 126280 Oct 10 13:57 sugarcrm.log*
-rwxr-xr-x 1 user1596 user1596 266674 Oct 29 17:21 suitecrm.log*
-rw-r--r-- 1 user1596 user1596 178578 Jan 1 23:30 suitecrm_01_01_18.log
-rw-r--r-- 1 user1596 user1596 174578 Jan 2 23:30 suitecrm_01_02_18.log
-rw-r--r-- 1 user1596 user1596 178426 Jan 3 23:30 suitecrm_01_03_18.log
-rw-r--r-- 1 user1596 user1596 168303 Jan 4 23:30 suitecrm_01_04_18.log
-rw-r--r-- 1 user1596 user1596 172985 Jan 5 23:30 suitecrm_01_05_18.log
-rw-r--r-- 1 user1596 user1596 166693 Jan 6 23:30 suitecrm_01_06_18.log
-rw-r--r-- 1 user1596 user1596 172989 Jan 7 23:30 suitecrm_01_07_18.log
-rw-r--r-- 1 user1596 user1596 169049 Jan 8 23:30 suitecrm_01_08_18.log
-rw-r--r-- 1 user1596 user1596 222694 Jan 9 23:30 suitecrm_01_09_18.log
-rw-r--r-- 1 user1596 user1596 177476 Jan 10 23:30 suitecrm_01_10_18.log
-rw-r--r-- 1 user1596 user1596 181815 Jan 11 23:30 suitecrm_01_11_18.log
-rw-r--r-- 1 user1596 user1596 178946 Jan 12 23:30 suitecrm_01_12_18.log
-rw-r--r-- 1 user1596 user1596 179630 Jan 13 23:30 suitecrm_01_13_18.log
-rw-r--r-- 1 user1596 user1596 228814 Jan 14 23:30 suitecrm_01_14_18.log
-rw-r--r-- 1 user1596 user1596 168980 Jan 15 23:30 suitecrm_01_15_18.log
-rw-r--r-- 1 user1596 user1596 169042 Jan 16 23:30 suitecrm_01_16_18.log
-rw-r--r-- 1 user1596 user1596 172981 Jan 17 23:30 suitecrm_01_17_18.log
-rw-r--r-- 1 user1596 user1596 172986 Jan 18 23:30 suitecrm_01_18_18.log
-rw-r--r-- 1 user1596 user1596 186964 Jan 19 23:30 suitecrm_01_19_18.log
-rw-r--r-- 1 user1596 user1596 169650 Jan 20 23:30 suitecrm_01_20_18.log
-rw-r--r-- 1 user1596 user1596 129433 Jan 21 17:30 suitecrm_01_21_18.log
-rwxr-xr-x 1 user1596 user1596 79542 Oct 29 21:00 suitecrm_10_29_17.log*
-rwxr-xr-x 1 user1596 user1596 3143 Oct 30 21:00 suitecrm_10_30_17.log*
-rwxr-xr-x 1 user1596 user1596 311992 Oct 31 23:30 suitecrm_10_31_17.log*
-rw-r--r-- 1 user1596 user1596 186350 Nov 1 23:30 suitecrm_11_01_17.log
-rw-r--r-- 1 user1596 user1596 175396 Nov 2 23:30 suitecrm_11_02_17.log
-rw-r--r-- 1 user1596 user1596 173066 Nov 3 23:30 suitecrm_11_03_17.log
-rw-r--r-- 1 user1596 user1596 173823 Nov 4 23:30 suitecrm_11_04_17.log
-rw-r--r-- 1 user1596 user1596 178086 Nov 5 23:30 suitecrm_11_05_17.log
-rw-r--r-- 1 user1596 user1596 169848 Nov 6 23:30 suitecrm_11_06_17.log
-rw-r--r-- 1 user1596 user1596 170707 Nov 7 23:30 suitecrm_11_07_17.log
-rw-r--r-- 1 user1596 user1596 177594 Nov 8 23:30 suitecrm_11_08_17.log
-rw-r--r-- 1 user1596 user1596 168103 Nov 9 23:30 suitecrm_11_09_17.log
-rw-r--r-- 1 user1596 user1596 180076 Nov 10 23:30 suitecrm_11_10_17.log
-rw-r--r-- 1 user1596 user1596 166736 Nov 11 23:30 suitecrm_11_11_17.log
-rw-r--r-- 1 user1596 user1596 173828 Nov 12 23:30 suitecrm_11_12_17.log
-rw-r--r-- 1 user1596 user1596 166733 Nov 13 23:30 suitecrm_11_13_17.log
-rw-r--r-- 1 user1596 user1596 170535 Nov 14 23:30 suitecrm_11_14_17.log
-rw-r--r-- 1 user1596 user1596 177677 Nov 15 23:30 suitecrm_11_15_17.log
-rw-r--r-- 1 user1596 user1596 176118 Nov 16 23:30 suitecrm_11_16_17.log
-rw-r--r-- 1 user1596 user1596 177712 Nov 17 23:30 suitecrm_11_17_17.log
-rw-r--r-- 1 user1596 user1596 162026 Nov 18 23:30 suitecrm_11_18_17.log
-rw-r--r-- 1 user1596 user1596 167490 Nov 19 23:30 suitecrm_11_19_17.log
-rw-r--r-- 1 user1596 user1596 174546 Nov 20 23:30 suitecrm_11_20_17.log
-rw-r--r-- 1 user1596 user1596 181605 Nov 21 23:30 suitecrm_11_21_17.log
-rw-r--r-- 1 user1596 user1596 170662 Nov 22 23:30 suitecrm_11_22_17.log
-rw-r--r-- 1 user1596 user1596 171482 Nov 23 23:30 suitecrm_11_23_17.log
-rw-r--r-- 1 user1596 user1596 177708 Nov 24 23:30 suitecrm_11_24_17.log
-rw-r--r-- 1 user1596 user1596 178417 Nov 25 23:30 suitecrm_11_25_17.log
-rw-r--r-- 1 user1596 user1596 173046 Nov 26 23:30 suitecrm_11_26_17.log
-rw-r--r-- 1 user1596 user1596 169019 Nov 27 23:30 suitecrm_11_27_17.log
-rw-r--r-- 1 user1596 user1596 173825 Nov 28 23:30 suitecrm_11_28_17.log
-rw-r--r-- 1 user1596 user1596 175344 Nov 29 23:30 suitecrm_11_29_17.log
-rw-r--r-- 1 user1596 user1596 174547 Nov 30 23:30 suitecrm_11_30_17.log
-rw-r--r-- 1 user1596 user1596 176963 Dec 1 23:30 suitecrm_12_01_17.log
-rw-r--r-- 1 user1596 user1596 174425 Dec 2 23:30 suitecrm_12_02_17.log
-rw-r--r-- 1 user1596 user1596 170552 Dec 3 23:30 suitecrm_12_03_17.log
-rw-r--r-- 1 user1596 user1596 171294 Dec 4 23:30 suitecrm_12_04_17.log
-rw-r--r-- 1 user1596 user1596 178463 Dec 5 23:30 suitecrm_12_05_17.log
-rw-r--r-- 1 user1596 user1596 170609 Dec 6 23:30 suitecrm_12_06_17.log
-rw-r--r-- 1 user1596 user1596 174570 Dec 7 23:30 suitecrm_12_07_17.log
-rw-r--r-- 1 user1596 user1596 173051 Dec 8 23:30 suitecrm_12_08_17.log
-rw-r--r-- 1 user1596 user1596 175335 Dec 9 23:30 suitecrm_12_09_17.log
-rw-r--r-- 1 user1596 user1596 173032 Dec 10 23:30 suitecrm_12_10_17.log
-rw-r--r-- 1 user1596 user1596 172211 Dec 11 23:30 suitecrm_12_11_17.log
-rw-r--r-- 1 user1596 user1596 176218 Dec 12 23:30 suitecrm_12_12_17.log
-rw-r--r-- 1 user1596 user1596 175358 Dec 13 23:30 suitecrm_12_13_17.log
-rw-r--r-- 1 user1596 user1596 174593 Dec 14 23:30 suitecrm_12_14_17.log
-rw-r--r-- 1 user1596 user1596 176076 Dec 15 23:30 suitecrm_12_15_17.log
-rw-r--r-- 1 user1596 user1596 175294 Dec 16 23:30 suitecrm_12_16_17.log
-rw-r--r-- 1 user1596 user1596 165924 Dec 17 23:30 suitecrm_12_17_17.log
-rw-r--r-- 1 user1596 user1596 171212 Dec 18 23:30 suitecrm_12_18_17.log
-rw-r--r-- 1 user1596 user1596 168324 Dec 19 23:30 suitecrm_12_19_17.log
-rw-r--r-- 1 user1596 user1596 170631 Dec 20 23:30 suitecrm_12_20_17.log
-rw-r--r-- 1 user1596 user1596 177672 Dec 21 23:30 suitecrm_12_21_17.log
-rw-r--r-- 1 user1596 user1596 171428 Dec 22 23:30 suitecrm_12_22_17.log
-rw-r--r-- 1 user1596 user1596 169804 Dec 23 23:30 suitecrm_12_23_17.log
-rw-r--r-- 1 user1596 user1596 171471 Dec 24 23:30 suitecrm_12_24_17.log
-rw-r--r-- 1 user1596 user1596 169149 Dec 25 23:30 suitecrm_12_25_17.log
-rw-r--r-- 1 user1596 user1596 176255 Dec 26 23:30 suitecrm_12_26_17.log
-rw-r--r-- 1 user1596 user1596 177758 Dec 27 23:30 suitecrm_12_27_17.log
-rw-r--r-- 1 user1596 user1596 189896 Dec 28 23:30 suitecrm_12_28_17.log
-rw-r--r-- 1 user1596 user1596 276567 Dec 29 23:30 suitecrm_12_29_17.log
-rw-r--r-- 1 user1596 user1596 180737 Dec 30 23:30 suitecrm_12_30_17.log
-rw-r--r-- 1 user1596 user1596 170691 Dec 31 23:30 suitecrm_12_31_17.log
-rwxr-xr-x 1 user1596 user1596 169 Oct 29 17:45 suitecrm_version.php*
drwxr-xr-x 2 user1596 user1596 4096 Oct 29 17:45 tests/
drwxrwxr-x 6 user1596 user1596 4096 Oct 10 12:03 themes/
drwxr-xr-x 3 user1596 user1596 4096 Oct 10 14:18 upgrade/
-rwxr-xr-x 1 user1596 user1596 646353 Jan 14 14:24 upgradeWizard.log*
drwxrwxr-x 4 user1596 user1596 4096 Jan 19 03:00 upload/
-rwxr-xr-x 1 user1596 user1596 2980 Oct 10 11:32 vCard.php*
-rwxr-xr-x 1 user1596 user1596 2248 Oct 29 17:45 vcal_server.php*The errors in the log file have change to
Sun Jan 21 17:00:07 2018 [35401][1][FATAL] Job 61d5a790-d179-3ad7-7ed9-5a651b095c9d (Perform Lucene Index) failed in CRON run
Sun Jan 21 17:30:01 2018 [17311][1][FATAL] Job 6beb3bdb-eec3-0e9c-b485-5a651b2c54cd (Optimise AOD Index) failed in CRON runDelete that lock file (do that after every time the Indexer runs but fails).
If you go in Admin / Schedulers, what do the instructions at the bottom of the screen say? The ones about setting up cron?
How exactly did you set up your cron jobs?
Do you see any errors in the web server log? Usually it’s called php_errors.log.
In order to run SuiteCRM Schedulers, edit your web server user’s crontab file with this command:
sudo crontab -e -u user1596
... and add the following line to the crontab file:
* * * * * cd /home/user1596/public_html/webdomain.com/crm; php -f cron.php > /dev/null 2>&1 Through server cPanel. It looks like this
Minute Hour Day Month Weekday Command Actions
0,30 * * * * cd /home/user1596/public_html/webdomain.com/crm; php -f cron.php > /dev/null 2>&1 Edit DeleteThis is the last note:
[22-Jan-2018 05:00:03 CST6CDT] PHP Fatal error: Uncaught exception 'Zend_Search_Lucene_Exception' with message 'Index doesn't exists in the specified directory.' in /home/user1596/public_html/webdomain.com/crm/modules/AOD_Index/Lib/Zend/Search/Lucene.php:566
Stack trace:
#0 /home/user1596/public_html/webdomain.com/crm/modules/AOD_Index/AOD_Index.php(342): Zend_Search_Lucene->__construct('modules/AOD_Ind...')
#1 /home/user1596/public_html/webdomain.com/crm/modules/AOD_Index/AOD_Index.php(83): AOD_Index->getLuceneIndex()
#2 /home/user1596/public_html/webdomain.com/crm/modules/Schedulers/_AddJobsHere.php(683): AOD_Index->optimise()
#3 [internal function]: aodOptimiseIndex(Object(SchedulersJob))
#4 /home/user1596/public_html/webdomain.com/crm/modules/SchedulersJobs/SchedulersJob.php(536): call_user_func_array('aodOptimiseInde...', Array)
#5 /home/user1596/public_html/webdomain.com/crm/include/SugarQueue/SugarCronJobs.php(188): SchedulersJob->runJob()
#6 /home/user1596/public_html/webdomain.com/crm/include/SugarQueue/SugarCronJobs.php(228): SugarCronJobs->execu in /home/user1596/public_html/webdomain.com/crm/modules/AOD_Index/Lib/Zend/Search/Lucene.php on line 566I advise you make sure that cron job is running with the correct user, since I don’t know exactly how Cpanel handles that.
Maybe add a line in that crontab to run this:
* * * * * php -r "echo exec('whoami');" > /home/user1596/public_html/webdomain.com/crm/phpinfo.txt
Then check that phpinfo.txt. If your hosting isn’t blocking “exec”, you should have a username there.
Also you can add permissions on those Index directories, and add the SETUID bit to make sure these are inherited by new subfolders.