I get the following error when turning on the search manager and trying to reindex. This is on an upgrade to 3.24.0, which search used to work fine before.
Fatal error: Uncaught exception 'Exception' with message 'Unable to add indexable content due to database error: SQLSTATE[25P02]: In failed sql transaction: 7
ERROR: current transaction is aborted, commands ignored until end of transaction block' in /home/websites/mysource_matrix/packages/search/search_manager/search_manager.inc:935 Stack trace: #0
/home/websites/mysource_matrix/packages/search/search_manager/search_manager.inc(418): Search_Manager->addIndexableContent('172', Array) #1
/home/websites/mysource_matrix/packages/search/hipo_jobs/hipo_job_reindex.inc(249): Search_Manager->reindexAttributes(Object(Page_Password_Reset), Array) #2
/home/websites/mysource_matrix/core/hipo/hipo_job.inc(1276): HIPO_Job_ReIndex->processReIndex(Array, 'hipo_job_reinde...') #3
/home/websites/mysource_matrix/core/hipo/hipo_job.inc(1173): HIPO_Job->processWeb(Array, 'hipo_job_reinde...') #4
/home/websites/mysource_matrix/core/hipo/hipo_herder.inc(209): HIPO_Jo in /home/websites/mysource_matrix/packages/search/search_manager/search_manager.inc on line 935
…I had this same issue - an issue with the upgrade going wrong I'm told. I didn't notice for a couple of weeks so going back to the backup not an option. Squiz Support are still looking into it for us so maybe just lodge a call with them so they can fix yours too once its available.
[quote]
I get the following error when turning on the search manager and trying to reindex. This is on an upgrade to 3.24.0, which search used to work fine before.
Fatal error: Uncaught exception 'Exception' with message 'Unable to add indexable content due to database error: SQLSTATE[25P02]: In failed sql transaction: 7
ERROR: current transaction is aborted, commands ignored until end of transaction block' in /home/websites/mysource_matrix/packages/search/search_manager/search_manager.inc:935 Stack trace: #0
/home/websites/mysource_matrix/packages/search/search_manager/search_manager.inc(418): Search_Manager->addIndexableContent('172', Array) #1
/home/websites/mysource_matrix/packages/search/hipo_jobs/hipo_job_reindex.inc(249): Search_Manager->reindexAttributes(Object(Page_Password_Reset), Array) #2
/home/websites/mysource_matrix/core/hipo/hipo_job.inc(1276): HIPO_Job_ReIndex->processReIndex(Array, 'hipo_job_reinde...') #3
/home/websites/mysource_matrix/core/hipo/hipo_job.inc(1173): HIPO_Job->processWeb(Array, 'hipo_job_reinde...') #4
/home/websites/mysource_matrix/core/hipo/hipo_herder.inc(209): HIPO_Jo in /home/websites/mysource_matrix/packages/search/search_manager/search_manager.inc on line 935
[/quote]
This looks like the error given in Bug 3891, resolved in the (almost there) 3.24.1 release.