TYPO3: Manually update SOLR index in PHP?

TYPO3: Manually update SOLR index in PHP?

Have you ever wanted to update the SOLR index live? Maybe if records are changed in the frontend or if - as in our case - the nightly import updates records in TYPO3? We'll quickly show you how it works.

In the first step we delete an existing entry in the SOLR index using the table name and the identifier:

// Delete SOLR entry $garbageCollector = GeneralUtility::makeInstance(GarbageHandler::class); $garbageCollector->collectGarbage('tx_ext_domain_model_product', $product->getUid());

After the import, we can create a new entry in the index queue table of the SOLR extension:

// Add to queue $queryBuilder = DatabaseUtility::getQueryBuilderForTable('tx_solr_indexqueue_item'); $queryBuilder ->insert('tx_solr_indexqueue_item') ->values([ 'root' => 1, 'item_type' => 'tx_ext_domain_model_product', 'item_uid' => $product->getUid(), 'indexing_configuration' => 'products', 'changed' => time(), 'errors' => '', ]) ->execute();

Explanation: root => PID of site-config, item_type: table name, item_uid: record identifier, indexing_configuration: name of indexconfiguration (see TypoScript)

Note: If you're wondering why we enter the data directly into the table and don't use a ready-made function from the SOLR extension: There is the add() function in the class \ApacheSolrForTypo3\Solr\Domain\Index\Queue\QueueItemRepository, here. However, there is a note that this is only there for internal purposes and should not be used from outside.

TYPO3: Finding unused files in fileadmin

Do you want to delete unused or orphaned files in fileadmin or another storage location? Unfortunately, there's no direct core functionality for this. But a small command in your site package can...

Go to news

TYPO3: Editors with individual user_upload folders

Perhaps you're familiar with this client requirement? Editors should be able to add videos using the "Add media by URL" button. But the files shouldn't be located in fileadmin/user_upload/, but rather...

Go to news

TYPO3: Finding pages in mixed mode

In TYPO3, Mixed Mode refers to translated pages that contain content only partially related to the corresponding content in the main language. This is indicated in the backend by an error message. But...

Go to news

Extbase Extensions: Think extensibility with data, site and language

Today, I have a small request for the TYPO3 extension authors out there: Make sure your extensions are extensible. This will also promote the distribution of the corresponding plugins.

Go to news

SQL: Show all tables sorted by size in descending order

Lately I've been using the SQL command more often to find out which tables in the TYPO3 database are the largest. I've published the snippet once.

Go to news

TYPO3 12 with CKEditor 5: Styles in a single selection

If you set a link in the RTE in TYPO3, you may have to choose between different link classes, for example to create buttons in the frontend. What's new in TYPO3 12 is that you can select not just one...

Go to news