Trouble with search - database errors and continually indexing on jobs page
Permalink
Hi There,
We have a test site which we use as a starting point for new projects. Recently, have noticed that the search indexing on the jobs page keeps running endlessly.
I've just duplicated the site and tried importing the database into a new site but see an error on import:
Does anyone know what this means and how to fix it?
Any help would be much appreciated.
Cheers
Ben
We have a test site which we use as a starting point for new projects. Recently, have noticed that the search indexing on the jobs page keeps running endlessly.
I've just duplicated the site and tried importing the database into a new site but see an error on import:
Dumping data for table `CollectionSearchIndexAttributes` -- INSERT INTO `CollectionSearchIndexAttributes` VALUES ( 2, NULL , NULL , NULL , 0, 0, NULL , 0, 0, NULL , 0, 0, 0, 0.0000 ) ; MySQL said: #1034 - Incorrect key file for table 'collectionsearchindexattributes'; try to repair it
Does anyone know what this means and how to fix it?
Any help would be much appreciated.
Cheers
Ben
After searching around on the search continually indexing issue, adding "&force=1" to the end of the job url and running it manually was mentioned.
This produces the following errors on the original test site (not the new one):
I'm hoping that if I fix the search issue, I can export a clean database for import into the new site - is that a correct assumption or are the two things unrelated?
Any help would be much appreciated.
Cheers
Ben
This produces the following errors on the original test site (not the new one):
Warning: Invalid argument supplied for foreach() in /path/to/c5-install/packages/sixeightforms/jobs/sixeightforms_clear_cache.php on line 19 Warning: Invalid argument supplied for foreach() in path/to/c5-install/packages/sixeightforms/jobs/sixeightforms_index_records.php on line 19 Fatal error: Call to a member function getCollectionID() on a non-object in path/to/c5-install/packages/core_commerce/blocks/product/controller.php on line 198
I'm hoping that if I fix the search issue, I can export a clean database for import into the new site - is that a correct assumption or are the two things unrelated?
Any help would be much appreciated.
Cheers
Ben
So figured out how to repair the table from phpMyAdmin and can now import the database without errors.
However, the search job still indexes continuously - have tried restarting MAMP but not sure what is causing the issue.
If I have the cache turned off (normally do during DEV) then I only get the core_commerce error when running the job with &force=1 on the end:
But if I have the cache turned off, I see errors in the sixeight froms add-on as well:
Any pointers in the right direction would be much appreciated.
However, the search job still indexes continuously - have tried restarting MAMP but not sure what is causing the issue.
If I have the cache turned off (normally do during DEV) then I only get the core_commerce error when running the job with &force=1 on the end:
Fatal error: Call to a member function getCollectionID() on a non-object in /path/to/c5-install/packages/core_commerce/blocks/product/controller.php on line 198
But if I have the cache turned off, I see errors in the sixeight froms add-on as well:
Warning: Invalid argument supplied for foreach() in /path/to/c5-install/packages/sixeightforms/jobs/sixeightforms_clear_cache.php on line 19 Warning: Invalid argument supplied for foreach() in /path/to/c5-install/packages/sixeightforms/jobs/sixeightforms_index_records.php on line 19
Any pointers in the right direction would be much appreciated.
#1034 - Incorrect key file for table 'collectionsearchindexattributes'; try to repair it