For coders TYPO3 Tech Corner

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.

"Code faster, look at the time" - does this sound familiar to you?

How about time and respect for code quality? Working in a team? Automated tests?

Join us

Lesson cancellation - and now? New portal for the Bavarian school system.

For the Bavarian school system, we developed a new web app based on an existing but very outdated portal. The portal reports lesson cancellations throughout Bavaria and registered users are informed...

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

Null-Safe Operator in the TYPO3 area

With the introduction of PHP8, problems with undefined arrays or variables in general can arise in many places. Here are a few examples and simple solutions.

Go to news

Delete the first/last lines of a (SQL) file

There isn't much to say about the following commands. Sometimes it can be useful to delete the first (or last) X lines from a file. And if the file is too large to open with a conventional program, a...

Go to news

b13/container: Add and modify child elements in edit view

Unlike gridelements, you cannot manage the child elements in the B13 Container extension when you open the container in the editing view. I would be happy to show you how you can quickly install this...

Go to news