Also clean-up the comments.

test for now was passing thanks to a lucky good ordering in indexation

Revert both revert, as the original commits were just raising another bug but was not the cause of this bug

This reverts commit e89d10aa.
This reverts commit ff1ca703.

add work around for the performance regression introduced in Zope 2.12.23 in BTreeFolder2, for the case where we use BTreeFolder2 directly.

readd work around for the performance regression introduced in Zope 2.12.23 in HBTreeFolder2, for the case where we use HBTreeFolder2 directly.

This reverts commit 3742a4c8.

This reverts commit dccbb3b8.

Take into account the fact that Base_getSectionUidListForSectionCategory returns -1 when no organisation exsits

Base_getSectionUidListForSectionCategory : returns [-1] if no organisations are member of this section_category.

This way we can directly pass the returned value as section_uid= to
getInventory without worrying about the problem that if this section category
has no member, then section_uid parameter is ignored.

use Base_getSectionUidListForSectionCategory instead of hack in where
expression which won't work if we don't have catalog as section selected

Sometime dialog fields are not validated ...

Use OOBTree instead of PersistentMapping. Because it is more disk-efficent,
it will reduce the number of conflicts, improve the performance.

Hide all unnecessary fields for adding a simple blog message as adding is done usually by a site member not site manager and it was quite complex (by default blog message is submitted for approval side manager can correct errors if any).
Try to guess all possible values from parent Web Section and generate nice reference from title.
Do not manually set contributor list as this is done in a generic way by a workflow.

update script:

ALTER TABLE `catalog`
DROP INDEX `validation_state`,
DROP INDEX `simulation_state`,
DROP INDEX `causality_state`,
ADD INDEX `validation_state_portal_type` (`validation_state`, `portal_type`),
ADD INDEX `simulation_state_portal_type` (`simulation_state`, `portal_type`),
ADD INDEX `causality_state_portal_type` (`causality_state`, `portal_type`)

To update:
ALTER TABLE `stock` DROP INDEX section_uid, ADD INDEX `section_uid_portal_type` (`section_uid`, `portal_type`)

Update with:
ALTER TABLE `translation` DROP INDEX `portal_type`, ADD INDEX `type_translated_message` (`portal_type`,`translated_message`);

update with:
ALTER TABLE `inventory_stock` DROP INDEX `resource_uid`; -- exists in resource_node_uid
ALTER TABLE `stock` DROP INDEX `resource_uid`; -- exists in resource_node_uid

update with
ALTER TABLE `predicate_category` DROP INDEX `FuzzyMembership`; -- exists in Membership

update with:

ALTER TABLE `versioning` DROP INDEX `expiration_date`;
ALTER TABLE `versioning` ADD INDEX `expiration_date` (`expiration_date`);

also remove now useless related key (should have been part of former commit)