Documents are not indexed

[chilladelia]

Hello Pimcore team,
I am wondering how you managed to index documents into the generic data index?

After some debugging I found out that documents are not added to the generic_data_index_queuetable.

The reason is that an INSERT IGNORE is used, which supresses the error: https://github.com/pimcore/generic-data-index-bundle/blob/2.x/src/Repository/IndexQueueRepository.php#L390

When executing the query without IGNORE I get the actual error:

INSERT INTO `generic_data_index_queue` (`elementId`, `elementType`, `elementIndexName`, `operation`, `operationTime`, `dispatched`) VALUES (1, 'document', 'document', 'update', 1764780528858, 0)

Field "id" does not have a default value.

I suppose id needs to be defined as autoincrement in IndexQueue.php (https://github.com/pimcore/generic-data-index-bundle/blob/2.x/src/Entity/IndexQueue.php#L33) ? Currently it isn't.

[chilladelia]

Found it. Autoincrement was added in the following migration: https://github.com/pimcore/generic-data-index-bundle/blob/2.x/src/Migrations/Version20251009110653.php#L42

Improvement would be to add #[ORM\GeneratedValue] to the entity directly. If wanted I can create a PR for that.

[fashxp]

thx for sharing, and yes please!

[chilladelia]

done: #376