We had a working SuiteCRM 7.9.17 install we tried to upgrade to next version (7.10.17). We had no luck. Whenever we moved to a 7.10.x version the layout was completely destroyed.
At the end we made a clean SuiteCRM 7.11.5 install and imported a backup dump from the 7.9.17 version into the database.
After importing customizations via Module Loader and a casual Quick Repair and Rebuild we were up and running again.
Now, the only thing I can’t get to work again is the global search in particular the indexing.
I have done this: https://pgorod.github.io/Reindex-AOD/
Under Schedulars when I look into “Perform Lucene Index” and “Optimise AOD Index” I get new entries, so the cron job seems to work.
In the folder “/modules/AOD_Index/Index/Index” nothing is happening. I have currently four files in there:
read.lock.file - 0kb - last change 20.06.2019
segments.gen - 1kb - last change 17.06.2019
segments_1 - 1kb - last change 17.06.2019
write.lock.file - 0kb - last change 17.06.2019
For “Perform Lucene Index” last successful run: 26.06.2019 00:00
For “Optimise AOD Index” last successful run: 26.06.2019 14:00
Would it make sense to copy back the old Index folder from the SuiteCRM 7.9.17 install?
Any ideas how to solve this?
Thank you for your time reading all this.
If you need more information to solve this let me know.
Importing a database dump from a 7.9 to a 7.11 seems a really dangerous idea to me… there are differences in database structure, there are upgrade scripts that make changes to the system… it is never appropriate to import a different version of database into an installation. I would be surprised if you don’t find many problems in the future…
About the rest, I would start by checking your logs for any messages related to the indexing, there might be clues there about what is going wrong. You probably have some peculiarity about your ownerships/permissions scheme that needs to be fixed so that the CLI process can write to the files.
Can you please post the results of these two commands, given from your SuiteCRM base directory:
ls -al modules/AOD_Index/Index/Index
This will help me get a quick glance of your ownerships and directory bits, etc.
Also, how did you set up your cron jobs? Which user’s crontab did you use, and which command did you write there? See Admin / Schedulers, at the bottom, for instructions specific to your system.
The permissions look right. But all those log errors really worry me. I fear your migration will leave you with a broken system, and as you use it you will only find out more pieces that are broken about it.
You said you tried an upgrade but the layouts didn’t turn out well - I believe we could fix that with a few repairs and clean-ups, do you want to try it again?