proxy role is required in SQLCatalog_deferFullTextIndexActivity not in SQLCatalog_deferFullTextIndex.

it should be used to get SearchableText that should be static.

also raise an exception in case of error, like cloudooo is not running.

Also remove copy pasted comments

Update stock report and field library to use parameters named node_category & section_category instead of site & group

* use translationContext instead of low level hacks
* introduce a script ERP5Site_notifyReportComplete to do the actual notification
* do not activate a useless getTitle
* store strings encoded as zlib to prevent database growth

Signed-off-by: Aurélien Calonne <aurel@nexedi.com>

usually generated SQL query can use a better index this way

We were not able to export and import back roles of a document when more than
one local role group id was used.

It can only work with default id generator and anyway catalog does not
understand this syntax, so this has no effect

you can apply this change on the existing table by the following query :

ALTER TABLE stock DROP INDEX `section_uid_portal_type`, ADD INDEX `section_uid_portal_type_mirror_section_uid` (`section_uid`,`portal_type`, `mirror_section_uid`);

Do not try to translate user input by using Localizier as it will fill up its internal structure (very inefficient) and lead to increase of ZODB (every modification is a new Localizer object holding all entries).

otherwise the result for 2-bit input is unreadable 2-bit with current imagemagick.

Otherwise a TypeError exception is raised when calling Connection().columns().